PREVIEW / stock_30min / 2013-01-14

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-14.parquet
  size:    1.4 MB
  rows:    74,793
  symbols: 3,469

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-01-14 04:00:00	AAPL	Stock	18.5857	18.5857	18.2093	18.25	211484.0
2013-01-14 04:30:00	AAPL	Stock	18.2236	18.2236	18.1789	18.1793	73164.0
2013-01-14 05:00:00	AAPL	Stock	18.1832	18.1875	18.0732	18.0732	202748.0
2013-01-14 05:30:00	AAPL	Stock	18.0443	18.0443	17.9293	17.9571	540064.0
2013-01-14 06:00:00	AAPL	Stock	17.9786	17.9804	17.75	17.7857	893872.0
2013-01-14 06:30:00	AAPL	Stock	17.7879	17.9179	17.7554	17.8929	1016568.0
2013-01-14 07:00:00	AAPL	Stock	17.9018	17.9818	17.8571	17.8714	2204020.0
2013-01-14 07:30:00	AAPL	Stock	17.8611	17.9632	17.8557	17.9471	2511936.0
2013-01-14 08:00:00	AAPL	Stock	17.9589	18.1571	17.875	18.1571	11438728.0
2013-01-14 08:30:00	AAPL	Stock	18.1525	18.1571	18.0357	18.06	7338856.0
2013-01-14 09:00:00	AAPL	Stock	18.0589	18.06	17.9268	17.9429	10768968.0
2013-01-14 09:30:00	AAPL	Stock	17.9529	18.0832	17.8039	17.9021	193383148.0
2013-01-14 10:00:00	AAPL	Stock	17.8984	18.0132	17.8804	17.9711	59455564.0
2013-01-14 10:30:00	AAPL	Stock	17.9775	18.125	17.9689	18.0954	49799792.0
2013-01-14 11:00:00	AAPL	Stock	18.0971	18.1111	18.0036	18.0179	30708216.0
2013-01-14 11:30:00	AAPL	Stock	18.0147	18.0532	17.9714	18.0118	27116516.0
2013-01-14 12:00:00	AAPL	Stock	18.0109	18.0257	17.9557	17.975	20370392.0
2013-01-14 12:30:00	AAPL	Stock	17.9785	18.0107	17.9318	17.9375	21728560.0
2013-01-14 13:00:00	AAPL	Stock	17.9375	17.9686	17.8994	17.9518	30311820.0
2013-01-14 13:30:00	AAPL	Stock	17.9518	17.9671	17.89	17.9043	27005356.0
2013-01-14 14:00:00	AAPL	Stock	17.9014	18.0314	17.8821	18.0107	41664840.0
2013-01-14 14:30:00	AAPL	Stock	18.0125	18.0575	17.9407	17.9607	26766180.0
2013-01-14 15:00:00	AAPL	Stock	17.9614	18.0157	17.9304	17.9404	26209428.0
2013-01-14 15:30:00	AAPL	Stock	17.9393	17.9407	17.8554	17.925	96669944.0
2013-01-14 16:00:00	AAPL	Stock	17.9196	17.9592	17.876	17.9421	26876220.0
2013-01-14 16:30:00	AAPL	Stock	17.9446	17.9514	17.9357	17.9393	542724.0
2013-01-14 17:00:00	AAPL	Stock	17.9404	17.9404	17.9111	17.9393	1149960.0
2013-01-14 17:30:00	AAPL	Stock	17.9375	17.9554	17.9375	17.95	363860.0
2013-01-14 18:00:00	AAPL	Stock	17.9536	17.9639	17.9482	17.9486	235088.0
2013-01-14 18:30:00	AAPL	Stock	17.9486	17.9518	17.9293	17.9429	643860.0
2013-01-14 19:00:00	AAPL	Stock	17.9361	17.9464	17.9361	17.9464	186928.0
2013-01-14 19:30:00	AAPL	Stock	17.9414	17.9821	17.9414	17.9811	324912.0
2013-01-14 04:00:00	MSFT	Stock	26.9	26.9	26.9	26.9	200.0
2013-01-14 05:30:00	MSFT	Stock	26.94	26.94	26.94	26.94	115.0
2013-01-14 06:00:00	MSFT	Stock	26.95	26.95	26.95	26.95	900.0
2013-01-14 06:30:00	MSFT	Stock	26.97	26.97	26.95	26.95	600.0
2013-01-14 07:00:00	MSFT	Stock	26.93	26.93	26.88	26.88	2300.0
2013-01-14 07:30:00	MSFT	Stock	26.88	26.88	26.85	26.86	13100.0
2013-01-14 08:00:00	MSFT	Stock	26.88	26.93	26.84	26.84	21341.0
2013-01-14 08:30:00	MSFT	Stock	26.83	26.9	26.83	26.89	12750.0
2013-01-14 09:00:00	MSFT	Stock	26.91	26.91	26.87	26.87	32276.0
2013-01-14 09:30:00	MSFT	Stock	26.87	26.98	26.82	26.87	4414250.0
2013-01-14 10:00:00	MSFT	Stock	26.88	26.89	26.835	26.86	2262520.0
2013-01-14 10:30:00	MSFT	Stock	26.87	26.88	26.83	26.84	1583915.0
2013-01-14 11:00:00	MSFT	Stock	26.845	26.86	26.76	26.795	2993242.0
2013-01-14 11:30:00	MSFT	Stock	26.8	26.86	26.79	26.837	2198945.0
2013-01-14 12:00:00	MSFT	Stock	26.836	26.855	26.8	26.85	2097496.0
2013-01-14 12:30:00	MSFT	Stock	26.84	26.91	26.84	26.89	1411350.0
2013-01-14 13:00:00	MSFT	Stock	26.889	26.89	26.84	26.88	1357600.0
2013-01-14 13:30:00	MSFT	Stock	26.871	26.88	26.85	26.85	1736649.0

> showing 50 of 74,793 rows — these rows as CSV

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