date(day) as date,

receiver as contract

(

select

ev.block_timestamp as day,

tx_receiver as receiver,

row_number() over (

partition by tx_receiver

order by

ev.block_timestamp asc

) as rank

from

near.core.fact_actions_events ev

join near.core.fact_transactions ft on ft.tx_hash = ev.tx_hash

where

action_name like '%DeployContract%'

and ev.block_timestamp >= dateadd(

month,

-6,

getdate()

)

group by

receiver,

day qualify rank = 1

)

group by date, contract