SELECT

min(t.BLOCK_TIMESTAMP) as time,TX_RECEIVER

FROM( near.core.fact_actions_events INNER JOIN near.core.fact_transactions t on t.TX_HASH = near.core.fact_actions_events.TX_HASH and t.BLOCK_TIMESTAMP=near.core.fact_actions_events.BLOCK_TIMESTAMP)

WHERE action_name = 'DeployContract'

GROUP BY TX_RECEIVER)

SELECT time,TX_RECEIVER as smart_contracts

from main

WHERE time>=CURRENT_DATE-30