PREVIEW / stock_30min / 2014-08-27

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-27.parquet
  size:    1.5 MB
  rows:    81,037
  symbols: 3,562

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-27 04:00:00	AAPL	Stock	25.2725	25.2725	25.2725	25.2725	400.0
2014-08-27 05:00:00	AAPL	Stock	25.3175	25.325	25.3175	25.325	1200.0
2014-08-27 05:30:00	AAPL	Stock	25.3225	25.33	25.3225	25.325	1600.0
2014-08-27 06:00:00	AAPL	Stock	25.2925	25.2925	25.2925	25.2925	400.0
2014-08-27 06:30:00	AAPL	Stock	25.315	25.315	25.315	25.315	400.0
2014-08-27 07:00:00	AAPL	Stock	25.32	25.32	25.2825	25.3125	41152.0
2014-08-27 07:30:00	AAPL	Stock	25.3125	25.3125	25.275	25.28	53476.0
2014-08-27 08:00:00	AAPL	Stock	25.2825	25.3125	25.2225	25.2825	221388.0
2014-08-27 08:30:00	AAPL	Stock	25.28	25.28	25.25	25.2625	177148.0
2014-08-27 09:00:00	AAPL	Stock	25.26	25.2775	25.2375	25.2625	211032.0
2014-08-27 09:30:00	AAPL	Stock	25.255	25.295	25.175	25.2125	18662968.0
2014-08-27 10:00:00	AAPL	Stock	25.2125	25.24	25.19	25.1975	9508468.0
2014-08-27 10:30:00	AAPL	Stock	25.1983	25.295	25.1775	25.2888	11013940.0
2014-08-27 11:00:00	AAPL	Stock	25.29	25.295	25.25	25.2825	6856892.0
2014-08-27 11:30:00	AAPL	Stock	25.2825	25.495	25.27	25.44	20803252.0
2014-08-27 12:00:00	AAPL	Stock	25.44	25.49	25.4328	25.4552	8891364.0
2014-08-27 12:30:00	AAPL	Stock	25.4575	25.515	25.4425	25.515	12240176.0
2014-08-27 13:00:00	AAPL	Stock	25.5148	25.515	25.46	25.4925	8804124.0
2014-08-27 13:30:00	AAPL	Stock	25.4912	25.545	25.49	25.54	10603280.0
2014-08-27 14:00:00	AAPL	Stock	25.5375	25.6425	25.5375	25.5815	18163220.0
2014-08-27 14:30:00	AAPL	Stock	25.5825	25.5925	25.5175	25.52	13687216.0
2014-08-27 15:00:00	AAPL	Stock	25.5175	25.5625	25.485	25.4942	12901700.0
2014-08-27 15:30:00	AAPL	Stock	25.4938	25.535	25.4875	25.53	14411340.0
2014-08-27 16:00:00	AAPL	Stock	25.5325	25.5325	25.4335	25.4825	7396800.0
2014-08-27 16:30:00	AAPL	Stock	25.4875	25.547	20.6265	25.4775	147440.0
2014-08-27 17:00:00	AAPL	Stock	25.4925	25.5125	25.4925	25.5075	79196.0
2014-08-27 17:30:00	AAPL	Stock	25.5	25.51	25.4975	25.4975	23020.0
2014-08-27 18:00:00	AAPL	Stock	25.51	25.5325	25.4925	25.5	898388.0
2014-08-27 18:30:00	AAPL	Stock	25.4925	25.5325	25.49	25.5	2312988.0
2014-08-27 19:00:00	AAPL	Stock	25.5	25.5025	25.49	25.5	82548.0
2014-08-27 19:30:00	AAPL	Stock	25.505	25.525	25.505	25.525	58280.0
2014-08-27 07:30:00	MSFT	Stock	45.1	45.1	45.1	45.1	100.0
2014-08-27 08:00:00	MSFT	Stock	45.11	45.11	45.11	45.11	100.0
2014-08-27 08:30:00	MSFT	Stock	45.0	45.0	45.0	45.0	450.0
2014-08-27 09:00:00	MSFT	Stock	45.01	45.01	44.9	44.9	2500.0
2014-08-27 09:30:00	MSFT	Stock	44.9	45.0	44.85	44.88	1815544.0
2014-08-27 10:00:00	MSFT	Stock	44.875	44.935	44.86	44.87	1652067.0
2014-08-27 10:30:00	MSFT	Stock	44.87	44.95	44.864	44.88	742896.0
2014-08-27 11:00:00	MSFT	Stock	44.88	44.95	44.88	44.91	814496.0
2014-08-27 11:30:00	MSFT	Stock	44.91	44.925	44.83	44.88	1028427.0
2014-08-27 12:00:00	MSFT	Stock	44.88	44.93	44.85	44.895	627694.0
2014-08-27 12:30:00	MSFT	Stock	44.89	44.9	44.86	44.87	447758.0
2014-08-27 13:00:00	MSFT	Stock	44.87	44.91	44.86	44.864	439570.0
2014-08-27 13:30:00	MSFT	Stock	44.86	44.875	44.76	44.76	1477859.0
2014-08-27 14:00:00	MSFT	Stock	44.76	44.83	44.76	44.806	1419082.0
2014-08-27 14:30:00	MSFT	Stock	44.8	44.82	44.765	44.77	770510.0
2014-08-27 15:00:00	MSFT	Stock	44.765	44.83	44.76	44.805	990998.0
2014-08-27 15:30:00	MSFT	Stock	44.804	44.87	44.77	44.86	3156754.0
2014-08-27 16:00:00	MSFT	Stock	44.87	44.87	44.74	44.87	2756146.0
2014-08-27 16:30:00	MSFT	Stock	44.823	44.87	44.78	44.87	2054649.0

> showing 50 of 81,037 rows — these rows as CSV

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