maybeyonaslevana_egg_owners
Updated 2021-12-18
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
meteor_info as (
select
block_timestamp,
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:execute_msg:mint:extension:attributes[3]:value::string as distance,
msg_value:execute_msg:mint:extension:attributes[4]:value::string as crystal1,
msg_value:execute_msg:mint:extension:attributes[5]:value::string as crystal2,
msg_value:execute_msg:mint:extension:attributes[6]:value::string as crystal3,
msg_value:execute_msg:mint:extension:attributes[7]:value::string as weight,
msg_value:execute_msg:mint:extension:attributes[8]:value::string as origin,
msg_value:execute_msg:mint:extension:attributes[9]:value::string as essence,
msg_value:execute_msg:mint:owner::string as owner,
msg_value:execute_msg:mint:token_id::string as token_id
-- 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_info as (
select
block_timestamp,
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 origin,
msg_value:execute_msg:mint:extension:attributes[3]:value::string as cracking_date,
msg_value:execute_msg:mint:extension:attributes[4]:value::string as essence,
msg_value:execute_msg:mint:extension:attributes[5]:value::string as rune,
msg_value:execute_msg:mint:extension:attributes[6]:value::string as infusion,
msg_value:execute_msg:mint:extension:attributes[7]:value::string as affecting_moon,
msg_value:execute_msg:mint:extension:attributes[8]:value::string as lucky_no,
msg_value:execute_msg:mint:extension:attributes[9]:value::string as constellation,
Run a query to Download Data