PREVIEW / stock_30min / 2016-10-03

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-03.parquet
  size:    1.6 MB
  rows:    80,045
  symbols: 3,218

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
2016-10-03 05:00:00	AAPL	Stock	28.2425	28.2425	28.2425	28.2425	1996.0
2016-10-03 06:00:00	AAPL	Stock	28.2425	28.2425	28.2425	28.2425	400.0
2016-10-03 06:30:00	AAPL	Stock	28.2425	28.2425	28.24	28.24	4000.0
2016-10-03 07:00:00	AAPL	Stock	28.245	28.3225	28.2375	28.3075	18696.0
2016-10-03 07:30:00	AAPL	Stock	28.3075	28.325	28.3075	28.3175	14248.0
2016-10-03 08:00:00	AAPL	Stock	28.3	28.3	28.2225	28.2575	119212.0
2016-10-03 08:30:00	AAPL	Stock	28.26	28.2625	28.2	28.2025	87220.0
2016-10-03 09:00:00	AAPL	Stock	28.2025	28.23	28.18	28.19	155008.0
2016-10-03 09:30:00	AAPL	Stock	28.1775	28.2548	28.0825	28.1225	12684468.0
2016-10-03 10:00:00	AAPL	Stock	28.1225	28.174	28.105	28.12	6053164.0
2016-10-03 10:30:00	AAPL	Stock	28.12	28.2625	28.115	28.2375	6377948.0
2016-10-03 11:00:00	AAPL	Stock	28.2375	28.25	28.2075	28.2175	3170484.0
2016-10-03 11:30:00	AAPL	Stock	28.22	28.225	28.115	28.1385	3999636.0
2016-10-03 12:00:00	AAPL	Stock	28.1375	28.1975	28.135	28.17	3431316.0
2016-10-03 12:30:00	AAPL	Stock	28.1725	28.173	28.13	28.155	3943000.0
2016-10-03 13:00:00	AAPL	Stock	28.1525	28.16	28.1125	28.14	3486160.0
2016-10-03 13:30:00	AAPL	Stock	28.14	28.1525	28.09	28.0925	4133064.0
2016-10-03 14:00:00	AAPL	Stock	28.0912	28.1512	28.085	28.13	4482792.0
2016-10-03 14:30:00	AAPL	Stock	28.1275	28.1318	28.07	28.1022	5022456.0
2016-10-03 15:00:00	AAPL	Stock	28.1022	28.1325	28.0988	28.1275	4785556.0
2016-10-03 15:30:00	AAPL	Stock	28.13	28.175	28.11	28.1275	10065128.0
2016-10-03 16:00:00	AAPL	Stock	28.13	28.175	28.12	28.135	7798168.0
2016-10-03 16:30:00	AAPL	Stock	28.1375	28.15	28.1325	28.15	8300.0
2016-10-03 17:00:00	AAPL	Stock	28.15	28.15	28.14	28.14	7404.0
2016-10-03 17:30:00	AAPL	Stock	28.1525	28.1525	28.13	28.15	222660.0
2016-10-03 18:00:00	AAPL	Stock	28.1475	28.1525	28.145	28.15	9000.0
2016-10-03 18:30:00	AAPL	Stock	28.145	28.145	28.1375	28.1375	6692.0
2016-10-03 19:00:00	AAPL	Stock	28.1375	28.14	28.1375	28.14	1600.0
2016-10-03 19:30:00	AAPL	Stock	28.15	28.17	28.145	28.1575	25080.0
2016-10-03 07:00:00	MSFT	Stock	57.86	57.86	57.68	57.7	1100.0
2016-10-03 07:30:00	MSFT	Stock	57.7	57.78	57.7	57.78	2500.0
2016-10-03 08:00:00	MSFT	Stock	57.6	57.63	57.5	57.56	4231.0
2016-10-03 08:30:00	MSFT	Stock	57.6	57.6	57.5	57.5	7325.0
2016-10-03 09:00:00	MSFT	Stock	57.45	57.45	57.4	57.41	1940.0
2016-10-03 09:30:00	MSFT	Stock	57.405	57.55	57.06	57.17	2632265.0
2016-10-03 10:00:00	MSFT	Stock	57.17	57.325	57.15	57.245	1846301.0
2016-10-03 10:30:00	MSFT	Stock	57.24	57.435	57.23	57.38	1232035.0
2016-10-03 11:00:00	MSFT	Stock	57.38	57.405	57.28	57.36	1159158.0
2016-10-03 11:30:00	MSFT	Stock	57.36	57.36	57.18	57.306	921264.0
2016-10-03 12:00:00	MSFT	Stock	57.3	57.33	57.2	57.23	871164.0
2016-10-03 12:30:00	MSFT	Stock	57.22	57.314	57.17	57.31	892822.0
2016-10-03 13:00:00	MSFT	Stock	57.31	57.38	57.27	57.36	756907.0
2016-10-03 13:30:00	MSFT	Stock	57.354	57.395	57.33	57.38	656015.0
2016-10-03 14:00:00	MSFT	Stock	57.383	57.485	57.37	57.41	783432.0
2016-10-03 14:30:00	MSFT	Stock	57.42	57.46	57.29	57.365	841887.0
2016-10-03 15:00:00	MSFT	Stock	57.36	57.415	57.34	57.37	1043851.0
2016-10-03 15:30:00	MSFT	Stock	57.375	57.48	57.36	57.41	2710632.0
2016-10-03 16:00:00	MSFT	Stock	57.42	57.42	57.3	57.42	1732663.0
2016-10-03 16:30:00	MSFT	Stock	57.48	57.49	57.48	57.49	3000.0
2016-10-03 17:00:00	MSFT	Stock	57.42	57.42	57.42	57.42	100.0

> showing 50 of 80,045 rows — these rows as CSV

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