sarathmisouser3.5
    Updated 2022-09-20
    with arbitrum as (select min(block_timestamp) as first_tx,
    from_address
    from arbitrum.core.fact_transactions
    where status = 'SUCCESS'
    and origin_function_signature = '0x29762960' --miso
    group by 2),

    avalanche as (select min(block_timestamp) as first_tx,
    from_address
    from avalanche.core.fact_transactions
    where status = 'SUCCESS'
    and origin_function_signature = '0x29762960' --miso
    group by 2),

    bsc as (select min(block_timestamp) as first_tx,
    from_address
    from bsc.core.fact_transactions
    where status = 'SUCCESS'
    and origin_function_signature = '0x29762960' --miso
    group by 2),

    ethereum as (select min(block_timestamp) as first_tx,
    from_address
    from ethereum.core.fact_transactions
    where status = 'SUCCESS'
    and origin_function_signature = '0x29762960' --miso
    group by 2),

    gnosis as (select min(block_timestamp) as first_tx,
    from_address
    from gnosis.core.fact_transactions
    where status = 'SUCCESS'
    and origin_function_signature = '0x29762960' --miso
    group by 2),

    optimism as (select min(block_timestamp) as first_tx,
    Run a query to Download Data