Nige7777Untitled Query
Updated 2022-02-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select * from ethereum.nft_events E
where event_to = lower('0x16f2F6eb3AFD95cE06eD9b700EC7D44FAF380C8A')
-- select distinct
-- avg(price_usd) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as AVG_PRICE,
-- min(price_usd) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as MIN_PRICE,
-- MAX(price_usd) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as MAX_PRICE,
-- COUNT( price_usd) over (partition by date_trunc('day',block_timestamp ) order by date_trunc('day',block_timestamp )) as Sale_count,
-- date_trunc('day',block_timestamp ) Hour
-- from ethereum.nft_events
-- where contract_address = '0xc2c747e0f7004f9e8817db2ca4997657a7746928'
-- and event_type = 'sale'
-- and date_trunc('day',block_timestamp ) > '2021-01-27T09:55:55Z'
-- order by hour--price_usd desc'
Run a query to Download Data