name_lookup as

(

with orgs as (

select

*,

regexp_substr_all(SUBSTR(input, 11, len(input)), '.{64}') AS segmented_input

from

polygon.core.fact_traces

where block_timestamp :: DATE > '2022-10-16' :: DATE

and type = 'CALL'

and from_address = LOWER('0x218b3c623ffb9c5e4dbb9142e6ca6f6559f1c2d6') -- deployer

and substr(input, 0, 10) = '0xb6dbcae5'

)

select

try_hex_decode_string(segmented_input[14]::string) as org_name,

to_address as org_address,

block_timestamp as org_created_timestamp

from orgs

),

orgs AS (

SELECT

CONCAT('0x', RIGHT(topics[1]::STRING, 40)) AS created_contracts

FROM

polygon.core.fact_event_logs

WHERE

block_timestamp::DATE > '2022-10-16'::DATE

AND contract_Address = LOWER('0x218b3c623ffb9c5e4dbb9142e6ca6f6559f1c2d6')

AND origin_function_signature = '0x7b366213'

),

base_table AS (

SELECT

block_timestamp as day,

tx_hash,

contract_address AS org,