Cipher009-CpUJ5k2023-12-02 11:47 PM
Updated 2023-12-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
t.eth_from_address AS user_address,
SUM(t.amount) / 1e18 AS total_value_in_ether,
COUNT(*) AS transaction_count,
SUBSTRING(t.origin_function_signature, 3, 8) AS function_selector
FROM
ethereum.core.ez_eth_transfers AS t
WHERE
t.eth_to_address = '0x9DBd0FFD43A3D440CEc5Eb76c3dc02B9eeA56912'
AND SUBSTRING(t.origin_function_signature, 3, 8) = 'f994144d'
GROUP BY
t.eth_from_address,
SUBSTRING(t.origin_function_signature, 3, 8)
ORDER BY
total_value_in_ether DESC;
Run a query to Download Data