HolonymSample 1 - v2
    Updated 2024-11-30
    with holonym_optimism_usresidency as (
    select
    block_timestamp,
    block_number,
    tx_hash,
    concat('0x',substring(substring(input_data, 11 + 64 * 9, 64), 25, 40)) as userAddress,
    'US Residency' as type
    from optimism.core.fact_transactions
    where to_address = '0x7497636f5e657e1e7ea2e851cdc8649487df3aab'
    ),
    holonym_optimism_sybilphone as (
    select
    block_timestamp,
    block_number,
    tx_hash,
    concat('0x',substring(substring(input_data, 11 + 64 * 9, 64), 25, 40)) as userAddress,
    'Phone' as type
    from optimism.core.fact_transactions
    where to_address = '0xa40c8aaf7f47b18c1eddbe7855b580f828ed9711'
    ),
    holonym_optimism_sybilresistance as (
    select
    block_timestamp,
    block_number,
    tx_hash,
    concat('0x',substring(substring(input_data, 11 + 64 * 9, 64), 25, 40)) as userAddress,
    'GovID' as type
    from optimism.core.fact_transactions
    where to_address = '0xdd748977bab5782625af1466f4c5f02eb92fce31'
    ),
    holonym_optimism_results as (
    select * from holonym_optimism_usresidency
    union all
    select * from holonym_optimism_sybilphone
    union all
    select * from holonym_optimism_sybilresistance