Query editor
with clanker_volume as (select d_day, sum(volume) as daily_volumefrom (select date_trunc('day', block_time) as d_day,a.tokenAddress,sum(amount_usd) as volumefrom dex.trades tinner join query_4405741 a on a.tokenAddress = t.token_bought_addresswhere t.blockchain = 'base'and t.block_time > timestamp '2024-11-08'and amount_usd > 1group by 1, 2union allselect date_trunc('day', block_time) as d_day,a.tokenAddress,sum(amount_usd) as volumefrom dex.trades tinner join query_4405741 a on a.tokenAddress = t.token_sold_addresswhere t.blockchain = 'base'and t.block_time > timestamp '2024-11-08'and amount_usd > 1group by 1, 2) agroup by 1),virtual as (select d_day, sum(volume) as daily_volumefrom (select date_trunc('day', block_time) as d_day,a.token,sum(amount_usd) as volumefrom dex.trades tinner join query_4427717 a on a.token = t.token_bought_addresswhere t.blockchain = 'base'and t.block_time > timestamp '2024-11-08'and amount_usd > 1group by 1, 2union allselect date_trunc('day', block_time) as d_day,a.token,sum(amount_usd) as volumefrom dex.trades tinner join query_4427717 a on a.token = t.token_sold_addresswhere t.blockchain = 'base'and t.block_time > timestamp '2024-11-08'and amount_usd > 1group by 1, 2) agroup by 1)selectc.d_day,c.daily_volume as clanker_volume,v.daily_volume as virtuals_volume,