PREVIEW / stock_1hour / 2009-12-22

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-22.parquet
  size:    892 KB
  rows:    42,497
  symbols: 3,444

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
2009-12-22 04:00:00	AAPL	Stock	7.0836	7.0836	7.0836	7.0836	5600.0
2009-12-22 05:00:00	AAPL	Stock	7.0914	7.0914	7.0914	7.0914	8400.0
2009-12-22 06:00:00	AAPL	Stock	7.0882	7.0961	7.0811	7.0811	37800.0
2009-12-22 07:00:00	AAPL	Stock	7.0893	7.1175	7.0714	7.1132	369768.0
2009-12-22 08:00:00	AAPL	Stock	7.1143	7.1193	7.0796	7.1132	3216444.0
2009-12-22 09:00:00	AAPL	Stock	7.1112	7.1732	7.1036	7.135	82013624.0
2009-12-22 10:00:00	AAPL	Stock	7.1357	7.1432	7.1111	7.1254	60094272.0
2009-12-22 11:00:00	AAPL	Stock	7.125	7.1264	7.095	7.1214	41839784.0
2009-12-22 12:00:00	AAPL	Stock	7.1212	7.1414	7.1118	7.1386	25636912.0
2009-12-22 13:00:00	AAPL	Stock	7.1382	7.1582	7.1325	7.1407	36779680.0
2009-12-22 14:00:00	AAPL	Stock	7.1404	7.1496	7.1271	7.1347	27196988.0
2009-12-22 15:00:00	AAPL	Stock	7.1336	7.1643	7.1286	7.1604	61039692.0
2009-12-22 16:00:00	AAPL	Stock	7.1589	7.1696	7.1087	7.1639	5441828.0
2009-12-22 17:00:00	AAPL	Stock	7.165	7.1696	7.1639	7.1696	293356.0
2009-12-22 18:00:00	AAPL	Stock	7.1654	7.1714	7.1557	7.1646	507192.0
2009-12-22 19:00:00	AAPL	Stock	7.1661	7.1714	7.1614	7.1693	212576.0
2009-12-22 05:00:00	MSFT	Stock	30.52	30.52	30.52	30.52	600.0
2009-12-22 06:00:00	MSFT	Stock	30.55	30.55	30.55	30.55	1000.0
2009-12-22 07:00:00	MSFT	Stock	30.64	30.65	30.6	30.6	3430.0
2009-12-22 08:00:00	MSFT	Stock	30.64	30.65	30.52	30.65	63191.0
2009-12-22 09:00:00	MSFT	Stock	30.62	30.7	30.54	30.67	3489424.0
2009-12-22 10:00:00	MSFT	Stock	30.68	30.9	30.63	30.873	5701791.0
2009-12-22 11:00:00	MSFT	Stock	30.87	30.89	30.67	30.85	4336404.0
2009-12-22 12:00:00	MSFT	Stock	30.85	30.87	30.76	30.86	3242556.0
2009-12-22 13:00:00	MSFT	Stock	30.865	30.93	30.83	30.83	3997758.0
2009-12-22 14:00:00	MSFT	Stock	30.833	30.84	30.71	30.795	3299277.0
2009-12-22 15:00:00	MSFT	Stock	30.795	30.88	30.77	30.82	8425198.0
2009-12-22 16:00:00	MSFT	Stock	30.82	30.94	30.739	30.89	2384254.0
2009-12-22 17:00:00	MSFT	Stock	30.91	30.92	30.87	30.87	300.0
2009-12-22 18:00:00	MSFT	Stock	30.87	30.87	30.82	30.86	3167.0
2009-12-22 19:00:00	MSFT	Stock	30.83	30.83	30.82	30.82	5037.0
2009-12-22 20:00:00	MSFT	Stock	30.52	30.52	30.52	30.52	107100.0
2009-12-22 08:00:00	NVDA	Stock	0.4375	0.44	0.435	0.4355	235680.0
2009-12-22 09:00:00	NVDA	Stock	0.435	0.4435	0.435	0.4425	117404960.0
2009-12-22 10:00:00	NVDA	Stock	0.4422	0.4472	0.4418	0.4452	119660840.0
2009-12-22 11:00:00	NVDA	Stock	0.4455	0.4458	0.4415	0.4458	92338520.0
2009-12-22 12:00:00	NVDA	Stock	0.4458	0.449	0.4448	0.4488	74962680.0
2009-12-22 13:00:00	NVDA	Stock	0.4488	0.45	0.447	0.4475	82615280.0
2009-12-22 14:00:00	NVDA	Stock	0.4478	0.45	0.446	0.4495	90946080.0
2009-12-22 15:00:00	NVDA	Stock	0.4498	0.4515	0.4472	0.4515	175975520.0
2009-12-22 16:00:00	NVDA	Stock	0.4515	0.4518	0.4443	0.4512	12054360.0
2009-12-22 17:00:00	NVDA	Stock	0.45	0.4512	0.4485	0.45	149600.0
2009-12-22 18:00:00	NVDA	Stock	0.45	0.45	0.4492	0.45	48000.0
2009-12-22 19:00:00	NVDA	Stock	0.45	0.4505	0.45	0.4505	86000.0
2009-12-22 06:00:00	AMZN	Stock	6.6325	6.6325	6.6325	6.6325	4000.0
2009-12-22 07:00:00	AMZN	Stock	6.699	6.699	6.67	6.6745	82000.0
2009-12-22 08:00:00	AMZN	Stock	6.675	6.6895	6.6395	6.6555	1701400.0
2009-12-22 09:00:00	AMZN	Stock	6.6575	6.7729	6.6325	6.758	37670740.0
2009-12-22 10:00:00	AMZN	Stock	6.7585	6.7995	6.729	6.742	37385920.0
2009-12-22 11:00:00	AMZN	Stock	6.7415	6.7415	6.6815	6.715	21037980.0

> showing 50 of 42,497 rows — these rows as CSV

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