HadisehNEAR City Layout 2
Updated 2022-11-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select 'NEAR' as chain,
date(block_timestamp) as date,
count(distinct pool_id) as total_pool ,
sum(total_pool) over (order by date) as cumulative_pool,
count(distinct trader) as total_trader,
sum(total_trader) over (order by date) as cumulative_trader
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(distinct pool_name) as total_pool ,
sum(total_pool) over (order by date) as cumulative_pool,
count(distinct sender) as total_trader,
sum(total_trader) over (order by date) as cumulative_trader
from ethereum.core.ez_dex_swaps
where date >= CURRENT_DATE - 120
group by date
Run a query to Download Data