with pools as (select pool_name, sum(from_amount_usd) as vol from thorchain.swaps where block_timestamp >= '2022-01-01' group by 1 order by 2 desc limit 10), doge as (select pool_name, sum(from_amount_usd) as "24hrs Vol" from thorchain.swaps where pool_name = 'DOGE.DOGE' and block_timestamp <= '2022-01-18 01:25:21.951' group by 1), usdc as (select pool_name, sum(from_amount_usd) as "24hrs Vol" from thorchain.swaps where pool_name = 'ETH.USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48' and block_timestamp <= '2021-05-07 06:40:55.488' group by 1), btc as (select pool_name, sum(from_amount_usd) as "24hrs Vol" from thorchain.swaps where pool_name = 'BTC.BTC' and block_timestamp <= '2021-04-12 09:46:16.317' group by 1), ltc as (select pool_name, sum(from_amount_usd) as "24hrs Vol" from thorchain.swaps where pool_name = 'LTC.LTC' and block_timestamp <= '2021-04-12 11:09:42.489' group by 1), eth as (select pool_name, sum(from_amount_usd) as "24hrs Vol" from thorchain.swaps where pool_name = 'ETH.ETH' and block_timestamp <= '2021-04-12 09:43:20.446' group by 1), bnbeth as (select pool_name, sum(from_amount_usd) as "24hrs Vol" from thorchain.swaps where pool_name = 'BNB.ETH-1C9' and block_timestamp <= '2021-04-17 20:59:38.933' group by 1), bnbbtc as (select pool_name, sum(from_amount_usd) as "24hrs Vol" from thorchain.swaps where pool_name = 'BNB.BTCB-1DE' and block_timestamp <= '2021-04-16 23:46:39.600' group by 1), bnb as (select pool_name, sum(from_amount_usd) as "24hrs Vol" from thorchain.swaps where pool_name = 'BNB.BNB' and block_timestamp <= '2021-04-12 09:42:36.280' group by 1), usdt as (select pool_name, sum(from_amount_usd) as "24hrs Vol" from thorchain.swaps where pool_name = 'ETH.USDT-0XDAC17F958D2EE523A2206206994597C13D831EC7' and block_timestamp <= '2021-04-12 07:28:47.929' group by 1), busd as (select pool_name, sum(from_amount_usd) as "24hrs Vol" from thorchain.swaps where pool_name = 'BNB.BUSD-BD1' and block_timestamp <= '2021-04-12 23:14:17.728' group by 1), final as (select * from doge union select * from usdc union select * from btc union select * from ltc union select * from eth union select * from bnbeth union select * from bnbbtc union select * from bnb union select * from usdt union select * from busd) select a.pool_name, a.vol, b."24hrs Vol" from pools a left join final b on a.pool_name = b.pool_name order by 2 desc

47. THORChain: DOGE Debut