PREVIEW / stock_1hour / 2007-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-08.parquet
  size:    685 KB
  rows:    32,088
  symbols: 2,515

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
2007-03-08 04:00:00	AAPL	Stock	3.1593	3.1646	3.1554	3.1571	14000.0
2007-03-08 06:00:00	AAPL	Stock	3.1643	3.1643	3.1643	3.1643	14000.0
2007-03-08 07:00:00	AAPL	Stock	3.1682	3.1746	3.1646	3.1746	282800.0
2007-03-08 08:00:00	AAPL	Stock	3.1686	3.175	3.1611	3.1643	3352132.0
2007-03-08 09:00:00	AAPL	Stock	3.1643	3.1686	3.1482	3.15	84006048.0
2007-03-08 10:00:00	AAPL	Stock	3.1496	3.1593	3.1429	3.1479	91730632.0
2007-03-08 11:00:00	AAPL	Stock	3.1475	3.1546	3.1414	3.15	56985992.0
2007-03-08 12:00:00	AAPL	Stock	3.1504	3.1539	3.1382	3.1432	46405800.0
2007-03-08 13:00:00	AAPL	Stock	3.1432	3.1564	3.1396	3.15	40569032.0
2007-03-08 14:00:00	AAPL	Stock	3.15	3.1511	3.1236	3.1354	100194304.0
2007-03-08 15:00:00	AAPL	Stock	3.1354	3.1429	3.1299	3.1414	74589508.0
2007-03-08 16:00:00	AAPL	Stock	3.1429	3.1464	3.1389	3.145	3762192.0
2007-03-08 17:00:00	AAPL	Stock	3.1446	3.1482	3.1446	3.1482	186396.0
2007-03-08 18:00:00	AAPL	Stock	3.1493	3.1511	3.1482	3.1511	211176.0
2007-03-08 19:00:00	AAPL	Stock	3.1493	3.1504	3.1482	3.1504	187516.0
2007-03-08 04:00:00	MSFT	Stock	27.75	27.79	27.75	27.79	1800.0
2007-03-08 05:00:00	MSFT	Stock	27.79	27.79	27.79	27.79	2300.0
2007-03-08 06:00:00	MSFT	Stock	27.79	27.79	27.79	27.79	100.0
2007-03-08 07:00:00	MSFT	Stock	27.79	27.9	27.79	27.87	7600.0
2007-03-08 08:00:00	MSFT	Stock	27.87	27.87	27.76	27.79	62590.0
2007-03-08 09:00:00	MSFT	Stock	27.8	27.82	27.66	27.7	6602167.0
2007-03-08 10:00:00	MSFT	Stock	27.7	27.85	27.68	27.74	8905206.0
2007-03-08 11:00:00	MSFT	Stock	27.74	27.75	27.66	27.7	7532347.0
2007-03-08 12:00:00	MSFT	Stock	27.7	27.7	27.59	27.59	7726034.0
2007-03-08 13:00:00	MSFT	Stock	27.59	27.69	27.52	27.54	8456864.0
2007-03-08 14:00:00	MSFT	Stock	27.54	27.55	27.21	27.3	14895928.0
2007-03-08 15:00:00	MSFT	Stock	27.3	27.39	27.27	27.34	14585305.0
2007-03-08 16:00:00	MSFT	Stock	27.34	27.38	27.24	27.38	1432054.0
2007-03-08 17:00:00	MSFT	Stock	27.38	27.38	27.36	27.37	1122.0
2007-03-08 18:00:00	MSFT	Stock	27.38	27.38	27.38	27.38	1953.0
2007-03-08 19:00:00	MSFT	Stock	27.38	27.38	27.35	27.36	6205.0
2007-03-08 08:00:00	NVDA	Stock	0.5025	0.5042	0.5017	0.5032	1092600.0
2007-03-08 09:00:00	NVDA	Stock	0.5032	0.5098	0.5018	0.5068	85505340.0
2007-03-08 10:00:00	NVDA	Stock	0.5068	0.5113	0.5055	0.51	92992320.0
2007-03-08 11:00:00	NVDA	Stock	0.51	0.5133	0.5098	0.5118	78618900.0
2007-03-08 12:00:00	NVDA	Stock	0.512	0.5158	0.5119	0.5155	92064240.0
2007-03-08 13:00:00	NVDA	Stock	0.5155	0.5193	0.5153	0.5153	97328700.0
2007-03-08 14:00:00	NVDA	Stock	0.5153	0.5168	0.51	0.5142	141401220.0
2007-03-08 15:00:00	NVDA	Stock	0.5142	0.5148	0.5107	0.5135	132724560.0
2007-03-08 16:00:00	NVDA	Stock	0.5137	0.5147	0.5132	0.5142	10342680.0
2007-03-08 17:00:00	NVDA	Stock	0.5142	0.5142	0.5137	0.5137	527100.0
2007-03-08 18:00:00	NVDA	Stock	0.5138	0.5138	0.5138	0.5138	7800.0
2007-03-08 19:00:00	NVDA	Stock	0.514	0.5167	0.514	0.5167	66000.0
2007-03-08 08:00:00	AMZN	Stock	1.939	1.939	1.93	1.9325	57000.0
2007-03-08 09:00:00	AMZN	Stock	1.935	1.9575	1.9325	1.9535	15069240.0
2007-03-08 10:00:00	AMZN	Stock	1.954	1.961	1.95	1.954	19666240.0
2007-03-08 11:00:00	AMZN	Stock	1.954	1.959	1.95	1.9535	14850860.0
2007-03-08 12:00:00	AMZN	Stock	1.954	1.954	1.946	1.9525	16130700.0
2007-03-08 13:00:00	AMZN	Stock	1.953	1.953	1.941	1.9435	11789140.0
2007-03-08 14:00:00	AMZN	Stock	1.9435	1.944	1.918	1.9205	25044800.0

> showing 50 of 32,088 rows — these rows as CSV

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