SELECT

HOUR::Date AS Date,

AVG(Price) AS AVG_Price

FROM

flow.price.ez_prices_hourly

WHERE

SYMBOL ILIKE 'Flow'

AND HOUR :: Date >= '2024-01-01'

GROUP BY

1

),

Tb2 AS (

SELECT

BLOCK_TIMESTAMP,

TX_ID,

NFT_COLLECTION,

NFT_ID,

BUYER,

SELLER,

CASE

WHEN Currency IN (

'A.1654653399040a61.FlowToken',

'A.ead892083b3e2c6c.FlowUtilityToken'

) then price * avg_price

ELSE price

END as Sales_Volume

FROM

flow.nft.ez_nft_sales a

JOIN Tb1 b

ON a.Block_timestamp::Date = b.Date

WHERE

BLOCK_TIMESTAMP :: Date >= '2024-01-01'

AND MARKETPLACE IN (

'A.4eb8a10cb9f87357.NFTStorefront',