SYMBOL | TRANSACTIONS | USERS | USD_AMOUNT | AMOUNTS | |
|---|---|---|---|---|---|
1 | ETH | 18 | 18 | 2161.87 | 0.7986678329 |
2 | USDC | 4 | 4 | 581.679657172 | 581.697612 |
3 | USDT | 1 | 1 | 29.81700635 | 29.837445 |
freemartianTotal Amount per token
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
29
30
31
32
›
⌄
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
symbol,
count(tx_hash) AS transactions,
count(DISTINCT user) AS users,
SUM(amount_usd) AS usd_amount,
SUM(amount) AS amounts,
FROM transfers
group by 1
order BY 1 ASC
Last run: 3 months agoAuto-refreshes every 1 hour
3
109B
5s