amirozaUntitled Query
Updated 2022-02-10
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
32
33
34
35
36
›
⌄
SELECT case event_attributes:"nft_contract_address"
WHEN 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k' THEN 'Galactic Punks'
WHEN 'terra1trn7mhgc9e2wfkm5mhr65p3eu7a2lc526uwny2' THEN 'LunaBulls'
WHEN 'terra1uv9w7aaq6lu2kn0asnvknlcgg2xd5ts57ss7qt' THEN 'HellCats'
WHEN 'terra1ggv86dkuzmky7ww20s2uvm6pl2jvl9mv0z6zyt' THEN 'DystopAI'
WHEN 'terra1qpu42s4hrrnvxsxr428scd5st9zd4fmn5me38t' THEN 'LunaShield'
WHEN 'terra1p4mlfdwm4h0hvyv0c64kmj3afs5zzj3t2jszvw' THEN 'Columbus Omnia Luna'
WHEN 'terra1zvmesqul8ss2ty84eml8aqkq0kq5ydwjuyf6a3' THEN 'BabyBulls'
WHEN 'terra1lfr4aja5a2xpxvnrl4gyjpru0wwglu7k87jmeq' THEN 'Hero'
WHEN 'terra1sux7jjk9vfd0q6z0l99wpg07yd0wme0ac9le40' THEN 'The Crunks'
WHEN 'terra1934kn7p03ns94htl75zpzsg0n4yvw8yf2746ep' THEN 'Styllar'
WHEN 'terra1wcdapxh8030czdketyfemsa7lndsmpmk2e76l5' THEN 'WagmiKongz'
WHEN 'terra1jp5fjj7rlc0erw4z3qr5zuvmg2w49pfzyhvsnk' THEN 'WagmiMonkeez'
WHEN 'terra1jdt2wnfhgy4ptk6m5kxacyj0k6e8rc7e2ugulz' THEN 'TerraWhales'
WHEN 'terra13ptfhnrl7n2zcq8369s39a5eqg85xxtj77jtuh' THEN 'Astroverse x Vinboy'
WHEN 'terra1xv0as2esvwqcuaqtdhvrdhykrfe75qw42tgh6f' THEN 'Astroverse #02'
WHEN 'terra1y076t8yrj0t4ag969w92ez9qfdj0c6dn7xhmkq' THEN 'Astroverse'
WHEN 'terra1nyqyxamvuhtd8h756tkqsejc7plj6lr5gdfj5e' THEN 'LUNILAND #1'
WHEN 'terra1np0zunma7m6380munyvmnk9qezjd5p742geed6' THEN 'LUNILAND #1 Supplementary'
WHEN 'terra12uxqcqfqrr9hrzen6pz0fx565hr8u88qfyusc0' THEN 'Mint DAO'
WHEN 'terra1h9rhu457nllgrh4w8rcmc2exv6nvfcjdnd30j0' THEN 'Silent Solohs'
WHEN 'terra1whyze49j9d0672pleaflk0wfufxrh8l0at2h8q' THEN 'Terranauts'
WHEN 'terra1lt4e5r5rhddhercgpk6v567z2yd3ucxq5n8jsh' THEN 'Red Eyed Space Toads'
WHEN 'terra1ygy58urzh826al6ktlskh4z6hnd2aunhcn0cvm' THEN 'Galactic Gridz'
WHEN 'Dirty Bears' THEN 'Dirty Bears'
ELSE 'Unknown' end as nft_name,
m.block_timestamp::date,
m.event_attributes:"price"/pow(10,6)*p.price_usd as price_usd,
m.event_attributes:"price"/pow(10,6) as PRICE_LUNA,
m.event_attributes:"0_token_id" as token_id
FROM terra.msg_events m
INNER JOIN terra.oracle_prices p
on m.block_timestamp::date = p.block_timestamp and symbol = 'LUNA'
WHERE m.event_attributes:"0_contract_address" = 'terra1fj44gmt0rtphu623zxge7u3t85qy0jg6p5ucnk'
and m.event_type = 'wasm'
and m.event_attributes:"order_type" = 'sell'