andy-parafiMEV
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
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