nsa2000ava8
Updated 2022-11-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select date_Trunc('day', block_timestamp) as day,
count(distinct(origin_from_address)) as swapper_count,
count(distinct(tx_hash)) as swaps_count,
'Avalanche'
from avalanche.core.fact_event_logs
where event_name = 'Swap'
and day >= '2022-10-15'
and day <= '2022-11-08'
group by 1
UNION
select date_Trunc('day', block_timestamp) as day,
count(distinct(origin_from_address)) as swapper_count,
count(distinct(tx_hash)) as swaps_count,
'Ethereum'
from ethereum.core.fact_event_logs
where event_name = 'Swap'
and day >= '2022-10-15'
and day <= '2022-11-08'
group by 1
Run a query to Download Data