ArioWhat makes a Top Shots moment valuable? (Part I) - 1
Updated 2022-07-24
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
›
⌄
with Price as (
select
date_trunc('day', TIMESTAMP) as date,
TOKEN_CONTRACT,
avg(PRICE_USD) as Token_Price_USD
from flow.core.fact_prices
where TOKEN_CONTRACT = 'A.1654653399040a61.FlowToken'
group by 1,2
),
sales_data as (
select
BLOCK_TIMESTAMP,
TX_ID,
MARKETPLACE,
NFT_ID,
BUYER,
SELLER,
PRICE * Token_Price_USD as Price_USD,
CURRENCY,
TX_SUCCEEDED
from flow.core.fact_nft_sales s join Price p on s.BLOCK_TIMESTAMP::date = p.date
where
NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot'
),
TopShot_Metadata as (
select
MOMENT_DATE,
NFT_ID,
NBATOPSHOT_ID,
SERIAL_NUMBER,
TOTAL_CIRCULATION,
PLAYER,
TEAM,
PLAY_CATEGORY,
PLAY_TYPE,
MOMENT_STATS_FULL:birthdate,
Run a query to Download Data