BLOCK_TIMESTAMP | TX_HASH | FROM_ADDRESS | TO_ADDRESS | AMOUNT | AMOUNT_USD | CONTRACT_ADDRESS | SYMBOL | TRANSFER_TYPE | |
|---|---|---|---|---|---|---|---|---|---|
1 | 2025-05-20 09:48:44.000 | 0x1f450e3464d2a45214c2d398e176ad29a49f01b323f8d5b0e693bc9623392d4f | 0x7fed2e17868121d72e75f571f227f7ebfe360ca8 | 0x43bfaa1ff40507e8aa7290d201e8ad5d42a5f170 | 20 | 20 | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | USDC | ERC20 |
2 | 2025-05-14 07:05:42.000 | 0x2b84598397caaaac76e9e1ae75d41dc391c6de4fcd0102289c0ad4eba991430c | 0x8a5bc9cf4faced6aa15dd89423066cb52b702f3c | 0x9a157d99b2463fa26c9d57dcd6e0e8557966980f | 4.593415 | 4.59 | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | USDt | ERC20 |
3 | 2025-05-12 07:50:59.000 | 0x5af11a63c98351d9aac49c15ecef7739ad6c322d9eab7ba754e40b57d41540c8 | 0xd328097602b9cef563a294eb940f6f9f781a2e0f | 0x3eb0d95df5a9c90d4746ab5ae4ca9e97696af80f | 100 | 100 | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | USDC | ERC20 |
4 | 2025-05-11 15:01:59.000 | 0xaaf1ff941dc602192b56f7c29fbaf3960823a65e2ea01aad7701830d65aa57fa | 0x81727959fc23610c84e6e9271be4dce254267c52 | 0x4d1506111c4cc880bba0b985ce4754116c8d55f2 | 30 | 30 | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | USDC | ERC20 |
5 | 2025-05-09 11:49:52.000 | 0x98a77ad038fddb3086bc4f726caa797df4438dd7389b1bc033ef603d2637c6d3 | 0xfddc787887346777ed8d1e6477ee37b5c8b1a8cc | 0x036823738f0bf4182015701885155ac322d9d8fd | 9 | 9 | 0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7 | USDt | ERC20 |
flipperjo0Avax Check
Updated 2 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
avalanche.core.ez_token_transfers
WHERE
LOWER(contract_address) IN (
-- My Tokens --
LOWER('0xb1f6078fc1bc983f0ef549a44cfdf3d562b87e87'),
LOWER('0xcc2212fd511b5e13b52e0a89026adfb72114436a'),
LOWER('0x50ce8b566f10058c45be6b334b72a4a3dcb5d816')
-- Competitors --
-- LOWER('0x7c4ae9e8f44e534e38155ecf1d3998cc10318835'),
-- LOWER('0x26115bD45140309ebb05a23228772066c2A9FaF5')
)
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
avalanche.core.ez_token_transfers
WHERE
to_address IN (
SELECT
to_address
FROM
initial_addresses
Last run: about 2 hours ago
5
1KB
12s