Using stellar-etl to export ledgers|transactions|operations|effects|trades|assets|diagnostic_events

stellar_export.sh

#!/bin/bash
# ref. https://github.com/stellar/stellar-etl/tree/master?tab=readme-ov-file#history-archive-commands
if [ $# -lt 3 ]; then
    echo "Usage: $0 <export_type> <start_ledger> <end_ledger> [network]"
    echo "       $0 ledgers 2 500"
    echo "       $0 transactions 2 500 --futurenet"
    echo "       $0 operations 2 500 --testnet"
    echo "       $0 effects 2 500"
    echo "       $0 assets 2 500 --futurenet"
    echo "===== History Archive URLs ====="
    echo " Mainnet: http://history.stellar.org/prd/core-live/core_live_001/.well-known/stellar-history.json"
    echo " Testnet: http://history.stellar.org/prd/core-testnet/core_testnet_001/.well-known/stellar-history.json"
    exit 1
fi

export_type=$1
start_ledger=$2
end_ledger=$3
network=$4

output_file="${start_ledger}-${end_ledger}-${export_type}.txt"

docker_command="docker run --rm -v $PWD:/working stellar/stellar-etl stellar-etl"

if [ -n "$network" ]; then
    docker_command+=" --$network"
fi

case $export_type in
    ledgers|transactions|operations|effects|trades|assets|diagnostic_events)
        $docker_command export_$export_type --start-ledger $start_ledger --end-ledger $end_ledger --output "/working/$output_file" --gcs-bucket ""
        ;;
    *)
        echo "Invalid export type: $export_type"
        exit 1
        ;;
esac