Nige7777Copy of BGanPunksV2 Prices
Updated 2021-07-01
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
›
⌄
--
--select * from ethereum.events_emitted where lower(tx_id) = lower('0x37c385c78600b86d99e3abf00c131911074c3095bc0071c1aa3fb42cf5df7621')
-- 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 = lower('0xedb61f74b0d09b2558f1eeb79b247c1f363ae452')
-- and event_type = 'sale'
-- and date_trunc('day',block_timestamp ) > '2020-02-27T09:55:55Z'
-- order by hour--price_usd desc
select count(*)
, project_name
, contract_address
from
ethereum.nft_events
where event_type = 'sale'
group by
project_name
, contract_address
order by count(*) desc
Run a query to Download Data