LTirrell2023-04-10 06:29 PM
    Updated 2023-04-10
    select
    count(DISTINCT tx_id) as num_tx,
    sum(fee) as total_fees,
    case
    when fee = 5000 then '01. normal'
    when fee = 10000 then '02. 2x sig'
    when fee = 15000 then '03. 3x sig'
    when fee = 20000 then '04. 4x sig'
    when fee = 25000 then '05. 5x sig'
    when fee = 30000 then '06. 6x sig'
    when fee = 35000 then '07. 7x sig'
    when fee = 40000 then '08. 8x sig'
    when fee = 45000 then '09. 9x sig'
    when fee = 50000 then '10. 10x sig'
    when fee = 55000 then '11. 11x sig'
    when fee = 60000 then '12. 12x sig'
    when fee = 65000 then '13. 13x sig'
    when fee = 70000 then '14. 14x sig'
    when fee = 75000 then '15. 15x sig'
    else '16. priority fee'
    end as fee_type
    from
    solana.core.fact_transactions
    where
    block_timestamp :: date between current_date - 8
    and current_date - 1
    group by
    fee_type
    Run a query to Download Data