HadisehNEAR City Layout 3
Updated 2022-11-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select 'NEAR' as chain,
date(block_timestamp) as date,
count(*) as total_swap ,
sum(total_swap) over (order by date) as cumulative_swap
from near.core.ez_dex_swaps
where date >= CURRENT_DATE - 120
group by date
UNION
select 'ETHEREUM' as chain,
date(block_timestamp) as date,
count(*) as total_swap ,
sum(total_swap) over (order by date) as cumulative_swap
from ethereum.core.ez_dex_swaps
where date >= CURRENT_DATE - 120
group by date
Run a query to Download Data