0xHaM-dvolume & number of swaps
Updated 2022-06-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
with tb1 as (
select
block_timestamp::date as date,
tx_hash,
symbol_in as symbol,
amount_in as amount
from ethereum.sushi.ez_swaps
where token_in in ('0xdac17f958d2ee523a2206206994597c13d831ec7', '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', '0x6b175474e89094c44da98b954eedeac495271d0f')
and block_timestamp::date >= '2022-01-01'
UNION
select
block_timestamp::date as date,
tx_hash,
symbol_out as symbol,
amount_out as amout
from ethereum.sushi.ez_swaps
where token_out in ('0xdac17f958d2ee523a2206206994597c13d831ec7', '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', '0x6b175474e89094c44da98b954eedeac495271d0f')
)
select date,
symbol,
count(DISTINCT tx_hash) as tx_count,
sum(tx_count) OVER (order by date asc ) as cum_growth_tx_count,
sum(amount) as swap_vol,
sum(swap_vol) OVER (order by date asc ) as cum_growth_swap_vol
from tb1
where date >= '2022-01-01'
group by 1, 2
order by 1
Run a query to Download Data