DAY | ASSET_NAME | NET_LIQUIDITY_CHANGE_USD | TOTAL_NET_LIQUIDITY_CHANGE_USD | |
|---|---|---|---|---|
1 | 2025-06-07 00:00:00.000 | ETH.ETH | 0 | -974.898968347 |
2 | 2025-06-07 00:00:00.000 | DOGE.DOGE | 0 | -974.898968347 |
3 | 2025-06-07 00:00:00.000 | BSC.BNB | 0 | -974.898968347 |
4 | 2025-06-07 00:00:00.000 | Others | 0 | -974.898968347 |
5 | 2025-06-07 00:00:00.000 | GAIA.ATOM | 0 | -974.898968347 |
6 | 2025-06-07 00:00:00.000 | BTC.BTC | -69.344438233 | -974.898968347 |
7 | 2025-06-07 00:00:00.000 | AVAX.AVAX | 0 | -974.898968347 |
8 | 2025-06-07 00:00:00.000 | BCH.BCH | 0 | -974.898968347 |
9 | 2025-06-07 00:00:00.000 | STABLECOIN | -905.554530114 | -974.898968347 |
10 | 2025-06-07 00:00:00.000 | BASE.ETH | 0 | -974.898968347 |
11 | 2025-06-07 00:00:00.000 | LTC.LTC | 0 | -974.898968347 |
12 | 2025-06-06 00:00:00.000 | AVAX.AVAX | 0 | -16780.749354398 |
13 | 2025-06-06 00:00:00.000 | GAIA.ATOM | 0 | -16780.749354398 |
14 | 2025-06-06 00:00:00.000 | Others | 6732.129158759 | -16780.749354398 |
15 | 2025-06-06 00:00:00.000 | LTC.LTC | 0 | -16780.749354398 |
16 | 2025-06-06 00:00:00.000 | BTC.BTC | -506.679366018 | -16780.749354398 |
17 | 2025-06-06 00:00:00.000 | BASE.ETH | -265.513051643 | -16780.749354398 |
18 | 2025-06-06 00:00:00.000 | BCH.BCH | 0 | -16780.749354398 |
19 | 2025-06-06 00:00:00.000 | STABLECOIN | -1996.473231747 | -16780.749354398 |
20 | 2025-06-06 00:00:00.000 | ETH.ETH | -20744.212863749 | -16780.749354398 |
pietrektLiquidity Net (add - withdraw)
Updated 15 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with init as (select day, pool_name, asset_liquidity, asset_price_usd, rune_liquidity, rune_price_usd,
WITHDRAW_ASSET_LIQUIDITY, WITHDRAW_ASSET_LIQUIDITY_USD, WITHDRAW_RUNE_LIQUIDITY, WITHDRAW_RUNE_LIQUIDITY_USD,
ADD_ASSET_LIQUIDITY, ADD_ASSET_LIQUIDITY_USD, ADD_RUNE_LIQUIDITY, ADD_RUNE_LIQUIDITY_USD
from thorchain.defi.fact_daily_pool_stats
where pool_name
like '%.%'
AND ADD_ASSET_LIQUIDITY_USD < 100000000)
SELECT day,
CASE
WHEN pool_name = 'BTC.BTC' THEN 'BTC.BTC'
WHEN pool_name = 'ETH.ETH' THEN 'ETH.ETH'
WHEN pool_name = 'BASE.ETH' THEN 'BASE.ETH'
WHEN pool_name = 'AVAX.AVAX' THEN 'AVAX.AVAX'
WHEN pool_name = 'BNB.BNB' THEN 'BSC.BNB'
WHEN pool_name = 'BSC.BNB' THEN 'BSC.BNB'
WHEN pool_name = 'BCH.BCH' THEN 'BCH.BCH'
WHEN pool_name = 'LTC.LTC' THEN 'LTC.LTC'
WHEN pool_name = 'DOGE.DOGE' THEN 'DOGE.DOGE'
WHEN pool_name = 'GAIA.ATOM' THEN 'GAIA.ATOM'
WHEN pool_name = 'AVAX.USDC-0XB97EF9EF8734C71904D8002F8B6BC66DD9C48A6E' THEN 'STABLECOIN'
WHEN pool_name = 'ETH.USDT-0XDAC17F958D2EE523A2206206994597C13D831EC7' THEN 'STABLECOIN'
WHEN pool_name = 'ETH.USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48' THEN 'STABLECOIN'
WHEN pool_name = 'AVAX.USDT-0X9702230A8EA53601F5CD2DC00FDBC13D4DF4A8C7' THEN 'STABLECOIN'
WHEN pool_name = 'BASE.USDC-0X833589FCD6EDB6E08F4C7C32D4F71B54BDA02913' THEN 'STABLECOIN'
WHEN pool_name = 'BSC.USDC-0X8AC76A51CC950D9822D68B83FE1AD97B32CD580D' THEN 'STABLECOIN'
WHEN pool_name = 'BSC.USDT-0X55D398326F99059FF775485246999027B3197955' THEN 'STABLECOIN'
WHEN pool_name = 'ETH.DAI-0X6B175474E89094C44DA98B954EEDEAC495271D0F' THEN 'STABLECOIN'
WHEN pool_name = 'ETH.GUSD-0X056FD409E1D7A124BD7017459DFEA2F387B6D5CD' THEN 'STABLECOIN'
WHEN pool_name = 'ETH.LUSD-0X5F98805A4E8BE255A32880FDEC7F6728C6568BA0' THEN 'STABLECOIN'
WHEN pool_name = 'ETH.USDP-0X8E870D67F660D95D5BE530380D0EC0BD388289E1' THEN 'STABLECOIN'
WHEN pool_name = 'BNB.BUSD-BD1' THEN 'STABLECOIN'
ELSE 'Others' END as asset_name,
Last run: about 15 hours agoAuto-refreshes every 24 hours
...
13917
924KB
3s