Abbas_ra21Untitled Query
    Updated 2022-08-28
    with withdraw_TX AS (select * from arbitrum.core.fact_event_logs
    where CONTRACT_ADDRESS='0x794a61358d6845594f94dc1db02a252b5b4814ad'
    and TOPICS[0] = '0x2b627736bca15cd5381dcf80b0bf11fd197d01a037c52b927a881a10fb73ba61')
    select DISTINCT PROJECT_NAME,ADDRESS_NAME,LABEL_SUBTYPE,LABEL_TYPE
    from arbitrum.core.fact_token_transfers inner join arbitrum.core.dim_labels on ADDRESS=CONTRACT_ADDRESS
    where TX_HASH in (select TX_HASH from withdraw_TX) and FROM_ADDRESS=ORIGIN_FROM_ADDRESS
    limit 10

    Run a query to Download Data