PREVIEW / stock_30min / 2017-04-20

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-20.parquet
  size:    1.6 MB
  rows:    81,377
  symbols: 3,062

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
2017-04-20 04:00:00	AAPL	Stock	35.25	35.3	35.25	35.3	8700.0
2017-04-20 04:30:00	AAPL	Stock	35.2975	35.35	35.2975	35.35	12024.0
2017-04-20 05:00:00	AAPL	Stock	35.345	35.35	35.345	35.35	6400.0
2017-04-20 05:30:00	AAPL	Stock	35.325	35.345	35.325	35.345	6668.0
2017-04-20 06:00:00	AAPL	Stock	35.3425	35.3425	35.3425	35.3425	408.0
2017-04-20 06:30:00	AAPL	Stock	35.3	35.3	35.3	35.3	7752.0
2017-04-20 07:00:00	AAPL	Stock	35.3125	35.325	35.2825	35.305	20616.0
2017-04-20 07:30:00	AAPL	Stock	35.335	35.345	35.3225	35.325	16680.0
2017-04-20 08:00:00	AAPL	Stock	35.325	35.3325	35.3025	35.3225	50416.0
2017-04-20 08:30:00	AAPL	Stock	35.3175	35.3325	35.2875	35.315	37048.0
2017-04-20 09:00:00	AAPL	Stock	35.305	35.3125	35.275	35.3	94340.0
2017-04-20 09:30:00	AAPL	Stock	35.3025	35.45	35.29	35.4052	12276596.0
2017-04-20 10:00:00	AAPL	Stock	35.4068	35.475	35.406	35.445	5768740.0
2017-04-20 10:30:00	AAPL	Stock	35.4462	35.47	35.3875	35.4525	4502896.0
2017-04-20 11:00:00	AAPL	Stock	35.455	35.5	35.43	35.493	4437856.0
2017-04-20 11:30:00	AAPL	Stock	35.4942	35.575	35.4675	35.575	5852724.0
2017-04-20 12:00:00	AAPL	Stock	35.5775	35.685	35.57	35.6725	6498472.0
2017-04-20 12:30:00	AAPL	Stock	35.675	35.73	35.66	35.6925	5349148.0
2017-04-20 13:00:00	AAPL	Stock	35.695	35.725	35.6175	35.6675	4812120.0
2017-04-20 13:30:00	AAPL	Stock	35.6688	35.7275	35.6525	35.71	3820596.0
2017-04-20 14:00:00	AAPL	Stock	35.7088	35.7275	35.6652	35.67	3879204.0
2017-04-20 14:30:00	AAPL	Stock	35.6718	35.71	35.6575	35.695	3465756.0
2017-04-20 15:00:00	AAPL	Stock	35.695	35.695	35.6588	35.6875	4024016.0
2017-04-20 15:30:00	AAPL	Stock	35.685	35.72	35.5975	35.61	11903192.0
2017-04-20 16:00:00	AAPL	Stock	35.61	35.6725	35.6025	35.615	9031356.0
2017-04-20 16:30:00	AAPL	Stock	35.615	35.615	35.6075	35.6125	155764.0
2017-04-20 17:00:00	AAPL	Stock	35.6025	35.6125	35.6	35.6025	9452.0
2017-04-20 17:30:00	AAPL	Stock	35.59	35.6025	35.5825	35.5875	21832.0
2017-04-20 18:00:00	AAPL	Stock	35.6025	35.61	35.6025	35.61	21360.0
2017-04-20 18:30:00	AAPL	Stock	35.6	35.6125	35.6	35.6125	3756.0
2017-04-20 19:00:00	AAPL	Stock	35.6025	35.62	35.6	35.62	7336.0
2017-04-20 19:30:00	AAPL	Stock	35.6175	35.625	35.605	35.605	32340.0
2017-04-20 05:00:00	MSFT	Stock	65.56	65.56	65.56	65.56	365.0
2017-04-20 08:00:00	MSFT	Stock	65.27	65.27	65.27	65.27	900.0
2017-04-20 08:30:00	MSFT	Stock	65.28	65.28	65.27	65.28	600.0
2017-04-20 09:00:00	MSFT	Stock	65.28	65.35	65.28	65.3	3505.0
2017-04-20 09:30:00	MSFT	Stock	65.36	65.46	65.16	65.365	2272179.0
2017-04-20 10:00:00	MSFT	Stock	65.365	65.535	65.305	65.36	1617980.0
2017-04-20 10:30:00	MSFT	Stock	65.356	65.4	65.21	65.3	1168485.0
2017-04-20 11:00:00	MSFT	Stock	65.3	65.33	65.23	65.23	765857.0
2017-04-20 11:30:00	MSFT	Stock	65.24	65.26	65.14	65.22	1189945.0
2017-04-20 12:00:00	MSFT	Stock	65.215	65.35	65.2	65.32	1315147.0
2017-04-20 12:30:00	MSFT	Stock	65.325	65.53	65.31	65.47	1026110.0
2017-04-20 13:00:00	MSFT	Stock	65.475	65.53	65.42	65.5	725223.0
2017-04-20 13:30:00	MSFT	Stock	65.505	65.67	65.5	65.63	1063533.0
2017-04-20 14:00:00	MSFT	Stock	65.63	65.66	65.55	65.63	961683.0
2017-04-20 14:30:00	MSFT	Stock	65.635	65.66	65.525	65.575	1052490.0
2017-04-20 15:00:00	MSFT	Stock	65.575	65.59	65.505	65.59	1126207.0
2017-04-20 15:30:00	MSFT	Stock	65.585	65.75	65.49	65.5	3944295.0
2017-04-20 16:00:00	MSFT	Stock	65.5	65.54	65.48	65.54	2180011.0

> showing 50 of 81,377 rows — these rows as CSV

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