binhachon3. [Easy] Brace for (Meteor) Impact - Meteor cracked by rarity
    Updated 2021-12-15
    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'),
    egg_data as(
    select block_timestamp,
    msg_value:execute_msg:mint:owner::string as owner,
    msg_value:execute_msg:mint:token_id::float 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,
    case
    when msg_value:execute_msg:mint:extension:attributes[0]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[0]:value::string
    when msg_value:execute_msg:mint:extension:attributes[1]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[1]:value::string
    when msg_value:execute_msg:mint:extension:attributes[2]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[2]:value::string
    when msg_value:execute_msg:mint:extension:attributes[3]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[3]:value::string
    when msg_value:execute_msg:mint:extension:attributes[4]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[4]:value::string
    when msg_value:execute_msg:mint:extension:attributes[5]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[5]:value::string
    when msg_value:execute_msg:mint:extension:attributes[6]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[6]:value::string
    when msg_value:execute_msg:mint:extension:attributes[7]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[7]:value::string
    when msg_value:execute_msg:mint:extension:attributes[8]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[8]:value::string
    when msg_value:execute_msg:mint:extension:attributes[9]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[9]:value::string
    when msg_value:execute_msg:mint:extension:attributes[10]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[10]:value::string
    when msg_value:execute_msg:mint:extension:attributes[11]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[11]:value::string
    when msg_value:execute_msg:mint:extension:attributes[12]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[12]:value::string
    when msg_value:execute_msg:mint:extension:attributes[13]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[13]:value::string
    when msg_value:execute_msg:mint:extension:attributes[14]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[14]:value::string
    when msg_value:execute_msg:mint:extension:attributes[15]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[15]:value::string
    when msg_value:execute_msg:mint:extension:attributes[16]:trait_type::string = 'Meteor ID' then msg_value:execute_msg:mint:extension:attributes[16]:value::string
    Run a query to Download Data