dannyamahTotal Users
Updated 2024-03-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH jupiterV6 AS (
SELECT
count(DISTINCT(swapper)) AS total_jupiter_users
FROM solana.defi.fact_swaps
WHERE swap_program = 'jupiter swap v6'
AND swap_to_amount IS NOT NULL
AND succeeded
AND date(block_timestamp) >= CURRENT_DATE - INTERVAL '90 Days'
),
uniswapV3 AS (
SELECT
count(DISTINCT(sender)) AS total_uniswap_users
FROM ethereum.uniswapv3.ez_swaps
WHERE amount1_usd IS NOT NULL
AND date(block_timestamp) >= CURRENT_DATE - INTERVAL '90 Days'
)
SELECT
total_jupiter_users,
total_uniswap_users
FROM jupiterV6, uniswapV3;
QueryRunArchived: QueryRun has been archived