PREVIEW / stock_30min / 2013-11-13

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-11-13.parquet
  size:    1.6 MB
  rows:    81,113
  symbols: 3,534

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-11-13 04:00:00	AAPL	Stock	18.5625	18.5643	18.5571	18.5625	28112.0
2013-11-13 04:30:00	AAPL	Stock	18.5404	18.5404	18.5375	18.5375	7000.0
2013-11-13 05:00:00	AAPL	Stock	18.5568	18.5568	18.5568	18.5568	2800.0
2013-11-13 06:00:00	AAPL	Stock	18.5364	18.5364	18.5364	18.5364	2800.0
2013-11-13 06:30:00	AAPL	Stock	18.5714	18.5714	18.5714	18.5714	5600.0
2013-11-13 07:00:00	AAPL	Stock	18.5554	18.5982	18.5464	18.5982	97468.0
2013-11-13 07:30:00	AAPL	Stock	18.59	18.59	18.5446	18.5536	116424.0
2013-11-13 08:00:00	AAPL	Stock	18.55	18.5971	18.4911	18.5321	5049156.0
2013-11-13 08:30:00	AAPL	Stock	18.5204	18.5204	18.5	18.5071	256340.0
2013-11-13 09:00:00	AAPL	Stock	18.5046	18.5321	18.4914	18.5089	473452.0
2013-11-13 09:30:00	AAPL	Stock	18.5	18.5607	18.4629	18.5536	34252232.0
2013-11-13 10:00:00	AAPL	Stock	18.5532	18.5979	18.5243	18.5782	19993372.0
2013-11-13 10:30:00	AAPL	Stock	18.5796	18.5904	18.5357	18.5539	16171372.0
2013-11-13 11:00:00	AAPL	Stock	18.5529	18.5639	18.5379	18.5432	8760976.0
2013-11-13 11:30:00	AAPL	Stock	18.545	18.5971	18.5429	18.5875	10909696.0
2013-11-13 12:00:00	AAPL	Stock	18.59	18.6429	18.5689	18.6337	13067684.0
2013-11-13 12:30:00	AAPL	Stock	18.6336	18.6518	18.6018	18.6075	10366020.0
2013-11-13 13:00:00	AAPL	Stock	18.6069	18.6179	18.5804	18.6121	6649188.0
2013-11-13 13:30:00	AAPL	Stock	18.6121	18.6189	18.5611	18.5696	8640520.0
2013-11-13 14:00:00	AAPL	Stock	18.5625	18.5779	18.5214	18.5325	9829260.0
2013-11-13 14:30:00	AAPL	Stock	18.5329	18.5643	18.515	18.5436	7335272.0
2013-11-13 15:00:00	AAPL	Stock	18.5432	18.5771	18.5411	18.5682	7224896.0
2013-11-13 15:30:00	AAPL	Stock	18.5689	18.5989	18.5546	18.5971	21366324.0
2013-11-13 16:00:00	AAPL	Stock	18.5982	18.6001	18.5514	18.5929	10536792.0
2013-11-13 16:30:00	AAPL	Stock	18.5929	18.6071	18.5911	18.605	267008.0
2013-11-13 17:00:00	AAPL	Stock	18.5986	18.5986	18.5682	18.5682	109396.0
2013-11-13 17:30:00	AAPL	Stock	18.5982	18.5982	18.5536	18.5539	256620.0
2013-11-13 18:00:00	AAPL	Stock	18.5607	18.5982	18.5589	18.5779	48384.0
2013-11-13 18:30:00	AAPL	Stock	18.5746	18.5804	18.5714	18.5804	33600.0
2013-11-13 19:00:00	AAPL	Stock	18.5879	18.5893	18.5879	18.5893	37100.0
2013-11-13 19:30:00	AAPL	Stock	18.5893	18.6036	18.5893	18.5914	227976.0
2013-11-13 07:30:00	MSFT	Stock	37.12	37.12	37.12	37.12	300.0
2013-11-13 08:00:00	MSFT	Stock	37.24	37.24	37.15	37.2	4710.0
2013-11-13 08:30:00	MSFT	Stock	37.36	37.36	37.02	37.07	95220.0
2013-11-13 09:00:00	MSFT	Stock	37.06	37.1	36.96	36.98	49605.0
2013-11-13 09:30:00	MSFT	Stock	36.98	37.14	36.9	37.05	7135330.0
2013-11-13 10:00:00	MSFT	Stock	37.045	37.15	37.01	37.07	2640924.0
2013-11-13 10:30:00	MSFT	Stock	37.07	37.22	37.05	37.185	2801297.0
2013-11-13 11:00:00	MSFT	Stock	37.182	37.19	36.96	37.1	2863246.0
2013-11-13 11:30:00	MSFT	Stock	37.11	37.15	37.04	37.15	1626505.0
2013-11-13 12:00:00	MSFT	Stock	37.15	37.43	37.12	37.379	2080894.0
2013-11-13 12:30:00	MSFT	Stock	37.37	37.57	37.36	37.57	1916079.0
2013-11-13 13:00:00	MSFT	Stock	37.56	37.62	37.46	37.61	1390165.0
2013-11-13 13:30:00	MSFT	Stock	37.61	37.7	37.59	37.67	1556690.0
2013-11-13 14:00:00	MSFT	Stock	37.68	37.74	37.66	37.71	1660019.0
2013-11-13 14:30:00	MSFT	Stock	37.71	37.72	37.7	37.715	1255356.0
2013-11-13 15:00:00	MSFT	Stock	37.72	37.87	37.71	37.86	2665549.0
2013-11-13 15:30:00	MSFT	Stock	37.854	38.16	37.85	38.15	8696314.0
2013-11-13 16:00:00	MSFT	Stock	38.15	38.17	37.091	38.11	4348907.0
2013-11-13 16:30:00	MSFT	Stock	38.07	38.15	37.87	38.14	16878.0

> showing 50 of 81,113 rows — these rows as CSV

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