boomer77Top NFTs Sold on Luart
Updated 2022-02-08
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
›
⌄
with luart as (select block_timestamp, tx_id, event_attributes:nft_contract_address::string as NFT, event_attributes:"1_token_id" as NFT_ID,
event_attributes:price/1e6 as Price,
event_attributes:denom::string as currency
from terra.msg_events
where event_type = 'wasm' and event_attributes:"1_sender"::string = 'terra1fj44gmt0rtphu623zxge7u3t85qy0jg6p5ucnk' and tx_status = 'SUCCEEDED'
and event_attributes:method::string = 'execute_order'),
final as (select NFT, NFT_ID, currency, price, case
when currency = 'uluna' then 'LUNA'
when currency = 'uusd' then 'UST' end as denom, case
when NFT = 'terra1uv9w7aaq6lu2kn0asnvknlcgg2xd5ts57ss7qt' then 'Hellcats'
when NFT = 'terra1nyqyxamvuhtd8h756tkqsejc7plj6lr5gdfj5e' then 'LUNI'
when NFT = 'terra1zvmesqul8ss2ty84eml8aqkq0kq5ydwjuyf6a3' then 'BabyBulls'
when NFT = 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k' then 'Galactic Punks'
when NFT = 'terra1934kn7p03ns94htl75zpzsg0n4yvw8yf2746ep' then 'Styllar'
when NFT = 'terra1ggv86dkuzmky7ww20s2uvm6pl2jvl9mv0z6zyt' then 'dystopAI'
when NFT = 'terra1trn7mhgc9e2wfkm5mhr65p3eu7a2lc526uwny2' then 'LunaBulls'
when NFT = 'terra1qpu42s4hrrnvxsxr428scd5st9zd4fmn5me38t' then 'Luna Shield'
when NFT = 'terra1lfr4aja5a2xpxvnrl4gyjpru0wwglu7k87jmeq' then 'Hero NFT'
when NFT = 'terra1jp5fjj7rlc0erw4z3qr5zuvmg2w49pfzyhvsnk' then 'wagmimonkeez'
when NFT = 'terra1wcdapxh8030czdketyfemsa7lndsmpmk2e76l5' then 'wagmikongz'
when NFT = 'terra1np0zunma7m6380munyvmnk9qezjd5p742geed6' then 'LUNI 2'
when NFT = 'terra1jdt2wnfhgy4ptk6m5kxacyj0k6e8rc7e2ugulz' then 'TerraWhales'
when NFT = 'terra1xv0as2esvwqcuaqtdhvrdhykrfe75qw42tgh6f' then 'Astroverse #02'
when NFT = 'terra1p4mlfdwm4h0hvyv0c64kmj3afs5zzj3t2jszvw' then 'Columbus Omnia Luna'
when NFT = 'terra1sux7jjk9vfd0q6z0l99wpg07yd0wme0ac9le40' then 'The Crunks'
when NFT = 'terra13ptfhnrl7n2zcq8369s39a5eqg85xxtj77jtuh' then 'Astroverse x Vinboy'
when NFT = 'terra1lt4e5r5rhddhercgpk6v567z2yd3ucxq5n8jsh' then 'Red Eyed Space Toads'
when NFT = 'terra1y076t8yrj0t4ag969w92ez9qfdj0c6dn7xhmkq' then 'Astroverse'
when NFT = 'terra1whyze49j9d0672pleaflk0wfufxrh8l0at2h8q' then 'Terranauts'
end as NFT_Collection
from luart
where price is not null)
select concat(NFT_collection,'#', NFT_id) as NFT_token, price, denom
from final
Run a query to Download Data