DATE | VOLUME_TYPE | VOLUME | |
---|---|---|---|
1 | 2023-01-01 00:00:00.000 | Normal | 575130428.432032 |
2 | 2023-06-01 00:00:00.000 | Normal | 385821718.067173 |
3 | 2023-10-01 00:00:00.000 | Normal | 2717594943.80613 |
4 | 2024-07-01 00:00:00.000 | Normal | 3139327522.51385 |
5 | 2023-02-01 00:00:00.000 | Normal | 489061318.249894 |
6 | 2024-08-01 00:00:00.000 | Normal | 3019621092.41896 |
7 | 2025-03-01 00:00:00.000 | Normal | 3717224088.01674 |
8 | 2025-04-01 00:00:00.000 | Normal | 1980626860.64166 |
9 | 2025-04-01 00:00:00.000 | Lazarus | 891520.278746163 |
10 | 2023-03-01 00:00:00.000 | Normal | 673333399.961941 |
11 | 2023-04-01 00:00:00.000 | Normal | 465356743.658814 |
12 | 2025-03-01 00:00:00.000 | Lazarus | 968052979.119611 |
13 | 2025-05-01 00:00:00.000 | Normal | 3114030830.94228 |
14 | 2025-06-01 00:00:00.000 | Lazarus | 293.37180978 |
15 | 2025-06-01 00:00:00.000 | Normal | 1085728240.75705 |
16 | 2024-06-01 00:00:00.000 | Normal | 3123047941.7665 |
17 | 2024-03-01 00:00:00.000 | Normal | 11097194568.0127 |
18 | 2024-12-01 00:00:00.000 | Normal | 5153701750.25902 |
19 | 2024-11-01 00:00:00.000 | Normal | 5383367473.51167 |
20 | 2025-02-01 00:00:00.000 | Lazarus | 1285014534.24078 |
BlockTrackerlazaros group
Updated 2025-06-13Copy Reference Fork
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: 2 months ago
36
2KB
12s