WITH deployed_Contracts AS
(
SELECT
block_timestamp::date as timestamps,
TX_HASH
FROM
near.core.fact_actions_events
WHERE
ACTION_NAME = 'DeployContract'
)
SELECT
a.block_timestamp::date as timestamps,
a.TX_HASH
FROM
near.core.fact_actions_events_function_call a JOIN deployed_Contracts b ON (a.TX_HASH = b.TX_HASH AND a.BLOCK_TIMESTAMP::date = b.timestamps)
WHERE
METHOD_NAME = 'new'
LIMIT 30