mlhMiami Heat
Updated 2022-07-09Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH Miami_Heat AS
(
SELECT NFT_ID
FROM flow.core.dim_topshot_metadata
WHERE (TEAM IN('Miami Heat')))
SELECT
date_trunc('day',block_timestamp) as days,
count (distinct tx_id) as transactions,
sum(PRICE) as volume
FROM flow.core.fact_nft_sales
WHERE NFT_ID IN (SELECT NFT_ID FROM Miami_Heat)
and block_timestamp BETWEEN '2022-05-01' and '2022-05-29'
group by 1
order by 1 asc
Run a query to Download Data