carlesmontalaCOSMO FREE PLAY 9
Updated 2023-01-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with EVMOSpricet as (
select recorded_at::date as day,
avg (price) as EVMOSPrice
from osmosis.core.dim_prices where symbol = 'EVMOS'
and recorded_at >= CURRENT_DATE - 7
group by 1)
select from_currency,
project_name,
count (distinct tx_id) as Swaps_Count,
count (distinct trader) as Swappers_Count,
sum ((to_amount/1e18)*EVMOSPrice) as USD_Volume
from osmosis.core.fact_swaps t1 join EVMOSPricet t2 on t1.block_timestamp::date = t2.day
full outer join osmosis.core.dim_labels t3 on t1.from_currency = t3.address
where to_currency = 'ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A'
and block_timestamp >= CURRENT_DATE - 7
group by 1,2
order by 3 DESC
limit 4
Run a query to Download Data