Eman-RazSEI Price Over time
Updated 2024-06-11
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with tab1 as (select date_trunc('hour',block_timestamp) as "Hour", sum(amount_out)/sum(amount_in) as "Price"
from sei.defi.fact_dex_swaps
where currency_out='factory/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/Hq4tuDzhRBnxw3tFA5n6M52NVMVcC19XggbyDiJKCD6H'
and currency_in='usei'
group by 1
order by 1)
select "Hour"::date as "Day", max("Price") as "Max", avg("Price") as "Avg", min("Price") as "Min", max("Price")-min("Price") as "RoPF"
from tab1
group by 1
order by 1
Auto-refreshes every 3 hours
QueryRunArchived: QueryRun has been archived