PREVIEW / stock_30min / 2013-03-13

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-13.parquet
  size:    1.4 MB
  rows:    76,281
  symbols: 3,465

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-03-13 05:00:00	AAPL	Stock	15.2786	15.2786	15.2786	15.2786	22204.0
2013-03-13 06:00:00	AAPL	Stock	15.2679	15.2679	15.2571	15.2571	5600.0
2013-03-13 06:30:00	AAPL	Stock	15.2489	15.2489	15.2321	15.2321	9800.0
2013-03-13 07:00:00	AAPL	Stock	15.2679	15.2679	15.2454	15.25	97608.0
2013-03-13 07:30:00	AAPL	Stock	15.2475	15.2543	15.2357	15.2539	89516.0
2013-03-13 08:00:00	AAPL	Stock	15.2411	15.2857	15.2321	15.2661	611156.0
2013-03-13 08:30:00	AAPL	Stock	15.2643	15.2946	15.2468	15.2707	1448412.0
2013-03-13 09:00:00	AAPL	Stock	15.27	15.3036	15.2654	15.2986	536676.0
2013-03-13 09:30:00	AAPL	Stock	15.3018	15.3125	15.1914	15.2673	52322368.0
2013-03-13 10:00:00	AAPL	Stock	15.2674	15.4089	15.215	15.3379	58878736.0
2013-03-13 10:30:00	AAPL	Stock	15.3354	15.4357	15.3286	15.4171	30580312.0
2013-03-13 11:00:00	AAPL	Stock	15.4179	15.4629	15.3614	15.3825	32274900.0
2013-03-13 11:30:00	AAPL	Stock	15.3861	15.4139	15.3682	15.375	12563796.0
2013-03-13 12:00:00	AAPL	Stock	15.375	15.455	15.3632	15.4377	18532360.0
2013-03-13 12:30:00	AAPL	Stock	15.4342	15.4457	15.4168	15.4321	10350060.0
2013-03-13 13:00:00	AAPL	Stock	15.4343	15.455	15.4011	15.4221	8644356.0
2013-03-13 13:30:00	AAPL	Stock	15.4229	15.5179	15.4191	15.475	26945072.0
2013-03-13 14:00:00	AAPL	Stock	15.4743	15.4821	15.4186	15.4396	14427952.0
2013-03-13 14:30:00	AAPL	Stock	15.44	15.4439	15.3332	15.3564	22506008.0
2013-03-13 15:00:00	AAPL	Stock	15.3564	15.3686	15.3168	15.3486	21192808.0
2013-03-13 15:30:00	AAPL	Stock	15.3514	15.3607	15.2807	15.2961	39867744.0
2013-03-13 16:00:00	AAPL	Stock	15.2982	15.4679	15.2929	15.2979	24899112.0
2013-03-13 16:30:00	AAPL	Stock	15.2975	15.3481	15.2932	15.2968	434672.0
2013-03-13 17:00:00	AAPL	Stock	15.2964	15.3157	15.2857	15.3139	387828.0
2013-03-13 17:30:00	AAPL	Stock	15.3143	15.3143	15.2982	15.305	212968.0
2013-03-13 18:00:00	AAPL	Stock	15.3011	15.3046	15.2975	15.2982	77700.0
2013-03-13 18:30:00	AAPL	Stock	15.2946	15.305	15.2946	15.305	55300.0
2013-03-13 19:00:00	AAPL	Stock	15.2996	15.305	15.2996	15.305	18200.0
2013-03-13 19:30:00	AAPL	Stock	15.2982	15.3161	15.2982	15.3032	189364.0
2013-03-13 07:00:00	MSFT	Stock	27.73	27.73	27.73	27.73	100.0
2013-03-13 08:30:00	MSFT	Stock	27.88	27.92	27.88	27.92	1100.0
2013-03-13 09:00:00	MSFT	Stock	27.91	27.91	27.84	27.89	31533.0
2013-03-13 09:30:00	MSFT	Stock	27.89	27.91	27.75	27.86	3972370.0
2013-03-13 10:00:00	MSFT	Stock	27.85	27.86	27.76	27.82	1406291.0
2013-03-13 10:30:00	MSFT	Stock	27.83	27.94	27.81	27.94	1584896.0
2013-03-13 11:00:00	MSFT	Stock	27.94	27.97	27.89	27.96	1813495.0
2013-03-13 11:30:00	MSFT	Stock	27.96	27.96	27.82	27.84	1250622.0
2013-03-13 12:00:00	MSFT	Stock	27.85	27.96	27.83	27.956	1451433.0
2013-03-13 12:30:00	MSFT	Stock	27.956	27.97	27.89	27.92	1516672.0
2013-03-13 13:00:00	MSFT	Stock	27.93	27.94	27.9	27.92	1002181.0
2013-03-13 13:30:00	MSFT	Stock	27.92	27.99	27.91	27.99	1439397.0
2013-03-13 14:00:00	MSFT	Stock	27.98	28.02	27.95	27.998	2666133.0
2013-03-13 14:30:00	MSFT	Stock	27.995	28.01	27.96	27.98	1416484.0
2013-03-13 15:00:00	MSFT	Stock	27.97	28.0	27.94	27.97	1774423.0
2013-03-13 15:30:00	MSFT	Stock	27.97	27.985	27.91	27.92	5428720.0
2013-03-13 16:00:00	MSFT	Stock	27.91	27.966	27.89	27.923	463037.0
2013-03-13 16:30:00	MSFT	Stock	27.92	27.97	27.9	27.92	25402.0
2013-03-13 17:30:00	MSFT	Stock	27.92	27.92	27.92	27.92	56116.0
2013-03-13 18:00:00	MSFT	Stock	27.91	27.92	27.91	27.92	1000.0
2013-03-13 18:30:00	MSFT	Stock	27.91	27.92	27.91	27.92	6049.0

> showing 50 of 76,281 rows — these rows as CSV

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