date_trunc('day', block_timestamp) as date,

count(event_amount) as transactions

FROM terra.transfers

WHERE (event_from_address_label = 'chai'

OR event_to_address_label = 'chai')

AND event_currency = 'KRT'

AND date >= '2021-01-01'

AND tx_status = 'SUCCEEDED'

GROUP BY 1

ORDER BY 1 ASC