date_trunc('DAY',block_timestamp) as DATE,

count(tx_id) as Txs_per_day,

sum(fee) as Total_fees_per_day_lamparts,

Total_fees_per_day_lamparts*0.000000001 as Total_fees_per_day_SOL,

Total_fees_per_day_SOL*112.6 as Total_fees_per_day_USD,

sum(fee)/count(tx_id) as Total_fee_per_tx_per_day

FROM

solana.transactions

WHERE

DATE >= '2022-01-01'

AND succeeded = 'TRUE'

GROUP BY 1

ORDER BY 1