SELECT

date_trunc('day', block_timestamp) as date,

COUNT(DISTINCT tx_id) as tx_count

FROM terra.msgs

WHERE block_timestamp > getdate() - interval '30 days'

-- AND block_timestamp <= '2021-08-01'

GROUP BY 1

ORDER BY 1 ASC

date_trunc('day', block_timestamp) as date,

fee[0]:denom::string as currency,

sum(fee[0]:amount)/POW(10,6) as fee,

count(tx_count) as total_transaction

FROM terra.transactions m

INNER JOIN this_data c

ON date = c.date

WHERE block_timestamp > getdate() - interval '30 days'

-- AND block_timestamp <= '2021-08-01'

AND currency = 'uusd'

GROUP BY 1,2

ORDER BY 1 ASC