Contents

• NEM Bidding Dashboard
  • Introduction
  • Web app
  • Python package / API
    • Installation
    • Quick examples
  • Contributing
  • License and Disclaimer
• API Reference
  • Dashboard lanucher interface
  • PostgresSQL interfaces
    • build_postgres_db
    • populate_postgres_db
    • query_postgres_db
    • postgres_helpers
  • Supabase interfaces
    • populate_supabase_db
    • query_supabase_db
  • Interfaces for accessing raw AEMO data
    • fetch_data
  • Interfaces for processing raw data
    • preprocessing
    • fetch_and_preprocess
  • Interface for aggregating from NEMOSIS cache
• Database Guide
  • Database tables
    • bidding_data
    • demand_data
    • duid_info
    • price_bins
    • unit_dispatch
  • Database functions
    • distinct_unit_types()
    • aggregate_bids_v2(regions text[], start_timetime timestamp, end_timetime timestamp, resolution text, dispatch_type text, adjusted text, tech_types text[])
    • aggregate_dispatch_data(regions text[], start_timetime timestamp, end_timetime timestamp, resolution text, dispatch_type text, tech_types text[])
    • get_bids_by_unit_v2(duids text[], start_timetime timestamp, end_timetime timestamp, resolution text, adjusted text)
    • get_duids_for_stations(stations text[])
    • get_duids_and_staions_in_regions_and_time_window_v2(regions text[], start_timetime timestamp, end_timetime timestamp, dispatch_type text, tech_types text[])
    • aggregate_prices(regions text[], start_timetime timestamp, end_timetime timestamp)
• Examples
  • Setup a PostgresSQL database
    • Install PostgresSQL and create database
    • Build database tables and functions
    • Populate database with data
    • Retrieve or aggregate data from the database
    • Run web app locally
  • Using the file cache backend
    • Retrieving raw AEMO data
    • Retrieving processed data
    • Aggregating data
  • Getting the data behind the Web App visualisations
• Development
• Indices and tables