PREVIEW / stock_30min / 2010-05-19

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-19.parquet
  size:    1.4 MB
  rows:    76,862
  symbols: 3,475

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
2010-05-19 04:00:00	AAPL	Stock	8.9125	8.9125	8.9125	8.9125	2800.0
2010-05-19 04:30:00	AAPL	Stock	8.86	8.86	8.86	8.86	6860.0
2010-05-19 05:00:00	AAPL	Stock	8.8814	8.8814	8.8814	8.8814	2800.0
2010-05-19 05:30:00	AAPL	Stock	8.9143	8.9143	8.9143	8.9143	12600.0
2010-05-19 06:00:00	AAPL	Stock	8.9107	8.9107	8.9107	8.9107	5600.0
2010-05-19 06:30:00	AAPL	Stock	8.8771	8.9107	8.8768	8.905	51520.0
2010-05-19 07:00:00	AAPL	Stock	8.9036	8.93	8.8946	8.9279	289240.0
2010-05-19 07:30:00	AAPL	Stock	8.925	8.9375	8.9214	8.9321	203504.0
2010-05-19 08:00:00	AAPL	Stock	8.9311	8.9446	8.8893	8.9243	2817416.0
2010-05-19 08:30:00	AAPL	Stock	8.9264	8.9779	8.9154	8.9736	2965732.0
2010-05-19 09:00:00	AAPL	Stock	8.975	8.975	8.9107	8.9107	2634492.0
2010-05-19 09:30:00	AAPL	Stock	8.9143	9.0329	8.8682	8.9	137336136.0
2010-05-19 10:00:00	AAPL	Stock	8.9	8.9075	8.7593	8.8226	140678076.0
2010-05-19 10:30:00	AAPL	Stock	8.8222	8.8729	8.7889	8.8596	90947360.0
2010-05-19 11:00:00	AAPL	Stock	8.8596	8.875	8.7536	8.7821	72622172.0
2010-05-19 11:30:00	AAPL	Stock	8.7832	8.8129	8.7446	8.7911	79960496.0
2010-05-19 12:00:00	AAPL	Stock	8.7889	8.8482	8.7679	8.8346	62267184.0
2010-05-19 12:30:00	AAPL	Stock	8.8337	8.855	8.7614	8.855	50800904.0
2010-05-19 13:00:00	AAPL	Stock	8.8554	8.89	8.8154	8.8601	64765428.0
2010-05-19 13:30:00	AAPL	Stock	8.8617	8.8979	8.8336	8.8686	39070332.0
2010-05-19 14:00:00	AAPL	Stock	8.8684	8.9286	8.8268	8.8643	56535640.0
2010-05-19 14:30:00	AAPL	Stock	8.8639	8.8964	8.8396	8.8607	39404036.0
2010-05-19 15:00:00	AAPL	Stock	8.8621	8.8707	8.7954	8.8657	66456572.0
2010-05-19 15:30:00	AAPL	Stock	8.8661	8.9064	8.8429	8.8682	92388268.0
2010-05-19 16:00:00	AAPL	Stock	8.8682	9.0133	8.8188	8.8693	12671792.0
2010-05-19 16:30:00	AAPL	Stock	8.8532	8.8746	8.8532	8.8714	847028.0
2010-05-19 17:00:00	AAPL	Stock	8.8721	8.875	8.8536	8.8639	1619660.0
2010-05-19 17:30:00	AAPL	Stock	8.8639	8.8657	8.8575	8.8643	323064.0
2010-05-19 18:00:00	AAPL	Stock	8.8621	8.8679	8.8607	8.8679	143136.0
2010-05-19 18:30:00	AAPL	Stock	8.8679	8.8714	8.8679	8.8682	322336.0
2010-05-19 19:00:00	AAPL	Stock	8.8682	8.8732	8.8679	8.8704	144844.0
2010-05-19 19:30:00	AAPL	Stock	8.8721	8.8821	8.8714	8.8821	410480.0
2010-05-19 05:00:00	MSFT	Stock	28.25	28.25	28.25	28.25	280.0
2010-05-19 07:00:00	MSFT	Stock	28.3	28.35	28.3	28.35	300.0
2010-05-19 07:30:00	MSFT	Stock	28.4	28.4	28.4	28.4	380.0
2010-05-19 08:00:00	MSFT	Stock	28.67	28.67	28.3	28.4	8626.0
2010-05-19 08:30:00	MSFT	Stock	28.4	28.47	28.39	28.46	12023.0
2010-05-19 09:00:00	MSFT	Stock	28.46	28.59	28.46	28.53	14558.0
2010-05-19 09:30:00	MSFT	Stock	28.52	28.69	28.34	28.44	5794419.0
2010-05-19 10:00:00	MSFT	Stock	28.43	28.45	27.79	28.16	9420840.0
2010-05-19 10:30:00	MSFT	Stock	28.16	28.3	28.1	28.29	4841894.0
2010-05-19 11:00:00	MSFT	Stock	28.29	28.335	28.07	28.2	3421885.0
2010-05-19 11:30:00	MSFT	Stock	28.199	28.25	28.03	28.17	3369340.0
2010-05-19 12:00:00	MSFT	Stock	28.17	28.36	28.15	28.31	2922340.0
2010-05-19 12:30:00	MSFT	Stock	28.31	28.345	28.14	28.28	3092275.0
2010-05-19 13:00:00	MSFT	Stock	28.28	28.44	28.26	28.35	3662751.0
2010-05-19 13:30:00	MSFT	Stock	28.35	28.42	28.27	28.31	1929556.0
2010-05-19 14:00:00	MSFT	Stock	28.31	28.42	28.15	28.25	2658632.0
2010-05-19 14:30:00	MSFT	Stock	28.246	28.4	28.14	28.178	2903830.0
2010-05-19 15:00:00	MSFT	Stock	28.17	28.205	28.01	28.2	4482807.0

> showing 50 of 76,862 rows — these rows as CSV

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