kaibladeArt Gobblers - Daily Max, Min, Avg, Med 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
›
⌄
WITH eth_price AS
(SELECT price, symbol
FROM ethereum.core.fact_hourly_token_prices
WHERE symbol = 'WETH'
ORDER BY hour DESC
LIMIT 1),
gobbler_resale AS
(SELECT *, 'WETH' AS symbol
FROM ethereum.core.ez_nft_sales
WHERE nft_address= LOWER('0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769')
ORDER BY block_timestamp),
gobbler_resale_usd AS
(SELECT sale.tx_hash, sale.block_timestamp,sale.platform_fee, sale.tx_fee, sale.platform_name,sale.price*price.price AS amount
FROM gobbler_resale sale
JOIN eth_price price
ON sale.symbol = price.symbol
),
daily_max_price AS
(
SELECT DATE_TRUNC('day', block_timestamp) AS "Days",
MAX(amount) AS "Daily Maximum Sale Price in USD"
FROM gobbler_resale_usd
GROUP BY "Days"
),
daily_min_price AS
(
SELECT DATE_TRUNC('day', block_timestamp) AS "Days",
MIN(amount) AS "Daily Minimum Sale Price in USD"
FROM gobbler_resale_usd
Run a query to Download Data