PREVIEW / stock_30min / 2015-05-04

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-04.parquet
  size:    1.6 MB
  rows:    82,388
  symbols: 3,522

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-04 04:00:00	AAPL	Stock	32.33	32.4225	32.3025	32.37	46164.0
2015-05-04 04:30:00	AAPL	Stock	32.3825	32.445	32.3825	32.41	47796.0
2015-05-04 05:00:00	AAPL	Stock	32.415	32.415	32.39	32.39	7928.0
2015-05-04 05:30:00	AAPL	Stock	32.3775	32.3775	32.3375	32.3375	25136.0
2015-05-04 06:00:00	AAPL	Stock	32.3625	32.375	32.325	32.3425	35628.0
2015-05-04 06:30:00	AAPL	Stock	32.35	32.3725	32.35	32.3625	27236.0
2015-05-04 07:00:00	AAPL	Stock	32.3375	32.425	32.3325	32.375	209780.0
2015-05-04 07:30:00	AAPL	Stock	32.3875	32.44	32.375	32.435	89908.0
2015-05-04 08:00:00	AAPL	Stock	32.425	32.485	32.3325	32.415	763728.0
2015-05-04 08:30:00	AAPL	Stock	32.4075	32.4552	32.405	32.4552	313872.0
2015-05-04 09:00:00	AAPL	Stock	32.455	32.465	32.375	32.375	678172.0
2015-05-04 09:30:00	AAPL	Stock	32.375	32.6425	32.375	32.5725	34626024.0
2015-05-04 10:00:00	AAPL	Stock	32.575	32.5875	32.385	32.5225	21240912.0
2015-05-04 10:30:00	AAPL	Stock	32.5225	32.545	32.345	32.43	13818736.0
2015-05-04 11:00:00	AAPL	Stock	32.4325	32.4925	32.405	32.4375	7846196.0
2015-05-04 11:30:00	AAPL	Stock	32.4375	32.4425	32.345	32.427	8752656.0
2015-05-04 12:00:00	AAPL	Stock	32.4255	32.427	32.305	32.3392	8463436.0
2015-05-04 12:30:00	AAPL	Stock	32.34	32.34	32.1068	32.18	14555256.0
2015-05-04 13:00:00	AAPL	Stock	32.18	32.185	32.065	32.1525	10487752.0
2015-05-04 13:30:00	AAPL	Stock	32.155	32.3275	32.115	32.32	9884236.0
2015-05-04 14:00:00	AAPL	Stock	32.32	32.3475	32.1675	32.215	10651212.0
2015-05-04 14:30:00	AAPL	Stock	32.2128	32.285	32.1875	32.2575	5653972.0
2015-05-04 15:00:00	AAPL	Stock	32.2575	32.26	32.1525	32.1575	7989996.0
2015-05-04 15:30:00	AAPL	Stock	32.16	32.275	32.1525	32.175	15033744.0
2015-05-04 16:00:00	AAPL	Stock	32.175	32.5355	32.15	32.1925	12527588.0
2015-05-04 16:30:00	AAPL	Stock	32.1925	32.1925	32.175	32.1825	34912.0
2015-05-04 17:00:00	AAPL	Stock	32.185	32.1922	32.18	32.1922	20796.0
2015-05-04 17:30:00	AAPL	Stock	32.1875	32.19	32.18	32.1875	28000.0
2015-05-04 18:00:00	AAPL	Stock	32.1825	32.1825	32.1625	32.175	34368.0
2015-05-04 18:30:00	AAPL	Stock	32.1875	32.1875	32.175	32.18	82504.0
2015-05-04 19:00:00	AAPL	Stock	32.18	32.1875	32.175	32.1775	18004.0
2015-05-04 19:30:00	AAPL	Stock	32.1775	32.1875	32.175	32.185	63600.0
2015-05-04 04:00:00	MSFT	Stock	48.65	48.65	48.55	48.55	300.0
2015-05-04 04:30:00	MSFT	Stock	48.62	48.62	48.51	48.51	1605.0
2015-05-04 05:00:00	MSFT	Stock	48.5	48.5	48.5	48.5	100.0
2015-05-04 05:30:00	MSFT	Stock	48.58	48.59	48.51	48.51	3660.0
2015-05-04 06:00:00	MSFT	Stock	48.55	48.55	48.55	48.55	708.0
2015-05-04 06:30:00	MSFT	Stock	48.49	48.49	48.47	48.47	2100.0
2015-05-04 07:00:00	MSFT	Stock	48.55	48.56	48.49	48.55	8618.0
2015-05-04 07:30:00	MSFT	Stock	48.5	48.54	48.49	48.54	6805.0
2015-05-04 08:00:00	MSFT	Stock	48.55	48.56	48.5	48.52	16620.0
2015-05-04 08:30:00	MSFT	Stock	48.55	48.58	48.47	48.5	18235.0
2015-05-04 09:00:00	MSFT	Stock	48.48	48.5	48.37	48.38	40070.0
2015-05-04 09:30:00	MSFT	Stock	48.44	48.87	48.35	48.8	3421946.0
2015-05-04 10:00:00	MSFT	Stock	48.8	48.84	48.57	48.64	2130862.0
2015-05-04 10:30:00	MSFT	Stock	48.63	48.67	48.5	48.535	1698937.0
2015-05-04 11:00:00	MSFT	Stock	48.533	48.67	48.48	48.64	1967335.0
2015-05-04 11:30:00	MSFT	Stock	48.634	48.65	48.515	48.535	1731656.0
2015-05-04 12:00:00	MSFT	Stock	48.53	48.575	48.48	48.51	1079799.0
2015-05-04 12:30:00	MSFT	Stock	48.51	48.54	48.44	48.445	1176393.0

> showing 50 of 82,388 rows — these rows as CSV

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