with meteor_data as(
select block_timestamp, msg_value:execute_msg:mint:owner::string as owner,
msg_value:execute_msg:mint:token_id::string as token_id,
msg_value:execute_msg:mint:extension:attributes[0]:value::string as rarity,
msg_value:execute_msg:mint:extension:attributes[1]:value::string as rank,
msg_value:execute_msg:mint:extension:attributes[2]:value::string as shower,
msg_value
from terra.msgs
where msg_value:contract::string = 'terra1chrdxaef0y2feynkpq63mve0sqeg09acjnp55v'
and msg_value:sender::string = 'terra1v7v2nqs7flrpqqam7l5ulvnva8ly8j653sw4n3'
and msg_value:execute_msg:mint is not null
and tx_status = 'SUCCEEDED')
select count(*) as number_of_meteors from meteor_data