feyikemi$ARB After Day 1
    Updated 2025-01-09
    WITH initial_claims AS (
    SELECT
    ethereum.public.udf_hex_to_int(DATA) / pow(10, 18) AS Total_claimed,
    CONCAT('0x', SUBSTR(TOPICS[1], -40, 40)) AS USER
    FROM
    arbitrum.core.fact_event_logs
    WHERE
    TOPICS[0] = '0x87aeeb9eda09a064caef63d00f62c15063631980bfc422ad7dd30c8a79f0cbb7'
    AND ORIGIN_FROM_ADDRESS = '0x2b9acfd85440b7828db8e54694ee07b2b056b30c'
    AND TX_STATUS = 'SUCCESS'
    AND DATEDIFF('Day', '2023-03-23', BLOCK_TIMESTAMP) <= 1
    ),

    claimers_sales AS (
    SELECT
    ORIGIN_FROM_ADDRESS AS USER,
    ethereum.public.udf_hex_to_int(DATA) / pow(10, 18) AS Total_sent
    FROM arbitrum.core.fact_event_logs
    WHERE 1=1
    AND TOPICS[0] = '0x87aeeb9eda09a064caef63d00f62c15063631980bfc422ad7dd30c8a79f0cbb7'
    AND USER IN (SELECT USER FROM initial_claims)
    AND TX_STATUS = 'SUCCESS'
    AND DATEDIFF('Day', '2023-03-23', BLOCK_TIMESTAMP) <= 1
    ),

    purchases_after_airdrop AS (
    SELECT
    ORIGIN_TO_ADDRESS AS USER,
    ethereum.public.udf_hex_to_int(DATA) / pow(10, 18) AS Total_bought
    FROM arbitrum.core.fact_event_logs
    WHERE 1=1
    AND TOPICS[0] = '0x87aeeb9eda09a064caef63d00f62c15063631980bfc422ad7dd30c8a79f0cbb7'
    AND ORIGIN_TO_ADDRESS NOT IN (SELECT USER FROM initial_claims)
    AND ORIGIN_FROM_ADDRESS != '0x2b9acfd85440b7828db8e54694ee07b2b056b30c'
    AND TX_STATUS = 'SUCCESS'
    AND DATEDIFF('Day', '2023-03-23', BLOCK_TIMESTAMP) <= 1
    QueryRunArchived: QueryRun has been archived