No Data to Display
flipperjo0Base Check
Updated 4 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')
-- 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
to_address
FROM
initial_addresses
)
Last run: about 4 hours ago
0
2B
104s