WALLET | OTHER | TX_TYPE | AMOUNT | TX_COUNT | BALANCE | LABEL_TYPE | LABEL_SUBTYPE | LABEL | ADDRESS_NAME | SOURCE | LABEL_PRIORITY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0x9059b7c20390161af7a8fd2aac21f1b9ac7b22be | 0xdf71525e5c7435ef860909547d1589e53c004f03 | out | 383053.704409842 | 4 | 4269909.90505447 | defi | dex | dex_pool | 3 | ||
2 | 0x9059b7c20390161af7a8fd2aac21f1b9ac7b22be | 0xd152f549545093347a162dce210e7293f1452150 | in | 215642.155080729 | 1 | -5.784386303e-10 | ||||||
3 | 0x9059b7c20390161af7a8fd2aac21f1b9ac7b22be | 0xdf71525e5c7435ef860909547d1589e53c004f03 | in | 155892.973044533 | 4 | 4269909.90505447 | defi | dex | dex_pool | 3 | ||
4 | 0x9059b7c20390161af7a8fd2aac21f1b9ac7b22be | 0xe8818e9666ff824c56135675a182d9153d279f8e | in | 11518.57628458 | 2 | 973.562477648 | defi | dex | dex_pool | 3 |
0xbitoken_flow_genera3 ethereum copy
Updated 2024-02-09
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 token_flow_genera2 ethereum @ https://flipsidecrypto.xyz/edit/queries/c7507283-dcf6-4e04-bd0e-da33f007a5c6
-- forked from token_flow_general @ https://flipsidecrypto.xyz/edit/queries/3e53f94c-0a90-4bc3-a404-5324f9224415
-- 0xfc5a1a6eb076a2c7ad06ed22c90d7e710e35ad0a
with contract_address_dim as (SELECT CONTRACT_ADDRESS as address from ethereum.core.fact_event_logs group by 1 ),
pool_address_dim AS ( SELECT POOL_ADDRESS as address FROM ethereum.defi.dim_dex_liquidity_pools GROUP BY 1 ),
special_address_dim AS (
SELECT
lower(ADDRESS) as ADDRESS, LABEL_TYPE, LABEL_SUBTYPE
FROM
(VALUES
('0xa75287d2f8b217273e7fcd7e86ef07d33972042e', 'defi','Vested GLP (vGLP)'),
('0x2032f4294f5c7111cac355b48d3d7f118c2e41a8', 'defi','GMX Bonds'),
('0x199070ddfd1cfb69173aa2f7e20906f26b363004', 'defi',' Vested GMX (vGMX)'),
('0xdddc546e07f1374a07b270b7d863371e575ea96a', 'defi',' tokenManager'),
('0x5f799f365fa8a2b60ac0429c48b153ca5a6f0cf8', 'defi',' GMX: Deployer'),
('0x50F22389C10FcC3bA9B1AB9BCDafE40448a357FB', 'defi',' GMX: Treasury1'),
('0x4E29d2ee6973E5Bd093df40ef9d0B28BD56C9e4E', 'defi',' GMX: Treasury2'),
('0x908c4d94d34924765f1edc22a1dd098397c59dd4', 'defi',' Staked GMX (sGMX)'),
('0x80a9ae39310abf666a87c743d6ebbd0e8c42158e', 'defi',' GMX: GMX - ETH Uniswap Pool'),
('0x2068fcc879f849e2d021b888ce62edb6e72a6bbf', 'defi',' Timelock'),
('0x49b373d422bda4c6bfcdd5ec1e48a9a26fda2f8b', 'defi',' Timelock Admin that Swap Collected Fee to WETH'),
('0x37f9ae2e0ea6742b9cad5abcfb6bbc3475b3862b', 'bridge',' Synapse: Bridge Zap 1'),
('0x26532682e1830cdacccbb7e385cff6de14dd08d8', 'bridge',' Synapse: Bridge Zap'),
('0xbb00f2e53888e60974110d68f1060e5eaab34790', 'defi',' referralStorage.setReferrerTier 1'),
('0x5F799f365Fa8A2B60ac0429C48B153cA5a6f0Cf8', 'defi',' referralStorage.setReferrerTier 2'),
('0xf66c5E4a91FF10466E78BD50F87449a802053112', 'defi',' Timeblock Spender'),
('0x68863dde14303bced249ca8ec6af85d4694dea6a', 'defi',' GmxTimelock'),
('0x0000000000000000000000000000000000000000', 'Blackhole', 'Blackhole')
) AS t (ADDRESS, LABEL_TYPE, LABEL_SUBTYPE)
),
final_label_raw_dim as
Last run: over 1 year ago
4
655B
30s