petertherockStarkware Qn 1
Updated 2022-06-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
SELECT
COUNT (DISTINCT(eth_from_address)) AS number_of_addresses,
SUM(amount) AS eth_amount,
'deposited' AS action
FROM ethereum.core.ez_eth_transfers
WHERE
eth_to_address = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419'
AND origin_function_signature = '0xb6b55f25'
-- AND tx_hash = '0x97a6db34db05b98c61d6d40d81965850124648ba1ff7fdd557b3f2d4522d7b9c'
UNION ALL
SELECT
COUNT (DISTINCT(eth_to_address)) AS number_of_addresses,
SUM(amount) AS eth_amount,
'withdrawn' AS action
FROM ethereum.core.ez_eth_transfers
WHERE
eth_from_address = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419'
AND origin_function_signature = '0x00f714ce'
-- AND tx_hash = '0x07fd50c90831dd95d759d37ed4bb603a10bd2d4b712215e0c6ddcd827499767d'
-- SELECT
-- *
-- FROM ethereum.core.ez_eth_transfers
-- WHERE
-- eth_from_address = '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419'
-- AND origin_function_signature = '0x00f714ce'
-- AND tx_hash IN ('0x07fd50c90831dd95d759d37ed4bb603a10bd2d4b712215e0c6ddcd827499767d',
-- '0xedf6fca3b0447f717bcc1281d096a5d639c1c216327a41f5fa042ae0e85ef172',
-- '0xd9cf5272231d575782cf4761f5671e2afdad23add08d56b857ce1bd5c89a829b')
Run a query to Download Data