nitsSwaps of NEAR
Updated 2022-12-15
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT * from
(SELECT date(block_timestamp) as day, platform,
COUNT(DISTINCT Tx_hash) as total_txs,
count(DISTINCT trader) as total_traders,
sum(case when token_in = 'wNEAR' then amount_in else amount_out end) as near_amt,
sum(near_amt) over (partition by platform order by day) as cum_amt,
sum(total_txs) over (partition by platform order by day) as cum_txs
from near.core.ez_dex_swaps
where token_in = 'wNEAR' or token_out = 'wNEAR'
GROUP by 1, 2 )
-- where day = CURRENT_DATE
-- LIMIT 100
Run a query to Download Data