Query editor
WITH solana_dex AS (SELECTDATE_TRUNC('day', block_time) AS dt,project,SUM(amount_usd) AS daily_volume_usdFROM dex_solana.tradesWHERE block_time >= TIMESTAMP '2025-03-15'AND project != 'pumpswap'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),exchange_rates AS (SELECTDATE_TRUNC('day', minute) AS dt,AVG(price) AS avg_sol_to_usdFROM prices.usdWHERE symbol = 'SOL'AND DATE_TRUNC('day', minute) >= DATE '2025-03-15'GROUP BY 1),pumpswap_trades AS (SELECTs.block_time,DATE_TRUNC('day', s.block_time) AS dt,CASEWHEN p.quoteMint IN ('So11111111111111111111111111111111111111112', -- SOL'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' -- mSOL) THEN (s.quoteAmountOutorIn / 1e9) * e.avg_sol_to_usdWHEN p.quoteMint IN ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', -- USDC'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', -- USDT'DEkqHyPN7GMRJ5cArtQFAWefqbZb33Hyf6s5iCwjEonT' -- USDE) THEN s.quoteAmountOutorIn / 1e6ELSE NULLEND AS volume_usd_equivFROM decoded_swap sJOIN decoded_pool p ON s.pool = p.poolJOIN exchange_rates e ON DATE_TRUNC('day', s.block_time) = e.dtWHERE s.block_time >= TIMESTAMP '2025-03-15'AND p.quoteMint IN ('So11111111111111111111111111111111111111112','mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So','EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB','DEkqHyPN7GMRJ5cArtQFAWefqbZb33Hyf6s5iCwjEonT')),