BLOCK_TIMESTAMP | TX_HASH | FROM_ADDRESS | TO_ADDRESS | AMOUNT | AMOUNT_USD | CONTRACT_ADDRESS | SYMBOL | TRANSFER_TYPE | |
|---|---|---|---|---|---|---|---|---|---|
1 | 2025-06-03 16:20:43.000 | 0x7521075d10ff83181e042da7435b2eb738a16776e927e5fcad3bc852bad0938c | 0xe56dd3624fde5c426aa0631fd8fcfb877c52e5a5 | 0xb5da52efc788a69edccf56e001a3a49298432201 | 1 | 1 | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | USDC | ERC20 |
2 | 2025-06-03 15:59:47.000 | 0x0225d4a5700f267d98bf810df9afd08c9569119896f4eafc6755711516809c5f | 0x2a07e5f30dfff8a33428eab14ff416e118aad048 | 0xf9895c0cb1560ba216e2de9c9a0b582699b62fa0 | 1 | 1 | 0x833589fcd6edb6e08f4c7c32d4f71b54bda02913 | USDC | ERC20 |
flipperjo0Base Check
Updated 9 hours ago
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 initial_addresses AS (
SELECT
DISTINCT to_address
FROM
base.core.ez_token_transfers
WHERE
LOWER(contract_address) IN (
-- My Tokens --
LOWER('0xefb79d04aae9c1619aeea423f2685230a1d8d200'),
LOWER('0xd9c5A67Dc8c782438864439f407f6cE2DA48D690'),
LOWER('0x20B454bda55840CDe0f908B3adC89244D64000a1'),
LOWER('0x1364111cD7351981f7D8C1a834b84c2A59A65680'),
LOWER('0x92861f808E8Ca9016cc5099556693404a7F3D2f1'),
LOWER('0x02DCB2ecc40d241F25FF1733de56F175AEA2Aa29')
-- Competitors --
-- LOWER('0x1619d964cf6904eAc8979464d99D92BEDD6e4435'),
-- LOWER('0xf89C349f460d6134724D89A6bCBF93d6520e0a08')
)
AND to_address IS NOT NULL
),
filtered_token_transfers AS (
SELECT
block_timestamp,
tx_hash,
from_address,
to_address,
amount,
amount_usd,
contract_address,
symbol,
'ERC20' AS transfer_type
FROM
base.core.ez_token_transfers
WHERE
to_address IN (
SELECT
Last run: about 9 hours ago
2
503B
170s