PREVIEW / stock_30min / 2016-12-20

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-20.parquet
  size:    1.6 MB
  rows:    83,079
  symbols: 3,170

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-12-20 04:30:00	AAPL	Stock	29.125	29.125	29.1175	29.1175	800.0
2016-12-20 05:00:00	AAPL	Stock	29.0775	29.0775	29.0675	29.0675	1252.0
2016-12-20 05:30:00	AAPL	Stock	29.11	29.11	29.11	29.11	400.0
2016-12-20 06:00:00	AAPL	Stock	29.095	29.095	29.09	29.09	5112.0
2016-12-20 06:30:00	AAPL	Stock	29.0925	29.125	29.09	29.125	11548.0
2016-12-20 07:00:00	AAPL	Stock	29.16	29.1975	29.16	29.16	23156.0
2016-12-20 07:30:00	AAPL	Stock	29.175	29.175	29.145	29.155	15064.0
2016-12-20 08:00:00	AAPL	Stock	29.1625	29.2275	29.125	29.2025	209044.0
2016-12-20 08:30:00	AAPL	Stock	29.2	29.225	29.1875	29.225	50484.0
2016-12-20 09:00:00	AAPL	Stock	29.235	29.245	29.1825	29.1825	191984.0
2016-12-20 09:30:00	AAPL	Stock	29.195	29.375	29.17	29.2975	14199160.0
2016-12-20 10:00:00	AAPL	Stock	29.3	29.3012	29.215	29.2588	6497956.0
2016-12-20 10:30:00	AAPL	Stock	29.2575	29.295	29.2175	29.2812	4722684.0
2016-12-20 11:00:00	AAPL	Stock	29.28	29.295	29.235	29.2795	4326736.0
2016-12-20 11:30:00	AAPL	Stock	29.2775	29.2775	29.22	29.2405	3210792.0
2016-12-20 12:00:00	AAPL	Stock	29.2412	29.275	29.2275	29.255	2877760.0
2016-12-20 12:30:00	AAPL	Stock	29.255	29.275	29.2512	29.27	2382164.0
2016-12-20 13:00:00	AAPL	Stock	29.27	29.285	29.2625	29.2625	2340688.0
2016-12-20 13:30:00	AAPL	Stock	29.2625	29.2875	29.2475	29.2775	3648700.0
2016-12-20 14:00:00	AAPL	Stock	29.2775	29.2775	29.235	29.24	2642592.0
2016-12-20 14:30:00	AAPL	Stock	29.2395	29.245	29.18	29.2075	3397280.0
2016-12-20 15:00:00	AAPL	Stock	29.2075	29.2475	29.1925	29.2385	3616128.0
2016-12-20 15:30:00	AAPL	Stock	29.24	29.26	29.2125	29.2375	5971884.0
2016-12-20 16:00:00	AAPL	Stock	29.2375	29.2525	29.2125	29.2525	14429292.0
2016-12-20 16:30:00	AAPL	Stock	29.2225	29.225	29.2175	29.225	32840.0
2016-12-20 17:00:00	AAPL	Stock	29.2175	29.225	29.2175	29.22	60536.0
2016-12-20 17:30:00	AAPL	Stock	29.2175	29.225	29.215	29.225	20000.0
2016-12-20 18:00:00	AAPL	Stock	29.22	29.225	29.22	29.225	11924.0
2016-12-20 18:30:00	AAPL	Stock	29.225	29.225	29.2175	29.2175	10436.0
2016-12-20 19:00:00	AAPL	Stock	29.215	29.2175	29.215	29.2175	4600.0
2016-12-20 19:30:00	AAPL	Stock	29.225	29.25	29.215	29.24	22644.0
2016-12-20 06:30:00	MSFT	Stock	63.54	63.6	63.54	63.6	400.0
2016-12-20 07:00:00	MSFT	Stock	63.65	63.75	63.65	63.75	1211.0
2016-12-20 08:00:00	MSFT	Stock	63.68	63.78	63.62	63.62	53217.0
2016-12-20 08:30:00	MSFT	Stock	63.77	63.8	63.73	63.8	5211.0
2016-12-20 09:00:00	MSFT	Stock	63.89	63.89	63.65	63.66	20398.0
2016-12-20 09:30:00	MSFT	Stock	63.69	63.8	63.52	63.73	2746695.0
2016-12-20 10:00:00	MSFT	Stock	63.73	63.76	63.43	63.464	1568829.0
2016-12-20 10:30:00	MSFT	Stock	63.465	63.596	63.43	63.494	1764485.0
2016-12-20 11:00:00	MSFT	Stock	63.5	63.51	63.11	63.11	2558606.0
2016-12-20 11:30:00	MSFT	Stock	63.11	63.2	63.025	63.2	1610048.0
2016-12-20 12:00:00	MSFT	Stock	63.2	63.396	63.15	63.375	1611368.0
2016-12-20 12:30:00	MSFT	Stock	63.375	63.52	63.35	63.5	873411.0
2016-12-20 13:00:00	MSFT	Stock	63.496	63.6	63.463	63.5	863458.0
2016-12-20 13:30:00	MSFT	Stock	63.5	63.54	63.43	63.51	520775.0
2016-12-20 14:00:00	MSFT	Stock	63.51	63.52	63.43	63.465	597728.0
2016-12-20 14:30:00	MSFT	Stock	63.47	63.48	63.335	63.4	769944.0
2016-12-20 15:00:00	MSFT	Stock	63.4	63.51	63.38	63.505	956338.0
2016-12-20 15:30:00	MSFT	Stock	63.505	63.57	63.48	63.54	1547849.0
2016-12-20 16:00:00	MSFT	Stock	63.54	63.55	63.52	63.55	5649403.0

> showing 50 of 83,079 rows — these rows as CSV

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