MLDZMNsne14
Updated 2023-02-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with t2 as (select
TIMESTAMP::date as day,
avg(PRICE_USD) as price
from near.core.fact_prices
where SYMBOL ilike '%near%'
group by 1 )
select
concat(SYMBOL_IN, '->', SYMBOL_OUT) as asset_pair,
count(distinct tx_hash) as swap,
count(distinct ORIGIN_FROM_ADDRESS) as swappers
from ethereum.core.ez_dex_swaps s left join t2 a on s.BLOCK_TIMESTAMP::date=a.day
where (SYMBOL_IN='NEAR' or SYMBOL_OUT='NEAR')
group by 1
Run a query to Download Data