theericstoneens task
    Updated 2022-07-26
    SELECT origin_address,
    MAX(CASE WHEN (origin_address = to_address AND origin_function_signature = '0x76122903' AND event_type = 'erc20_transfer') THEN AMOUNT/1e18 ELSE 0 END) as tokens_in,
    MAX(CASE WHEN (origin_address = to_address AND origin_function_signature = '0x76122903' AND event_type = 'erc20_transfer') THEN 0 ELSE AMOUNT/1e18 END) as tokens_out
    FROM ethereum.udm_events
    WHERE
    contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
    AND block_timestamp >= CURRENT_DATE - 180

    GROUP BY origin_address
    LIMIT 10000


    Run a query to Download Data