with usdc_pools as ( select distinct pool_address, platform from ethereum.dex_liquidity_pools where token0 = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' or token1 = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' and platform like 'uniswap%' and platform <> 'sushiswap'), USDC_swap_volume as ( Select date_trunc('day', block_timestamp) as date, sum(amount_usd) as USDC_swap_volume from ethereum.dex_swaps where pool_address in (select pool_address from usdc_pools) and direction = 'OUT' and platform <> 'sushiswap' and date < CURRENT_DATE() group by 1 order by 1 DESC limit 30), dai_pools as ( select distinct pool_address, platform from ethereum.dex_liquidity_pools where token0 = lower('0x6B175474E89094C44Da98b954EedeAC495271d0F') or token1 = lower('0x6B175474E89094C44Da98b954EedeAC495271d0F') and platform like 'uniswap%' and platform <> 'sushiswap'), DAI_swap_volume as ( Select date_trunc('day', block_timestamp) as date, sum(amount_usd) as DAI_swap_volume from ethereum.dex_swaps where pool_address in (select pool_address from dai_pools) and direction = 'OUT' and platform <> 'sushiswap' and date < CURRENT_DATE() group by 1 order by 1 DESC limit 30), usdt_pools as ( select distinct pool_address, platform from ethereum.dex_liquidity_pools where token0 = lower('0xdAC17F958D2ee523a2206206994597C13D831ec7') or token1 = lower('0xdAC17F958D2ee523a2206206994597C13D831ec7') and platform like 'uniswap%' and platform <> 'sushiswap'), USDT_swap_volume as ( Select date_trunc('day', block_timestamp) as date, sum(amount_usd) as USDT_swap_volume from ethereum.dex_swaps where pool_address in (select pool_address from usdt_pools) and direction = 'OUT' and platform <> 'sushiswap' and date < CURRENT_DATE() group by 1 order by 1 DESC limit 30), ust_pools as ( select distinct pool_address, platform from ethereum.dex_liquidity_pools where token0 = lower('0xa47c8bf37f92aBed4A126BDA807A7b7498661acD') or token1 = lower('0xa47c8bf37f92aBed4A126BDA807A7b7498661acD') and platform like 'uniswap%' and platform <> 'sushiswap'), UST_swap_volume as ( Select date_trunc('day', block_timestamp) as date, sum(amount_usd) as UST_swap_volume from ethereum.dex_swaps where pool_address in (select pool_address from ust_pools) and direction = 'OUT' and platform <> 'sushiswap' and date < CURRENT_DATE() group by 1 order by 1 DESC limit 30), busd_pools as ( select distinct pool_address, platform from ethereum.dex_liquidity_pools where token0 = lower('0x4Fabb145d64652a948d72533023f6E7A623C7C53') or token1 = lower('0x4Fabb145d64652a948d72533023f6E7A623C7C53') and platform like 'uniswap%' and platform <> 'sushiswap'), BUSD_swap_volume as ( Select date_trunc('day', block_timestamp) as date, sum(amount_usd) as BUSD_swap_volume from ethereum.dex_swaps where pool_address in (select pool_address from busd_pools) and direction = 'OUT' and platform <> 'sushiswap' and date < CURRENT_DATE() group by 1 order by 1 DESC limit 30), fei_pools as ( select distinct pool_address, platform from ethereum.dex_liquidity_pools where token0 = lower('0x956F47F50A910163D8BF957Cf5846D573E7f87CA') or token1 = lower('0x956F47F50A910163D8BF957Cf5846D573E7f87CA') and platform like 'uniswap%' and platform <> 'sushiswap'), FEI_swap_volume as ( Select date_trunc('day', block_timestamp) as date, sum(amount_usd) as FEI_swap_volume from ethereum.dex_swaps where pool_address in (select pool_address from fei_pools) and direction = 'OUT' and platform <> 'sushiswap' and date < CURRENT_DATE() group by 1 order by 1 DESC limit 30) Select DAI_swap_volume.date, DAI_swap_volume.DAI_swap_volume as DAI_swap_volume, USDC_swap_volume.USDC_swap_volume as USDC_swap_volume, USDT_swap_volume.USDT_swap_volume as USDT_swap_volume, UST_swap_volume.UST_swap_volume as UST_swap_volume, BUSD_swap_volume.BUSD_swap_volume as BUSD_swap_volume, -- There seems to be some errors in the data for BUSD swaps on Uniswap. FEI_swap_volume.FEI_swap_volume as FEI_swap_volume from DAI_swap_volume left join USDC_swap_volume on DAI_swap_volume.date = USDC_swap_volume.date left join USDT_swap_volume on DAI_swap_volume.date = USDT_swap_volume.date left join UST_swap_volume on DAI_swap_volume.date = UST_swap_volume.date left join BUSD_swap_volume on DAI_swap_volume.date = BUSD_swap_volume.date left join FEI_swap_volume on DAI_swap_volume.date = FEI_swap_volume.date group by 1,2,3,4,5,6,7 order by 1 desc

Stablecoin Trends