PREVIEW / stock_30min / 2016-09-29

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-29.parquet
  size:    1.6 MB
  rows:    80,584
  symbols: 3,212

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-09-29 04:00:00	AAPL	Stock	28.4625	28.4625	28.425	28.425	3888.0
2016-09-29 04:30:00	AAPL	Stock	28.4	28.4	28.4	28.4	1372.0
2016-09-29 05:00:00	AAPL	Stock	28.3875	28.3875	28.375	28.375	880.0
2016-09-29 05:30:00	AAPL	Stock	28.3775	28.3775	28.3625	28.375	2424.0
2016-09-29 06:00:00	AAPL	Stock	28.4125	28.4125	28.35	28.35	18680.0
2016-09-29 06:30:00	AAPL	Stock	28.35	28.35	28.275	28.2875	54872.0
2016-09-29 07:00:00	AAPL	Stock	28.2775	28.3125	28.2525	28.3	63936.0
2016-09-29 07:30:00	AAPL	Stock	28.295	28.33	28.295	28.32	120180.0
2016-09-29 08:00:00	AAPL	Stock	28.335	28.425	28.28	28.2875	419300.0
2016-09-29 08:30:00	AAPL	Stock	28.2875	28.3375	28.2875	28.315	91912.0
2016-09-29 09:00:00	AAPL	Stock	28.3275	28.3375	28.2875	28.2875	91696.0
2016-09-29 09:30:00	AAPL	Stock	28.3	28.45	28.255	28.285	13654492.0
2016-09-29 10:00:00	AAPL	Stock	28.2825	28.3	28.115	28.22	19234780.0
2016-09-29 10:30:00	AAPL	Stock	28.22	28.22	28.11	28.1135	9868660.0
2016-09-29 11:00:00	AAPL	Stock	28.115	28.1725	28.05	28.085	10025556.0
2016-09-29 11:30:00	AAPL	Stock	28.085	28.155	28.08	28.1548	5496172.0
2016-09-29 12:00:00	AAPL	Stock	28.155	28.26	28.1375	28.2275	6319812.0
2016-09-29 12:30:00	AAPL	Stock	28.225	28.2425	28.0375	28.0925	9349456.0
2016-09-29 13:00:00	AAPL	Stock	28.09	28.09	28.0125	28.0522	8834268.0
2016-09-29 13:30:00	AAPL	Stock	28.05	28.07	27.95	28.0	9205536.0
2016-09-29 14:00:00	AAPL	Stock	28.0	28.0912	27.9775	28.0775	6830952.0
2016-09-29 14:30:00	AAPL	Stock	28.0775	28.1	28.0375	28.045	7773696.0
2016-09-29 15:00:00	AAPL	Stock	28.0425	28.14	28.025	28.1325	8598456.0
2016-09-29 15:30:00	AAPL	Stock	28.1315	28.1525	28.03	28.045	13020972.0
2016-09-29 16:00:00	AAPL	Stock	28.045	28.195	28.04	28.055	5562048.0
2016-09-29 16:30:00	AAPL	Stock	28.055	28.065	28.045	28.0575	510624.0
2016-09-29 17:00:00	AAPL	Stock	28.065	28.065	28.055	28.0575	43628.0
2016-09-29 17:30:00	AAPL	Stock	28.055	28.0575	28.05	28.05	19004.0
2016-09-29 18:00:00	AAPL	Stock	28.0525	28.0525	28.0375	28.0375	42348.0
2016-09-29 18:30:00	AAPL	Stock	28.035	28.05	28.035	28.0375	6996.0
2016-09-29 19:00:00	AAPL	Stock	28.045	28.0525	28.04	28.0525	11628.0
2016-09-29 19:30:00	AAPL	Stock	28.0525	28.0525	28.035	28.0475	18752.0
2016-09-29 07:30:00	MSFT	Stock	58.0	58.0	57.97	57.97	200.0
2016-09-29 08:00:00	MSFT	Stock	57.98	57.98	57.96	57.96	700.0
2016-09-29 09:00:00	MSFT	Stock	57.94	57.94	57.84	57.84	26221.0
2016-09-29 09:30:00	MSFT	Stock	57.83	58.12	57.81	58.07	2005162.0
2016-09-29 10:00:00	MSFT	Stock	58.08	58.168	57.81	58.03	2281800.0
2016-09-29 10:30:00	MSFT	Stock	58.03	58.045	57.9	57.965	906642.0
2016-09-29 11:00:00	MSFT	Stock	57.965	58.06	57.92	58.05	1412954.0
2016-09-29 11:30:00	MSFT	Stock	58.04	58.07	57.96	58.0	926699.0
2016-09-29 12:00:00	MSFT	Stock	57.995	58.09	57.96	58.02	760087.0
2016-09-29 12:30:00	MSFT	Stock	58.02	58.024	57.42	57.48	2315284.0
2016-09-29 13:00:00	MSFT	Stock	57.47	57.52	57.3	57.46	2777775.0
2016-09-29 13:30:00	MSFT	Stock	57.46	57.47	57.21	57.32	1449365.0
2016-09-29 14:00:00	MSFT	Stock	57.32	57.58	57.22	57.575	1445088.0
2016-09-29 14:30:00	MSFT	Stock	57.57	57.73	57.555	57.62	1022016.0
2016-09-29 15:00:00	MSFT	Stock	57.62	57.65	57.445	57.602	1404534.0
2016-09-29 15:30:00	MSFT	Stock	57.6	57.69	57.39	57.4	3090730.0
2016-09-29 16:00:00	MSFT	Stock	57.4	57.8	57.39	57.4	2059493.0
2016-09-29 16:30:00	MSFT	Stock	57.46	57.47	57.4	57.4	197638.0

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

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