mattkstewTop Week 1 Players NFT Sales Metrics After Week 1
    Updated 2022-09-19
    select
    player,
    sum(price),
    avg(price),
    count(*),
    max(price),
    min(price)


    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 > current_date - 11
    and player 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
    order by 2 desc


    Run a query to Download Data