CryptoIcicleFlow-5.Volume Scoring with NBA Top Shot
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- Volume Scoring with NBA Top Shot
-- Payout 27.99 FLOW
-- Grand Prize 83.96 FLOW
-- Level Intermediate
-- Q5. NBA Top Shot allows users to buy, sell, and collect NBA NFTs that showcase influential “Moments” minted on the FLOW blockchain.
-- Create a visualization tracking the total sales volume traded on NBA Top Shot since May 9th by day.
-- How many unique wallets have made a trade on Top Shot over that timeframe?
-- How do those metrics compare to sales volume and unique users of Magic Eden on Solana and OpenSea on Ethereum?
select
*
from flow.core.fact_events
where block_timestamp >= '2022-05-09'
and split(event_contract,'.')[2] = 'TopShot'
limit 1000
Run a query to Download Data