superflyUntitled Query
Updated 2022-10-17
9
1
2
3
4
5
6
7
8
›
⌄
select DATE_TRUNC ('day' ,block_timestamp) as date,
'Sushi on Arbitrum' as dex,
count(distinct tx_hash) as swap_count,
count(distinct origin_from_address) as unique_swappers,
sum(swap_count) over (order by date asc) as cum_swap_count,
sum(unique_swappers) over (order by date asc) as cum_unique_swapper from arbitrum.sushi.ez_swaps
where block_timestamp::date >= CURRENT_DATE - 365
group by 1
Run a query to Download Data