PREVIEW / stock_30min / 2014-01-06

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-06.parquet
  size:    1.6 MB
  rows:    83,132
  symbols: 3,532

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
2014-01-06 04:00:00	AAPL	Stock	19.3504	19.3504	19.3175	19.3175	28868.0
2014-01-06 04:30:00	AAPL	Stock	19.3186	19.32	19.3161	19.3171	25200.0
2014-01-06 05:00:00	AAPL	Stock	19.3182	19.3214	19.3179	19.3214	20076.0
2014-01-06 05:30:00	AAPL	Stock	19.3125	19.3214	19.2679	19.2679	57792.0
2014-01-06 06:00:00	AAPL	Stock	19.2511	19.2611	19.0536	19.1329	412552.0
2014-01-06 06:30:00	AAPL	Stock	19.1361	19.1361	19.0857	19.1061	258524.0
2014-01-06 07:00:00	AAPL	Stock	19.1061	19.2139	19.1061	19.1639	485996.0
2014-01-06 07:30:00	AAPL	Stock	19.1786	19.2321	19.1557	19.2186	752192.0
2014-01-06 08:00:00	AAPL	Stock	19.2143	19.3368	19.1571	19.2543	1179080.0
2014-01-06 08:30:00	AAPL	Stock	19.2657	19.2661	19.1821	19.2071	893284.0
2014-01-06 09:00:00	AAPL	Stock	19.2071	19.2318	19.1764	19.1875	1677704.0
2014-01-06 09:30:00	AAPL	Stock	19.1946	19.2321	19.0571	19.2052	74874408.0
2014-01-06 10:00:00	AAPL	Stock	19.2061	19.2432	19.1132	19.2162	28810628.0
2014-01-06 10:30:00	AAPL	Stock	19.2209	19.365	19.2079	19.3157	39134508.0
2014-01-06 11:00:00	AAPL	Stock	19.3154	19.3386	19.2425	19.3164	24095988.0
2014-01-06 11:30:00	AAPL	Stock	19.3175	19.3596	19.2568	19.3571	13976732.0
2014-01-06 12:00:00	AAPL	Stock	19.3596	19.4239	19.3554	19.3954	18872056.0
2014-01-06 12:30:00	AAPL	Stock	19.3954	19.4643	19.3725	19.4511	14048244.0
2014-01-06 13:00:00	AAPL	Stock	19.4518	19.4839	19.4221	19.4339	19676860.0
2014-01-06 13:30:00	AAPL	Stock	19.4364	19.4907	19.4225	19.4436	13790588.0
2014-01-06 14:00:00	AAPL	Stock	19.4436	19.4893	19.4286	19.4729	16985276.0
2014-01-06 14:30:00	AAPL	Stock	19.4721	19.5136	19.4666	19.4857	17066560.0
2014-01-06 15:00:00	AAPL	Stock	19.4855	19.5286	19.4718	19.5032	13685028.0
2014-01-06 15:30:00	AAPL	Stock	19.5011	19.5118	19.4111	19.4267	32615548.0
2014-01-06 16:00:00	AAPL	Stock	19.4264	19.4404	19.1643	19.4293	20682060.0
2014-01-06 16:30:00	AAPL	Stock	19.4286	19.4329	19.3012	19.4286	1772960.0
2014-01-06 17:00:00	AAPL	Stock	19.4286	19.4325	19.4268	19.4293	61628.0
2014-01-06 17:30:00	AAPL	Stock	19.4289	19.4357	19.4204	19.4221	214816.0
2014-01-06 18:00:00	AAPL	Stock	19.4357	19.4364	19.4204	19.4261	108052.0
2014-01-06 18:30:00	AAPL	Stock	19.4239	19.4279	19.4111	19.4279	58128.0
2014-01-06 19:00:00	AAPL	Stock	19.4146	19.4375	19.4132	19.4357	203728.0
2014-01-06 19:30:00	AAPL	Stock	19.4357	19.4554	19.4357	19.45	152320.0
2014-01-06 05:30:00	MSFT	Stock	37.0	37.0	37.0	37.0	100.0
2014-01-06 06:00:00	MSFT	Stock	37.14	37.14	37.14	37.14	200.0
2014-01-06 06:30:00	MSFT	Stock	37.08	37.08	37.04	37.04	300.0
2014-01-06 07:00:00	MSFT	Stock	37.03	37.03	36.99	36.99	300.0
2014-01-06 07:30:00	MSFT	Stock	37.09	37.09	37.0	37.0	1500.0
2014-01-06 08:00:00	MSFT	Stock	36.95	37.02	36.9	36.9	7211.0
2014-01-06 08:30:00	MSFT	Stock	36.8	36.81	36.7	36.73	13034.0
2014-01-06 09:00:00	MSFT	Stock	36.75	36.9	36.65	36.81	122912.0
2014-01-06 09:30:00	MSFT	Stock	36.85	36.89	36.45	36.46	4400794.0
2014-01-06 10:00:00	MSFT	Stock	36.45	36.505	36.24	36.4	3910702.0
2014-01-06 10:30:00	MSFT	Stock	36.404	36.45	36.2	36.235	3406250.0
2014-01-06 11:00:00	MSFT	Stock	36.24	36.34	36.17	36.21	2181087.0
2014-01-06 11:30:00	MSFT	Stock	36.21	36.36	36.2	36.334	1578290.0
2014-01-06 12:00:00	MSFT	Stock	36.34	36.35	36.25	36.31	1221276.0
2014-01-06 12:30:00	MSFT	Stock	36.3	36.305	36.21	36.256	1145043.0
2014-01-06 13:00:00	MSFT	Stock	36.26	36.26	36.172	36.19	2664617.0
2014-01-06 13:30:00	MSFT	Stock	36.195	36.26	36.18	36.255	1565661.0
2014-01-06 14:00:00	MSFT	Stock	36.26	36.27	36.2	36.205	1567857.0

> showing 50 of 83,132 rows — these rows as CSV

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