with NFLallDay as (
select EVENT_CONTRACT, CONTRACT_NAME
from flow.core.dim_contract_labels
where contract_name ='AllDay'
group by 1,2
)
select player,
price
from flow.core.ez_nft_sales FULL join flow.core.dim_allday_metadata using (nft_id)
where NFT_COLLECTION in (select EVENT_CONTRACT from NFLallDay )
and tx_succeeded = 'TRUE'
group by 1,2 order by price desc limit 10