SELECT

mint AS token_address,

tx_to,

min(date_trunc('day', block_timestamp)) AS first_day

FROM solana.core.fact_transfers

WHERE mint IN (

'hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux', --HNT

'iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns', --IOT

'mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6', --MOBILE

'rndrizKT3MK1iimdxRdWabcF7Zg7AR5T4nud4EkHBof', --RENDER

'SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y', --SHDW

'MMAPdo5j2weUCQLs536p3Y6kB4CBcxdddNb8aobiPTc', --MMAPSv2

'ETAtLmCmsoiEEKfNrHKJ2kYy3MoABhU6NQvpSfij5tDs', --MEDIA

'4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy', --HONEY

'wxmJYe17a2oGJZJ1wDe6ZyRKUKmrLj2pJsavEdTVhPP', --WXM

'xNETbUB7cRb3AAu2pNG2pUwQcJ2BHcktfvSB8x1Pq6L', --XNET

'FRySi8LPkuByB7VPSCCggxpewFUeeJiwEGRKKuhwpKcX', --NATIX

'BZLbGTNCSFfoth2GYDtwr7e4imWzpR5jqcUuGEwr646K' --IONET

)

AND block_timestamp > CURRENT_DATE - INTERVAL '30 days'

GROUP BY token_address, tx_to

),

daily_new_holders AS (

SELECT

first_day AS day,

token_address,

count(*) AS new_holders

FROM first_day_holders

GROUP BY day, token_address

),

final_aggregation AS (

SELECT

day,