token_name,

to_number(trim(token_name,'Ecumenopolis #')) AS Number,

project_name,

replace(token_metadata:traits[1]:value::string,'Theme: ','') AS Theme,

replace(token_metadata:traits[2]:value::string,'Palette: ','') AS Palette,

replace(token_metadata:traits[3]:value::string,'Lights: ','') AS Lights,

replace(token_metadata:traits[4]:value::string,'Atmosphere: ','') AS Atmosphere,

replace(token_metadata:traits[5]:value::string,'Blueprint: ','') AS Blueprint,

replace(token_metadata:traits[6]:value::string,'Architect: ','') AS Architect,

replace(token_metadata:traits[7]:value::string,'Painter: ','') AS Painter,

replace(token_metadata:traits[8]:value::string,'Lean: ','') AS Lean,

replace(token_metadata:traits[9]:value::string,'Complication: ','') AS Complication,

replace(token_metadata:traits[10]:value::string,'Vertigo: ','') AS Vertigo,

replace(token_metadata:traits[11]:value::string,'Warping: ','') AS Warping,

replace(token_metadata:traits[12]:value::string,'Stacked: ','') AS Stacked,

replace(token_metadata:traits[13]:value::string,'Height: ','') AS Height,

replace(token_metadata:traits[14]:value::string,'Scale: ','') AS Scale,

replace(token_metadata:traits[15]:value::string,'Takeover: ','') AS Takeover

from ethereum.nft_metadata

where contract_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'

and lower(token_name) LIKE '%ecumenopolis%'

and number <> 0

select *, case

when number = '310' then '50'

when number = '502' then '45'

when number = '395' then '40'

when number = '627' then '35'

when number = '448' then '30'

when number = '670' then '30'

when number = '413' then '29'

when number = '491' then '29'

when number = '557' then '28'

else '28' end Last_sold_ETH