SELECT

date_trunc('day',block_timestamp) as date,

COUNT(DISTINCT(from_address)) as tokens_p_day,

SUM(COUNT(DISTINCT(from_address))) OVER(ORDER BY date_trunc('day',block_timestamp)) as tokens_created

FROM ethereum.core.ez_token_transfers

WHERE origin_to_address = LOWER('0x7603a35af5cf10b113f167d424eb75bb7062c8ce')

AND symbol IS NOT NULL

AND amount IS NOT NULL

GROUP BY 1

ORDER BY 1 DESC

)

SELECT * FROM tokens