DT | NUM_TXS | TOTAL_FEES | BASE_FEES | PRIORITY_FEES | AVG_PRIORITY_FEE_PER_TX | |
|---|---|---|---|---|---|---|
1 | 2024-12-01 00:00:00.000 | 51624348 | 15037209146765 | 293631275000 | 14743577871765 | 285593.493050314 |
2 | 2024-12-02 00:00:00.000 | 52468810 | 16176856810461 | 300685975000 | 15876170835461 | 302583.017138391 |
3 | 2024-12-03 00:00:00.000 | 58258370 | 16209538028072 | 334470210000 | 15875067818072 | 272494.198139632 |
4 | 2024-12-04 00:00:00.000 | 52113206 | 14290637409792 | 298594290000 | 13992043119792 | 268493.232210507 |
5 | 2024-12-05 00:00:00.000 | 53504372 | 14320557097791 | 307901070000 | 14012656027791 | 261897.402099982 |
6 | 2024-12-06 00:00:00.000 | 52275198 | 13324886298372 | 301384000000 | 13023502298372 | 249133.485795157 |
7 | 2024-12-07 00:00:00.000 | 52322993 | 10960474822483 | 300151015000 | 10660323807483 | 203740.711229631 |
dani_syndicagrieving-black
Updated 2025-01-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
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-08 00:00:00'
AND succeeded = TRUE
GROUP BY
DATE_TRUNC('day', block_timestamp)
ORDER BY
dt ASC;
Last run: about 1 month ago
7
680B
41s