Query editor
WITH decoded_swap AS (SELECT * FROM query_4893450),decoded_pool AS (SELECT pool, quoteMintFROM query_4922901),exchange_rates AS (SELECT AVG(price) AS avg_sol_to_usdFROM prices.usdWHERE symbol = 'SOL'AND DATE_TRUNC('day', minute) >= DATE '2025-03-15'),pumpswap_trades AS (SELECTs.block_time,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.poolCROSS JOIN exchange_rates eWHERE s.block_time >= TIMESTAMP '2025-03-15'AND p.quoteMint IN ('So11111111111111111111111111111111111111112','mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So','EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB','DEkqHyPN7GMRJ5cArtQFAWefqbZb33Hyf6s5iCwjEonT')),sol_volumes AS (SELECTSUM(volume_usd_equiv) AS total_volume_usd,SUM(CASE WHEN block_time >= NOW() - INTERVAL '7' day THEN volume_usd_equiv ELSE 0 END) AS volume_7d_usd,SUM(CASE WHEN block_time >= NOW() - INTERVAL '1' day THEN volume_usd_equiv ELSE 0 END) AS volume_24h_usdFROM pumpswap_tradesWHERE volume_usd_equiv IS NOT NULL)SELECTv.total_volume_usd / 1e9 AS total_volume_usd_billions,v.volume_7d_usd / 1e9 AS volume_7d_usd_billions,v.volume_24h_usd / 1e6 AS volume_24h_usd_millionsFROM sol_volumes v;