Hyperliquid

aws s3 ls s3://artemis-hyperliquid-data/raw/ --request-payer requester

aws s3 cp s3://artemis-hyperliquid-data/raw/<file_path> . --request-payer requester

import boto3

def copy_files(source_bucket, source_prefix, dest_bucket, dest_prefix=""):
    s3 = boto3.client("s3")

    # List objects in the source bucket
    paginator = s3.get_paginator("list_objects_v2")
    pages = paginator.paginate(
        Bucket=source_bucket,
        Prefix=source_prefix,
        RequestPayer="requester"
    )

    for page in pages:
        if "Contents" not in page:
            continue

        for obj in page["Contents"]:
            key = obj["Key"]
            dest_key = f"{dest_prefix}{key[len(source_prefix):]}" if source_prefix else key

            print(f"Copying {key} -> {dest_bucket}/{dest_key}")

            copy_source = {
                "Bucket": source_bucket,
                "Key": key
            }

            s3.copy(
                copy_source,
                dest_bucket,
                dest_key,
                ExtraArgs={"RequestPayer": "requester"}
            )

if __name__ == "__main__":
    # Source: Artemis Hyperliquid open data bucket
    source_bucket = "artemis-hyperliquid-data"
    source_prefix = "raw/"   # Change this if you want a subfolder (e.g. "raw/node_order_statuses/")

    # Destination: your own bucket
    dest_bucket = "my-bucket-name"
    dest_prefix = "hyperliquid-data/"

    copy_files(source_bucket, source_prefix, dest_bucket, dest_prefix)

-- Analyze Hyperliquid trading activity
SELECT
    date,
    perp_volume,
    spot_volume,
    perp_dau,
    perp_txns
FROM
    art_share.hyperliquid.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

-- Analyze Hyperliquid revenue streams
SELECT
    date,
    fees,
    perp_fees,
    spot_fees,
    chain_fees
FROM
    art_share.hyperliquid.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

-- Track how Hyperliquid revenue is distributed
SELECT
    date,
    fees,
    buyback_fee_allocation,
    service_fee_allocation,
    burned_fee_allocation
FROM
    art_share.hyperliquid.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date ASC

-- Track HYPE token supply changes
SELECT
    date,
    price,
    circulating_supply_native,
    emissions_native,
    premine_unlocks_native,
    burns_native,
    net_supply_change_native
FROM
    art_share.hyperliquid.ez_metrics
WHERE
    date >= '2023-06-01'
ORDER BY
    date ASC

-- Compare metrics across chains
SELECT
    date,
    chain,
    perp_volume,
    perp_dau,
    fees,
    burned_fee_allocation
FROM
    art_share.hyperliquid.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    chain, date ASC