PREVIEW / stock_30min / 2014-02-10

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-10.parquet
  size:    1.6 MB
  rows:    83,107
  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
2014-02-10 04:00:00	AAPL	Stock	18.6464	18.6464	18.6218	18.625	15400.0
2014-02-10 04:30:00	AAPL	Stock	18.6279	18.6554	18.6279	18.6554	11200.0
2014-02-10 05:00:00	AAPL	Stock	18.6607	18.6643	18.6407	18.6407	25200.0
2014-02-10 05:30:00	AAPL	Stock	18.6339	18.6464	18.6339	18.6464	8484.0
2014-02-10 06:00:00	AAPL	Stock	18.6429	18.6429	18.6321	18.6321	13944.0
2014-02-10 06:30:00	AAPL	Stock	18.6375	18.6375	18.6375	18.6375	2800.0
2014-02-10 07:00:00	AAPL	Stock	18.6129	18.6161	18.5718	18.5939	110432.0
2014-02-10 07:30:00	AAPL	Stock	18.5857	18.6346	18.5857	18.6179	239876.0
2014-02-10 08:00:00	AAPL	Stock	18.6161	18.6357	18.5607	18.5968	644364.0
2014-02-10 08:30:00	AAPL	Stock	18.5971	18.6143	18.5943	18.6061	512288.0
2014-02-10 09:00:00	AAPL	Stock	18.5986	18.6139	18.4543	18.5014	4892216.0
2014-02-10 09:30:00	AAPL	Stock	18.5236	18.8661	18.5	18.7995	64855140.0
2014-02-10 10:00:00	AAPL	Stock	18.8043	18.8618	18.7957	18.8151	23428160.0
2014-02-10 10:30:00	AAPL	Stock	18.8204	18.8546	18.7679	18.82	19462436.0
2014-02-10 11:00:00	AAPL	Stock	18.8229	18.905	18.8043	18.8868	19431356.0
2014-02-10 11:30:00	AAPL	Stock	18.8871	18.9179	18.8679	18.9098	12686576.0
2014-02-10 12:00:00	AAPL	Stock	18.9086	18.9814	18.9086	18.9586	22240512.0
2014-02-10 12:30:00	AAPL	Stock	18.9571	18.9996	18.9068	18.9146	17423812.0
2014-02-10 13:00:00	AAPL	Stock	18.9179	18.9396	18.8718	18.9239	11140948.0
2014-02-10 13:30:00	AAPL	Stock	18.92	18.9321	18.8607	18.9011	10630900.0
2014-02-10 14:00:00	AAPL	Stock	18.9046	18.9636	18.8821	18.9464	9505468.0
2014-02-10 14:30:00	AAPL	Stock	18.9464	18.96	18.9061	18.9304	9747696.0
2014-02-10 15:00:00	AAPL	Stock	18.9307	18.9411	18.8825	18.8857	10820852.0
2014-02-10 15:30:00	AAPL	Stock	18.8866	18.9107	18.8629	18.8923	20727448.0
2014-02-10 16:00:00	AAPL	Stock	18.8925	18.9071	18.8314	18.9018	17928008.0
2014-02-10 16:30:00	AAPL	Stock	18.9018	18.9132	18.8925	18.9036	327124.0
2014-02-10 17:00:00	AAPL	Stock	18.9054	18.9054	18.8925	18.8925	152796.0
2014-02-10 17:30:00	AAPL	Stock	18.9025	18.9036	18.8925	18.8989	72240.0
2014-02-10 18:00:00	AAPL	Stock	18.8982	18.9	18.8961	18.8982	11200.0
2014-02-10 18:30:00	AAPL	Stock	18.8946	18.8964	18.8929	18.8929	15820.0
2014-02-10 19:00:00	AAPL	Stock	18.9032	18.9032	18.9007	18.9007	16800.0
2014-02-10 19:30:00	AAPL	Stock	18.9014	18.9154	18.8946	18.9018	102928.0
2014-02-10 05:00:00	MSFT	Stock	36.65	36.65	36.54	36.54	1100.0
2014-02-10 05:30:00	MSFT	Stock	36.65	36.65	36.65	36.65	1000.0
2014-02-10 06:00:00	MSFT	Stock	36.65	36.65	36.65	36.65	2500.0
2014-02-10 07:00:00	MSFT	Stock	36.6	36.61	36.6	36.61	2200.0
2014-02-10 07:30:00	MSFT	Stock	36.6	36.6	36.6	36.6	2400.0
2014-02-10 08:00:00	MSFT	Stock	36.62	36.64	36.6	36.64	6900.0
2014-02-10 08:30:00	MSFT	Stock	36.64	36.65	36.64	36.64	900.0
2014-02-10 09:00:00	MSFT	Stock	36.64	36.65	36.6	36.61	3239.0
2014-02-10 09:30:00	MSFT	Stock	36.6	36.736	36.46	36.54	3366551.0
2014-02-10 10:00:00	MSFT	Stock	36.54	36.566	36.4	36.43	2491241.0
2014-02-10 10:30:00	MSFT	Stock	36.43	36.437	36.29	36.345	2562394.0
2014-02-10 11:00:00	MSFT	Stock	36.345	36.56	36.34	36.525	1144801.0
2014-02-10 11:30:00	MSFT	Stock	36.525	36.66	36.475	36.65	959033.0
2014-02-10 12:00:00	MSFT	Stock	36.65	36.65	36.53	36.57	727228.0
2014-02-10 12:30:00	MSFT	Stock	36.57	36.66	36.54	36.57	723312.0
2014-02-10 13:00:00	MSFT	Stock	36.575	36.668	36.57	36.66	584392.0
2014-02-10 13:30:00	MSFT	Stock	36.67	36.73	36.65	36.71	872511.0
2014-02-10 14:00:00	MSFT	Stock	36.71	36.74	36.66	36.68	1036035.0

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

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