mucryptoTrader Joe
Updated 2023-05-19
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
block_timestamp::date as day,
count(distinct trader) as unique_daily_traders,
-- sum(unique_daily_traders) over (order by day asc) as cmulative_traders,
sum(amount_out) as weth_bought_daily,
sum(amount_out_usd) as weth_bought_daily_in_usd
from crosschain.core.ez_dex_swaps
where block_timestamp >= '2023-04-01'
and platform = 'trader-joe-v2'
and token_in = lower('0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E') --usdc
and token_out = lower('0x49D5c2BdFfac6CE2BFdB6640F4F80f226bc10bAB') --weth.e
group by 1
Run a query to Download Data