SELECT

block_timestamp::date AS date,

tx_hash,

tokenid,

price AS sale_price,

price_usd AS sale_price_usd

FROM

ethereum.nft.ez_nft_sales

WHERE block_timestamp::date >= '2024-01-01'

AND block_timestamp::date <= CURRENT_DATE()

AND nft_address = '0x8a90cab2b38dba80c64b7734e58ee1db38b8992e'

AND currency_address IN ('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2',

'0x0000000000a39bb272e79075ade125fd351887ac')

AND price > 0

--AND platform_name = 'opensea'

),

daily_price AS (

SELECT

date,

sale_price,

sale_price_usd

FROM all_sales

qualify row_number() over (partition by date order by sale_price_usd asc) <= 5

),

daily_floor AS (

SELECT

date,

AVG(sale_price) AS floor_price

FROM

daily_price

GROUP BY

date