arabianhorses-jZtVNa2023-06-16 03:25 PM
    Updated 2023-06-16
    SELECT
    CASE CONTRACT
    WHEN '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3' THEN 'DAI'
    WHEN '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8' THEN 'USDC'
    WHEN '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' THEN 'ETH'
    ELSE 'CHECK'
    END AS tokenSymbol
    , PARAMETERS[2]:"value"[0]:"value" AS rawValue
    , TX_HASH

    FROM external.tokenflow_starknet.decoded_events ev

    WHERE NAME = 'Transfer'
    AND CONTRACT IN ( '0x00da114221cb83fa859dbdb4c44beeaa0bb37c7537ad5ae66fe5e0efd20e6eb3'
    , '0x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a8'
    , '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7' )
    LIMIT 200
    Run a query to Download Data