superflyUntitled Query
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select DATE_TRUNC ('day' ,block_timestamp) as date,
'Uni on Arbitrum' as dex,
count(distinct tx_hash) as number_of_swaps,
count(distinct origin_from_address) as user_unique,
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.core.fact_event_logs
where origin_to_address IN ('0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45','0xe592427a0aece92de3edee1f18e0157c05861564')
and event_name = 'Swap'
and tx_status = 'SUCCESS'
and block_timestamp::date >= CURRENT_DATE - 365
group by 1
Run a query to Download Data