mz0111arb 10
Updated 2023-05-25
9
1
2
3
4
5
6
7
8
›
⌄
--credit to https://flipsidecrypto.xyz/mattkstew/q/2023-05-21-06-13-pm-lLhLfe
select
date_trunc('day', block_timestamp) as Date,
avg(LIQUIDITY_USD) as Liquidity_USD
from osmosis.core.fact_pool_hour
where pool_id = '1011'
AND block_timestamp :: DATE >= CURRENT_DATE - {{period}}
group by 1
Run a query to Download Data