WITH epoch_fees AS (
    SELECT
    bp.block_slot,
    bp.block_timestamp,
    bp.epoch,
    bp.producer_identity,
    bp.fee_mev,
    bp.fee_burned
    FROM solana.core.fact_blocks bp
    WHERE bp.epoch >= (SELECT MAX(epoch) - 400 FROM solana.core.fact_blocks)
    )

    SELECT
    epoch,
    COUNT(DISTINCT block_slot) as blocks_produced,
    COUNT(DISTINCT producer_identity) as unique_validators,
    SUM(fee_mev) as total_mev_fees,
    AVG(fee_mev) as avg_mev_per_block,
    SUM(fee_burned) as total_fees_burned,
    DATE_TRUNC('day', block_timestamp) as date
    FROM epoch_fees
    GROUP BY epoch, DATE_TRUNC('day', block_timestamp)
    ORDER BY epoch DESC;
    Run a query to Download Data