rustygeeAsterix: Total Bids vs Sales plot
Updated 2024-04-15
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.nft.ez_nft_sales
WHERE NFT_ADDRESS = '0x0000000000c26fabfe894d13233d5ec73f61cc72'
AND BLOCK_TIMESTAMP >= CURRENT_DATE - interval '30 day'
AND PLATFORM_NAME = 'blur'
-- AND PRICE < 1.7
-- 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