Crazy_KidAnalysis of Solana Tx Fee from Jan 2022
    Updated 2022-02-08
    -- Create a visualization showing transaction fees per day accumulated since the beginning of January. Also create a visualization that shows transaction
    -- fees per transaction on each day. Do fees ever seem to spike or is it consistent?
    SELECT DATE(block_timestamp) as date, COUNT(tx_id) as no_of_txs, sum(fee*0.000000001) as total_tx_fees_in_sol, avg(fee) as fee_per_tx_in_lamport
    FROM solana.transactions
    WHERE DATE >= '2022-01-01'
    GROUP BY date
    ORDER BY date DESC
    Run a query to Download Data