PREVIEW / stock_30min / 2014-06-02

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-02.parquet
  size:    1.6 MB
  rows:    82,803
  symbols: 3,557

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-06-02 04:00:00	AAPL	Stock	22.6782	22.7032	22.6782	22.6786	74984.0
2014-06-02 04:30:00	AAPL	Stock	22.6786	22.6786	22.6718	22.6739	39200.0
2014-06-02 05:00:00	AAPL	Stock	22.6786	22.7125	22.6786	22.71	19600.0
2014-06-02 05:30:00	AAPL	Stock	22.7143	22.7143	22.7054	22.7071	57624.0
2014-06-02 06:00:00	AAPL	Stock	22.7136	22.7286	22.7136	22.7232	96936.0
2014-06-02 06:30:00	AAPL	Stock	22.7214	22.7232	22.6936	22.7	87584.0
2014-06-02 07:00:00	AAPL	Stock	22.6904	22.7036	22.6839	22.6839	218764.0
2014-06-02 07:30:00	AAPL	Stock	22.6911	22.6911	22.6386	22.6457	234416.0
2014-06-02 08:00:00	AAPL	Stock	22.6429	22.7	22.6161	22.6393	963564.0
2014-06-02 08:30:00	AAPL	Stock	22.6414	22.6786	22.6375	22.6775	694904.0
2014-06-02 09:00:00	AAPL	Stock	22.6739	22.6764	22.6414	22.6432	699832.0
2014-06-02 09:30:00	AAPL	Stock	22.6414	22.6725	22.3842	22.389	51698080.0
2014-06-02 10:00:00	AAPL	Stock	22.3895	22.5125	22.3701	22.4779	23496424.0
2014-06-02 10:30:00	AAPL	Stock	22.4789	22.4879	22.3786	22.4193	18926180.0
2014-06-02 11:00:00	AAPL	Stock	22.4193	22.5286	22.3834	22.5264	17666320.0
2014-06-02 11:30:00	AAPL	Stock	22.5279	22.5711	22.4882	22.5539	14767564.0
2014-06-02 12:00:00	AAPL	Stock	22.5511	22.5704	22.4825	22.4946	9665180.0
2014-06-02 12:30:00	AAPL	Stock	22.4911	22.5521	22.4769	22.5021	8273776.0
2014-06-02 13:00:00	AAPL	Stock	22.5021	22.5279	22.3782	22.4336	22694140.0
2014-06-02 13:30:00	AAPL	Stock	22.4321	22.4971	22.4164	22.4564	11711644.0
2014-06-02 14:00:00	AAPL	Stock	22.4546	22.4854	22.2321	22.3071	35303772.0
2014-06-02 14:30:00	AAPL	Stock	22.3071	22.4746	22.2961	22.2979	27168960.0
2014-06-02 15:00:00	AAPL	Stock	22.3046	22.4036	22.2682	22.3307	19593504.0
2014-06-02 15:30:00	AAPL	Stock	22.3311	22.4639	22.3311	22.4464	29313592.0
2014-06-02 16:00:00	AAPL	Stock	22.4518	22.4571	22.4321	22.4321	4295872.0
2014-06-02 16:30:00	AAPL	Stock	22.4329	22.4343	22.4107	22.4321	199976.0
2014-06-02 17:00:00	AAPL	Stock	22.4354	22.4529	22.4354	22.4521	69384.0
2014-06-02 17:30:00	AAPL	Stock	22.4514	22.4525	22.4429	22.4518	141736.0
2014-06-02 18:00:00	AAPL	Stock	22.4518	22.4607	22.4446	22.4579	93016.0
2014-06-02 18:30:00	AAPL	Stock	22.4532	22.4614	22.4532	22.4575	43092.0
2014-06-02 19:00:00	AAPL	Stock	22.4468	22.4482	22.4468	22.4471	28644.0
2014-06-02 19:30:00	AAPL	Stock	22.4432	22.4464	22.4425	22.4425	127372.0
2014-06-02 04:00:00	MSFT	Stock	40.94	40.94	40.94	40.94	200.0
2014-06-02 04:30:00	MSFT	Stock	40.94	40.94	40.94	40.94	300.0
2014-06-02 06:30:00	MSFT	Stock	40.94	40.94	40.88	40.9	600.0
2014-06-02 07:00:00	MSFT	Stock	40.9	41.01	40.9	41.0	900.0
2014-06-02 07:30:00	MSFT	Stock	41.0	41.0	41.0	41.0	500.0
2014-06-02 08:00:00	MSFT	Stock	40.95	41.05	40.95	41.05	4210.0
2014-06-02 08:30:00	MSFT	Stock	41.04	41.05	41.04	41.04	4700.0
2014-06-02 09:00:00	MSFT	Stock	41.02	41.05	40.88	40.94	17452.0
2014-06-02 09:30:00	MSFT	Stock	40.95	41.0	40.8	40.972	2566751.0
2014-06-02 10:00:00	MSFT	Stock	40.98	41.09	40.85	40.95	2440743.0
2014-06-02 10:30:00	MSFT	Stock	40.95	41.01	40.93	41.0	1067794.0
2014-06-02 11:00:00	MSFT	Stock	40.99	41.01	40.9	40.97	1098636.0
2014-06-02 11:30:00	MSFT	Stock	40.96	40.99	40.86	40.87	1048086.0
2014-06-02 12:00:00	MSFT	Stock	40.865	40.9	40.86	40.88	752289.0
2014-06-02 12:30:00	MSFT	Stock	40.885	40.9	40.82	40.845	933041.0
2014-06-02 13:00:00	MSFT	Stock	40.84	40.86	40.798	40.83	764824.0
2014-06-02 13:30:00	MSFT	Stock	40.838	40.88	40.75	40.79	902397.0
2014-06-02 14:00:00	MSFT	Stock	40.79	40.81	40.73	40.781	570873.0

> showing 50 of 82,803 rows — these rows as CSV

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