Query editor
WITH decoded_swap AS (SELECT * FROM query_4893450),decoded_pool AS (SELECT pool, quoteMintFROM query_4922901),avg_price AS (SELECT AVG(price) AS avg_sol_to_usdFROM prices.usdWHERE symbol = 'SOL'AND DATE_TRUNC('day', minute) >= DATE '2025-03-15'),filtered_trades AS (SELECTCASEWHEN p.quoteMint IN ('So11111111111111111111111111111111111111112', -- SOL'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' -- mSOL) THEN s.protocolFee / 1e9ELSE s.protocolFee / 1e6END AS protocol_fee_usd_equiv,CASEWHEN p.quoteMint IN ('So11111111111111111111111111111111111111112','mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So') THEN s.lpFee / 1e9ELSE s.lpFee / 1e6END AS lp_fee_usd_equiv,p.quoteMintFROM 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')),aggregated_fees AS (SELECTSUM(CASE WHEN quoteMint IN ('So11111111111111111111111111111111111111112','mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So') THEN protocol_fee_usd_equiv ELSE 0 END) AS total_protocol_fees_sol,SUM(CASE WHEN quoteMint IN ('So11111111111111111111111111111111111111112','mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So') THEN lp_fee_usd_equiv ELSE 0 END) AS total_lp_fees_sol,SUM(CASE WHEN quoteMint NOT IN (