SELECT

trunc(e.BLOCK_TIMESTAMP,'day') AS "Hour_Timestamp",

t.TX_HASH as "Transaction",

e.AMOUNT_PRECISE AS "Sale",

e.ORIGIN_FROM_ADDRESS as "Buyer",

e.TO_ADDRESS as "Seller"

FROM

(

SELECT

DISTINCT TX_HASH

FROM

polygon.core.ez_token_transfers

WHERE

ORIGIN_FUNCTION_SIGNATURE = '0x0d5f7d35'

AND BLOCK_TIMESTAMP >= '2024-06-01'

AND TX_HASH != 'Hidden'

) t

JOIN polygon.core.ez_token_transfers e ON t.TX_HASH = e.TX_HASH

WHERE

e.ORIGIN_FUNCTION_SIGNATURE = '0x0d5f7d35'

AND e.BLOCK_TIMESTAMP >= '2024-06-01'

, hourly_sales AS (

SELECT

"Hour_Timestamp",

COUNT(DISTINCT "Transaction") AS "Transactions",

COUNT(DISTINCT "Buyer") AS "Unique_Buyers",

COUNT(DISTINCT "Seller") AS "Unique_Sellers",

SUM("Sale") AS "Volume"

FROM

tab1

GROUP BY

"Hour_Timestamp"

, cumulative_metrics AS (