rustygeeRemillo: Avg Bids vs Sales
Updated 2024-04-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- SELECT *
-- FROM ethereum.nft.ez_nft_sales
-- WHERE NFT_ADDRESS = '0xd3d9ddd0cf0a5f0bfb8f7fceae075df687eaebab'
-- AND BLOCK_TIMESTAMP >= CURRENT_DATE - interval '7 day'
-- -- WHERE PLATFORM_NAME = 'blur'
SELECT
AVG(CASE WHEN EVENT_TYPE = 'bid_won' THEN PRICE ELSE NULL END) AS avg_price_bid_won,
AVG(CASE WHEN EVENT_TYPE = 'sale' THEN PRICE ELSE NULL END) AS avg_price_sale,
COUNT(CASE WHEN EVENT_TYPE = 'bid_won' THEN 1 END) AS count_bid_won,
COUNT(CASE WHEN EVENT_TYPE = 'sale' THEN 1 END) AS count_sale
FROM ethereum.nft.ez_nft_sales
WHERE NFT_ADDRESS = '0xd3d9ddd0cf0a5f0bfb8f7fceae075df687eaebab'
AND BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '7 day'
AND PLATFORM_NAME = 'blur'
-- EVENT_TYPE sale or bid_won
QueryRunArchived: QueryRun has been archived