SpiltadavidNumber of NEAR Users of Swap Platforms per month
Updated 2022-11-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with cex as (select address , project_name from near.core.dim_address_labels where L2_LABEL in ('distributor_cex' , 'distributor_cex_satellite') )
, projects as (select count(*) , count(distinct tx_signer) , project_name from near.core.fact_transactions inner join cex
on tx_receiver=address
group by project_name)
, projects_chart as (select count(*) , count(distinct tx_signer) , project_name , trunc(block_timestamp, 'MONTH') from near.core.fact_transactions inner join cex
on tx_receiver=address
group by project_name , trunc(block_timestamp, 'MONTH') )
, cex_daily as (select count(*) , count(distinct tx_signer) , trunc(block_timestamp, 'MONTH') from near.core.fact_transactions inner join cex
on tx_receiver=address
group by trunc(block_timestamp, 'MONTH'))
, swaps_platform as (select count(*) , count(distinct trader) , platform from near.core.ez_dex_swaps
group by platform)
, swaps_platform_chart as (select count(*) , count(distinct trader) , platform, trunc(block_timestamp, 'MONTH') from near.core.ez_dex_swaps
group by platform, trunc(block_timestamp, 'MONTH'))
, swaps_chart as (select count(*) , count(distinct trader) , trunc(block_timestamp, 'MONTH') from near.core.ez_dex_swaps
group by trunc(block_timestamp, 'MONTH'))
select * from swaps_chart
Run a query to Download Data