date_trunc('day', block_timestamp) ,

player,

from flow.core.ez_nft_sales left outer join flow.core.dim_allday_metadata

on flow.core.ez_nft_sales.nft_id = flow.core.dim_allday_metadata.nft_id

where block_timestamp > '2022-09-08'

and player not in ('Christian McCaffrey', 'Jonathan Taylor', 'Austin Ekeler', 'Alvin Kamara', 'Derrick Henry', 'Saquon Barkley' ,-- RB

'Josh Allen', 'Lamar Jackson', 'Justin Herbert', 'Jalen Hurts', 'Russell Wilson', -- QB

'Cooper Kupp', 'Justin Jefferson', 'JaMarr Chase', 'CeeDee Lamb', 'Davante Adams', -- WR

'Mark Andrews', 'Travis Kelce' , 'Kyle Pitts', 'Darren Waller', 'Dalton Schultz') -- TE

and player is not null

group by 1, 2