AlishTerra Transaction fee
    Updated 2022-03-29
    SELECT
    to_date(block_timestamp) as date,
    sum(fee[0].amount[0].amount :: INTEGER/1e9) as amt,
    (fee[0].amount[0].denom :: STRING) as denom
    FROM terra.transactions
    WHERE array_size(fee[0].amount) > 0
    AND date>='2022-01-01'
    GROUP BY date, denom
    ORDER BY date

    Run a query to Download Data