messarisolana priority txs
Updated 2024-07-01
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
-- forked from solana dailys @ https://flipsidecrypto.xyz/edit/queries/34996e52-7bb7-4cb9-aeb3-bca3fc6167d4
select
date(block_timestamp) as date,
count(DISTINCT CASE WHEN regexp_count(array_to_string(instructions, ','), 'ComputeBudget111111111111111111111111111111') = 2 THEN tx_id ELSE NULL END) AS priority_fee_tx_count
from solana.core.fact_transactions
where date(block_timestamp) between '2024-06-21' and '2024-06-20'
group by date
order by date asc
QueryRunArchived: QueryRun has been archived