PREVIEW / stock_1hour / 2003-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-01-07.parquet
  size:    435 KB
  rows:    20,373
  symbols: 1,538

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-07 08:00:00	AAPL	Stock	0.2625	0.2648	0.2589	0.2641	1459696.0
2003-01-07 09:00:00	AAPL	Stock	0.2643	0.2661	0.2586	0.2648	74310544.0
2003-01-07 10:00:00	AAPL	Stock	0.2648	0.2652	0.2596	0.26	68512528.0
2003-01-07 11:00:00	AAPL	Stock	0.2601	0.2634	0.26	0.2625	30321928.0
2003-01-07 12:00:00	AAPL	Stock	0.2625	0.2645	0.2614	0.2623	24683176.0
2003-01-07 13:00:00	AAPL	Stock	0.2623	0.2661	0.2621	0.2652	26430544.0
2003-01-07 14:00:00	AAPL	Stock	0.2654	0.2679	0.2614	0.2621	46547424.0
2003-01-07 15:00:00	AAPL	Stock	0.2623	0.2661	0.2609	0.2661	37857792.0
2003-01-07 16:00:00	AAPL	Stock	0.2661	0.2679	0.2589	0.2616	9011856.0
2003-01-07 17:00:00	AAPL	Stock	0.2621	0.2652	0.2589	0.2652	1008392.0
2003-01-07 18:00:00	AAPL	Stock	0.2652	0.2652	0.2607	0.2607	1937600.0
2003-01-07 08:00:00	MSFT	Stock	27.4125	27.5	27.205	27.4	86764.0
2003-01-07 09:00:00	MSFT	Stock	27.385	27.56	27.34	27.55	9373732.0
2003-01-07 10:00:00	MSFT	Stock	27.55	28.0	27.475	27.585	20321326.0
2003-01-07 11:00:00	MSFT	Stock	27.585	27.87	27.545	27.805	8424234.0
2003-01-07 12:00:00	MSFT	Stock	27.82	27.84	27.655	27.715	4748942.0
2003-01-07 13:00:00	MSFT	Stock	27.71	27.95	27.625	27.95	8871864.0
2003-01-07 14:00:00	MSFT	Stock	27.95	27.995	27.785	27.86	7870766.0
2003-01-07 15:00:00	MSFT	Stock	27.855	27.9605	27.67	27.885	11429902.0
2003-01-07 16:00:00	MSFT	Stock	27.92	28.0	27.7	27.79	2833502.0
2003-01-07 17:00:00	MSFT	Stock	27.7875	27.9	27.78	27.865	120280.0
2003-01-07 18:00:00	MSFT	Stock	27.9	27.9	27.8025	27.8025	273064.0
2003-01-07 08:00:00	NVDA	Stock	0.1131	0.114	0.1108	0.1117	5824080.0
2003-01-07 09:00:00	NVDA	Stock	0.1117	0.1137	0.1105	0.1129	182668800.0
2003-01-07 10:00:00	NVDA	Stock	0.1129	0.1157	0.1099	0.111	330141240.0
2003-01-07 11:00:00	NVDA	Stock	0.1111	0.1147	0.1106	0.114	203271840.0
2003-01-07 12:00:00	NVDA	Stock	0.1139	0.1141	0.1122	0.1126	95866800.0
2003-01-07 13:00:00	NVDA	Stock	0.1126	0.1132	0.111	0.1125	166496160.0
2003-01-07 14:00:00	NVDA	Stock	0.1125	0.1128	0.1093	0.1108	215389920.0
2003-01-07 15:00:00	NVDA	Stock	0.1109	0.1115	0.1095	0.1105	161284800.0
2003-01-07 16:00:00	NVDA	Stock	0.1105	0.1112	0.1096	0.1107	14235600.0
2003-01-07 17:00:00	NVDA	Stock	0.1107	0.1107	0.1104	0.1106	972000.0
2003-01-07 18:00:00	NVDA	Stock	0.1106	0.1108	0.1106	0.1107	1740000.0
2003-01-07 08:00:00	AMZN	Stock	1.0675	1.0765	1.024	1.0335	254060.0
2003-01-07 09:00:00	AMZN	Stock	1.034	1.0565	1.0325	1.0565	17221100.0
2003-01-07 10:00:00	AMZN	Stock	1.057	1.0725	1.03	1.035	50524440.0
2003-01-07 11:00:00	AMZN	Stock	1.0355	1.0625	1.0345	1.06	23149420.0
2003-01-07 12:00:00	AMZN	Stock	1.06	1.0695	1.0565	1.0635	15578140.0
2003-01-07 13:00:00	AMZN	Stock	1.063	1.075	1.06	1.0735	20832820.0
2003-01-07 14:00:00	AMZN	Stock	1.074	1.0875	1.073	1.08	27416300.0
2003-01-07 15:00:00	AMZN	Stock	1.08	1.087	1.072	1.0785	19438560.0
2003-01-07 16:00:00	AMZN	Stock	1.0795	1.082	1.0765	1.082	1476000.0
2003-01-07 17:00:00	AMZN	Stock	1.081	1.083	1.0775	1.0775	368000.0
2003-01-07 18:00:00	AMZN	Stock	1.0775	1.083	1.0775	1.083	376000.0
2003-01-07 09:00:00	CL	Stock	27.125	27.145	27.1	27.11	244400.0
2003-01-07 10:00:00	CL	Stock	27.11	27.165	27.05	27.055	716600.0
2003-01-07 11:00:00	CL	Stock	27.05	27.125	27.05	27.075	325000.0
2003-01-07 12:00:00	CL	Stock	27.07	27.075	27.005	27.03	446000.0
2003-01-07 13:00:00	CL	Stock	27.02	27.06	26.905	26.93	369200.0
2003-01-07 14:00:00	CL	Stock	26.935	26.975	26.9	26.9	215600.0

> showing 50 of 20,373 rows — these rows as CSV

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