MLDZMNartg6
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select
date_trunc('hour',BLOCK_TIMESTAMP) as hour,
avg(price) as avg_sale,
median(price) as med_price,
min(price) as min_price,
max(price) as max_price,
max_price-min_price as bond_price,
avg(price_usd) as avg_sale_usd,
median(price_usd) as med_price_usd,
min(price_usd) as min_price_usd,
max(price_usd) as max_price_usd,
max_price_usd-min_price_usd as bond_price_usd,
avg(avg_sale) OVER (ORDER BY hour ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as MA_7_Days,
avg(avg_sale_usd) OVER (ORDER BY hour ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as MA_7_Days_usd
from ethereum.core.ez_nft_sales
where NFT_ADDRESS=lower('0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769')
group by 1
Run a query to Download Data