PREVIEW / stock_1hour / 2003-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-05-07.parquet
  size:    439 KB
  rows:    21,553
  symbols: 1,578

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-05-07 08:00:00	AAPL	Stock	0.3071	0.3125	0.3045	0.308	728000.0
2003-05-07 09:00:00	AAPL	Stock	0.308	0.3123	0.3055	0.3089	164154088.0
2003-05-07 10:00:00	AAPL	Stock	0.3089	0.3173	0.3084	0.317	142660784.0
2003-05-07 11:00:00	AAPL	Stock	0.317	0.3257	0.3164	0.3209	176193696.0
2003-05-07 12:00:00	AAPL	Stock	0.3211	0.3227	0.3179	0.3189	124571384.0
2003-05-07 13:00:00	AAPL	Stock	0.3189	0.3207	0.3143	0.3143	58053744.0
2003-05-07 14:00:00	AAPL	Stock	0.3143	0.3163	0.3109	0.3113	92772008.0
2003-05-07 15:00:00	AAPL	Stock	0.3114	0.3164	0.3086	0.3155	139121136.0
2003-05-07 16:00:00	AAPL	Stock	0.3157	0.317	0.3152	0.3161	9458400.0
2003-05-07 17:00:00	AAPL	Stock	0.3161	0.3161	0.3152	0.3154	308000.0
2003-05-07 18:00:00	AAPL	Stock	0.3161	0.3161	0.3161	0.3161	16800.0
2003-05-07 08:00:00	MSFT	Stock	26.43	26.45	26.2	26.211	49300.0
2003-05-07 09:00:00	MSFT	Stock	26.229	26.36	26.06	26.13	6902778.0
2003-05-07 10:00:00	MSFT	Stock	26.13	26.293	26.033	26.22	8629652.0
2003-05-07 11:00:00	MSFT	Stock	26.22	26.281	26.12	26.22	4752465.0
2003-05-07 12:00:00	MSFT	Stock	26.21	26.22	26.115	26.17	3299357.0
2003-05-07 13:00:00	MSFT	Stock	26.17	26.18	25.97	25.99	5388341.0
2003-05-07 14:00:00	MSFT	Stock	25.99	26.04	25.85	25.91	5565632.0
2003-05-07 15:00:00	MSFT	Stock	25.91	26.06	25.84	25.99	6039247.0
2003-05-07 16:00:00	MSFT	Stock	25.98	26.13	25.96	26.01	824276.0
2003-05-07 17:00:00	MSFT	Stock	26.01	26.01	25.96	25.974	82720.0
2003-05-07 18:00:00	MSFT	Stock	25.961	25.99	25.96	25.96	7040.0
2003-05-07 08:00:00	NVDA	Stock	0.1352	0.1362	0.1349	0.1349	912000.0
2003-05-07 09:00:00	NVDA	Stock	0.1357	0.1357	0.1314	0.1342	181577400.0
2003-05-07 10:00:00	NVDA	Stock	0.1343	0.135	0.1337	0.1347	104084760.0
2003-05-07 11:00:00	NVDA	Stock	0.1348	0.1362	0.1342	0.1353	77367240.0
2003-05-07 12:00:00	NVDA	Stock	0.1353	0.1371	0.1353	0.1364	81677760.0
2003-05-07 13:00:00	NVDA	Stock	0.1364	0.1364	0.135	0.1353	106401360.0
2003-05-07 14:00:00	NVDA	Stock	0.1353	0.1356	0.1341	0.1349	88935000.0
2003-05-07 15:00:00	NVDA	Stock	0.1349	0.1355	0.1337	0.1337	117074400.0
2003-05-07 16:00:00	NVDA	Stock	0.1337	0.1351	0.1318	0.1337	21780000.0
2003-05-07 17:00:00	NVDA	Stock	0.1337	0.1339	0.1335	0.1339	482400.0
2003-05-07 18:00:00	NVDA	Stock	0.1334	0.1335	0.1333	0.1333	696000.0
2003-05-07 08:00:00	AMZN	Stock	1.544	1.545	1.5335	1.537	251000.0
2003-05-07 09:00:00	AMZN	Stock	1.536	1.543	1.5095	1.5095	30908480.0
2003-05-07 10:00:00	AMZN	Stock	1.5095	1.529	1.5055	1.529	43240660.0
2003-05-07 11:00:00	AMZN	Stock	1.5285	1.543	1.519	1.532	30226140.0
2003-05-07 12:00:00	AMZN	Stock	1.5324	1.534	1.5275	1.529	13512340.0
2003-05-07 13:00:00	AMZN	Stock	1.529	1.533	1.521	1.524	14510000.0
2003-05-07 14:00:00	AMZN	Stock	1.524	1.53	1.521	1.5255	16581120.0
2003-05-07 15:00:00	AMZN	Stock	1.5255	1.5365	1.523	1.5355	25347420.0
2003-05-07 16:00:00	AMZN	Stock	1.535	1.54	1.5325	1.535	1149340.0
2003-05-07 17:00:00	AMZN	Stock	1.535	1.537	1.5252	1.537	288000.0
2003-05-07 18:00:00	AMZN	Stock	1.535	1.54	1.5345	1.5345	154000.0
2003-05-07 09:00:00	CL	Stock	28.65	28.77	28.65	28.765	292800.0
2003-05-07 10:00:00	CL	Stock	28.825	28.95	28.735	28.95	682200.0
2003-05-07 11:00:00	CL	Stock	28.95	28.975	28.82	28.965	236800.0
2003-05-07 12:00:00	CL	Stock	28.96	29.0	28.885	28.905	354000.0
2003-05-07 13:00:00	CL	Stock	28.905	28.92	28.785	28.84	337000.0
2003-05-07 14:00:00	CL	Stock	28.84	28.94	28.81	28.9	218200.0

> showing 50 of 21,553 rows — these rows as CSV

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