PREVIEW / stock_30min / 2014-08-26

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-26.parquet
  size:    1.6 MB
  rows:    83,325
  symbols: 3,591

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-08-26 04:00:00	AAPL	Stock	25.3125	25.35	25.3125	25.35	4800.0
2014-08-26 04:30:00	AAPL	Stock	25.35	25.3525	25.3425	25.3475	6596.0
2014-08-26 05:00:00	AAPL	Stock	25.3425	25.3425	25.3425	25.3425	2400.0
2014-08-26 05:30:00	AAPL	Stock	25.315	25.315	25.31	25.31	7912.0
2014-08-26 06:00:00	AAPL	Stock	25.3125	25.3375	25.3125	25.3375	10000.0
2014-08-26 06:30:00	AAPL	Stock	25.3425	25.35	25.325	25.35	9756.0
2014-08-26 07:00:00	AAPL	Stock	25.335	25.3675	25.325	25.3675	36048.0
2014-08-26 07:30:00	AAPL	Stock	25.3675	25.3975	25.3625	25.3875	54064.0
2014-08-26 08:00:00	AAPL	Stock	25.385	25.395	25.325	25.3575	386216.0
2014-08-26 08:30:00	AAPL	Stock	25.3625	25.3775	25.3575	25.375	177604.0
2014-08-26 09:00:00	AAPL	Stock	25.375	25.3825	25.35	25.355	208432.0
2014-08-26 09:30:00	AAPL	Stock	25.355	25.375	25.215	25.305	26620240.0
2014-08-26 10:00:00	AAPL	Stock	25.305	25.315	25.2175	25.2725	16882796.0
2014-08-26 10:30:00	AAPL	Stock	25.2725	25.3112	25.2525	25.2575	10481820.0
2014-08-26 11:00:00	AAPL	Stock	25.2575	25.2925	25.2475	25.29	8856376.0
2014-08-26 11:30:00	AAPL	Stock	25.29	25.2975	25.26	25.29	6298348.0
2014-08-26 12:00:00	AAPL	Stock	25.2888	25.35	25.2675	25.2925	5744084.0
2014-08-26 12:30:00	AAPL	Stock	25.2925	25.3175	25.2675	25.2775	5157120.0
2014-08-26 13:00:00	AAPL	Stock	25.279	25.3025	25.26	25.2925	4036144.0
2014-08-26 13:30:00	AAPL	Stock	25.2925	25.3	25.2775	25.295	3254608.0
2014-08-26 14:00:00	AAPL	Stock	25.2975	25.3175	25.2875	25.3075	4246528.0
2014-08-26 14:30:00	AAPL	Stock	25.305	25.32	25.2688	25.28	6220664.0
2014-08-26 15:00:00	AAPL	Stock	25.28	25.3	25.2675	25.2725	5115896.0
2014-08-26 15:30:00	AAPL	Stock	25.2725	25.295	25.22	25.2225	14013088.0
2014-08-26 16:00:00	AAPL	Stock	25.2225	25.2825	25.2025	25.24	3361268.0
2014-08-26 16:30:00	AAPL	Stock	25.225	25.2832	19.4375	25.2275	205516.0
2014-08-26 17:00:00	AAPL	Stock	25.2275	25.2375	25.2225	25.2375	72368.0
2014-08-26 17:30:00	AAPL	Stock	25.4075	25.4075	25.2225	25.2425	51660.0
2014-08-26 18:00:00	AAPL	Stock	25.2225	25.25	25.2225	25.25	103916.0
2014-08-26 18:30:00	AAPL	Stock	25.25	25.25	25.235	25.2475	24320.0
2014-08-26 19:00:00	AAPL	Stock	25.24	25.24	25.235	25.24	24092.0
2014-08-26 19:30:00	AAPL	Stock	25.245	25.2575	25.2375	25.255	69572.0
2014-08-26 06:00:00	MSFT	Stock	45.13	45.13	45.13	45.13	100.0
2014-08-26 07:00:00	MSFT	Stock	45.01	45.17	45.01	45.17	1600.0
2014-08-26 07:30:00	MSFT	Stock	45.17	45.17	45.17	45.17	500.0
2014-08-26 08:30:00	MSFT	Stock	45.25	45.25	45.25	45.25	1632.0
2014-08-26 09:00:00	MSFT	Stock	45.26	45.31	45.26	45.31	18600.0
2014-08-26 09:30:00	MSFT	Stock	45.3	45.395	45.15	45.22	1502918.0
2014-08-26 10:00:00	MSFT	Stock	45.22	45.3	45.11	45.165	1619921.0
2014-08-26 10:30:00	MSFT	Stock	45.165	45.23	45.14	45.21	571750.0
2014-08-26 11:00:00	MSFT	Stock	45.22	45.23	45.06	45.07	1069047.0
2014-08-26 11:30:00	MSFT	Stock	45.07	45.12	45.02	45.025	668256.0
2014-08-26 12:00:00	MSFT	Stock	45.03	45.06	45.0	45.0	539620.0
2014-08-26 12:30:00	MSFT	Stock	45.0	45.03	44.94	44.97	1048149.0
2014-08-26 13:00:00	MSFT	Stock	44.97	45.05	44.96	45.05	632765.0
2014-08-26 13:30:00	MSFT	Stock	45.05	45.09	45.035	45.07	477414.0
2014-08-26 14:00:00	MSFT	Stock	45.07	45.08	45.02	45.045	564696.0
2014-08-26 14:30:00	MSFT	Stock	45.04	45.06	45.03	45.06	432566.0
2014-08-26 15:00:00	MSFT	Stock	45.055	45.09	44.98	45.009	1154360.0
2014-08-26 15:30:00	MSFT	Stock	45.005	45.04	44.98	45.0	2186261.0

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

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