MadiAvg price, max,min
Updated 2022-09-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH nft_allday AS (
SELECT
date_trunc('day', b.block_timestamp) AS date,
b.NFT_ID as nft_id,
b.TX_ID as TX_ID,
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,
ROUND(AVG(PRICE),2) as avg_price
FROM nft_allday
WHERE date >= DATEADD(day, -30, getdate())
GROUP BY date
ORDER BY date ASC
Run a query to Download Data