date_trunc('day',block_timestamp) as day,

count(*) as sales,

case

when nft_address = '0x81b30ff521d1feb67ede32db726d95714eb00637' and address_name is null then 'Optimistic Explorer'

when nft_address = '0x69a68eb548a37ee475d9f89646945588558796d1' and address_name is null then 'Oliens'

when nft_address = '0xe0a3711d4286e628998d47bef524c292defd1719' and address_name is null then 'Holo Mask : White & Black'

when nft_address = '0x40426c367f44c37e10f0a452574c2f84dcba3038' and address_name is null then 'Galaxy Gans'

when nft_address = '0x0d21136236c0731378286be2ea3611a19280dd56' and address_name is null then 'Holo Mask : Blue'

when nft_address = '0x5c9d55b78febcc2061715ba4f57ecf8ea2711f2c' and address_name is null then 'motorheadz'

when nft_address = '0x80fe12c1076d2b708d6495186690f6d275740d44' and address_name is null then 'My Missing Jigsaw'

when nft_address = '0x441f60b4e1f7e973cc5baafcd6d5b065eef90358' and address_name is null then 'L3s Quarterly Report (June)'

when nft_address = '0x2e6a5b24bfe6c2e45a0f1af5bb5eb6e362129e2c' and address_name is null then 'Airgans'

when nft_address = '0x9b66424ad77a243f4b3cc5b59b236162b39f5b02' and address_name is null then 'Optimistic Dishes #1'

when nft_address = '0x2abecf0d844c85eca7a08ea7a2d6747c8a6662a2' and address_name is null then 'Jigsaw Launchpad'

when nft_address = '0xc480325c86392b773cbad885759c205f26d91bbb' and address_name is null then 'JustBanana'

when nft_address = '0x7a1adbf33fd7bddd0a901692a352eafbb6f9e371' and address_name is null then '8 Dwarfs'

when nft_address = '0xef32a67bef57125f05f244310820acf1d278971e' and address_name is null then 'Bored WOW'

when nft_address = '0xb5c4fc379064258c4c9b197e99fd3efd9f2f21e3' and address_name is null then 'moody kittens'

when nft_address = '0x72294ea069fcafb98a960cadf80b2452360e44e1' and address_name is null then 'Silly Seals'

when nft_address = '0xb7ee42a295bcc8caebea298d3c3473d97c8fa16d' and address_name is null then 'RabbitHole Quests x NFT Artist'

when nft_address = '0xb489a7b15f0797c104d759dc4a308d6fb84f1a50' and address_name is null then 'Crypto Geometric (OPT)'

when nft_address = '0x29402faf14780906895b3093d05e3db4fc6b9a50' and address_name is null then 'XiaoTuTus Links'

when nft_address = '0x325865cfd0b482abdd7cece30c86e8ee8c186dac' and address_name is null then 'turnips'

when nft_address = '0xa4b00887accd7b5f5325732b4e82b98630129b67' and address_name is null then 'BETA'

when nft_address = '0x8b50fde10e6d2256b12dd839f92130c5d20c1e51' and address_name is null then 'Holo Mask : Gold'

when nft_address = '0x7ed8f3ad5268e5593042cd0c16edb566c308896f' and address_name is null then 'Cosmoball'

when nft_address = '0x7b95fe8957387fca48ac7c94ca073a56a471fd2a' and address_name is null then 'Aetherwarden'

when nft_address = '0xcdd9c8804c0ed7db5a4cdda55605d0621afba7fc' and address_name is null then 'Feline the cute'

when nft_address = '0xd20ca30dedfe25bde730b098601268ec9c02a15f' and address_name is null then 'Come for the creator, stay for the economy'

when nft_address = '0x31fcf00d84a3ccc36a299412741e7cc754ac0466' and address_name is null then 'MUTED🔇'

when nft_address = '0x8cc3b11ef2102d54360e25dbb43514095144af72' and address_name is null then 'สรุป ครบ จบโพสต์เดียว ต้นกำเนิด การนำไปใช้ การลงทุน Web3, อินเทอร์เน็ตแห่งโลกอนาคต!'

when nft_address = '0x5649cb6ac4870d617bc13604b06f2e2db5c13f15' and address_name is null then 'OmniSkulls'

when nft_address = '0x2da61a0ec93e3209c0046397ba9aa3e2bcc339f9' and address_name is null then 'Optical Xplosions'

when nft_address = '0x36bfdb5d2217452f1f2eccdd4af88e263e412888' and address_name is null then 'R.o.s.e.s (OPT)'