KaskoazulLuart NFT Project Volume Original
Updated 2022-02-10
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:"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