BLOCK_TIMESTAMP | TX_HASH | FROM_ADDRESS | TO_ADDRESS | AMOUNT | AMOUNT_USD | CONTRACT_ADDRESS | SYMBOL | |
|---|---|---|---|---|---|---|---|---|
1 | 2025-03-24 19:40:56.000 | 0x4922e1cccff47d1d61ff01e89eba769523601175e254528c9aba5e4e2b913893 | 0x714e5676c388c4ddb01e79b385139fbded20edad | 0x13a19e1f977da37a0e4c99175d0b8276550ca47f | 355 | 354.94604 | 0x3c499c542cef5e3811e1192ce70d8cc03d5c3359 | USDC |
2 | 2025-01-05 00:01:44.000 | 0xb8f749af6deec5ebe6504c01287b93ab6b884e230e234b710a28731a15510203 | 0x471f6aba65f1aece353af0938703aef66535a3b3 | 0x3c17ced80661d50252199a1d1d249f35fed83130 | 160.958942351 | 5.742966778 | 0x59b5654a17ac44f3068b3882f298881433bb07ef | CHP |
flipperjo0unsightly-green
Updated 2025-03-30
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
polygon.core.ez_token_transfers
WHERE
LOWER(contract_address) IN (
LOWER('0x8C2Bc8D864eDF00680f27dd2B35E3Ae7287EF794'),
LOWER('0x3619D11399f78e0f46569fd394fFaB419dC02347'),
LOWER('0x7D49Fe3D004B238fcafE3fE480F4546c5D6B4e7D')
)
AND to_address IS NOT NULL
),
filtered_transactions AS (
SELECT
block_timestamp,
tx_hash,
from_address,
to_address,
amount,
amount_usd,
contract_address,
symbol
FROM
polygon.core.ez_token_transfers
WHERE
to_address IN (
SELECT to_address
FROM initial_addresses
)
AND amount_usd > 1
)
SELECT
*
FROM
filtered_transactions
Last run: 25 days ago
2
518B
305s