MLDZMNbbon1
Updated 2023-01-04Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with tb1 as (select
date_trunc('day',recorded_at) as day,
avg (price) as usd_price
from osmosis.core.dim_prices
where symbol='OSMO'
and recorded_at::date>='2022-03-01'
group by 1
)
select
date_trunc('day', block_timestamp) as day,
16104002.4212317 as "Average transfer before Terra Collapse",
5331222.08447821 as "Average transfer before Listing",
sum((amount/POW (10,decimal))*usd_price) as transfer_usd,
avg((amount/POW (10,decimal))*usd_price) as avg_transfer_usd
from osmosis.core.fact_transfers s left join tb1 b on s.block_timestamp::date = b.day
where currency='uosmo'
and TX_STATUS = 'SUCCEEDED'
and block_timestamp::date>='2022-10-21'
group by 1
Run a query to Download Data