Ali3NDailyy Stats of AVAX Pools In THORChain Over Time
Updated 2024-07-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from Dately Remove Liquidity AVAX Pools Stats in THORCHain Over Time @ https://flipsidecrypto.xyz/edit/queries/d873e16c-0911-45f7-a6e9-883ec43bfd44
-- forked from Dately AVAX Pools Stats in THORCHain Over Time @ https://flipsidecrypto.xyz/edit/queries/bacbb1a8-f407-4084-83d3-248ef73ce865
select block_timestamp::date as date,
split(pool_name, '-')[0] as poolname,
avg (coalesce (rune_amount_usd,0) + coalesce (asset_amount_usd,0)) as Balance
from thorchain.defi.fact_pool_block_balances
where poolname in ('AVAX.USDC','AVAX.AVAX','AVAX.SOL')
--pool_name in ('AVAX.AVAX','AVAX/USDC-0XB97EF9EF8734C71904D8002F8B6BC66DD9C48A6E','AVAX.SOL-0XFE6B19286885A4F7F55ADAD09C3CD1F906D2478F','AVAX.USDT-0X9702230A8EA53601F5CD2DC00FDBC13D4DF4A8C7')
and block_timestamp >= '{{Start_Date}}' and block_timestamp <= '{{End_Date}}'
group by 1,2
order by 1 desc
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived