Query editor
--colors phoe F37A44 whirl FFCE5B ray AB0DEB lif 5D5AE5 meteora 609A00 goosefx 726FFFSELECTdate_trunc('week', block_time) as time, project, sum(amount_usd) as amount_usd-- , sum(COALESCE(amount_usd, tr.token_bought_amount*p.median_price)) as amount_usd_otherFROM dex_solana.trades tr-- LEFT JOIN dune.dune.result_dex_prices_solana p ON p.token_mint_address = tr.token_bought_mint_address-- AND date_trunc('day',tr.block_time) = p.day-- AND rolling_two_months_trades > 100WHERE block_time > timestamp '{{start date}}'AND token_bought_mint_address != '4PfN9GDeF9yQ37qt9xCPsQ89qktp1skXfbsZ5Azk82Xi' and token_sold_mint_address != '4PfN9GDeF9yQ37qt9xCPsQ89qktp1skXfbsZ5Azk82Xi'group by 1, 2