mondovtraderjoe
Updated 2023-03-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
date_trunc('day', block_timestamp) as date,
count(distinct tx_hash) as "Number of Swaps",
count(distinct origin_from_address) as "Traders",
sum("Number of Swaps") over (
order by
date
) as "Cumulative # of swaps",
sum("Traders") over (ORDER BY date) as "Cumulative Traders",
count(distinct )
from
avalanche.core.ez_decoded_event_logs
where
origin_to_address = lower('0x60aE616a2155Ee3d9A68541Ba4544862310933d4')
and event_name = 'Swap'
and tx_status = 'SUCCESS'
group by
1
order by
1 desc
Run a query to Download Data