Nige7777Fucking Pickle Prices
Updated 2022-11-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- select * from ethereum.nft_events e
-- where token_id < 100
-- and e.block_timestamp > dateadd('day', -1, getdate())
-- limit 500
--select event_platform , count(*) from ethereum.nft_events group by event_platform
--select * from ethereum.transactions t where tx_id = '0x65f650a3c2d55ef2db0b5bb0ad3df4f833eed08a0b7a45b3cf4635f238145f05'
--select * from ethereum.events_emitted where tx_id = '0x65f650a3c2d55ef2db0b5bb0ad3df4f833eed08a0b7a45b3cf4635f238145f05'
--select * from ethereum.nft_events where tx_id= '0x5c7fec9d7aa91ad38c46d6956435dd203cb4e4238c98520a13f74726b9e5e72d'
-- select *
-- ,
-- avg(price_usd) over (partition by date_trunc('Day',block_timestamp ) order by date_trunc('Day',block_timestamp )) as AVG_PRICE,
-- date_trunc('Day',block_timestamp ) Day
-- from ethereum.nft_events
-- where contract_address = '0xf78296dfcf01a2612c2c847f68ad925801eeed80'
-- and event_type = 'sale'
-- and date_trunc('day',block_timestamp ) > '2021-06-15T09:55:55Z'
-- order by block_timestamp--price_usd desc
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 ) Day
from ethereum.nft_events
where contract_address = '0xf78296dfcf01a2612c2c847f68ad925801eeed80'
Run a query to Download Data