PREVIEW / stock_30min / 2014-05-28

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-28.parquet
  size:    1.6 MB
  rows:    83,010
  symbols: 3,566

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-05-28 04:00:00	AAPL	Stock	22.3596	22.3596	22.3596	22.3596	5600.0
2014-05-28 05:00:00	AAPL	Stock	22.4607	22.4893	22.4104	22.4893	19152.0
2014-05-28 05:30:00	AAPL	Stock	22.4893	22.4907	22.4893	22.4907	8848.0
2014-05-28 06:00:00	AAPL	Stock	22.4711	22.4711	22.4286	22.4286	42000.0
2014-05-28 06:30:00	AAPL	Stock	22.4125	22.4286	22.3929	22.4107	85316.0
2014-05-28 07:00:00	AAPL	Stock	22.4143	22.4143	22.4018	22.4018	70896.0
2014-05-28 07:30:00	AAPL	Stock	22.3946	22.4	22.3571	22.3571	241780.0
2014-05-28 08:00:00	AAPL	Stock	22.3839	22.4286	22.3439	22.4068	1238384.0
2014-05-28 08:30:00	AAPL	Stock	22.4011	22.4036	22.3207	22.3207	1193892.0
2014-05-28 09:00:00	AAPL	Stock	22.3104	22.3643	22.3104	22.3571	1182048.0
2014-05-28 09:30:00	AAPL	Stock	22.3579	22.4829	22.3143	22.46	60730488.0
2014-05-28 10:00:00	AAPL	Stock	22.4607	22.4939	22.3414	22.4029	34265364.0
2014-05-28 10:30:00	AAPL	Stock	22.4071	22.4225	22.2779	22.3611	24930808.0
2014-05-28 11:00:00	AAPL	Stock	22.3593	22.4107	22.3537	22.4018	15197364.0
2014-05-28 11:30:00	AAPL	Stock	22.4025	22.4141	22.365	22.3686	8208032.0
2014-05-28 12:00:00	AAPL	Stock	22.3682	22.3993	22.36	22.3746	10045868.0
2014-05-28 12:30:00	AAPL	Stock	22.3732	22.3868	22.3618	22.3846	4985372.0
2014-05-28 13:00:00	AAPL	Stock	22.3861	22.4643	22.3854	22.4443	10795820.0
2014-05-28 13:30:00	AAPL	Stock	22.4439	22.4521	22.3964	22.4286	12067636.0
2014-05-28 14:00:00	AAPL	Stock	22.4286	22.4343	22.3977	22.4112	7488404.0
2014-05-28 14:30:00	AAPL	Stock	22.4104	22.4105	22.3461	22.3479	12253304.0
2014-05-28 15:00:00	AAPL	Stock	22.3485	22.3839	22.3357	22.3761	9599296.0
2014-05-28 15:30:00	AAPL	Stock	22.3761	22.3786	22.2836	22.2857	26811204.0
2014-05-28 16:00:00	AAPL	Stock	22.2861	22.3834	22.2679	22.2816	17399928.0
2014-05-28 16:30:00	AAPL	Stock	22.2936	22.3207	22.2804	22.2946	1188908.0
2014-05-28 17:00:00	AAPL	Stock	22.2861	22.2982	22.2861	22.2982	308504.0
2014-05-28 17:30:00	AAPL	Stock	22.2911	22.3179	22.2904	22.3032	40656.0
2014-05-28 18:00:00	AAPL	Stock	22.2932	22.2982	22.2904	22.2982	86324.0
2014-05-28 18:30:00	AAPL	Stock	22.2861	22.3018	22.2861	22.2982	116564.0
2014-05-28 19:00:00	AAPL	Stock	22.2907	22.3018	22.2907	22.2911	45360.0
2014-05-28 19:30:00	AAPL	Stock	22.2961	22.3068	22.295	22.3068	72856.0
2014-05-28 07:00:00	MSFT	Stock	40.21	40.24	40.17	40.19	1550.0
2014-05-28 08:00:00	MSFT	Stock	40.19	40.19	40.18	40.18	39326.0
2014-05-28 08:30:00	MSFT	Stock	40.05	40.19	40.05	40.11	4509.0
2014-05-28 09:00:00	MSFT	Stock	40.09	40.14	40.09	40.12	1600.0
2014-05-28 09:30:00	MSFT	Stock	40.14	40.19	39.85	39.875	3992527.0
2014-05-28 10:00:00	MSFT	Stock	39.87	39.95	39.84	39.916	1942119.0
2014-05-28 10:30:00	MSFT	Stock	39.92	39.94	39.82	39.92	2266530.0
2014-05-28 11:00:00	MSFT	Stock	39.925	40.02	39.89	39.986	2097259.0
2014-05-28 11:30:00	MSFT	Stock	39.985	40.19	39.98	40.075	1489550.0
2014-05-28 12:00:00	MSFT	Stock	40.075	40.13	39.96	39.97	984256.0
2014-05-28 12:30:00	MSFT	Stock	39.965	40.01	39.96	39.98	661756.0
2014-05-28 13:00:00	MSFT	Stock	39.98	40.07	39.97	40.01	837803.0
2014-05-28 13:30:00	MSFT	Stock	40.012	40.06	40.0	40.05	867774.0
2014-05-28 14:00:00	MSFT	Stock	40.046	40.075	40.02	40.04	758747.0
2014-05-28 14:30:00	MSFT	Stock	40.035	40.07	39.99	40.037	1013874.0
2014-05-28 15:00:00	MSFT	Stock	40.036	40.1	40.03	40.085	916933.0
2014-05-28 15:30:00	MSFT	Stock	40.085	40.1	40.0	40.0	2802835.0
2014-05-28 16:00:00	MSFT	Stock	40.01	40.057	39.92	40.055	2723613.0
2014-05-28 16:30:00	MSFT	Stock	39.98	39.98	39.98	39.98	399.0

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

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