boomer77native tokens vs luna thor
Updated 2022-04-19
9
1
2
3
4
5
›
⌄
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.LUNA', 'BTC.BTC', 'ETH.ETH', 'DOGE.DOGE', 'LTC.LTC', 'BNB.BNB', 'BCH.BCH') and year(day) = '2022'
Run a query to Download Data