PREVIEW / stock_30min / 2012-09-20

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-09-20.parquet
  size:    1.4 MB
  rows:    74,426
  symbols: 3,476

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
2012-09-20 04:00:00	AAPL	Stock	24.9643	24.9643	24.9643	24.9643	2800.0
2012-09-20 05:00:00	AAPL	Stock	24.9821	24.9821	24.9621	24.9643	38724.0
2012-09-20 05:30:00	AAPL	Stock	24.9429	24.9468	24.9314	24.9468	19488.0
2012-09-20 06:00:00	AAPL	Stock	24.9504	24.9536	24.9504	24.9536	6076.0
2012-09-20 06:30:00	AAPL	Stock	24.9643	24.9821	24.9643	24.9821	32200.0
2012-09-20 07:00:00	AAPL	Stock	24.9911	25.0286	24.98	25.0232	177296.0
2012-09-20 07:30:00	AAPL	Stock	25.0179	25.0179	24.9643	25.0	300384.0
2012-09-20 08:00:00	AAPL	Stock	24.9968	25.0179	24.9643	25.0	719488.0
2012-09-20 08:30:00	AAPL	Stock	24.9839	24.9857	24.9536	24.9854	800520.0
2012-09-20 09:00:00	AAPL	Stock	24.9854	24.9975	24.9654	24.9696	923160.0
2012-09-20 09:30:00	AAPL	Stock	24.97	24.9821	24.7721	24.8154	74810204.0
2012-09-20 10:00:00	AAPL	Stock	24.815	24.9111	24.8036	24.8707	38164952.0
2012-09-20 10:30:00	AAPL	Stock	24.8707	24.9404	24.865	24.9254	25898068.0
2012-09-20 11:00:00	AAPL	Stock	24.9281	24.9532	24.9018	24.9204	17689224.0
2012-09-20 11:30:00	AAPL	Stock	24.9171	24.94	24.8929	24.9382	12823468.0
2012-09-20 12:00:00	AAPL	Stock	24.9382	24.9532	24.9107	24.9164	10241532.0
2012-09-20 12:30:00	AAPL	Stock	24.9168	24.9282	24.895	24.9075	10869068.0
2012-09-20 13:00:00	AAPL	Stock	24.9075	24.9093	24.875	24.9089	13696900.0
2012-09-20 13:30:00	AAPL	Stock	24.9089	24.9421	24.8932	24.9146	10463124.0
2012-09-20 14:00:00	AAPL	Stock	24.9146	24.9936	24.9104	24.9814	17323572.0
2012-09-20 14:30:00	AAPL	Stock	24.9811	24.9882	24.95	24.9714	14204540.0
2012-09-20 15:00:00	AAPL	Stock	24.97	25.0021	24.9518	24.9889	16862132.0
2012-09-20 15:30:00	AAPL	Stock	24.9879	24.9989	24.9146	24.9534	29725304.0
2012-09-20 16:00:00	AAPL	Stock	24.9568	24.9696	24.919	24.9614	11441668.0
2012-09-20 16:30:00	AAPL	Stock	24.9536	24.9768	24.9536	24.975	383264.0
2012-09-20 17:00:00	AAPL	Stock	24.975	24.9757	24.9568	24.9671	686308.0
2012-09-20 17:30:00	AAPL	Stock	24.9707	24.9761	24.9536	24.9704	72996.0
2012-09-20 18:00:00	AAPL	Stock	24.9743	24.9814	24.9743	24.9786	118748.0
2012-09-20 18:30:00	AAPL	Stock	24.9804	24.9814	24.9754	24.9761	216188.0
2012-09-20 19:00:00	AAPL	Stock	24.9807	24.9814	24.9739	24.9811	154196.0
2012-09-20 19:30:00	AAPL	Stock	24.9793	24.9818	24.9643	24.9818	190064.0
2012-09-20 08:00:00	MSFT	Stock	30.99	30.99	30.95	30.97	8200.0
2012-09-20 08:30:00	MSFT	Stock	30.97	30.97	30.91	30.94	7825.0
2012-09-20 09:00:00	MSFT	Stock	30.94	31.02	30.89	30.96	76113.0
2012-09-20 09:30:00	MSFT	Stock	30.95	31.16	30.91	31.1	4833094.0
2012-09-20 10:00:00	MSFT	Stock	31.1	31.17	31.08	31.166	2762823.0
2012-09-20 10:30:00	MSFT	Stock	31.17	31.36	31.15	31.313	3951342.0
2012-09-20 11:00:00	MSFT	Stock	31.32	31.48	31.31	31.44	5693732.0
2012-09-20 11:30:00	MSFT	Stock	31.44	31.442	31.31	31.37	3433731.0
2012-09-20 12:00:00	MSFT	Stock	31.36	31.39	31.34	31.355	1665788.0
2012-09-20 12:30:00	MSFT	Stock	31.35	31.44	31.35	31.43	1604994.0
2012-09-20 13:00:00	MSFT	Stock	31.43	31.48	31.38	31.41	1874587.0
2012-09-20 13:30:00	MSFT	Stock	31.41	31.45	31.38	31.395	1825884.0
2012-09-20 14:00:00	MSFT	Stock	31.395	31.426	31.35	31.406	2454496.0
2012-09-20 14:30:00	MSFT	Stock	31.4	31.42	31.33	31.398	2676463.0
2012-09-20 15:00:00	MSFT	Stock	31.395	31.45	31.38	31.425	1962472.0
2012-09-20 15:30:00	MSFT	Stock	31.42	31.47	31.34	31.47	5071547.0
2012-09-20 16:00:00	MSFT	Stock	31.47	31.47	31.05	31.46	4056815.0
2012-09-20 16:30:00	MSFT	Stock	31.45	31.46	31.291	31.44	618850.0
2012-09-20 17:00:00	MSFT	Stock	31.44	31.48	31.44	31.48	174360.0

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

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