Nige7777Time Pieces Prices
Updated 2021-09-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select distinct
avg(price_usd) over (partition by date_trunc('hour',block_timestamp ) order by date_trunc('hour',block_timestamp )) as AVG_PRICE,
min(price_usd) over (partition by date_trunc('hour',block_timestamp ) order by date_trunc('hour',block_timestamp )) as MIN_PRICE,
MAX(price_usd) over (partition by date_trunc('hour',block_timestamp ) order by date_trunc('hour',block_timestamp )) as MAX_PRICE,
COUNT( price_usd) over (partition by date_trunc('hour',block_timestamp ) order by date_trunc('hour',block_timestamp )) as Sale_count,
round( SUM(round(price,4)) over (partition by date_trunc('hour',block_timestamp ) order by date_trunc('hour',block_timestamp )),4) as ETH_Sales,
round( SUM(round(price,4)) over (partition by contract_address order by contract_address),4) as Total_ETH_Sales,
'Time Pieces' AS NTF,
date_trunc('hour',block_timestamp ) day,
avg(price) over (partition by date_trunc('hour',block_timestamp ) order by date_trunc('hour',block_timestamp )) as AVG_PRICE_ETH,
min(price) over (partition by date_trunc('hour',block_timestamp ) order by date_trunc('hour',block_timestamp )) as MIN_PRICE_ETH,
MAX(price) over (partition by date_trunc('hour',block_timestamp ) order by date_trunc('hour',block_timestamp )) as MAX_PRICE_ETH
from ethereum.nft_events
where contract_address = lower('0xdd69da9a83cedc730bc4d3c56e96d29acc05ecde')
and event_type = 'sale'
and date_trunc('hour',block_timestamp ) > '2021-09-23T09:55:55Z'
--and tx_currency <> 'CK' -- someone has part exed a crypto kitty and .9 eth which creates unhandlable number -- tx_id = '0x3316cc0239294d5676e98de49e4ca42222575412c101cb84ad35cde320091f2c' date_trunc('hour',block_timestamp ) = '2021-08-10T18:00:00Z'
order by day--price_usd desc
Run a query to Download Data