dannerUntitled Query
    Updated 2022-10-31
    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,
    block_number as org_created_block,
    tx_hash as org_created_hash
    from orgs
    Run a query to Download Data