USER | TRANSFERS | USD_AMOUNT | AVG_AMOUNT_TRANSFERRED | TOKENS_TRANSFERRED | |
|---|---|---|---|---|---|
1 | 0x5f364e17c75762440802c93ca6dc8b4b99e94eaa | 1 | 543.9 | 543.9 | ETH |
2 | 0x66dc2cccd7fa6206617a8bdee3fb6dc21b848a3a | 1 | 271.95 | 271.95 | ETH |
3 | 0x7d8fe63026e4a6c6cce63dd1199cd7650fba3a38 | 1 | 269.83 | 269.83 | ETH |
4 | 0x1f96649560f2e5cde1356929796971cfd1df9f56 | 1 | 269.83 | 269.83 | ETH |
5 | 0x82b171ccadf43fc453b428b428693be638d62843 | 1 | 250.037546885 | 250.037546885 | USDC |
6 | 0x73da852e961c2939a711b4596d39896fdb74fd35 | 1 | 249.984 | 249.984 | USDC |
7 | 0xe30d38d0da9591aee94696c4be6fab4feb6f0b0a | 1 | 147.84 | 147.84 | ETH |
8 | 0x23176b5c391fd6f957f6e7354cafb294935130be | 1 | 100.62 | 100.62 | ETH |
9 | 0x15a69bd652a2db3834a37bbaa1f6529ce2be1e02 | 1 | 100.45 | 100.45 | ETH |
10 | 0x25e2a352478b83dc0de5d74bec53a8f13d4062b6 | 1 | 99.97 | 99.97 | ETH |
11 | 0xff04a3cf847edeeacb247cef23859a06574461c1 | 1 | 81.06 | 81.06 | ETH |
12 | 0x369575d3dc46079077692a6e8868746d4b402410 | 1 | 54.999835 | 54.999835 | USDC |
13 | 0x216116c1db0099c398f912dc9331e5c1fe1e1b75 | 1 | 54.15 | 54.15 | ETH |
14 | 0xff21ce470788e58a65836e4212f1bc928fd5fa49 | 1 | 54.08 | 54.08 | ETH |
15 | 0x1d891a31e92bd4327b2562f86b7eb100c3ea27a8 | 1 | 44.82 | 44.82 | ETH |
16 | 0x944b4cd2a1e6a59cbec6ca0777267f11c3c981e2 | 1 | 29.81700635 | 29.81700635 | USDT |
17 | 0x3ba3893fde7e06eaf13a4c06e190147b867c82fb | 1 | 27.02 | 27.02 | ETH |
18 | 0x8fa84759562491b2b92fa649971a236054f5c413 | 1 | 26.98 | 26.98 | ETH |
19 | 0xc8cabb9007872426a0425f2a8cf57089f0e980ed | 1 | 26.658275287 | 26.658275287 | USDC |
20 | 0x578eef570bbaab9723feef4ff2f39f35e0c1c95f | 1 | 25.84 | 25.84 | ETH |
freemartianAll Users
Updated 2025-02-11
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
›
⌄
WITH transfers AS (
SELECT
block_timestamp, tx_hash, from_address AS user, amount, amount_usd, symbol
FROM base.core.ez_token_transfers
WHERE to_address = '0xa035e7fa5e4704c2ecb2f7f8c1eeff09c550fdc5'
AND block_timestamp::date >= '2025-02-10'
AND has_price
UNION ALL
SELECT
block_timestamp, tx_hash, from_address AS user, amount, amount_usd, 'ETH' AS symbol
FROM base.core.ez_native_transfers
WHERE to_address = '0xa035e7fa5e4704c2ecb2f7f8c1eeff09c550fdc5'
AND block_timestamp::date >= '2025-02-10'
)
SELECT
user, count(tx_hash) AS transfers, SUM(amount_usd) AS usd_amount, AVG(amount_usd) avg_amount_transferred, LISTAGG(DISTINCT symbol, ', ') WITHIN GROUP (ORDER BY symbol) AS tokens_transferred
FROM transfers
GROUP BY 1
ORDER BY 3 DESC
Last run: about 2 months agoAuto-refreshes every 1 hour
23
2KB
16s