PREVIEW / stock_1hour / 2003-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-03-27.parquet
  size:    409 KB
  rows:    20,279
  symbols: 1,542

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-03-27 09:00:00	AAPL	Stock	0.2571	0.258	0.2557	0.2568	21392168.0
2003-03-27 10:00:00	AAPL	Stock	0.2568	0.2588	0.2563	0.2571	17705632.0
2003-03-27 11:00:00	AAPL	Stock	0.2571	0.258	0.2568	0.2573	9495528.0
2003-03-27 12:00:00	AAPL	Stock	0.2573	0.2607	0.2573	0.2601	15436568.0
2003-03-27 13:00:00	AAPL	Stock	0.2606	0.2614	0.2589	0.2614	9385992.0
2003-03-27 14:00:00	AAPL	Stock	0.2613	0.2625	0.2602	0.2607	12535208.0
2003-03-27 15:00:00	AAPL	Stock	0.2607	0.2618	0.2577	0.2582	22774248.0
2003-03-27 16:00:00	AAPL	Stock	0.2586	0.2623	0.2582	0.2588	1658944.0
2003-03-27 17:00:00	AAPL	Stock	0.2588	0.2588	0.2588	0.2588	1288000.0
2003-03-27 08:00:00	MSFT	Stock	25.06	25.25	24.95	24.98	318527.0
2003-03-27 09:00:00	MSFT	Stock	24.97	25.25	24.78	24.78	7450444.0
2003-03-27 10:00:00	MSFT	Stock	24.781	24.869	24.599	24.75	12357189.0
2003-03-27 11:00:00	MSFT	Stock	24.75	24.89	24.72	24.77	5871963.0
2003-03-27 12:00:00	MSFT	Stock	24.77	25.09	24.76	25.0289	6632423.0
2003-03-27 13:00:00	MSFT	Stock	25.02	25.12	24.91	25.12	5166123.0
2003-03-27 14:00:00	MSFT	Stock	25.11	25.249	25.06	25.108	7205678.0
2003-03-27 15:00:00	MSFT	Stock	25.101	25.26	24.96	25.04	8492247.0
2003-03-27 16:00:00	MSFT	Stock	25.04	25.05	24.99	25.04	839398.0
2003-03-27 17:00:00	MSFT	Stock	25.04	25.08	25.04	25.08	175200.0
2003-03-27 18:00:00	MSFT	Stock	25.07	25.075	25.07	25.075	1700.0
2003-03-27 08:00:00	NVDA	Stock	0.1187	0.1196	0.1182	0.1187	1208040.0
2003-03-27 09:00:00	NVDA	Stock	0.1187	0.121	0.1179	0.1202	146084040.0
2003-03-27 10:00:00	NVDA	Stock	0.1202	0.1208	0.1171	0.1196	369307800.0
2003-03-27 11:00:00	NVDA	Stock	0.1194	0.1202	0.1188	0.1197	79072800.0
2003-03-27 12:00:00	NVDA	Stock	0.1197	0.1207	0.119	0.1205	96701160.0
2003-03-27 13:00:00	NVDA	Stock	0.1205	0.1209	0.1175	0.1185	166644240.0
2003-03-27 14:00:00	NVDA	Stock	0.1185	0.1192	0.1172	0.1184	182002200.0
2003-03-27 15:00:00	NVDA	Stock	0.1184	0.1192	0.1163	0.1166	192366600.0
2003-03-27 16:00:00	NVDA	Stock	0.1167	0.1187	0.1162	0.1172	31440120.0
2003-03-27 17:00:00	NVDA	Stock	0.1166	0.1167	0.1165	0.1165	1806960.0
2003-03-27 18:00:00	NVDA	Stock	0.1165	0.1167	0.1164	0.1167	180000.0
2003-03-27 08:00:00	AMZN	Stock	1.375	1.386	1.3725	1.386	1427600.0
2003-03-27 09:00:00	AMZN	Stock	1.3755	1.391	1.3725	1.381	33067000.0
2003-03-27 10:00:00	AMZN	Stock	1.3814	1.3831	1.375	1.3805	23577480.0
2003-03-27 11:00:00	AMZN	Stock	1.3807	1.3995	1.3795	1.3905	28573480.0
2003-03-27 12:00:00	AMZN	Stock	1.391	1.4002	1.3885	1.4	18369840.0
2003-03-27 13:00:00	AMZN	Stock	1.3995	1.402	1.3925	1.3965	25668120.0
2003-03-27 14:00:00	AMZN	Stock	1.3955	1.398	1.3875	1.3875	24889860.0
2003-03-27 15:00:00	AMZN	Stock	1.3875	1.395	1.3818	1.3875	23940800.0
2003-03-27 16:00:00	AMZN	Stock	1.388	1.39	1.387	1.3885	689100.0
2003-03-27 17:00:00	AMZN	Stock	1.3875	1.3885	1.3875	1.3885	292000.0
2003-03-27 18:00:00	AMZN	Stock	1.3895	1.39	1.3895	1.39	29080.0
2003-03-27 09:00:00	CL	Stock	26.75	26.775	26.49	26.505	201400.0
2003-03-27 10:00:00	CL	Stock	26.485	26.83	26.445	26.795	364400.0
2003-03-27 11:00:00	CL	Stock	26.775	26.9	26.725	26.9	286200.0
2003-03-27 12:00:00	CL	Stock	26.885	27.11	26.885	27.04	356800.0
2003-03-27 13:00:00	CL	Stock	27.045	27.23	27.035	27.225	157600.0
2003-03-27 14:00:00	CL	Stock	27.225	27.32	27.11	27.13	343000.0
2003-03-27 15:00:00	CL	Stock	27.125	27.195	27.0	27.04	479000.0
2003-03-27 16:00:00	CL	Stock	27.04	27.04	27.04	27.04	61400.0

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

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