CryptoIcicleNFL All Day Tournament [Round 1] Volume/Wallets
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
›
⌄
-- 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
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'
)
select
block_timestamp::date as date,
count(distinct tx_id) as n_txns,
sum(price) as sale_volume,
count(distinct buyer) as n_wallets_daily,
(select count(distinct buyer) from nft_sales) as n_wallets_unique
from nft_sales
group by date
Run a query to Download Data