Total Fee paid per month last 3 year

behnamqTotal Fee paid per month last 3 year

Updated 2022-07-08

SELECT date_trunc('month',BLOCK_TIMESTAMP) as month_date,

sum(fee) as sum_fee, sum(sum_fee) over (ORDER by month_date) as accumulative_fee,

COUNT(tx_id) as count_tx, sum(count_tx) over (ORDER by month_date) as accumulative_count_tx,

avg(fee) as Average_fee,

avg(nvl(fee,0)) as Average_fee_bynull

from flipside_prod_db.algorand.transactions

group by month_date--, sender

Run a query to Download Data