TOTAL_TOKENS_RELEASED | DIRECT_TO_CEX_HOP1 | TO_CEX_HOP2 | TO_CEX_HOP3 | TO_CEX_HOP4 | TO_CEX_HOP5 | TOTAL_TO_CEX | UNIQUE_CEX_HOP1 | UNIQUE_CEX_HOP2 | UNIQUE_CEX_HOP3 | UNIQUE_CEX_HOP4 | UNIQUE_CEX_HOP5 | TOTAL_UNIQUE_CEX | TX_COUNT_HOP1 | TX_COUNT_HOP2 | TX_COUNT_HOP3 | TX_COUNT_HOP4 | TX_COUNT_HOP5 | PERCENTAGE_TO_CEX | PERCENT_OF_TOTAL_VESTING | PERCENT_OF_CLIFF | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 848101961.514931 | 2783854.17 | 145377664.755533 | 31281833.4325177 | 188491268.924011 | 269288076.567672 | 637222697.849734 | 2 | 49 | 18 | 330 | 871 | 1002 | 5 | 109 | 487 | 2599 | 4520 | 75.135151994 | 10.601274519 | 42.405098076 |
0xgabeENA - All vesting contracts
Updated 9 days ago
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
›
⌄
-- Token Flow Tracking from Vesting Contracts to CEX through 4 hops
-- This query uses a recursive approach to track token flows through multiple hops
-- while preventing double counting by following balance-based constraints
WITH
-- Define source vesting contract addresses
vesting_contracts AS (
SELECT address, description FROM (
VALUES
(LOWER('0xd4B34207a671b813B5E66d31EA0b0A9849de9bc1'), '600mil multisig investors'),
(LOWER('0xc4e512313dd1ce0795f88ec5229778edf1fdf79b'), '2.8bil vest core contributors'),
(LOWER('0x2146aa5807d96e6b2922a149cee870f17347f1d0'), '1.5bil vest probable core contributors'),
(LOWER('0x54b8c65f0635fd91c8729dd3269c630d9aed54e5'), '1.31bil vest probable investors'),
(LOWER('0x877b3d5c681c8890d19dbf450306caa3c3d4bba6'), '375mil vest investor'),
(LOWER('0x41c7d5db1bb11a30196f4e9873b2ce417b9cba39'), '350mil vest'),
(LOWER('0x3c716d252b53891753de883894ff29a9ebee0f54'), '130mil vest blocktower'),
(LOWER('0x3cd9c4942467c859224325b41aeb3a4d2b84c541'), '90mil vest'),
(LOWER('0x8af2833f3aa3933a58c07e6244f9c35580f4611d'), '60mil vest'),
(LOWER('0xf608291ed68a5ab477a4eacf5781060936970a6e'), '40mil vest')
) AS src(address, description)
),
-- Define centralized exchange addresses
cex_addresses AS (
SELECT address
FROM ethereum.core.dim_labels
WHERE label_type = 'cex'
UNION
-- Add known OTC desks and additional unlabeled exchange addresses
SELECT address FROM (
VALUES
(LOWER('0xe67821b76985007b4cf744b0f045c8933b3e91d9')), -- FalconX
(LOWER('0x3284ac109eb04f070b40ea2bdc644d3a00de7bdb')), -- Galaxy Digital
(LOWER('0x6c4898242ec8efe57cd079b435a11cb56fa28804')), -- Nonco
Last run: 9 days ago
1
196B
137s