SYMBOL | TRANSACTIONS | USERS | USD_AMOUNT | AMOUNTS | |
|---|---|---|---|---|---|
1 | ETH | 167 | 135 | 190578.57 | 70.392824685 |
2 | KAITO | 1 | 1 | 20433 | 7350 |
3 | USDC | 149 | 124 | 210925.835015712 | 210940.118013 |
4 | USDT | 19 | 18 | 101015.739251591 | 101254.859766309 |
5 | YT | 19 | 4 | 8706.565662087 | 39046790.7756358 |
mehdimarjanTotal Amount per token
Updated 2025-03-15
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 transfers AS (
-- Base
SELECT
block_timestamp, tx_hash, from_address AS user, amount, amount_usd, symbol, 'Base' AS chain
FROM base.core.ez_token_transfers
WHERE to_address = '0xa035e7fa5e4704c2ecb2f7f8c1eeff09c550fdc5'
AND block_timestamp::date >= '2025-02-10'
AND has_price
AND amount_usd > 0.01
UNION ALL
SELECT
block_timestamp, tx_hash, from_address AS user, amount, amount_usd, 'ETH' AS symbol, 'Base' AS chain
FROM base.core.ez_native_transfers
WHERE to_address = '0xa035e7fa5e4704c2ecb2f7f8c1eeff09c550fdc5'
AND block_timestamp::date >= '2025-02-10'
AND amount_usd > 0.01
UNION ALL
-- Ethereum
SELECT
block_timestamp, tx_hash, from_address AS user, amount, amount_usd, symbol, 'Ethereum' AS chain
FROM ethereum.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, 'Ethereum' AS chain
FROM ethereum.core.ez_native_transfers
WHERE to_address = '0xa035e7fa5e4704c2ecb2f7f8c1eeff09c550fdc5'
AND block_timestamp::date >= '2025-02-10'
UNION ALL
-- Optimism
Last run: about 1 month agoAuto-refreshes every 12 hours
5
206B
32s