KaskoazulLuart Top 10 NFT Sales with TokenID
Updated 2022-02-11
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
SALES_USD AS(
SELECT
e.block_timestamp,
e.tx_id,
CASE e.event_attributes:"nft_contract_address"
WHEN 'terra1uv9w7aaq6lu2kn0asnvknlcgg2xd5ts57ss7qt' THEN 'HellCats'
WHEN 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k' THEN 'Galactic Punks'
WHEN 'terra1ggv86dkuzmky7ww20s2uvm6pl2jvl9mv0z6zyt' THEN 'DystopAI'
WHEN 'terra1trn7mhgc9e2wfkm5mhr65p3eu7a2lc526uwny2' THEN 'LunaBulls'
WHEN 'terra1934kn7p03ns94htl75zpzsg0n4yvw8yf2746ep' THEN 'Styllar'
WHEN 'terra1lfr4aja5a2xpxvnrl4gyjpru0wwglu7k87jmeq' THEN 'Hero'
WHEN 'terra1ygy58urzh826al6ktlskh4z6hnd2aunhcn0cvm' THEN 'Galactic Gridz'
WHEN 'terra12uxqcqfqrr9hrzen6pz0fx565hr8u88qfyusc0' THEN 'Mint DAO'
WHEN 'terra1h9rhu457nllgrh4w8rcmc2exv6nvfcjdnd30j0' THEN 'Silent Solohs'
WHEN 'terra1p4mlfdwm4h0hvyv0c64kmj3afs5zzj3t2jszvw' THEN 'Columbus Omnia Luna'
WHEN 'terra1sux7jjk9vfd0q6z0l99wpg07yd0wme0ac9le40' THEN 'The Crunks'
WHEN 'terra1p6p58amsfxe534dc9enfxdz5wf58z8ysu2nr8v' THEN 'Dirty Bears Country Club'
WHEN 'terra1jdt2wnfhgy4ptk6m5kxacyj0k6e8rc7e2ugulz' THEN 'TerraWhales'
WHEN 'terra13ptfhnrl7n2zcq8369s39a5eqg85xxtj77jtuh' THEN 'Astroverse x Vinboy'
WHEN 'terra1xv0as2esvwqcuaqtdhvrdhykrfe75qw42tgh6f' THEN 'Astroverse #02'
WHEN 'terra1y076t8yrj0t4ag969w92ez9qfdj0c6dn7xhmkq' THEN 'Astroverse'
WHEN 'terra1wcdapxh8030czdketyfemsa7lndsmpmk2e76l5' THEN 'WagmiKongz'
WHEN 'terra1jp5fjj7rlc0erw4z3qr5zuvmg2w49pfzyhvsnk' THEN 'WagmiMonkeez'
WHEN 'terra1qpu42s4hrrnvxsxr428scd5st9zd4fmn5me38t' THEN 'LunaShield'
WHEN 'terra1np0zunma7m6380munyvmnk9qezjd5p742geed6' THEN 'LUNILAND #1 Supplementary'
WHEN 'terra1zvmesqul8ss2ty84eml8aqkq0kq5ydwjuyf6a3' THEN 'BabyBulls'
WHEN 'terra1nyqyxamvuhtd8h756tkqsejc7plj6lr5gdfj5e' THEN 'LUNILAND #1'
WHEN 'terra1lt4e5r5rhddhercgpk6v567z2yd3ucxq5n8jsh' THEN 'Red Eyed Space Toads'
WHEN 'terra1whyze49j9d0672pleaflk0wfufxrh8l0at2h8q' THEN 'Terranauts'
END AS NFT_PROJECT,
e.event_attributes:"0_token_id" as TOKEN_ID,
e.event_attributes:"price"/pow(10,6) as PRICE_USD
FROM
terra.msg_events e
WHERE