Ali3NSpecific Pool Dately Liquidity AVAX Pools Stats in THORCHain Over Time copy
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
22
23
›
⌄
-- forked from Specific Pool Dately Liquidity AVAX Pools Stats in THORCHain Over Time @ https://flipsidecrypto.xyz/edit/queries/9460c412-166b-418d-b306-631a2d6e13b6
select block_timestamp::date as date,
split(pool_name, '-')[0] as poolname,
sum (case when lp_action = 'add_liquidity' then coalesce (rune_amount_usd,asset_amount_usd) end) as Add_Liquidity,
sum (case when lp_action = 'remove_liquidity' then coalesce (rune_amount_usd,asset_amount_usd)*-1 end) as Remove_Liquidity,
sum (case when lp_action = 'add_liquidity' then coalesce (rune_amount_usd,asset_amount_usd) else coalesce (rune_amount_usd,asset_amount_usd)*-1 end) as Net_Volume
from thorchain.defi.fact_liquidity_actions
where poolname = '{{Specific_Pool}}'
--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