CryptoIcicleNFL All Day Tournament [Round 1] - Top Moments by Position
Updated 2022-09-14
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
31
32
33
34
35
36
›
⌄
-- NFL All Day Tournament [Round 1]
-- Welcome to the NFL All Day Tournament!
-- Grand Prize 30.05 FLOW
-- Payout 30.05 FLOW
-- Payout Network Flow
-- Level Beginner
-- Difficulty Medium
-- For the first round of this tournament, create an analysis that shows top-line NFL All Day metrics and stats.
-- Chart total sales and sales volume growth, user analysis, player. Track metrics by player and position,
-- and see if there are any notable spikes in sales so far this preseason.
-- Only the top 32 most stellar dashboards submitted will receive payment + make it to the next round, so get creative with your analysis to stand out!
with nft_sales as (
select
m.moment_stats_full:metadata:playerPosition as play_type,
s.*
from flow.core.fact_nft_sales s
join flow.core.dim_allday_metadata m on s.nft_id = m.nft_id
where block_timestamp >= '2022-08-01'
),
top_15 as (
select
play_type,
sum(price) as sale_volume
from nft_sales
group by 1
order by sale_volume desc
limit 15
),
top as (
select
block_timestamp::date as date,
s.play_type as category,
count(distinct tx_id) as n_sales,
Run a query to Download Data