DATE_TRUNC('day', block_timestamp) AS dt,

COUNT(*) as num_txs,

SUM(fee) as total_fees,

SUM(ARRAY_SIZE(signers) * 5000) as base_fees,

SUM(fee - (ARRAY_SIZE(signers) * 5000)) as priority_fees,

AVG(CAST(fee - (ARRAY_SIZE(signers) * 5000) AS DOUBLE)) as avg_priority_fee_per_tx

FROM

solana.core.fact_transactions

WHERE

block_timestamp >= TIMESTAMP '2024-12-01 00:00:00'

AND block_timestamp < TIMESTAMP '2024-12-15 00:00:00'

AND succeeded = TRUE

GROUP BY

DATE_TRUNC('day', block_timestamp)

ORDER BY

dt ASC;