CryptoIcicleFlow-15.NBA Playoff Usage
Updated 2022-06-28
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
›
⌄
-- Q.15 Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume. What about NBA Top Shots?
-- Payout 33.56 FLOW
-- Grand Prize 100.67 FLOW
-- Level Beginner
with
overall_nft_sales as (
select
*
from flow.core.fact_nft_sales
where block_timestamp >= '2022-04-15'
and marketplace not ilike 'A.c1e4f4f4c4257510.%'
),
top_shot_nft_sales as (
select
*
from flow.core.fact_nft_sales
where block_timestamp >= '2022-04-15'
and marketplace ilike 'A.c1e4f4f4c4257510.%'
),
top_shot as (
select
block_timestamp::date as date,
'topshots' as category,
count(distinct tx_id) as n_txns,
sum(price) as sale_volume,
count(distinct buyer) as n_wallets_daily
from top_shot_nft_sales
group by date
),
overall as (
select
block_timestamp::date as date,
'non-topshots' as category,
Run a query to Download Data