mz01112023-05-25 05:57 AM
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('day', block_timestamp) as Date_Day,
avg(liquidity) as Liquidity,
avg(LIQUIDITY_USD) as Liquidity_USD,
rank() over (order by date asc ) as Day
from osmosis.core.fact_pool_hour
where pool_id = 789
group by 1
Run a query to Download Data