SELECT

*

FROM

near.core.fact_actions_events

WHERE

ACTION_NAME = 'DeployContract'

),

new_Contract AS

SELECT

b.BLOCK_TIMESTAMP,

b.TX_HASH

FROM

deployed_Ct a JOIN near.core.fact_actions_events_function_call b ON a.TX_HASH = b.TX_HASH

WHERE

METHOD_NAME = 'new' AND b.BLOCK_TIMESTAMP::date >= '2022-12-01' AND b.BLOCK_TIMESTAMP::date < '2023-01-01'

),

overall_t AS

SELECT

a.BLOCK_TIMESTAMP,

a.TX_RECEIVER as CONTRACT_ADDRESS,

a.TX_SIGNER as DEPLOYER_ADDRESS,

b.TX_HASH,

ADDRESS_NAME,

L1_LABEL, L2_LABEL,

LABEL_SUBTYPE, LABEL_TYPE,

PROJECT_NAME,

ADDRESS

FROM

near.core.fact_transactions a JOIN new_Contract b ON a.TX_HASH = b.TX_HASH

JOIN near.core.dim_address_labels c ON a.TX_RECEIVER = c.ADDRESS