KaskoazulLuart NFT Project Volume Original
    Updated 2022-02-10
    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:"price"/pow(10,6) as PRICE_USD
    FROM
    terra.msg_events e
    WHERE
    e.block_timestamp >= '2021-12-27'
    Run a query to Download Data