PREVIEW / stock_1hour / 2000-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2000/2000-01-05.parquet
  size:    274 KB
  rows:    14,214
  symbols: 1,123

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2000-01-05 09:00:00	AAPL	Stock	0.9263	0.9431	0.9196	0.9219	76932800.0
2000-01-05 10:00:00	AAPL	Stock	0.9219	0.9554	0.9196	0.9291	106288000.0
2000-01-05 11:00:00	AAPL	Stock	0.9288	0.9598	0.9258	0.9531	88211200.0
2000-01-05 12:00:00	AAPL	Stock	0.9542	0.9682	0.9252	0.9336	99075200.0
2000-01-05 13:00:00	AAPL	Stock	0.9325	0.9576	0.9308	0.9386	91918400.0
2000-01-05 14:00:00	AAPL	Stock	0.9386	0.9872	0.9375	0.9612	181316800.0
2000-01-05 15:00:00	AAPL	Stock	0.9609	0.971	0.9286	0.9286	83272000.0
2000-01-05 16:00:00	AAPL	Stock	0.9291	0.9291	0.9286	0.9286	1131200.0
2000-01-05 09:00:00	MSFT	Stock	55.5625	56.125	55.0312	55.0625	8392400.0
2000-01-05 10:00:00	MSFT	Stock	55.0625	55.9375	54.6875	55.3438	12169000.0
2000-01-05 11:00:00	MSFT	Stock	55.3125	56.3125	55.25	55.875	7134400.0
2000-01-05 12:00:00	MSFT	Stock	55.8438	55.875	55.2188	55.5625	4170800.0
2000-01-05 13:00:00	MSFT	Stock	55.5156	56.6875	55.2812	56.6562	5162200.0
2000-01-05 14:00:00	MSFT	Stock	56.625	57.5938	56.5	57.3125	11873000.0
2000-01-05 15:00:00	MSFT	Stock	57.25	58.1875	56.875	56.875	10266200.0
2000-01-05 16:00:00	MSFT	Stock	56.875	57.2812	56.8438	56.9062	182400.0
2000-01-05 09:00:00	NVDA	Stock	0.0922	0.0937	0.0917	0.0922	29232000.0
2000-01-05 10:00:00	NVDA	Stock	0.0922	0.093	0.0911	0.0917	95712000.0
2000-01-05 11:00:00	NVDA	Stock	0.0927	0.0932	0.0919	0.0921	6768000.0
2000-01-05 12:00:00	NVDA	Stock	0.0919	0.0922	0.0914	0.0914	12768000.0
2000-01-05 13:00:00	NVDA	Stock	0.0914	0.0917	0.0914	0.0915	3792000.0
2000-01-05 14:00:00	NVDA	Stock	0.0916	0.0932	0.0915	0.0921	10608000.0
2000-01-05 15:00:00	NVDA	Stock	0.0923	0.0924	0.0905	0.0917	13392000.0
2000-01-05 16:00:00	NVDA	Stock	0.0916	0.0918	0.0916	0.0918	3024000.0
2000-01-05 09:00:00	AMZN	Stock	3.525	3.6875	3.5	3.525	153140000.0
2000-01-05 10:00:00	AMZN	Stock	3.5	3.6375	3.4875	3.6062	109004000.0
2000-01-05 11:00:00	AMZN	Stock	3.6062	3.7562	3.5844	3.5891	75632000.0
2000-01-05 12:00:00	AMZN	Stock	3.5844	3.6	3.5312	3.5656	54692000.0
2000-01-05 13:00:00	AMZN	Stock	3.5688	3.5938	3.5438	3.5781	47758000.0
2000-01-05 14:00:00	AMZN	Stock	3.5781	3.6312	3.55	3.5875	83252000.0
2000-01-05 15:00:00	AMZN	Stock	3.5906	3.6062	3.4	3.4906	128816000.0
2000-01-05 16:00:00	AMZN	Stock	3.4938	3.4938	3.4375	3.4875	396000.0
2000-01-05 09:00:00	CL	Stock	30.375	30.625	29.8125	29.8125	260000.0
2000-01-05 10:00:00	CL	Stock	29.8125	29.8125	29.375	29.5	380000.0
2000-01-05 11:00:00	CL	Stock	29.4688	29.625	29.3125	29.5	416200.0
2000-01-05 12:00:00	CL	Stock	29.5	29.5312	29.25	29.3438	170400.0
2000-01-05 13:00:00	CL	Stock	29.375	29.5	29.25	29.4062	231400.0
2000-01-05 14:00:00	CL	Stock	29.375	29.5625	28.875	28.9375	493200.0
2000-01-05 15:00:00	CL	Stock	28.9375	29.4375	28.9062	29.3125	954200.0
2000-01-05 16:00:00	CL	Stock	29.2812	29.2812	29.2812	29.2812	75800.0

> showing 40 of 14,214 rows — these rows as CSV

> unlock the full archive -- $79 one-time