sum(price) as "price",

case when marketplace = 'A.e4cf4bdc1751c65d.AllDay' then 'AllDay'

when marketplace = 'A.329feb3ab062d289.NFL_NFT'then 'NFL'

end as nflallday_market

from flow.core.fact_nft_sales

where nft_collection like '%AllDay%'

and tx_succeeded = 'TRUE'

group by 2