PREVIEW / stock_30min / 2015-05-14

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-14.parquet
  size:    1.6 MB
  rows:    83,414
  symbols: 3,511

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
2015-05-14 04:00:00	AAPL	Stock	29.0	31.5775	29.0	31.5625	7200.0
2015-05-14 04:30:00	AAPL	Stock	31.6075	31.63	31.6	31.63	11840.0
2015-05-14 05:00:00	AAPL	Stock	31.605	31.625	31.5625	31.625	3932.0
2015-05-14 06:00:00	AAPL	Stock	31.5875	31.625	31.5875	31.625	6232.0
2015-05-14 06:30:00	AAPL	Stock	31.6125	31.6825	31.61	31.6825	97216.0
2015-05-14 07:00:00	AAPL	Stock	31.67	31.7125	31.65	31.7	169432.0
2015-05-14 07:30:00	AAPL	Stock	31.6925	31.725	31.655	31.7175	161128.0
2015-05-14 08:00:00	AAPL	Stock	31.715	31.775	31.6525	31.7575	704772.0
2015-05-14 08:30:00	AAPL	Stock	31.7575	31.8	31.7575	31.7825	516076.0
2015-05-14 09:00:00	AAPL	Stock	31.785	31.8725	31.775	31.87	696348.0
2015-05-14 09:30:00	AAPL	Stock	31.855	31.95	31.79	31.925	32320820.0
2015-05-14 10:00:00	AAPL	Stock	31.925	32.045	31.875	31.9985	23361996.0
2015-05-14 10:30:00	AAPL	Stock	32.0	32.0625	31.9575	32.06	13141504.0
2015-05-14 11:00:00	AAPL	Stock	32.0575	32.1125	32.0375	32.0625	11558772.0
2015-05-14 11:30:00	AAPL	Stock	32.0625	32.1125	32.04	32.0962	8739856.0
2015-05-14 12:00:00	AAPL	Stock	32.0975	32.1225	32.0425	32.0952	7434996.0
2015-05-14 12:30:00	AAPL	Stock	32.095	32.14	32.0675	32.1275	7283236.0
2015-05-14 13:00:00	AAPL	Stock	32.1275	32.1725	32.1175	32.1725	6960308.0
2015-05-14 13:30:00	AAPL	Stock	32.1702	32.2125	32.1475	32.1708	8082216.0
2015-05-14 14:00:00	AAPL	Stock	32.1725	32.22	32.1275	32.205	6825820.0
2015-05-14 14:30:00	AAPL	Stock	32.205	32.23	32.1775	32.2275	6409372.0
2015-05-14 15:00:00	AAPL	Stock	32.23	32.23	32.1875	32.2075	7654480.0
2015-05-14 15:30:00	AAPL	Stock	32.2075	32.2375	32.16	32.2375	18817192.0
2015-05-14 16:00:00	AAPL	Stock	32.2375	32.2375	32.1975	32.2075	5674228.0
2015-05-14 16:30:00	AAPL	Stock	32.22	32.22	32.155	32.2125	130636.0
2015-05-14 17:00:00	AAPL	Stock	32.2	32.2175	32.1952	32.2125	107480.0
2015-05-14 17:30:00	AAPL	Stock	32.2125	32.225	32.2125	32.2175	49316.0
2015-05-14 18:00:00	AAPL	Stock	32.2175	32.2175	32.2	32.2	17084.0
2015-05-14 18:30:00	AAPL	Stock	32.2	32.2225	32.1975	32.22	32812.0
2015-05-14 19:00:00	AAPL	Stock	32.2225	32.24	32.2125	32.2225	85524.0
2015-05-14 19:30:00	AAPL	Stock	32.23	32.235	32.2225	32.2325	74660.0
2015-05-14 04:00:00	MSFT	Stock	47.83	47.83	47.83	47.83	100.0
2015-05-14 04:30:00	MSFT	Stock	47.9	47.95	47.9	47.95	1900.0
2015-05-14 06:30:00	MSFT	Stock	47.89	47.95	47.89	47.95	4073.0
2015-05-14 07:00:00	MSFT	Stock	47.9	47.91	47.89	47.89	1800.0
2015-05-14 07:30:00	MSFT	Stock	47.88	47.94	47.88	47.94	1178.0
2015-05-14 08:00:00	MSFT	Stock	47.94	48.05	47.84	48.0	24841.0
2015-05-14 08:30:00	MSFT	Stock	47.911	47.97	47.911	47.97	2300.0
2015-05-14 09:00:00	MSFT	Stock	47.97	48.08	47.97	48.03	22477.0
2015-05-14 09:30:00	MSFT	Stock	48.03	48.59	48.03	48.505	4294878.0
2015-05-14 10:00:00	MSFT	Stock	48.505	48.82	48.47	48.77	3675843.0
2015-05-14 10:30:00	MSFT	Stock	48.78	48.805	48.58	48.615	2237438.0
2015-05-14 11:00:00	MSFT	Stock	48.62	48.693	48.55	48.605	2248449.0
2015-05-14 11:30:00	MSFT	Stock	48.605	48.67	48.55	48.63	1402442.0
2015-05-14 12:00:00	MSFT	Stock	48.63	48.7	48.59	48.68	1305387.0
2015-05-14 12:30:00	MSFT	Stock	48.69	48.725	48.61	48.63	1054805.0
2015-05-14 13:00:00	MSFT	Stock	48.631	48.78	48.615	48.76	1341602.0
2015-05-14 13:30:00	MSFT	Stock	48.76	48.8	48.67	48.715	1745967.0
2015-05-14 14:00:00	MSFT	Stock	48.715	48.74	48.68	48.7	1042512.0
2015-05-14 14:30:00	MSFT	Stock	48.69	48.72	48.6	48.65	1212025.0

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

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