0-MIDTeam Token Count Share That Bought by Top 10 Buyers After THG Day
Updated 2023-04-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
›
⌄
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