FROM_ADDRESS | TRANSACTIONS | ETH_VALUE | USD_VALUE | RANK | |
|---|---|---|---|---|---|
1 | 0xc3708f8c576f9b374138d7cc101978da8ec954b6 | 7 | 5102.615497967 | 11748924.8674263 | 7 |
freemartianuser1
Updated 2024-02-16
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
34
35
36
›
⌄
with puffer AS (
SELECT
block_timestamp,
tx_hash,
origin_function_signature,
from_address,
to_address,
amount,
amount_usd,
symbol
FROM ethereum.core.ez_token_transfers
WHERE to_address = '0x4aa799c5dfc01ee7d790e3bf1a7c2257ce1dceff'
AND origin_from_address = from_address
AND block_timestamp::date >= '2024-02-01'
),
users AS (
SELECT
from_address,
count(tx_hash) AS transactions,
SUM(amount) AS eth_value,
SUM(amount_usd) AS usd_value,
rank() over(ORDER BY SUM(amount) DESC) AS rank
FROM puffer
GROUP BY 1
ORDER BY 3 DESC
LIMIT 20
)
SELECT * FROM users WHERE from_address = lower('{{wallet_address}}')
Last run: about 1 year ago
1
84B
1s