Pudgy Penguins: Total Bids vs Sales plot

rustygeePudgy Penguins: Total Bids vs Sales plot

Updated 2024-04-15

-- forked from Remillo: Total Bids vs Sales plot @ https://flipsidecrypto.xyz/edit/queries/9279170d-df98-427a-b776-0f1930693371

-- forked from Remillo: Avg Bids vs Sales @ https://flipsidecrypto.xyz/edit/queries/bbdff6e2-0b3f-4f17-8e7a-8770b00c843c

SELECT *

FROM ethereum.nft.ez_nft_sales

WHERE NFT_ADDRESS = '0xbd3531da5cf5857e7cfaa92426877b022e612cf8'

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