BlockTrackerlazaros group
    Updated 2025-06-13
    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
    DATE
    VOLUME_TYPE
    VOLUME
    1
    2023-01-01 00:00:00.000Normal575130428.432032
    2
    2023-06-01 00:00:00.000Normal385821718.067173
    3
    2023-10-01 00:00:00.000Normal2717594943.80613
    4
    2024-07-01 00:00:00.000Normal3139327522.51385
    5
    2023-02-01 00:00:00.000Normal489061318.249894
    6
    2024-08-01 00:00:00.000Normal3019621092.41896
    7
    2025-03-01 00:00:00.000Normal3717224088.01674
    8
    2025-04-01 00:00:00.000Normal1980626860.64166
    9
    2025-04-01 00:00:00.000Lazarus891520.278746163
    10
    2023-03-01 00:00:00.000Normal673333399.961941
    11
    2023-04-01 00:00:00.000Normal465356743.658814
    12
    2025-03-01 00:00:00.000Lazarus968052979.119611
    13
    2025-05-01 00:00:00.000Normal3114030830.94228
    14
    2025-06-01 00:00:00.000Lazarus293.37180978
    15
    2025-06-01 00:00:00.000Normal1085728240.75705
    16
    2024-06-01 00:00:00.000Normal3123047941.7665
    17
    2024-03-01 00:00:00.000Normal11097194568.0127
    18
    2024-12-01 00:00:00.000Normal5153701750.25902
    19
    2024-11-01 00:00:00.000Normal5383367473.51167
    20
    2025-02-01 00:00:00.000Lazarus1285014534.24078
    36
    2KB
    12s