WITH medPriorityRate1h as ( SELECT CASE WHEN ((fee - 5000) * 1E6) / units_consumed <= 0 THEN '0' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1 AND 10 THEN '1 to 10' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 10 AND 100 THEN '10 to 100' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E2 AND 1E3 THEN '100 to 1,000' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E3 AND 1E4 THEN '1E3 to 1E4' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E4 AND 1E5 THEN '1E4 to 1E5' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E5 AND 1E6 THEN '1E5 to 1E6' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E6 AND 1E7 THEN '1E6 to 1E7' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E7 AND 1E8 THEN '1E7 to 1E8' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E8 AND 1E9 THEN '1E8 to 1E9' WHEN ((fee - 5000) * 1E6) / units_consumed >= 1E9 THEN '>1E9' ELSE 'Other' -- for fees less than 1E-5 or any unexpected values END AS priority_range, COUNT(*) AS count FROM solana.core.fact_transactions WHERE block_timestamp > CURRENT_TIMESTAMP() - INTERVAL '1 hours' GROUP BY priority_range ORDER BY MIN(CASE WHEN (((fee - 5000) * 1E6) / units_consumed) <= 0 THEN 0 WHEN (((fee - 5000) * 1E6) / units_consumed) <= 1E0 THEN 1 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E1 THEN 2 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E2 THEN 3 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E3 THEN 4 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E4 THEN 5 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E5 THEN 6 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E6 THEN 7 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E7 THEN 8 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E8 THEN 9 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E9 THEN 10 ELSE 11 END) ) ,medPriorityRate4h as ( SELECT CASE WHEN ((fee - 5000) * 1E6) / units_consumed <= 0 THEN '0' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1 AND 10 THEN '1 to 10' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 10 AND 100 THEN '10 to 100' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E2 AND 1E3 THEN '100 to 1,000' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E3 AND 1E4 THEN '1E3 to 1E4' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E4 AND 1E5 THEN '1E4 to 1E5' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E5 AND 1E6 THEN '1E5 to 1E6' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E6 AND 1E7 THEN '1E6 to 1E7' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E7 AND 1E8 THEN '1E7 to 1E8' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E8 AND 1E9 THEN '1E8 to 1E9' WHEN ((fee - 5000) * 1E6) / units_consumed >= 1E9 THEN '>1E9' ELSE 'Other' -- for fees less than 1E-5 or any unexpected values END AS priority_range, COUNT(*) AS count FROM solana.core.fact_transactions WHERE block_timestamp > CURRENT_TIMESTAMP() - INTERVAL '4 hours' GROUP BY priority_range ORDER BY MIN(CASE WHEN (((fee - 5000) * 1E6) / units_consumed) <= 0 THEN 0 WHEN (((fee - 5000) * 1E6) / units_consumed) <= 1E0 THEN 1 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E1 THEN 2 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E2 THEN 3 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E3 THEN 4 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E4 THEN 5 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E5 THEN 6 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E6 THEN 7 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E7 THEN 8 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E8 THEN 9 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E9 THEN 10 ELSE 11 END) ), medPriorityRate24h as ( SELECT CASE WHEN ((fee - 5000) * 1E6) / units_consumed <= 0 THEN '0' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1 AND 10 THEN '1 to 10' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 10 AND 100 THEN '10 to 100' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E2 AND 1E3 THEN '100 to 1,000' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E3 AND 1E4 THEN '1E3 to 1E4' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E4 AND 1E5 THEN '1E4 to 1E5' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E5 AND 1E6 THEN '1E5 to 1E6' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E6 AND 1E7 THEN '1E6 to 1E7' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E7 AND 1E8 THEN '1E7 to 1E8' WHEN ((fee - 5000) * 1E6) / units_consumed BETWEEN 1E8 AND 1E9 THEN '1E8 to 1E9' WHEN ((fee - 5000) * 1E6) / units_consumed >= 1E9 THEN '>1E9' ELSE 'Other' -- for fees less than 1E-5 or any unexpected values END AS priority_range, COUNT(*) AS count FROM solana.core.fact_transactions WHERE block_timestamp > CURRENT_TIMESTAMP() - INTERVAL '24 hours' GROUP BY priority_range ORDER BY MIN(CASE WHEN (((fee - 5000) * 1E6) / units_consumed) <= 0 THEN 0 WHEN (((fee - 5000) * 1E6) / units_consumed) <= 1E0 THEN 1 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E1 THEN 2 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E2 THEN 3 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E3 THEN 4 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E4 THEN 5 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E5 THEN 6 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E6 THEN 7 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E7 THEN 8 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E8 THEN 9 WHEN (((fee - 5000) * 1E6) / units_consumed) < 1E9 THEN 10 ELSE 11 END) ) SELECT p1h.PRIORITY_RANGE, p1h.COUNT as TX_COUNT_1h, p4h.count as TX_COUNT_4h, p24h.count as TX_COUNT_24h FROM medPriorityRate1h p1h JOIN medPriorityRate4h p4h ON p1h.PRIORITY_RANGE = p4h.PRIORITY_RANGE JOIN medPriorityRate24h p24h ON p1h.PRIORITY_RANGE = p24h.PRIORITY_RANGE ORDER BY p1h.PRIORITY_RANGE;

SOLANA GAS TRACKER