NakedCollectorMASTER copy
    Updated 2024-09-28
    -- forked from d8a529ae-be3c-414f-ab5c-e730e7371a6c
    with ERC721 as(
    select
    --cast(block_timestamp as date),
    date_trunc('day', block_timestamp) as date,
    nft_address,
    case
    when nft_address = '0x74eb94b3b84bd3c28e36c6df7743fa7ffe1f84fd' then 'Azuki x AMBUSH IKZ'
    when nft_address = '0x1e52f7a450b08b1b249a4f4f54518fc5278c2285' then 'Azuki Twin Tigers Jacket (claim closed)'
    when nft_address = '0xccc1825cf04cae4d497b202d1434ec0f79ee535f' then '10KTF Kagami'
    when nft_address = '0x4b61413d4392c806e6d0ff5ee91e6073c21d6430' then 'Muri' --when nft_address = '0xed5af388653567af2f388e6224dc7c4b3241c544' then 'Azuki'
    -- when nft_address = '0x306b1ea3ecdf94ab739f1910bbda052ed4a9f949' then 'Azuki BEANZ Official'
    when nft_address = '0x28472a58a490c5e09a238847f66a68a47cc76f0f' then 'Adidas Into the Metaverse'
    when nft_address = '0x455c732fee7b5c3b09531439b598ead4817d5274' then 'Adidas IMPOSSIBLE BOX'
    when nft_address = '0xba0c9cf4da821dba98407cc4f9c11f6c7a5f9bbc' then 'Adidas Virtual Gear - Genesis Collection'
    when nft_address = '0xa49a0e5ef83cf89ac8aae182f22e6464b229efc8' then 'RTFKT Clone X Forging SZN 1 (claim closed)'
    when nft_address = '0x52a043ec29fbb9a1b142b8913a76c0bc592d0849' then 'RTFKT Clone X Forging SZN 1 (claim closed)'
    when nft_address = '0x029af5c555807c2b5d337478e5f895e8f3b557e2' then 'RTFKT Space Drip x Nike Air Force 1 (claim closed)'
    when nft_address = '0x86825dfca7a6224cfbd2da48e85df2fc3aa7c4b1' then 'RTFKT MNLTH'
    when nft_address = '0xf661d58cfe893993b11d53d11148c4650590c692' then 'RTFKT Cryptokicks'
    when nft_address = '0x9a06ef3a841316a9e2c1c93b9c21a7342abe484f' then 'RTFKT Skin Vial: EVO X'
    when nft_address = '0x212590b0dac9502e0591b79db4cedeb6356dcc36' then 'RTFKT AR Hoodie Pre-Forged'
    when nft_address = '0x1bb6edf7b129967d512086fbdf489ed659580916' then 'RTFKT AR Hoodie Forged'
    when nft_address = '0x348fc118bcc65a92dc033a951af153d14d945312' then 'RTFKT CloneX Mintvial'
    when nft_address = '0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b' then 'RTFKT CloneX'
    when nft_address = '0x6d4bbc0387dd4759eee30f6a482ac6dc2df3facf' then 'RTFKT x Nike MNLTH'
    when nft_address = '0x56a67d475ded20f1120d6377988ae12992888ac4' then 'RTFKT MNLTH X'
    when nft_address = '0x9930929903f9c6c83d9e7c70d058d03c376a8337' then 'RTFKT Creators'
    when nft_address = '0xb7be4001bff2c5f4a61dd2435e4c9a19d8d12343' then 'RTFKT PodX'
    when nft_address = '0xd3f69f10532457d35188895feaa4c20b730ede88' then 'RTFKT Space Drip'
    when nft_address = '0xc541fc1aa62384ab7994268883f80ef92aac6399' then 'RTFKT Space Drip 1.2'
    when nft_address = '0x0972290a80333d19c6703073c3e57134a4ca0127' then 'RTFKT Bonus Items'
    when nft_address = '0xae3d8d68b4f6c3ee784b2b0669885a315ba77c08' then 'RTFKT Punk Project Gen1'
    when nft_address = '0x2250D7c238392f4B575Bb26c672aFe45F0ADcb75' then 'FEWOCiOUS x RTFKT'
    when nft_address = '0x253ef258563e146f685e60219da56a6b75178e19' then 'RTFKT X RIMOWA'
    when nft_address = '0x11708dc8a3ea69020f520c81250abb191b190110' then 'RTFKT cIRL'
    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived