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