date(block_timestamp),

count(tx_id) as number_of_instant_burns

from terra.msgs m

where msg_value:contract = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp'

and msg_value:execute_msg:send:msg:swap is not null

and tx_status = 'SUCCEEDED'

group by 1

order by 1 desc;