adambalapv11
Updated 2023-04-13
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
›
⌄
with
avg as
(SELECT
sum(PRICE) as volume ,avg(PRICE) as prices , ' avg prices' as title , BLOCK_TIMESTAMP::date as date
FROM ethereum.core.ez_nft_sales
WHERE EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH' and LOWER(NFT_ADDRESS)=lower('0x960b7a6bcd451c9968473f7bbfd9be826efd549a')
group by date,title)
,
max as
(SELECT
sum(PRICE) as volume ,max(PRICE) as prices , 'max prices'as title , BLOCK_TIMESTAMP::date as date
FROM ethereum.core.ez_nft_sales
WHERE EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH' and LOWER(NFT_ADDRESS)=lower('0x960b7a6bcd451c9968473f7bbfd9be826efd549a')
group by date,title)
,
min as
(SELECT
sum(PRICE) as volume ,min(PRICE) as prices , 'min prices' as title , BLOCK_TIMESTAMP::date as date
FROM ethereum.core.ez_nft_sales
WHERE EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH' and LOWER(NFT_ADDRESS)=lower('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')
group by date,title)
select * from avg
union
select * from min
union
select * from max
Run a query to Download Data