afonsoswap from aETHb
Updated 2023-01-13Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date_trunc('week', block_timestamp::date) 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_in = '0xd01ef7c0a5d8c432fc2d1a85c66cf2327362e5c6' --aETHb
group by week
having volume_usd > 0
order by 1 asc
Run a query to Download Data