TX_HASH | DISTINCT_TO_ADDRESS | |
|---|---|---|
1 | 0xec48569063925474836c30b3bb9f449fde1a40f4e51a34b08f3eebe780a9297a | 0x14968d8b4eb966848ff78e9c17f65e9f1afbb820 |
2 | 0x25bc3822f122f8dda04fae8caac196d1f9fa50eaf59971daf722b030fd1a3750 | 0x14968d8b4eb966848ff78e9c17f65e9f1afbb820 |
3 | 0xde18ae0b0617768214509c4ae896a9a4355b402370a91626e241d872d7682d57 | 0x1d6c52631df36fbd699141f11a4cdc0d08baf176 |
4 | 0xad5824baf7d8a8c96a8661d7bd14a1002b77c1feaa0080feb49879db298cd55f | 0x212ac61a1faf46af2fb798c5a6afdb70735bab94 |
5 | 0x865229c1edc03b357fcfeae89edc0e2a126fabd55730329e7e1acf5969cfa15f | 0x319763bf57f2218a5e7fd60a9ccb56fdbb3c7953 |
6 | 0xcae8fe773e7bb0a0cfb00f45a0e6659789950463c1de7d649fc2f0d28ba13cd5 | 0x39a578443e2e81190c75a605aca1b2c38ee5c406 |
7 | 0x74c196aa64120819867a1a7487e4e5b1fcd83e1e19b23ae44723c63714f2acd1 | 0x39a578443e2e81190c75a605aca1b2c38ee5c406 |
8 | 0xab3daa4bd69dd8a1b0173f0402c0b2f783bfc097919ba3a0b85986a0fe65e54b | 0x39a578443e2e81190c75a605aca1b2c38ee5c406 |
9 | 0x4a80ef5577c8a96d7dcf39746371919ec237a0a7579bd09c2ae7f837f441d140 | 0x39a578443e2e81190c75a605aca1b2c38ee5c406 |
10 | 0xc81f0279b1ba9ffc38d0910ef05df1774147922339ca7d2b0e5d5f5eac7c2798 | 0x4c78a97cef589b01bb91dbf893fffa14243d2444 |
11 | 0x37ba710a7dd6b2f011714022e0f6fc22e277729c9ef431b25096c3b01615e446 | 0x615803c1ab56b5b1314d9a7728729f840e7a51cf |
12 | 0x01c4ea23822f17b0c334aeb68a49b1dc2d97818debfe05fd099069de71a2c9f4 | 0x71e6686f6267b454dbdf6db3399e7d6ced2b5313 |
13 | 0x78754dbba80e674eb113286d08eaf21e2c0f74cab327b7a714edf792ef1b68cf | 0x71e6686f6267b454dbdf6db3399e7d6ced2b5313 |
14 | 0x3f4de073281448e752569fb7c9c8c9eafed92bf8189da192d6903b6d492db336 | 0x9c7fc6916095d6492fa9fc388e633f7bce3aa9ef |
15 | 0x328ae365a07a9a7fb7dcb9f73a49eb8931acf7830b0f3a9ccd0ccc9a825748e2 | 0x9c7fc6916095d6492fa9fc388e633f7bce3aa9ef |
16 | 0xe6720d068c9a3b27fbce05e23276cbde8667adb0afe167314c20fc653f2aab00 | 0xa42f7168d19c9d94e50e5c778e13e3195ce9126b |
17 | 0x945719ee5d7b1e64a4e1ec31a7198f47c29a94639859f027034f0bfe2ef8339d | 0xa42f7168d19c9d94e50e5c778e13e3195ce9126b |
18 | 0x822d8de2ff5cadbf575cbadb87928ea936cd40597113b335b4cbaf8f80b80705 | 0xa989f388644d466fc57e79c149ab7a6cbb9816f3 |
19 | 0x085111e7826f2ea66799cd87e1dcb210d8d9a7f9091e790f9fe50274f776a2d2 | 0xc938ba7c04e43d528f987a3c297f1526dcb95ee8 |
20 | 0x5294b6ca825f3abe9e5ddda0284102c93002332722e0aca447d8c9eaaf4d6353 | 0xc938ba7c04e43d528f987a3c297f1526dcb95ee8 |
datavortexassociated-sapphire
Updated 2025-03-21
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
›
⌄
⌄
⌄
SELECT DISTINCT tx_hash,
decoded_log:to AS distinct_to_address
FROM
ethereum.core.ez_decoded_event_logs
WHERE
decoded_log:from = LOWER('0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0')
AND origin_function_signature = ('0x23024408') --0x6a761202 -- 0x70a10c89
ORDER BY
distinct_to_address;
/*
SELECT DISTINCT origin_function_signature
FROM ethereum.core.ez_decoded_event_logs
WHERE decoded_log:from = LOWER('0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0')
AND decoded_log:to = LOWER('0xDA28e780472B5754a1144bcE6e83aF06a33107D2')
*/
/*
SELECT
decoded_log:from,
decoded_log:to, decoded_log:value / 1e6,
event_name,
block_timestamp,
origin_function_signature,
tx_hash
FROM
ethereum.core.ez_decoded_event_logs
WHERE
-- event_name = 'Transfer'
--decoded_log:to = LOWER('0x028FFcfF8c8d9C0E75186F62fF483adDbBC50075')
decoded_log:from = LOWER('0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0') --
and origin_function_signature = '0x23024408'
--AND date(block_timestamp) = '2025-03-17'
*/
Last run: 3 months ago
25
3KB
31s