-- 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