PREVIEW / stock_30min / 2015-09-04

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-04.parquet
  size:    1.5 MB
  rows:    79,950
  symbols: 3,437

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-09-04 04:00:00	AAPL	Stock	27.5025	27.5025	27.3325	27.4	13320.0
2015-09-04 04:30:00	AAPL	Stock	27.325	27.375	27.325	27.35	19420.0
2015-09-04 05:00:00	AAPL	Stock	27.3725	27.375	27.3625	27.3625	4800.0
2015-09-04 05:30:00	AAPL	Stock	27.365	27.3825	27.35	27.35	1600.0
2015-09-04 06:00:00	AAPL	Stock	27.3275	27.3575	27.2525	27.275	13736.0
2015-09-04 06:30:00	AAPL	Stock	27.32	27.34	27.2925	27.3375	15780.0
2015-09-04 07:00:00	AAPL	Stock	27.3275	27.4175	27.3275	27.4	75732.0
2015-09-04 07:30:00	AAPL	Stock	27.4	27.4325	27.3575	27.4	139256.0
2015-09-04 08:00:00	AAPL	Stock	27.41	27.435	27.2525	27.3675	729136.0
2015-09-04 08:30:00	AAPL	Stock	27.375	27.5675	27.2175	27.25	1173800.0
2015-09-04 09:00:00	AAPL	Stock	27.255	27.3575	27.1625	27.245	1424208.0
2015-09-04 09:30:00	AAPL	Stock	27.2425	27.6125	27.2325	27.429	30518620.0
2015-09-04 10:00:00	AAPL	Stock	27.4275	27.5	27.295	27.41	15649576.0
2015-09-04 10:30:00	AAPL	Stock	27.41	27.55	27.3125	27.365	12014352.0
2015-09-04 11:00:00	AAPL	Stock	27.3675	27.405	27.275	27.355	10213896.0
2015-09-04 11:30:00	AAPL	Stock	27.3525	27.3775	27.2425	27.302	10024944.0
2015-09-04 12:00:00	AAPL	Stock	27.3	27.32	27.1625	27.205	9467016.0
2015-09-04 12:30:00	AAPL	Stock	27.205	27.23	27.13	27.1825	9224596.0
2015-09-04 13:00:00	AAPL	Stock	27.185	27.285	27.1275	27.2725	9672888.0
2015-09-04 13:30:00	AAPL	Stock	27.2725	27.31	27.2325	27.245	7640892.0
2015-09-04 14:00:00	AAPL	Stock	27.245	27.27	27.14	27.19	8854240.0
2015-09-04 14:30:00	AAPL	Stock	27.19	27.2788	27.15	27.275	8574912.0
2015-09-04 15:00:00	AAPL	Stock	27.2725	27.3325	27.215	27.31	12828688.0
2015-09-04 15:30:00	AAPL	Stock	27.31	27.44	27.2725	27.2925	24855268.0
2015-09-04 16:00:00	AAPL	Stock	27.2975	27.35	27.285	27.3275	9160464.0
2015-09-04 16:30:00	AAPL	Stock	27.3275	27.3275	27.26	27.2875	152832.0
2015-09-04 17:00:00	AAPL	Stock	27.2925	27.325	27.2825	27.3175	80144.0
2015-09-04 17:30:00	AAPL	Stock	27.325	27.325	27.29	27.295	94208.0
2015-09-04 18:00:00	AAPL	Stock	27.295	27.3075	27.275	27.275	38132.0
2015-09-04 18:30:00	AAPL	Stock	27.275	27.2925	27.275	27.2925	32224.0
2015-09-04 19:00:00	AAPL	Stock	27.2925	27.2925	27.275	27.2875	21052.0
2015-09-04 19:30:00	AAPL	Stock	27.275	27.2875	27.2525	27.2625	48532.0
2015-09-04 04:00:00	MSFT	Stock	43.1	43.1	43.1	43.1	250.0
2015-09-04 04:30:00	MSFT	Stock	43.1	43.1	43.1	43.1	750.0
2015-09-04 06:30:00	MSFT	Stock	42.97	42.97	42.97	42.97	100.0
2015-09-04 07:00:00	MSFT	Stock	43.0	43.0	43.0	43.0	1100.0
2015-09-04 07:30:00	MSFT	Stock	43.0	43.0	43.0	43.0	100.0
2015-09-04 08:00:00	MSFT	Stock	43.15	43.15	43.05	43.15	4957.0
2015-09-04 08:30:00	MSFT	Stock	43.05	43.19	42.85	42.85	72656.0
2015-09-04 09:00:00	MSFT	Stock	42.81	43.0	42.8	42.8	51684.0
2015-09-04 09:30:00	MSFT	Stock	42.8	43.04	42.49	42.65	4922063.0
2015-09-04 10:00:00	MSFT	Stock	42.65	42.8	42.57	42.79	2347658.0
2015-09-04 10:30:00	MSFT	Stock	42.79	42.88	42.5	42.525	1865197.0
2015-09-04 11:00:00	MSFT	Stock	42.54	42.61	42.43	42.55	1824464.0
2015-09-04 11:30:00	MSFT	Stock	42.55	42.7	42.46	42.6	1698630.0
2015-09-04 12:00:00	MSFT	Stock	42.6	42.61	42.37	42.45	2028334.0
2015-09-04 12:30:00	MSFT	Stock	42.44	42.51	42.35	42.425	1254458.0
2015-09-04 13:00:00	MSFT	Stock	42.43	42.45	42.32	42.43	1508731.0
2015-09-04 13:30:00	MSFT	Stock	42.428	42.52	42.335	42.34	1798117.0
2015-09-04 14:00:00	MSFT	Stock	42.34	42.36	42.195	42.31	1771224.0

> showing 50 of 79,950 rows — these rows as CSV

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