with pallet as (

select

block_timestamp::date as date,

tx_id,

seller_address as seller,

buyer_address as buyer,

amount as price,

amount_usd as price_usd,

nft_address as collection ,

project_name

from sei.nft.ez_nft_sales

where tx_succeeded = 'TRUE'

and platform_name ilike '%pallet%'

and block_timestamp::date >= current_date - 7)

,

fnl as (select

case when collection ilike '%sei1rhx6r2q63t37yfsymzq9esx784lm2esskm7ny6j7j208xvpghzesp20vz2%' then 'RoverSeals'

when collection ilike '%sei13zrt6ts27fd7rl3hfha7t63udghm0d904ds68h5wsvkkx5md9jqqkd7z5j%' then 'Dob'

when collection ilike '%sei1za9z9l8pwueataj5gx7mwt8g5zrndhjls7yr6tnhan0zlgw2r8fszn5089%' then 'Seiyan by Cult'

when collection ilike '%sei1aj6t3eyus0vc5w7f4dnr84tk7g5xwrxfughvl0rfjljjs90rtklqlmz966%' then 'Sei Shiba'

when collection ilike '%sei172r2cah7m898qj86epfe2wtvvkkgq5h408jz08h0ny26rj5zjs5qkch29k%' then 'Sei Rocks'

when collection ilike '%sei1msmdzdn92aele5878x905h780l2ura0scppt74mkupmeyxk2zdds7e6swx%' then 'Sei Spritis'

when collection ilike '%sei1pe3x3dpvq7gl9xl332t0pws0yej9xvp5f280r3sg0mlfqcrhrkfsavf072%' then 'Sei Ducks'

when collection ilike '%sei1za9z9l8pwueataj5gx7mwt8g5zrndhjls7yr6tnhan0zlgw2r8fszn5089%' then 'Seiyan by Cult'

when collection ilike '%sei1va06zjmjyjrhmqnepznt6z94hnd2dssj489rh4pggv5uaxphzc0qyhec5c%' then 'Sei Punks'

when collection ilike '%sei1d8hvqelcqf5qec3p5tqckagduqdgel6krfl50mdp33wl452tfjwsqnj2dj%' then 'Rug Duck Association'

when collection ilike '%sei1dk4tyuffcgsscuwtg6hna97rhlngwe2gwl92mhfjgtseymnqjm6qr5jqlf%' then 'Kweck'

when collection ilike '%sei18jvwmxdrymavyftqhexzypr7gv5vruf44mj9r06094nzc7x96l2skfkpww%' then 'Seinsei'

when collection ilike '%sei1np5ls7wmptvy2dd5tjldywlt0wwtfhptw76xlyjhqwsv7sj6rq0s90jhqf%' then 'Sei Portals'

when collection ilike '%sei1skh49xnyqc3gz2gq8jq2ycqjg9dc4klvzq9sxs4dkgdynndfsc4q46pavk%' then 'Cool Cows'

when collection ilike '%sei1pxldvejk2q57yhxh2hck450gvddwhv5fcdchu7ys8xv33ywkcvpsftur73%' then 'Seiguins'

when collection ilike '%sei1swh8dxdpntgdj3z0mv6z030fjy80t484pkf9ce8veascfljynkjs3na2xs%' then 'SuperTusks'