afonsoUntitled Query
Updated 2023-01-14
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc('week', block_timestamp) as week,
count (distinct tx_hash) as swaps_count,
count (distinct origin_from_address) as swappers_count,
sum (amount_in_usd) as volume_usd,
sum(swaps_count) over (order by week asc) as cumulative_swaps_count,
sum(swappers_count) over (order by week asc) as cumulative_swappers_count,
sum(volume_usd) over (order by week asc) as cumulative_volume_usd
from ethereum.core.ez_dex_swaps
where token_out = '0xe95a203b1a91a908f9b9ce46459d101078c2c3cb' --aETHc
group by 1
order by 1 asc
Run a query to Download Data