TheLaughingManNew Wallets By Counts: 5
    Updated 2023-10-17
    -- forked from New Wallets By L2 Cumulative @ https://flipsidecrypto.xyz/edit/queries/28692dcc-db45-40ea-bfae-9ccaee84d32e

    -- forked from New Wallets By L2 @ https://flipsidecrypto.xyz/edit/queries/9480a1aa-b212-4b9a-aca9-d78f60f2259c

    with arb as (
    SELECT
    from_address as wallet
    , block_timestamp::date as ddate
    , 'arbitrum' as cat
    from arbitrum.core.fact_transactions
    WHERE 1=1
    AND nonce=0
    and block_timestamp>='2023-08-01'
    AND STATUS='SUCCESS'
    )
    ,

    base as (
    SELECT
    from_address as wallet
    , block_timestamp::date as ddate
    , 'base' as cat
    from base.core.fact_transactions
    WHERE 1=1
    AND nonce=0
    and block_timestamp>='2023-08-01'
    AND STATUS='SUCCESS'
    )
    ,

    opt as (
    SELECT
    from_address as wallet
    , block_timestamp::date as ddate
    , 'optimism' as cat
    from optimism.core.fact_transactions