PREVIEW / stock_30min / 2013-08-23

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-23.parquet
  size:    1.5 MB
  rows:    78,122
  symbols: 3,519

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-08-23 04:00:00	AAPL	Stock	18.0	18.0521	18.0	18.0521	22400.0
2013-08-23 04:30:00	AAPL	Stock	18.0529	18.0607	18.05	18.0539	14000.0
2013-08-23 05:00:00	AAPL	Stock	18.0586	18.0586	18.0357	18.0357	8400.0
2013-08-23 05:30:00	AAPL	Stock	18.0357	18.0357	18.0357	18.0357	14000.0
2013-08-23 06:00:00	AAPL	Stock	18.0357	18.0357	18.0357	18.0357	5600.0
2013-08-23 06:30:00	AAPL	Stock	18.0064	18.0089	18.0064	18.0089	8400.0
2013-08-23 07:00:00	AAPL	Stock	18.0007	18.0264	17.9975	18.0071	140560.0
2013-08-23 07:30:00	AAPL	Stock	18.0168	18.0168	17.9779	17.9779	204372.0
2013-08-23 08:00:00	AAPL	Stock	17.9857	18.0171	17.9339	17.9646	1008672.0
2013-08-23 08:30:00	AAPL	Stock	17.9714	17.9732	17.9468	17.9582	509376.0
2013-08-23 09:00:00	AAPL	Stock	17.9554	17.975	17.9396	17.9607	700000.0
2013-08-23 09:30:00	AAPL	Stock	17.9568	17.9768	17.8339	17.8921	53101524.0
2013-08-23 10:00:00	AAPL	Stock	17.8896	17.9446	17.8361	17.9229	26707912.0
2013-08-23 10:30:00	AAPL	Stock	17.9293	17.9589	17.9179	17.9329	14624708.0
2013-08-23 11:00:00	AAPL	Stock	17.93	17.9389	17.8804	17.9225	13717228.0
2013-08-23 11:30:00	AAPL	Stock	17.9215	17.9286	17.9004	17.9046	7924868.0
2013-08-23 12:00:00	AAPL	Stock	17.9046	17.9204	17.9004	17.9079	7129444.0
2013-08-23 12:30:00	AAPL	Stock	17.9061	17.9143	17.8764	17.8775	9244788.0
2013-08-23 13:00:00	AAPL	Stock	17.8764	17.8968	17.8689	17.8864	7027748.0
2013-08-23 13:30:00	AAPL	Stock	17.8857	17.891	17.8686	17.8711	6401948.0
2013-08-23 14:00:00	AAPL	Stock	17.8689	17.8839	17.86	17.8635	8796816.0
2013-08-23 14:30:00	AAPL	Stock	17.8636	17.8864	17.8564	17.8732	9747556.0
2013-08-23 15:00:00	AAPL	Stock	17.8729	17.8868	17.8668	17.8842	10245564.0
2013-08-23 15:30:00	AAPL	Stock	17.8846	17.9175	17.8661	17.8957	31470012.0
2013-08-23 16:00:00	AAPL	Stock	17.8925	17.9339	17.8775	17.89	10102232.0
2013-08-23 16:30:00	AAPL	Stock	17.8893	17.8914	17.8608	17.8643	679532.0
2013-08-23 17:00:00	AAPL	Stock	17.8643	17.8936	17.8614	17.8804	345996.0
2013-08-23 17:30:00	AAPL	Stock	17.8839	17.8925	17.8786	17.8836	66948.0
2013-08-23 18:00:00	AAPL	Stock	17.8829	17.8839	17.8661	17.8661	85820.0
2013-08-23 18:30:00	AAPL	Stock	17.8782	17.8839	17.8775	17.8839	59024.0
2013-08-23 19:00:00	AAPL	Stock	17.8907	17.8921	17.8789	17.8843	66276.0
2013-08-23 19:30:00	AAPL	Stock	17.8821	17.8821	17.875	17.875	167020.0
2013-08-23 04:00:00	MSFT	Stock	32.5	32.5	32.5	32.5	100.0
2013-08-23 04:30:00	MSFT	Stock	32.5	32.5	32.5	32.5	400.0
2013-08-23 06:00:00	MSFT	Stock	32.45	32.45	32.45	32.45	500.0
2013-08-23 07:30:00	MSFT	Stock	32.42	32.47	32.42	32.47	300.0
2013-08-23 08:00:00	MSFT	Stock	32.41	32.5	32.41	32.5	1200.0
2013-08-23 08:30:00	MSFT	Stock	32.4	32.47	32.33	32.43	15300.0
2013-08-23 09:00:00	MSFT	Stock	32.47	35.5	32.45	35.18	23430571.0
2013-08-23 09:30:00	MSFT	Stock	35.17	35.2	34.34	34.68	55975483.0
2013-08-23 10:00:00	MSFT	Stock	34.68	34.88	34.39	34.54	20168763.0
2013-08-23 10:30:00	MSFT	Stock	34.535	34.74	34.5	34.52	13791048.0
2013-08-23 11:00:00	MSFT	Stock	34.52	34.55	34.25	34.25	13149567.0
2013-08-23 11:30:00	MSFT	Stock	34.25	34.33	34.0	34.21	13576271.0
2013-08-23 12:00:00	MSFT	Stock	34.21	34.47	34.11	34.43	14586273.0
2013-08-23 12:30:00	MSFT	Stock	34.42	34.595	34.38	34.54	8273843.0
2013-08-23 13:00:00	MSFT	Stock	34.54	34.67	34.53	34.609	6136478.0
2013-08-23 13:30:00	MSFT	Stock	34.6	34.7	34.52	34.545	6121497.0
2013-08-23 14:00:00	MSFT	Stock	34.55	34.8	34.5	34.76	7284795.0
2013-08-23 14:30:00	MSFT	Stock	34.77	34.99	34.73	34.74	9134135.0

> showing 50 of 78,122 rows — these rows as CSV

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