date(block_timestamp),

sum(msg_value:execute_msg:send:amount / POW(10, 6)) as bLUNA_Burn_Amounts

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;