2844ALL TEAMS SELLS
Updated 2022-07-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select COUNT (TX_ID) AS "VOLUME", SUM(PRICE) AS "USD PRICE",
TEAM ,
CASE
WHEN BLOCK_TIMESTAMP::date <'2022-05-17' THEN 'BEFORE FINAL'
WHEN BLOCK_TIMESTAMP::date >'2022-05-16' AND BLOCK_TIMESTAMP::date <'2022-05-30' THEN 'FINAL'
WHEN BLOCK_TIMESTAMP::date >'2022-05-29' THEN 'AFTER FINAL'
END AS "PERIOD"
from flow.core.fact_nft_sales S
INNER JOIN flow.core.dim_topshot_metadata M ON S.NFT_ID=M.NFT_ID
where S.NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot'
and CURRENCY not in ('A.1654653399040a61.FlowToken')
GROUP BY 3,4
ORDER BY 2
Run a query to Download Data