TheLaughingManREPORT # 14
Updated 2024-05-29
999
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
›
⌄
-- forked from Cluster Details @ https://flipsidecrypto.xyz/edit/queries/62e5c11d-1412-425c-827b-14cee4674420
-- forked from Sybils: CEX Deposit Clusters - A - Overview @ https://flipsidecrypto.xyz/edit/queries/7b449cdc-ce21-48a8-a5a3-52899727ebed
-- ARKHAM LINK: https://platform.arkhamintelligence.com/visualizer/entity/0xeF29688Da54f5Dd185201C6e50357Ef4Ca0004b3?flow=all&positions=%7B%7D&sortDir=desc&sortKey=time&usdGte=0.1
with snap_senders as (
SELECT
DISTINCT sender_wallet as wallet
FROM external.layerzero.fact_transactions_snapshot
WHERE 1=1
)
,
cluster_detail as (
(
SELECT
DISTINCT to_address as deposit_wallet
, project_name as cex
, 'arbitrum' as cluster_src
, from_address as cluster_member
from arbitrum.core.fact_token_transfers t
LEFT JOIN arbitrum.core.dim_labels dl on t.to_address=dl.address
where 1=1
and dl.label_type='cex'
and dl.label_subtype IN ('deposit_wallet') --, 'hot_wallet'
AND from_address IN (SELECT wallet from snap_senders)
--AND to_address = '0x95dcf8372dceb2a43478d590872c9d27cf43dd84'
)
UNION ALL
(
SELECT
DISTINCT to_address as deposit_wallet
QueryRunArchived: QueryRun has been archived