flipside

    sum of transaction fee per day
    kiacryptosum of transaction fee per day
    Updated 2022-02-04
    SELECT date_trunc(day, block_timestamp) as "day", sum(fee)
    FROM algorand.transactions
    where block_timestamp >= to_timestamp('2021-01-01T00:00:00', 'YYYY-MM-DD"T"HH24:MI:SS')
    GROUP by "day"

    Run a query to Download Data