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 week,AVG(price) AS avg_sol_to_usdFROM prices.usdWHERE symbol = 'SOL'AND DATE_TRUNC('week', minute) >= DATE '2025-03-15'GROUP BY 1),filtered_trades AS (SELECTDATE_TRUNC('week', s.block_time) AS week,CASEWHEN 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 (SELECTweek,SUM(CASE WHEN quoteMint IN ('So11111111111111111111111111111111111111112','mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So') THEN protocol_fee_usd_equiv ELSE 0 END) AS weekly_protocol_fees_sol,SUM(CASE WHEN quoteMint IN (