amirozaUntitled Query
    Updated 2022-02-10
    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'