mz0111near1 open
Updated 2023-05-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
date_trunc('week',day) as date,
count( distinct tx_hash) as txs,
count(DISTINCT(trader)) as users,
txs/users as tra_number_per_user,
sum(txs) over (order by date asc) as cum_txs,
sum(users) over (order by date asc) as cum_users
from(
select
block_timestamp:: date as day,
tx_hash,
trader,
token_out,
token_in ,
token_in_contract,
TOKEN_OUT_CONTRACT,
concat(token_in,'-->',token_out) as pair
from near.core.ez_dex_swaps
where PLATFORM = 'v2.ref-finance.near'
and block_timestamp::date >= current_date - {{period}}
)
group by 1
Run a query to Download Data