Query editor
withL as( select * from query_2685984 where tag = 'telebot'),P as( SELECT block_date, blockchain as chain, token_sold_address as contract, amount_usd from dex.trades union allSELECT block_date, blockchain as chain, token_bought_address as contract, amount_usd from dex.trades )select date_trunc('week',block_date) as day, b.token, sum(amount_usd) as volumefrom P as ajoin L as b on a.contract = b.contractwhere date(block_date) > date('2023-06-30')group by 1,2order by day , volume