SELECT

distinct e.ORIGIN_FROM_ADDRESS as "Buyer",

min(trunc(e.BLOCK_TIMESTAMP,'day')) AS "Debut"

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'

group by 1

"Debut",

count(distinct "Buyer") as "New traders",

sum("New traders") over (order by "Debut") as "Total traders"

tab1

group by 1

ORDER BY

"Debut" DESC;