with floor as

with nft_sales as

select ns.*, dl.contract_name as project from solana.core.fact_nft_sales ns

inner join solana.core.dim_nft_metadata dl

on ns.mint=dl.mint

where ns.block_timestamp::date between '2023-01-24' and current_date

and dl.contract_name in

('Blocksmith Labs','Famous Fox Federation','Okay Bears','Cets On Creck','ABC'

,'DeGods','Solana Monkey Business','SOLGods','Transdimensional Fox Federation'

, 'Degen Apes''Pawnshop Gnomies','Aurory','Catalina Whale Mixer','Underworld'

)

select block_timestamp::date as "date", project, min(sales_amount) as floor

from nft_sales

group by "date",project

union

select block_timestamp::date as "date", 'underworld' as project , min (sales_amount) as floor from solana.core.fact_nft_sales

where mint in

(select address from solana.core.dim_labels

where address_name='underworld_nft'

group by 1,2

),

emission as

(select block_timestamp::date as "date",sum(amount) as emission from solana.core.fact_transfers