zakkisyedNew Wallets in Web3.0
    Updated 2023-05-08
    WITH wallet_activity AS (
    SELECT
    'Arbitrum' AS blockchain,
    from_address,
    MIN(DATE_TRUNC('{{period}}', block_timestamp)) as first_activity_period
    FROM
    ARBITRUM.core.fact_transactions
    WHERE block_timestamp >= '2023-01-01'
    GROUP BY
    from_address

    UNION ALL

    SELECT
    'Optimism' AS blockchain,
    from_address,
    MIN(DATE_TRUNC('{{period}}', block_timestamp)) as first_activity_period
    FROM
    OPTIMISM.core.fact_transactions
    WHERE block_timestamp >= '2023-01-01'
    GROUP BY
    from_address

    UNION ALL

    SELECT
    'Avalanche' AS blockchain,
    from_address,
    MIN(DATE_TRUNC('{{period}}', block_timestamp)) as first_activity_period
    FROM
    AVALANCHE.core.fact_transactions
    WHERE block_timestamp >= '2023-01-01'
    GROUP BY
    from_address


    Run a query to Download Data