PREVIEW / stock_1hour / 2003-01-21

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-01-21.parquet
  size:    420 KB
  rows:    19,950
  symbols: 1,536

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
2003-01-21 08:00:00	AAPL	Stock	0.2527	0.2527	0.2527	0.2527	145600.0
2003-01-21 09:00:00	AAPL	Stock	0.2536	0.2573	0.2532	0.2552	37480184.0
2003-01-21 10:00:00	AAPL	Stock	0.2548	0.2556	0.2527	0.2536	30408560.0
2003-01-21 11:00:00	AAPL	Stock	0.2538	0.2543	0.253	0.2538	24506552.0
2003-01-21 12:00:00	AAPL	Stock	0.2541	0.255	0.2536	0.255	20086808.0
2003-01-21 13:00:00	AAPL	Stock	0.255	0.2561	0.2536	0.2541	14703024.0
2003-01-21 14:00:00	AAPL	Stock	0.2541	0.2543	0.2525	0.2525	37539376.0
2003-01-21 15:00:00	AAPL	Stock	0.2523	0.2529	0.25	0.25	58217376.0
2003-01-21 16:00:00	AAPL	Stock	0.2504	0.2516	0.2493	0.2493	6372800.0
2003-01-21 19:00:00	AAPL	Stock	0.2527	0.2527	0.2527	0.2527	218400.0
2003-01-21 08:00:00	MSFT	Stock	25.775	26.12	25.75	25.8795	232558.0
2003-01-21 09:00:00	MSFT	Stock	25.9	26.075	25.725	25.995	17174620.0
2003-01-21 10:00:00	MSFT	Stock	25.995	26.02	25.73	25.82	17741060.0
2003-01-21 11:00:00	MSFT	Stock	25.82	25.8415	25.655	25.81	9951860.0
2003-01-21 12:00:00	MSFT	Stock	25.81	25.89	25.705	25.875	7397432.0
2003-01-21 13:00:00	MSFT	Stock	25.87	25.975	25.85	25.895	6453910.0
2003-01-21 14:00:00	MSFT	Stock	25.895	25.905	25.775	25.809	7172086.0
2003-01-21 15:00:00	MSFT	Stock	25.8	25.86	25.655	25.67	12221900.0
2003-01-21 16:00:00	MSFT	Stock	25.66	25.785	25.65	25.7	1979028.0
2003-01-21 17:00:00	MSFT	Stock	25.705	25.8604	25.665	25.685	125618.0
2003-01-21 18:00:00	MSFT	Stock	25.715	25.725	25.715	25.725	1000.0
2003-01-21 08:00:00	NVDA	Stock	0.0918	0.0918	0.0904	0.0909	532200.0
2003-01-21 09:00:00	NVDA	Stock	0.0911	0.0932	0.0901	0.0903	174572520.0
2003-01-21 10:00:00	NVDA	Stock	0.0902	0.0906	0.0871	0.0877	240842640.0
2003-01-21 11:00:00	NVDA	Stock	0.0879	0.0885	0.0872	0.0884	110713320.0
2003-01-21 12:00:00	NVDA	Stock	0.0884	0.0894	0.088	0.0887	62905320.0
2003-01-21 13:00:00	NVDA	Stock	0.0887	0.0894	0.0885	0.0889	51497280.0
2003-01-21 14:00:00	NVDA	Stock	0.0889	0.089	0.0875	0.0875	66829920.0
2003-01-21 15:00:00	NVDA	Stock	0.0875	0.0886	0.0871	0.0875	184920120.0
2003-01-21 16:00:00	NVDA	Stock	0.0876	0.1021	0.0871	0.0872	9724800.0
2003-01-21 17:00:00	NVDA	Stock	0.0874	0.0877	0.0873	0.0877	1368000.0
2003-01-21 18:00:00	NVDA	Stock	0.0878	0.0895	0.0878	0.0895	720000.0
2003-01-21 08:00:00	AMZN	Stock	1.07	1.07	1.07	1.07	14000.0
2003-01-21 09:00:00	AMZN	Stock	1.07	1.07	1.037	1.0405	19517840.0
2003-01-21 10:00:00	AMZN	Stock	1.04	1.0505	1.018	1.0435	30882260.0
2003-01-21 11:00:00	AMZN	Stock	1.0435	1.05	1.042	1.0496	11847960.0
2003-01-21 12:00:00	AMZN	Stock	1.05	1.074	1.048	1.0735	15008900.0
2003-01-21 13:00:00	AMZN	Stock	1.0734	1.0805	1.061	1.0625	11891240.0
2003-01-21 14:00:00	AMZN	Stock	1.063	1.0645	1.0505	1.061	9931660.0
2003-01-21 15:00:00	AMZN	Stock	1.06	1.0685	1.0545	1.059	15115220.0
2003-01-21 16:00:00	AMZN	Stock	1.0545	1.0625	1.05	1.05	4016700.0
2003-01-21 17:00:00	AMZN	Stock	1.054	1.055	1.0475	1.05	252000.0
2003-01-21 19:00:00	AMZN	Stock	1.07	1.07	1.07	1.07	14000.0
2003-01-21 09:00:00	CL	Stock	27.0	27.125	26.95	27.115	325000.0
2003-01-21 10:00:00	CL	Stock	27.12	27.225	26.98	27.015	923200.0
2003-01-21 11:00:00	CL	Stock	27.0	27.005	26.885	26.94	380600.0
2003-01-21 12:00:00	CL	Stock	26.93	26.945	26.77	26.875	274800.0
2003-01-21 13:00:00	CL	Stock	26.875	26.92	26.8	26.87	237800.0
2003-01-21 14:00:00	CL	Stock	26.865	26.875	26.755	26.795	278800.0
2003-01-21 15:00:00	CL	Stock	26.795	26.795	26.56	26.565	461600.0

> showing 50 of 19,950 rows — these rows as CSV

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