CHAIN | TRANSACTIONS | USERS | USD_AMOUNT | AMOUNTS | |
|---|---|---|---|---|---|
1 | Arbitrum | 25 | 22 | 8507.882805742 | 7225.532804729 |
2 | BSC | 8 | 7 | 513.619893098 | 511.62919391 |
3 | Base | 272 | 203 | 335592.646852159 | 39279344.6035874 |
4 | Ethereum | 45 | 39 | 186342.414313998 | 78899.599157784 |
5 | Optimism | 5 | 5 | 703.146064395 | 424.781496 |
mehdimarjanTotal Amount per chain
Updated 2025-03-11
999
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
234B
93s