0xtoshifindconnection
Updated 2023-09-01
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 suspectSybil as (
SELECT * FROM (
VALUES
('0x008b34d620493319c94d9e2e8ebeb3b602024f15'),
('0x297f97548e3e7a6c3054c8c36989a3fe7d037e5e'),
('0x37250ed5683476d32bac83a4b337f34adbe080bf'),
('0x5d2f3617de2997a29669a8dcc2caa42f6a08e2a1'),
('0x7c7982808cf12832ce17086930877bbc52ebad25'),
('0x867439daa8bdd72d65633c5e61870e6eae471f80'),
('0x8931144be611df4435626b2ae65a6d4588a66247'),
('0x953bad06ebbb361113a99bbc37ad9548ded518f1'),
('0xa40dbad86d0c09ce492307827ef25bd7f71a6e41'),
('0xd5c16df4258daa25ebec0ff74adf1a65e0b3c9c0'),
('0xd8703641e95d2cca7113062246610cf930b9721c')
) t (address)
), PolygonDepositor as (
SELECT MATIC_FROM_ADDRESS as FROM_ADDRESS, MATIC_TO_ADDRESS as TO_ADDRESS, AMOUNT, BLOCK_TIMESTAMP, TX_HASH, 'POLYGON' as BLOCKCHAIN
FROM polygon.core.ez_matic_transfers
WHERE MATIC_TO_ADDRESS IN (SELECT address FROM suspectSybil)
AND MATIC_FROM_ADDRESS IN (SELECT address FROM suspectSybil)
),
EthereumDepositor as (
SELECT ETH_FROM_ADDRESS as FROM_ADDRESS, ETH_TO_ADDRESS as TO_ADDRESS, AMOUNT, BLOCK_TIMESTAMP, TX_HASH, 'ETHEREUM' as BLOCKCHAIN
FROM ethereum.core.ez_eth_transfers
WHERE ETH_TO_ADDRESS IN (SELECT address FROM suspectSybil)
AND ETH_FROM_ADDRESS IN (SELECT address FROM suspectSybil)
),
ArbitrumDepositor as (
SELECT ETH_FROM_ADDRESS as FROM_ADDRESS, ETH_TO_ADDRESS as TO_ADDRESS, AMOUNT, BLOCK_TIMESTAMP, TX_HASH, 'ARBITRUM' as BLOCKCHAIN
FROM arbitrum.core.ez_eth_transfers
WHERE ETH_TO_ADDRESS IN (SELECT address FROM suspectSybil)
AND ETH_FROM_ADDRESS IN (SELECT address FROM suspectSybil)
),
OptimismDepositor as (
SELECT ETH_FROM_ADDRESS as FROM_ADDRESS, ETH_TO_ADDRESS as TO_ADDRESS, AMOUNT, BLOCK_TIMESTAMP, TX_HASH, 'OPTIMISM' as BLOCKCHAIN
FROM optimism.core.ez_eth_transfers
Run a query to Download Data