date_trunc('day', block_timestamp) as datec,

sum(EVENT_AMOUNT) as total_chai_tx,

count(tx_id)

FROM terra.transfers

WHERE

(event_from_address_label = 'chai'

OR event_to_address_label = 'chai')

and event_to_address_label is not null

AND datec BETWEEN '2021-03-11' AND '2021-08-31'

group by 1

order by 1