Query editor
WITH decoded_swap AS (SELECT * FROM query_4893450),decoded_pool AS (SELECT pool, quoteMintFROM query_4922901),exchange_rates AS (SELECTDATE_TRUNC('week', 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('week', 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')),weekly_volume AS (SELECTdt AS week,SUM(volume_usd_equiv) AS weekly_volume_usdFROM pumpswap_tradesWHERE volume_usd_equiv IS NOT NULLGROUP BY dt)SELECT