MadiUntitled Query
Updated 2022-09-13Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH nft_allday AS (
SELECT
date_trunc('days', b.block_timestamp) AS date,
b.NFT_ID as nft_id,
b.MARKETPLACE as MARKETPLACE,
b.price as price
FROM flow.core.dim_allday_metadata a
LEFT JOIN flow.core.ez_nft_sales b
ON a.NFT_ID = b.NFT_ID
)
SELECT
date,
MARKETPLACE,
ROUND(SUM(PRICE),2) as total_sales_volume
FROM nft_allday
GROUP BY date, MARKETPLACE
ORDER BY total_sales_volume DESC
Run a query to Download Data