boomer77ust vs stablecoins thorswap
Updated 2022-04-19
9
1
2
3
4
5
6
›
⌄
select day, pool_name, (asset_liquidity*asset_price_usd) as asset_liq, (rune_liquidity*rune_price_usd) as rune_liq, (asset_liq+rune_liq) as total_liquidity_usd,
total_swap_fees_rune, total_swap_fees_usd, swap_volume_rune_usd, swap_count,
(add_asset_liquidity_usd+add_rune_liquidity_usd) as add_lp_vol_usd, (withdraw_asset_liquidity_usd+withdraw_rune_liquidity_usd) as withdraw_lp_volume_usd
from thorchain.daily_pool_stats
where pool_name in ('TERRA.UST', 'BNB.BUSD-BD1', 'ETH.USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48', 'ETH.USDT-0XDAC17F958D2EE523A2206206994597C13D831EC7', 'ETH.DAI-0X6B175474E89094C44DA98B954EEDEAC495271D0F')
and year(day) = '2022'
Run a query to Download Data