Query editor
WITH solana_dex AS (SELECTDATE_TRUNC('week', block_time) AS dt,project,SUM(amount_usd) AS weekly_volume_usdFROM dex_solana.tradesWHERE block_time >= TIMESTAMP '2025-03-15'AND token_bought_mint_address != '4PfN9GDeF9yQ37qt9xCPsQ89qktp1skXfbsZ5Azk82Xi'AND token_sold_mint_address != '4PfN9GDeF9yQ37qt9xCPsQ89qktp1skXfbsZ5Azk82Xi'GROUP BY 1, 2),decoded_swap AS (SELECT *FROM query_4893450),decoded_pool AS (SELECT pool, quoteMintFROM query_4922901),pumpswap_trades AS (SELECTs.block_time,CASEWHEN p.quoteMint IN ('So11111111111111111111111111111111111111112', -- SOL'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' -- mSOL) THEN s.quoteAmountOutorIn / 1e9WHEN p.quoteMint IN ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', -- USDC'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', -- USDT'DEkqHyPN7GMRJ5cArtQFAWefqbZb33Hyf6s5iCwjEonT' -- USDE) THEN s.quoteAmountOutorIn / 1e6ELSE NULLEND AS usd_amountFROM decoded_swap sJOIN decoded_pool p ON s.pool = p.poolWHERE s.block_time >= TIMESTAMP '2025-03-15'AND p.quoteMint IN ('So11111111111111111111111111111111111111112','mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So','EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB','DEkqHyPN7GMRJ5cArtQFAWefqbZb33Hyf6s5iCwjEonT')),pumpswap_volume AS (SELECTDATE_TRUNC('week', block_time) AS dt,SUM(usd_amount) AS weekly_volume_token_unitsFROM pumpswap_tradesWHERE usd_amount IS NOT NULLGROUP BY 1),