DAY | NON_VOTE_TXN_BASE | CUM_BASE_FEE | NON_VOTE_TXN_PRIORITY | CUM_PRIORITY_FEE | |
|---|---|---|---|---|---|
1 | 2025-03-25 00:00:00.000 | 126.974215 | 30754.553605 | 1792.82513 | 808489.73712 |
2 | 2025-03-24 00:00:00.000 | 504.258885 | 30627.57939 | 7274.335858 | 806696.91199 |
3 | 2025-03-23 00:00:00.000 | 488.311885 | 30123.320505 | 4074.532663 | 799422.576132 |
4 | 2025-03-22 00:00:00.000 | 433.58012 | 29635.00862 | 3018.678156 | 795348.043469 |
5 | 2025-03-21 00:00:00.000 | 423.542705 | 29201.4285 | 2891.179838 | 792329.365313 |
6 | 2025-03-20 00:00:00.000 | 439.657955 | 28777.885795 | 5222.774381 | 789438.185475 |
7 | 2025-03-19 00:00:00.000 | 502.41974 | 28338.22784 | 5044.333525 | 784215.411094 |
8 | 2025-03-18 00:00:00.000 | 506.753555 | 27835.8081 | 4764.884141 | 779171.077569 |
9 | 2025-03-17 00:00:00.000 | 493.809845 | 27329.054545 | 5649.430675 | 774406.193428 |
10 | 2025-03-16 00:00:00.000 | 420.922345 | 26835.2447 | 4677.410365 | 768756.762753 |
11 | 2025-03-15 00:00:00.000 | 450.920705 | 26414.322355 | 5502.270573 | 764079.352388 |
12 | 2025-03-14 00:00:00.000 | 463.37192 | 25963.40165 | 5217.610869 | 758577.081815 |
13 | 2025-03-13 00:00:00.000 | 465.34969 | 25500.02973 | 5716.413364 | 753359.470946 |
14 | 2025-03-12 00:00:00.000 | 483.44137 | 25034.68004 | 5802.21022 | 747643.057582 |
15 | 2025-03-11 00:00:00.000 | 455.168145 | 24551.23867 | 5286.848623 | 741840.847362 |
16 | 2025-03-10 00:00:00.000 | 469.008705 | 24096.070525 | 5453.661926 | 736553.998739 |
17 | 2025-03-09 00:00:00.000 | 445.531675 | 23627.06182 | 4706.01464 | 731100.336813 |
18 | 2025-03-08 00:00:00.000 | 466.140375 | 23181.530145 | 5497.619017 | 726394.322173 |
19 | 2025-03-07 00:00:00.000 | 543.83566 | 22715.38977 | 9055.163026 | 720896.703156 |
20 | 2025-03-06 00:00:00.000 | 492.020085 | 22171.55411 | 6435.076409 | 711841.54013 |
ArioBase and Priority Fees
Updated 2025-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with non_vote as (select
date_trunc(day, block_timestamp) as day,
sum(case
when fee/ARRAY_SIZE(signers)/1e9>0.000005 then 0.000005*ARRAY_SIZE(signers)
else fee/1e9 end)
as non_vote_txn_base,
sum(non_vote_txn_base) over(order by day) as CUM_Base_Fee,
sum(case
when fee/ARRAY_SIZE(signers)/1e9>0.000005 then fee/1e9-0.000005*ARRAY_SIZE(signers)
else 0 end)
as non_vote_txn_priority,
sum(non_vote_txn_priority) over(order by day) as Cum_Priority_Fee
from solana.core.fact_transactions
where block_timestamp > current_date - 60
group by 1
)
select * from non_vote
order by day desc
Last run: 10 days ago
61
5KB
437s