PREVIEW / stock_30min / 2013-10-15

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-15.parquet
  size:    1.5 MB
  rows:    80,778
  symbols: 3,544

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
2013-10-15 04:00:00	AAPL	Stock	17.6786	17.7696	17.6786	17.7696	8680.0
2013-10-15 04:30:00	AAPL	Stock	17.7811	17.7829	17.7811	17.7829	5600.0
2013-10-15 05:00:00	AAPL	Stock	17.7743	17.7996	17.7743	17.7996	16800.0
2013-10-15 05:30:00	AAPL	Stock	17.7939	17.8107	17.7939	17.8107	12488.0
2013-10-15 06:00:00	AAPL	Stock	17.8111	17.8179	17.8057	17.8057	25200.0
2013-10-15 06:30:00	AAPL	Stock	17.8214	17.8214	17.7857	17.7893	113512.0
2013-10-15 07:00:00	AAPL	Stock	17.7929	17.8214	17.7857	17.8068	323344.0
2013-10-15 07:30:00	AAPL	Stock	17.7996	17.8204	17.7479	17.7479	371140.0
2013-10-15 08:00:00	AAPL	Stock	17.7321	17.8214	17.7143	17.7554	1234072.0
2013-10-15 08:30:00	AAPL	Stock	17.7489	17.7857	17.7375	17.7821	603148.0
2013-10-15 09:00:00	AAPL	Stock	17.7743	17.8107	17.7193	17.7625	1917860.0
2013-10-15 09:30:00	AAPL	Stock	17.7804	17.8054	17.6971	17.78	49284620.0
2013-10-15 10:00:00	AAPL	Stock	17.7854	17.8514	17.7729	17.8368	28491932.0
2013-10-15 10:30:00	AAPL	Stock	17.8357	17.8507	17.7789	17.8029	22956248.0
2013-10-15 11:00:00	AAPL	Stock	17.8018	17.9179	17.7886	17.9004	39356156.0
2013-10-15 11:30:00	AAPL	Stock	17.895	17.9071	17.8418	17.8586	20794060.0
2013-10-15 12:00:00	AAPL	Stock	17.8589	17.8779	17.7954	17.8632	21245896.0
2013-10-15 12:30:00	AAPL	Stock	17.8632	17.9043	17.8596	17.8775	14404124.0
2013-10-15 13:00:00	AAPL	Stock	17.8786	17.9089	17.8543	17.875	11090716.0
2013-10-15 13:30:00	AAPL	Stock	17.8782	17.9286	17.8632	17.9168	15380372.0
2013-10-15 14:00:00	AAPL	Stock	17.9161	17.9286	17.8293	17.8493	17654112.0
2013-10-15 14:30:00	AAPL	Stock	17.8525	17.8536	17.7793	17.8321	22769348.0
2013-10-15 15:00:00	AAPL	Stock	17.8314	17.8839	17.7982	17.8607	15882692.0
2013-10-15 15:30:00	AAPL	Stock	17.8586	17.8586	17.7932	17.8171	21957320.0
2013-10-15 16:00:00	AAPL	Stock	17.81	17.8482	17.8096	17.8125	5764864.0
2013-10-15 16:30:00	AAPL	Stock	17.8207	17.8464	17.8064	17.8161	862512.0
2013-10-15 17:00:00	AAPL	Stock	17.8182	17.8482	17.8157	17.8286	240240.0
2013-10-15 17:30:00	AAPL	Stock	17.8268	17.8268	17.8179	17.825	120652.0
2013-10-15 18:00:00	AAPL	Stock	17.8214	17.8214	17.8171	17.8171	66780.0
2013-10-15 18:30:00	AAPL	Stock	17.8171	17.8404	17.8171	17.8179	247716.0
2013-10-15 19:00:00	AAPL	Stock	17.8161	17.8346	17.8125	17.8214	356272.0
2013-10-15 19:30:00	AAPL	Stock	17.8225	17.855	17.8214	17.855	402948.0
2013-10-15 04:00:00	MSFT	Stock	34.65	34.88	34.65	34.88	625.0
2013-10-15 04:30:00	MSFT	Stock	34.79	34.79	34.79	34.79	390.0
2013-10-15 05:00:00	MSFT	Stock	34.75	34.99	34.7	34.76	2426.0
2013-10-15 05:30:00	MSFT	Stock	34.81	34.86	34.81	34.86	410.0
2013-10-15 06:00:00	MSFT	Stock	34.79	34.81	34.79	34.81	3000.0
2013-10-15 07:00:00	MSFT	Stock	34.78	34.8	34.73	34.76	4790.0
2013-10-15 07:30:00	MSFT	Stock	34.76	34.83	34.66	34.73	49715.0
2013-10-15 08:00:00	MSFT	Stock	34.72	34.84	34.72	34.8	52769.0
2013-10-15 08:30:00	MSFT	Stock	34.8	34.89	34.78	34.85	37986.0
2013-10-15 09:00:00	MSFT	Stock	34.83	34.89	34.7	34.7	70554.0
2013-10-15 09:30:00	MSFT	Stock	34.7	34.98	34.53	34.965	7978165.0
2013-10-15 10:00:00	MSFT	Stock	34.96	34.99	34.88	34.95	5237527.0
2013-10-15 10:30:00	MSFT	Stock	34.955	34.98	34.81	34.835	4740678.0
2013-10-15 11:00:00	MSFT	Stock	34.84	34.965	34.8	34.92	3269633.0
2013-10-15 11:30:00	MSFT	Stock	34.92	34.96	34.8	34.835	3261957.0
2013-10-15 12:00:00	MSFT	Stock	34.835	34.867	34.805	34.83	2292483.0
2013-10-15 12:30:00	MSFT	Stock	34.83	34.83	34.77	34.8	2375757.0
2013-10-15 13:00:00	MSFT	Stock	34.804	34.81	34.735	34.76	1585897.0

> showing 50 of 80,778 rows — these rows as CSV

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