PREVIEW / stock_30min / 2016-10-17

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-17.parquet
  size:    1.5 MB
  rows:    79,343
  symbols: 3,184

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-17 04:00:00	AAPL	Stock	29.3775	29.5	29.31	29.3175	8616.0
2016-10-17 05:00:00	AAPL	Stock	29.3	29.325	29.3	29.325	20896.0
2016-10-17 05:30:00	AAPL	Stock	29.3	29.3	29.3	29.3	1984.0
2016-10-17 06:00:00	AAPL	Stock	29.3	29.3	29.3	29.3	400.0
2016-10-17 06:30:00	AAPL	Stock	29.3375	29.3375	29.3275	29.3375	5600.0
2016-10-17 07:00:00	AAPL	Stock	29.3375	29.425	29.3375	29.425	32688.0
2016-10-17 07:30:00	AAPL	Stock	29.43	29.43	29.4075	29.4125	8612.0
2016-10-17 08:00:00	AAPL	Stock	29.4125	29.475	29.3475	29.45	133128.0
2016-10-17 08:30:00	AAPL	Stock	29.4575	29.4575	29.42	29.44	51576.0
2016-10-17 09:00:00	AAPL	Stock	29.4375	29.4875	29.3325	29.3325	393716.0
2016-10-17 09:30:00	AAPL	Stock	29.335	29.46	29.2125	29.2288	17918836.0
2016-10-17 10:00:00	AAPL	Stock	29.23	29.345	29.195	29.336	8770196.0
2016-10-17 10:30:00	AAPL	Stock	29.3375	29.365	29.305	29.3312	5071308.0
2016-10-17 11:00:00	AAPL	Stock	29.3325	29.39	29.25	29.2725	5529896.0
2016-10-17 11:30:00	AAPL	Stock	29.2725	29.34	29.2575	29.3175	5179664.0
2016-10-17 12:00:00	AAPL	Stock	29.3175	29.3275	29.2775	29.2825	3723572.0
2016-10-17 12:30:00	AAPL	Stock	29.2835	29.3025	29.2375	29.24	3790540.0
2016-10-17 13:00:00	AAPL	Stock	29.24	29.2675	29.2332	29.2518	3243420.0
2016-10-17 13:30:00	AAPL	Stock	29.2525	29.3	29.24	29.25	3952544.0
2016-10-17 14:00:00	AAPL	Stock	29.25	29.2985	29.2475	29.295	3335588.0
2016-10-17 14:30:00	AAPL	Stock	29.2925	29.3325	29.2725	29.3275	3928208.0
2016-10-17 15:00:00	AAPL	Stock	29.33	29.3725	29.3175	29.37	5763676.0
2016-10-17 15:30:00	AAPL	Stock	29.3712	29.3915	29.3588	29.3875	9058624.0
2016-10-17 16:00:00	AAPL	Stock	29.3875	29.435	29.277	29.425	8060984.0
2016-10-17 16:30:00	AAPL	Stock	29.425	29.4375	29.3875	29.425	96540.0
2016-10-17 17:00:00	AAPL	Stock	29.4275	29.4375	29.4125	29.415	51892.0
2016-10-17 17:30:00	AAPL	Stock	29.3875	29.435	29.3875	29.435	62616.0
2016-10-17 18:00:00	AAPL	Stock	29.4375	29.45	29.42	29.4425	20160.0
2016-10-17 18:30:00	AAPL	Stock	29.4425	29.445	29.425	29.445	18800.0
2016-10-17 19:00:00	AAPL	Stock	29.445	29.45	29.425	29.45	11680.0
2016-10-17 19:30:00	AAPL	Stock	29.445	29.4475	29.425	29.4475	12540.0
2016-10-17 04:00:00	MSFT	Stock	57.41	57.41	57.41	57.41	200.0
2016-10-17 05:00:00	MSFT	Stock	57.27	57.27	57.27	57.27	200.0
2016-10-17 07:00:00	MSFT	Stock	57.34	57.35	57.34	57.35	1880.0
2016-10-17 07:30:00	MSFT	Stock	57.35	57.35	57.35	57.35	100.0
2016-10-17 08:00:00	MSFT	Stock	57.42	57.42	57.42	57.42	1370.0
2016-10-17 09:00:00	MSFT	Stock	57.45	57.46	57.35	57.35	12102.0
2016-10-17 09:30:00	MSFT	Stock	57.36	57.46	56.9	56.94	4216577.0
2016-10-17 10:00:00	MSFT	Stock	56.94	57.165	56.87	57.14	2693055.0
2016-10-17 10:30:00	MSFT	Stock	57.14	57.2	57.05	57.145	1325185.0
2016-10-17 11:00:00	MSFT	Stock	57.145	57.23	57.07	57.09	1475028.0
2016-10-17 11:30:00	MSFT	Stock	57.1	57.205	57.04	57.145	865638.0
2016-10-17 12:00:00	MSFT	Stock	57.15	57.205	57.09	57.115	695456.0
2016-10-17 12:30:00	MSFT	Stock	57.11	57.18	57.07	57.11	648513.0
2016-10-17 13:00:00	MSFT	Stock	57.11	57.18	57.064	57.11	659282.0
2016-10-17 13:30:00	MSFT	Stock	57.115	57.139	57.07	57.11	812363.0
2016-10-17 14:00:00	MSFT	Stock	57.11	57.25	57.095	57.25	809546.0
2016-10-17 14:30:00	MSFT	Stock	57.245	57.27	57.185	57.225	786163.0
2016-10-17 15:00:00	MSFT	Stock	57.23	57.34	57.21	57.262	994002.0
2016-10-17 15:30:00	MSFT	Stock	57.265	57.29	57.17	57.21	2305567.0

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

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