🌍 Global Weather Tracking
Real-time weather monitoring across Buenos Aires, London, and Tokyo. Temperature, humidity, and atmospheric pressure updated every 5 minutes.
Live Data
|
OpenWeatherMap + Arc
Loading weather data...
🇦🇷 Buenos Aires
Argentina (GMT-3)
South America
🇬🇧 London
United Kingdom (GMT+0)
Europe
🇯🇵 Tokyo
Japan (GMT+9)
Asia
How It Works
Data Source: OpenWeatherMap API provides current weather conditions for each city every 5 minutes
Ingestion: Python script polls the API for 3 cities and writes measurements to Arc using MessagePack columnar format
Storage: Arc stores weather observations (temperature, humidity, pressure, conditions) in compressed Parquet files
Visualization: Multi-city charts showing temperature trends, humidity levels, and atmospheric pressure with automatic updates
SQL Query for Weather Trends
SELECT city, AVG(temperature) as avg_temp, AVG(humidity) as avg_humidity, AVG(pressure) as avg_pressure, COUNT(*) as readings FROM weather_tracking.weather_observations WHERE time > NOW() - INTERVAL '24 hours' GROUP BY city ORDER BY city ASC