PREVIEW / stock_30min / 2008-11-03

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-11-03.parquet
  size:    1.2 MB
  rows:    68,775
  symbols: 3,325

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
2008-11-03 06:00:00	AAPL	Stock	3.8732	3.8732	3.8286	3.8286	16800.0
2008-11-03 06:30:00	AAPL	Stock	3.8293	3.8293	3.8293	3.8293	28000.0
2008-11-03 07:00:00	AAPL	Stock	3.8571	3.8732	3.8296	3.8339	109956.0
2008-11-03 07:30:00	AAPL	Stock	3.8425	3.8464	3.8218	3.8225	114212.0
2008-11-03 08:00:00	AAPL	Stock	3.8371	3.8429	3.7768	3.7793	3855796.0
2008-11-03 08:30:00	AAPL	Stock	3.7836	3.8032	3.7836	3.7893	1909796.0
2008-11-03 09:00:00	AAPL	Stock	3.79	3.8425	3.7443	3.7814	7175280.0
2008-11-03 09:30:00	AAPL	Stock	3.7814	3.85	3.745	3.8364	150323824.0
2008-11-03 10:00:00	AAPL	Stock	3.8368	3.8964	3.825	3.8593	129349948.0
2008-11-03 10:30:00	AAPL	Stock	3.86	3.8696	3.8271	3.855	91163072.0
2008-11-03 11:00:00	AAPL	Stock	3.8554	3.8593	3.8375	3.8507	52392816.0
2008-11-03 11:30:00	AAPL	Stock	3.8504	3.8586	3.8436	3.8521	45123344.0
2008-11-03 12:00:00	AAPL	Stock	3.8524	3.8729	3.8482	3.8699	50653456.0
2008-11-03 12:30:00	AAPL	Stock	3.87	3.8746	3.8582	3.8621	43143268.0
2008-11-03 13:00:00	AAPL	Stock	3.862	3.8889	3.8589	3.8618	48000036.0
2008-11-03 13:30:00	AAPL	Stock	3.8614	3.8704	3.8493	3.855	40367516.0
2008-11-03 14:00:00	AAPL	Stock	3.8554	3.8586	3.8293	3.8429	62189092.0
2008-11-03 14:30:00	AAPL	Stock	3.8425	3.8429	3.7907	3.7946	81298420.0
2008-11-03 15:00:00	AAPL	Stock	3.7954	3.8	3.7668	3.785	98084616.0
2008-11-03 15:30:00	AAPL	Stock	3.785	3.8375	3.7789	3.8196	120864044.0
2008-11-03 16:00:00	AAPL	Stock	3.8193	3.8587	3.8075	3.8143	20155464.0
2008-11-03 16:30:00	AAPL	Stock	3.8143	3.82	3.8082	3.8096	1145480.0
2008-11-03 17:00:00	AAPL	Stock	3.8139	3.8343	3.8107	3.8125	106820.0
2008-11-03 17:30:00	AAPL	Stock	3.8129	3.82	3.8125	3.8157	84420.0
2008-11-03 18:00:00	AAPL	Stock	3.8161	3.8161	3.8136	3.8136	67900.0
2008-11-03 18:30:00	AAPL	Stock	3.8143	3.815	3.8125	3.8129	122276.0
2008-11-03 19:00:00	AAPL	Stock	3.8111	3.8143	3.8107	3.8107	65800.0
2008-11-03 19:30:00	AAPL	Stock	3.8107	3.8168	3.8107	3.8107	270480.0
2008-11-03 07:30:00	MSFT	Stock	22.34	22.66	22.33	22.66	2000.0
2008-11-03 08:00:00	MSFT	Stock	22.55	22.58	22.45	22.51	9926.0
2008-11-03 08:30:00	MSFT	Stock	22.33	22.48	22.33	22.45	4007.0
2008-11-03 09:00:00	MSFT	Stock	22.45	22.46	22.41	22.46	12466.0
2008-11-03 09:30:00	MSFT	Stock	22.46	22.6	22.21	22.5	6146907.0
2008-11-03 10:00:00	MSFT	Stock	22.5	22.58	22.36	22.45	6235544.0
2008-11-03 10:30:00	MSFT	Stock	22.45	22.6	22.32	22.55	4061382.0
2008-11-03 11:00:00	MSFT	Stock	22.55	22.61	22.45	22.548	3529771.0
2008-11-03 11:30:00	MSFT	Stock	22.56	22.85	22.54	22.8	3264164.0
2008-11-03 12:00:00	MSFT	Stock	22.8	22.9	22.45	22.828	3098689.0
2008-11-03 12:30:00	MSFT	Stock	22.82	22.9	22.81	22.88	2637343.0
2008-11-03 13:00:00	MSFT	Stock	22.88	22.91	22.84	22.85	4133767.0
2008-11-03 13:30:00	MSFT	Stock	22.84	22.89	22.69	22.74	2505437.0
2008-11-03 14:00:00	MSFT	Stock	22.75	22.79	22.62	22.78	3016939.0
2008-11-03 14:30:00	MSFT	Stock	22.79	22.84	22.69	22.69	3001042.0
2008-11-03 15:00:00	MSFT	Stock	22.7	22.77	22.55	22.63	4959027.0
2008-11-03 15:30:00	MSFT	Stock	22.62	22.77	22.56	22.64	8131938.0
2008-11-03 16:00:00	MSFT	Stock	22.65	22.825	22.407	22.62	3984157.0
2008-11-03 16:30:00	MSFT	Stock	22.72	22.72	22.62	22.71	123260.0
2008-11-03 17:00:00	MSFT	Stock	22.69	22.71	22.62	22.69	6950.0
2008-11-03 17:30:00	MSFT	Stock	22.69	22.71	22.69	22.71	1039.0
2008-11-03 18:00:00	MSFT	Stock	22.72	22.72	22.63	22.72	1000.0

> showing 50 of 68,775 rows — these rows as CSV

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