Madidf
Updated 2022-10-28
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 df as (SELECT
CASE
WHEN contract_address = '0x91ac106090fe2b0fa7d01efdf4487a5bfafad7fa' then 'Spooky Season'
WHEN contract_address = '0xe1b5e23fdbc003aec16e6e79726a0b5f75ff93f5' then 'Spooky Season: tfoust10'
WHEN contract_address = '0x3e4627665bf2e52c69be03788e664ab545f2be71' then 'Spooky Season Rojom'
WHEN contract_address = '0x81ba34b90876f42f34a4f232cfc0fe4b6ec949a3' then 'Spooky Season: StutterVoid'
WHEN contract_address = '0x621ce7e7e44d43a428a183d5390c4f4572c9ff9d' then 'Spooky Season: eando9745'
WHEN contract_address = '0xdaa6e4ba2d4022ed820460bb501b9e061d9614fb' then 'Spooky Season Sys32Template'
WHEN contract_address = '0x3458161f2dc5d7eafa48e7c8d9acd7f415cf6da6' then 'Spooky Season Conall-in-Space'
WHEN contract_address = '0x8264e2bad3d2f7afd72a00233b9f841fe4b388cd' then 'Spooky Season Earth To Planet'
WHEN contract_address = '0xc70a7496716b3e25546901fe88215531abbd5a10' then 'Spooky Season Genuine Ardvark'
WHEN contract_address = '0x150afa2dfcaaada471472dfa6ad4b79e718a197c' then ' Spooky Season TreasureOfOphiel'
WHEN contract_address = '0x97439ee4c93ff9f76417696ce648aa6f35ab3b25' then ' Creatures of the Nighties'
WHEN contract_address = '0x425bf054ef7bad65b7bdd8e6587b1c3500e4f4ca' then ' Avatar Rock Out'
WHEN contract_address = '0x2956409293da98603025cc0121c06a4244752039' then ' Protectwhens of the Fwhenest'
WHEN contract_address = '0x47749c5b970e63f3a0ed57cd6cef773e74fafe9d' then ' Cute, Cool and Creepy'
WHEN contract_address = '0xc5aa1f91b0d52e26d2847f8e51f505d6e2ece795' then 'Lightspeed Lads'
WHEN contract_address = '0xee1ee80338958fa596471ceb70f0177daff80323' then 'Growl Gang'
WHEN contract_address = '0x4670e4890bc1b76f3ae5c7660aa98e0b6668c6f3' then 'Old School Cool'
WHEN contract_address = '0x2d58a44d6c0a355de25761fb33a1f6269a97e2c5' then ' Aylia'
WHEN contract_address = '0xd8cf23bf309de778609d234bd2410b0156118c26' then 'Magic of the Woods'
WHEN contract_address = '0xd6261320f49d38c137f6e229a2ea4ab0f4fae6de' then ' Peculiar Gang'
WHEN contract_address = '0xfc190440e8f357ffe8a75940e7d8a291e165d019' then 'Gettin Groovy'
WHEN contract_address = '0x808ed3e23aac685126524aa4416d8eaeb2e767b9' then ' Wearing Your Emotions'
WHEN contract_address = '0x65a83530ca8abc27969907913fe5e641a5da2e9f' then 'I quit my job to be an Artist'
WHEN contract_address = '0x6d1c3646e8cce8537e6ec9ecab26762bfaf1f891' then ' Baked Goods & Evils'
WHEN contract_address = '0x63e2f0c058ce9a194ec68f04320b7eb8ca555bd3' then 'Enlightenment'
WHEN contract_address = '0x45308788743bbdae5de7ba9e565c0502d0ebb81f' then ' Doodle Collection'
WHEN contract_address = '0x907808732079863886443057c65827a0f1c64357' then 'Foustlings'
WHEN contract_address = '0x8d0501d85becda92b89e56177ddfcea5fc1f0af2' then 'The Senses'
WHEN contract_address = '0x946ad8e53db653053e8ef7c02dfca83ce8ba8022' then 'Natsukashii'
WHEN contract_address = '0x27b37e4befacc50b02102d1e2117c4ea8a54beff' then '5 Bwheno Bodega'
WHEN contract_address = '0x71dc46607f31f30510f0ccc670b0963f431b212a' then 'Celestial Assembly'
end as collection,
*
from polygon.core.fact_event_logs
Run a query to Download Data