0-MIDTeam Token Count Share That Bought by Top 10 Buyers After THG Day
    Updated 2023-04-12
    with tab1 as (
    select BUYER
    ,PRICE
    ,NFT_ID
    from flow.core.ez_nft_sales
    where NFT_COLLECTION='A.e4cf4bdc1751c65d.AllDay'
    and BLOCK_TIMESTAMP>='2022-11-24'
    and TX_SUCCEEDED='TRUE'
    and BUYER in ('0x4b7ad060d826fba2','0xffee4f34acfc3ea6','0x7e378ec7ee8e14e8','0xb7700366fa738a43'
    ,'0xa74bc9b3f1838cd0','0x712044d6a4c14181','0x2cad71c44ba127a7','0xbd7e4456bc32784f','0x8bf951fe6f7918b1','0x0743aa0c3b6fac89')),
    tab2 as (
    select
    case
    when TEAM in ('Minnesota Vikings','New England Patriots','Dallas Cowboys','New York Giants','Detroit Lions','Buffalo Bills')
    then 'Belonging to the teams that played on Thanksgiving Day' else 'Other Teams' end as team_type
    ,NFT_ID
    ,PLAYER
    ,TEAM
    from flow.core.dim_allday_metadata)
    select team_type,count(distinct tab2.NFT_ID)as nft_count
    from tab1
    left join tab2
    on tab1.NFT_ID=tab2.NFT_ID
    where team_type is not null
    group by 1
    order by 2 desc
    limit 10

    Run a query to Download Data