No Data to Display
flipperjo0Ethereum Check
Updated 5 days 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
ethereum.core.ez_token_transfers
WHERE
LOWER(contract_address) IN (
LOWER('0x085712B410c637EDc85EcF631857C74f5cdCd91e'),
LOWER('0xEfB79D04aAE9c1619AEea423F2685230A1D8D200')
)
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
ethereum.core.ez_token_transfers
WHERE
to_address IN (
SELECT
to_address
FROM
initial_addresses
)
AND amount_usd > 0
AND LOWER(to_address) NOT IN (
LOWER('0xe68d40485d223fac1667a0e7826a456fcc00ae99')
)
Last run: 5 days ago
0
2B
39s