afonsoswap from rETH
Updated 2023-01-13
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 = '0xae78736cd615f374d3085123a210448e74fc6393' --rETH
group by week
having volume_usd > 0
order by 1 asc
Run a query to Download Data