SELECT

from_address,

MIN(block_timestamp) AS first_tx_timestamp

FROM

polygon.core.ez_token_transfers

WHERE 1=1

AND CONTRACT_ADDRESS = '0x385eeac5cb85a38a9a07a70c73e0a3271cfb54a7' -- $GHST Contract Address'

GROUP BY

from_address

HAVING

MIN(block_timestamp) >= '2024-01-01'

),

existing_addresses AS (

SELECT

from_address,

block_timestamp

FROM

polygon.core.ez_token_transfers

WHERE 1=1

AND CONTRACT_ADDRESS = '0x385eeac5cb85a38a9a07a70c73e0a3271cfb54a7' -- $GHST Contract Address'

AND from_address NOT IN (SELECT from_address FROM new_addresses)

AND block_timestamp >= '2024-01-01'

SELECT

DATE_TRUNC('day', first_tx_timestamp) AS Date,

'New Users' AS type,

COUNT(from_address) AS n_addresses

FROM

new_addresses

GROUP BY

Date, type

UNION ALL