Diamond2023 Season Data
Updated 2023-09-22
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
›
⌄
WITH PlayerData AS (
SELECT DISTINCT
set_id,
nft_collection,
tier,
set_name,
CONCAT(metadata:playerFirstName::text, ' ', metadata:playerLastName::text) AS playerName,
metadata:teamName::text AS teamName
FROM flow.nft.dim_moment_metadata
WHERE set_id = '37'
AND nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
AND tier = 'LEGENDARY'
AND set_name = 'Dynamic'
),
SalesData AS (
SELECT
count(distinct buyer) as "Buyers",
count(distinct seller) as "Sellers",
count(distinct tx_id) as "Total Transactions"
FROM flow.nft.ez_nft_sales ez
WHERE ez.nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
)
SELECT
PD.set_id,
PD.nft_collection,
PD.playerName,
PD.teamName,
PD.tier,
PD.set_name,
SD."Buyers",
SD."Sellers",
SD."Total Transactions"
FROM PlayerData PD
JOIN SalesData SD ON PD.nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
AND PD.set_name = 'Dynamic';
Run a query to Download Data