DigitalDanUser Activity with $ARB Tokens Users copy
    Updated 2023-03-29
    -- forked from dbd7773d-08b2-42ad-9c65-40ef885cd555

    WITH all_arb_airdrops AS (
    SELECT
    CONCAT('0x', SUBSTR(TOPICS[1], -40, 40)) AS AIRDROP_WALLET_RECIPIENT,
    ethereum.public.udf_hex_to_int(DATA) / pow(10, 18) AS CLAIMED_AMOUNT
    FROM
    arbitrum.core.fact_event_logs
    WHERE
    ORIGIN_TO_ADDRESS = '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9'
    AND ORIGIN_FUNCTION_SIGNATURE = '0xae373c1b'
    AND BLOCK_NUMBER >= 70506697
    AND TX_STATUS = 'SUCCESS'
    ),
    token_transfers AS (
    SELECT
    FROM_ADDRESS,
    TO_ADDRESS,
    RAW_AMOUNT / POWER(10, 18) AS AMOUNT,
    BLOCK_TIMESTAMP
    FROM
    arbitrum.core.fact_token_transfers
    WHERE
    contract_address = lower('0x912CE59144191C1204E64559FE8253a0e49E6548')
    AND from_address != '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9'
    ),
    transfers_with_labels AS (
    SELECT
    tt.FROM_ADDRESS,
    tt.TO_ADDRESS,
    tt.AMOUNT,
    tt.BLOCK_TIMESTAMP,
    dl.ADDRESS_NAME,
    dl.LABEL_TYPE,
    dl.LABEL_SUBTYPE,
    dl.PROJECT_NAME
    Run a query to Download Data