PREVIEW / stock_30min / 2014-09-25

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-25.parquet
  size:    1.6 MB
  rows:    85,969
  symbols: 3,564

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-09-25 04:00:00	AAPL	Stock	25.2625	25.295	25.1225	25.2775	48792.0
2014-09-25 04:30:00	AAPL	Stock	25.2775	25.3175	25.275	25.295	13200.0
2014-09-25 05:00:00	AAPL	Stock	25.305	25.305	25.25	25.2625	45096.0
2014-09-25 05:30:00	AAPL	Stock	25.275	25.2775	25.25	25.265	32012.0
2014-09-25 06:00:00	AAPL	Stock	25.275	25.285	25.2	25.25	49788.0
2014-09-25 06:30:00	AAPL	Stock	25.265	25.2875	25.2075	25.28	35356.0
2014-09-25 07:00:00	AAPL	Stock	25.2875	25.32	25.24	25.2775	111940.0
2014-09-25 07:30:00	AAPL	Stock	25.2875	25.31	25.275	25.29	93568.0
2014-09-25 08:00:00	AAPL	Stock	25.295	25.4375	25.205	25.205	1115456.0
2014-09-25 08:30:00	AAPL	Stock	25.2075	25.2325	25.1375	25.155	1394292.0
2014-09-25 09:00:00	AAPL	Stock	25.15	25.4375	25.125	25.1275	1139924.0
2014-09-25 09:30:00	AAPL	Stock	25.1275	25.1775	24.775	24.8675	68067316.0
2014-09-25 10:00:00	AAPL	Stock	24.8725	24.925	24.565	24.73	56860548.0
2014-09-25 10:30:00	AAPL	Stock	24.7325	24.7325	24.43	24.55	47623964.0
2014-09-25 11:00:00	AAPL	Stock	24.5525	24.6825	24.515	24.68	28137796.0
2014-09-25 11:30:00	AAPL	Stock	24.68	24.7125	24.605	24.64	22440856.0
2014-09-25 12:00:00	AAPL	Stock	24.64	24.7375	24.6075	24.6162	17404328.0
2014-09-25 12:30:00	AAPL	Stock	24.6175	24.7075	24.5925	24.655	12137508.0
2014-09-25 13:00:00	AAPL	Stock	24.6562	24.715	24.615	24.6742	11646664.0
2014-09-25 13:30:00	AAPL	Stock	24.675	24.69	24.57	24.61	15203812.0
2014-09-25 14:00:00	AAPL	Stock	24.6112	24.6375	24.5325	24.6	16146316.0
2014-09-25 14:30:00	AAPL	Stock	24.5988	24.62	24.535	24.5422	13999680.0
2014-09-25 15:00:00	AAPL	Stock	24.5413	24.6175	24.54	24.555	16475036.0
2014-09-25 15:30:00	AAPL	Stock	24.5525	24.58	24.465	24.4675	37306500.0
2014-09-25 16:00:00	AAPL	Stock	24.4675	24.6925	24.465	24.4875	10536056.0
2014-09-25 16:30:00	AAPL	Stock	24.5	24.6375	24.4625	24.51	1003772.0
2014-09-25 17:00:00	AAPL	Stock	24.5225	24.5425	24.4675	24.525	373388.0
2014-09-25 17:30:00	AAPL	Stock	24.5325	24.55	24.4675	24.4675	636076.0
2014-09-25 18:00:00	AAPL	Stock	24.515	24.56	24.4675	24.5575	150972.0
2014-09-25 18:30:00	AAPL	Stock	24.5575	24.5875	24.4675	24.5875	252764.0
2014-09-25 19:00:00	AAPL	Stock	24.575	24.61	24.575	24.58	161232.0
2014-09-25 19:30:00	AAPL	Stock	24.5825	24.595	24.565	24.5675	132892.0
2014-09-25 04:00:00	MSFT	Stock	47.17	47.17	47.17	47.17	300.0
2014-09-25 04:30:00	MSFT	Stock	47.17	47.2	47.17	47.2	735.0
2014-09-25 05:30:00	MSFT	Stock	47.18	47.18	47.18	47.18	100.0
2014-09-25 06:30:00	MSFT	Stock	47.18	47.18	47.18	47.18	300.0
2014-09-25 07:00:00	MSFT	Stock	47.16	47.16	47.16	47.16	100.0
2014-09-25 07:30:00	MSFT	Stock	47.09	47.09	47.08	47.08	400.0
2014-09-25 08:00:00	MSFT	Stock	47.1	47.1	47.0	47.08	1300.0
2014-09-25 08:30:00	MSFT	Stock	47.01	47.01	47.01	47.01	1300.0
2014-09-25 09:00:00	MSFT	Stock	47.04	47.04	46.9	46.95	4495.0
2014-09-25 09:30:00	MSFT	Stock	46.88	47.09	46.65	46.71	3430607.0
2014-09-25 10:00:00	MSFT	Stock	46.71	46.76	46.575	46.72	2926412.0
2014-09-25 10:30:00	MSFT	Stock	46.72	46.72	46.45	46.58	2183150.0
2014-09-25 11:00:00	MSFT	Stock	46.57	46.58	46.26	46.37	3532065.0
2014-09-25 11:30:00	MSFT	Stock	46.36	46.39	46.23	46.25	1905841.0
2014-09-25 12:00:00	MSFT	Stock	46.245	46.31	46.18	46.189	1917378.0
2014-09-25 12:30:00	MSFT	Stock	46.18	46.26	46.17	46.21	960122.0
2014-09-25 13:00:00	MSFT	Stock	46.213	46.28	46.15	46.235	1157798.0
2014-09-25 13:30:00	MSFT	Stock	46.24	46.27	46.09	46.131	1720733.0

> showing 50 of 85,969 rows — these rows as CSV

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