Weather desk basics
For anyone starting with the Weather database: analysts, meteorology-curious traders, data teams
Read any of 399 US stations and 55 world cities like a symbol: today's conditions, long history, units, anomalies against the station's own normal, and the catalog of what can be asked. Stations are named by airport code (KORD), city (CHICAGO) or station id.
- Weather
- 8 steps
- Runs on live data
How EquationDB answers it
Each step is one query on live data. Run them in order, or open any one and adapt it: change the symbol, the station, the dates or the filter.
The last two weeks in Chicago
Highs, lows, rain and snow at O'Hare for the last fourteen days (calendar days back from the newest observation).
GET weather:CHICAGO SELECT tmax, tmin, prcp, snow LAST 14d
A record from 1869
Central Park's record 106 °F on 9 July 1936: the history goes back to 1869 for New York and to the 1940s for most stations.
SERIES weather:KNYC.tmax FROM 1936-07-08 TO 1936-07-10
How far from normal is it?
The daily mean and its distance from the station's own 1991–2020 normal for that time of year.
GET weather:KNYC SELECT tavg, tavg_anom LAST 14d
Monthly rain in Miami
Rain is a flow, so ALIGN monthly sums it: the June–October wet season stands out.
SERIES weather:MIAMI.prcp LAST 3y ALIGN monthly
Snowfall by year in Buffalo
Yearly snowfall totals at Buffalo since 2000.
SERIES weather:BUFFALO.snow SINCE 2000-01-01 ALIGN yearly
Celsius and millimetres
Metric units for any station; world cities like Heathrow arrive about a year late, so they are history.
GET weather:LONDON SELECT tmax_c, prcp_mm SINCE 2024-06-01
Every series of one station
All 19 measures for O'Hare with their first and last dates.
SHOW SERIES FOR weather:KORD
What can be asked
The weather measures, each a series for all 454 stations.
SHOW SERIES LIKE 'weather'
Run it on your own question
Sign in and press Try it on any step, or ask for a short demo on your data.
More weather use cases
- World citiesGlobal macro, commodity and international teams
- Weather for energy and powerNatural gas, power and utilities desks
- Natural gas: winter demandNatural gas traders, utilities and demand planners
- Texas power: heat and freezePower traders, generators and utility analysts covering Texas
- Corn Belt growing seasonGrain traders, agribusiness analysts and crop insurers
- Insurance: catastrophe watchProperty and casualty insurers, reinsurers and insurance analysts