theericstoneens task
Updated 2022-07-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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