flipside

    Plot fees generated over time by day on Algorand since the beginning of 2021
    elsinaPlot fees generated over time by day on Algorand since the beginning of 2021
    Updated 2022-02-20
    select
    date_trunc('day', block_timestamp) as tx_day , sum(iff(fee is null ,0,fee)) as sum
    from algorand.transactions
    where to_date('2021-01-01') <block_timestamp
    group by tx_day
    order by tx_day ASC
    Run a query to Download Data