CryptoIcicleFlow-5.Volume Scoring with NBA Top Shot - Flow vs Opensea vs Magic Eden
Updated 2022-06-07
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
›
⌄
-- 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?
with flow_nft_sales as (
select
block_timestamp::date as date,
count(distinct buyer) as n_wallets_daily,
count(distinct tx_id) as sale_volume,
'flow' as type
from flow.core.fact_nft_sales
where block_timestamp >= '2022-05-09'
and marketplace ilike 'A.c1e4f4f4c4257510.%'
group by date
),
opensea_nft_sales as (
select
block_timestamp::date as date,
count(distinct buyer_address) as n_wallets_daily,
count(distinct tx_hash) as sale_volume,
'opensea' as type
from ethereum.core.ez_nft_sales
where block_timestamp >= '2022-05-09'
and platform_name = 'opensea'
group by date
),
magic_eden_nft_sales as (
select
block_timestamp::date as date,
count(distinct purchaser) as n_wallets_daily,
Run a query to Download Data