kidaLevana Meteors
Updated 2022-05-31
99
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
›
⌄
WITH cracked_meteors as (
SELECT
msg_value:execute_msg:mint:extension:attributes[0]:value::string as rarity,
COUNT(DISTINCT msg_value:execute_msg:mint:token_id) as num_meteors_cracked
FROM terra.msgs
WHERE
msg_value:execute_msg:mint is not null
AND msg_value:contract IN ('terra1p70x7jkqhf37qa7qm4v23g4u4g8ka4ktxudxa7','terra1k0y373yxqne22pc9g7jvnr4qclpsxtafevtrpg')
GROUP BY rarity
),
meteors as (
SELECT
msg_value:execute_msg:mint:extension:attributes[0]:value::string as rarity,
COUNT(DISTINCT msg_value:execute_msg:mint:token_id) as num_meteors
FROM terra.msgs
WHERE
msg_value:execute_msg:mint is not null
AND msg_value:contract = 'terra1chrdxaef0y2feynkpq63mve0sqeg09acjnp55v'
GROUP BY rarity
)
SELECT
cracked_meteors.rarity,
num_meteors as total_meteors,
num_meteors_cracked as cracked,
num_meteors - num_meteors_cracked as uncracked,
CONCAT(((num_meteors_cracked / num_meteors) * 100), '%') as cracked_pct
FROM cracked_meteors
JOIN meteors
ON cracked_meteors.rarity = meteors.rarity
Run a query to Download Data