DATE | VOLUME_TYPE | VOLUME | |
|---|---|---|---|
1 | 2023-02-01 00:00:00.000 | Normal | 489061318.249894 |
2 | 2024-08-01 00:00:00.000 | Normal | 3019623318.54173 |
3 | 2023-12-01 00:00:00.000 | Normal | 4934733432.35385 |
4 | 2024-07-01 00:00:00.000 | Normal | 3139330271.05502 |
5 | 2025-02-01 00:00:00.000 | Normal | 4688842891.01519 |
6 | 2024-01-01 00:00:00.000 | Normal | 4858046733.21439 |
7 | 2023-01-01 00:00:00.000 | Normal | 575130428.432033 |
8 | 2025-02-01 00:00:00.000 | Lazarus | 1336379002.09205 |
9 | 2025-04-01 00:00:00.000 | Normal | 1705948939.61385 |
10 | 2023-06-01 00:00:00.000 | Normal | 385821718.067173 |
11 | 2024-06-01 00:00:00.000 | Normal | 3123048320.20935 |
12 | 2023-07-01 00:00:00.000 | Normal | 449864932.833728 |
13 | 2023-10-01 00:00:00.000 | Normal | 2717594943.80616 |
14 | 2025-01-01 00:00:00.000 | Normal | 4676375039.8844 |
15 | 2024-10-01 00:00:00.000 | Normal | 2639673833.06073 |
16 | 2024-11-01 00:00:00.000 | Normal | 5385162060.71009 |
17 | 2024-12-01 00:00:00.000 | Normal | 5158370508.38702 |
18 | 2025-04-01 00:00:00.000 | Lazarus | 909562.231205537 |
19 | 2023-03-01 00:00:00.000 | Normal | 673333399.961941 |
20 | 2024-02-01 00:00:00.000 | Normal | 3843178568.19359 |
BlockTrackerlazaros group
Updated 1 day ago
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 lazarus_bybit_address as (
with json_input as (select livequery.live.udf_api('https://hackscan.hackbounty.io/public/hack-address.json') as response )
,
arbi_address AS (
SELECT VALUE::STRING AS address
FROM json_input,
LATERAL FLATTEN(input => GET_PATH(response, 'data."0221".arbi'))
),
bsc_address AS (
SELECT VALUE::STRING AS address
FROM json_input,
LATERAL FLATTEN(input => GET_PATH(response, 'data."0221".bsc'))
),
btc_address AS (
SELECT VALUE::STRING AS address
FROM json_input,
LATERAL FLATTEN(input => GET_PATH(response, 'data."0221".btc'))
)
,
eth_address as (
SELECT VALUE::STRING AS address
FROM json_input,
LATERAL FLATTEN(input => GET_PATH(response, 'data."0221".eth'))
)
,
sol_address as ( --
SELECT VALUE::STRING AS address
FROM json_input,
LATERAL FLATTEN(input => GET_PATH(response, 'data."0221".solana'))
)
SELECT address
FROM arbi_address
UNION ALL
SELECT address
FROM bsc_address
Last run: 1 day ago
32
2KB
13s