WITH AddressData AS (

SELECT

'BitmapPunks' AS project_name,

LOWER('0xBBBB2D4d765c1e455E4896A64BA3883e914ABBBB') AS erc20_address,

LOWER('0xBBBBA1eE822c9B8fc134deA6aDfC26603a9cBBBB') AS nft_address

),

eth_price as (

SELECT

date_trunc('day', hour) as date,

avg(close) as eth_pr

FROM

crosschain.price.fact_prices_ohlc_hourly

where

asset_id = '1027'

and date_trunc('day', hour) >= '2025-01-01'

group by

1

),

NFTData AS (

WITH OutNFTTransfers AS (

SELECT

tx_hash AS out_tx_hash,

nft_from_address AS sender,

tokenid,

block_timestamp AS out_timestamp,

nft_address

FROM

ethereum.nft.ez_nft_transfers

WHERE

nft_address IN (

SELECT

nft_address

FROM

AddressData