PREVIEW / stock_30min / 2017-01-19

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-19.parquet
  size:    1.6 MB
  rows:    81,451
  symbols: 3,113

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-01-19 05:30:00	AAPL	Stock	29.9775	29.9775	29.9625	29.9625	10148.0
2017-01-19 06:00:00	AAPL	Stock	30.0	30.0625	30.0	30.0625	30336.0
2017-01-19 06:30:00	AAPL	Stock	30.0425	30.0625	29.9925	30.0125	57992.0
2017-01-19 07:00:00	AAPL	Stock	30.0125	30.0125	29.9275	29.95	76400.0
2017-01-19 07:30:00	AAPL	Stock	29.95	29.9675	29.9325	29.9375	36216.0
2017-01-19 08:00:00	AAPL	Stock	29.98	29.98	29.875	29.9125	306556.0
2017-01-19 08:30:00	AAPL	Stock	29.9	29.9325	29.8775	29.9	157172.0
2017-01-19 09:00:00	AAPL	Stock	29.905	29.9075	29.78	29.85	610964.0
2017-01-19 09:30:00	AAPL	Stock	29.85	30.0125	29.8425	30.005	15546144.0
2017-01-19 10:00:00	AAPL	Stock	30.005	30.0125	29.9075	29.94	6707856.0
2017-01-19 10:30:00	AAPL	Stock	29.94	29.9775	29.925	29.9625	3885972.0
2017-01-19 11:00:00	AAPL	Stock	29.9625	30.01	29.9275	30.005	5037308.0
2017-01-19 11:30:00	AAPL	Stock	30.0025	30.0225	29.9775	30.0025	4653744.0
2017-01-19 12:00:00	AAPL	Stock	30.0025	30.0075	29.965	29.9925	5678200.0
2017-01-19 12:30:00	AAPL	Stock	29.995	30.0	29.945	29.96	3392064.0
2017-01-19 13:00:00	AAPL	Stock	29.96	29.9625	29.93	29.935	2519344.0
2017-01-19 13:30:00	AAPL	Stock	29.935	29.9542	29.92	29.95	2540848.0
2017-01-19 14:00:00	AAPL	Stock	29.95	29.9725	29.8775	29.9225	4461728.0
2017-01-19 14:30:00	AAPL	Stock	29.9225	29.935	29.8862	29.893	3481544.0
2017-01-19 15:00:00	AAPL	Stock	29.895	29.9375	29.88	29.92	4404712.0
2017-01-19 15:30:00	AAPL	Stock	29.921	29.9475	29.895	29.9425	10801980.0
2017-01-19 16:00:00	AAPL	Stock	29.9425	30.0325	29.9175	29.945	10715784.0
2017-01-19 16:30:00	AAPL	Stock	29.985	29.985	29.945	29.97	988692.0
2017-01-19 17:00:00	AAPL	Stock	29.97	29.97	29.93	29.9375	44340.0
2017-01-19 17:30:00	AAPL	Stock	29.94	29.945	29.9325	29.9325	7876.0
2017-01-19 18:00:00	AAPL	Stock	29.9425	29.955	29.94	29.94	68500.0
2017-01-19 18:30:00	AAPL	Stock	29.9575	29.9625	29.945	29.9625	9700.0
2017-01-19 19:00:00	AAPL	Stock	29.96	29.96	29.95	29.9525	4672.0
2017-01-19 19:30:00	AAPL	Stock	29.96	29.9675	29.955	29.9575	16516.0
2017-01-19 07:00:00	MSFT	Stock	62.5	62.5	62.5	62.5	620.0
2017-01-19 07:30:00	MSFT	Stock	62.5	62.5	62.5	62.5	159.0
2017-01-19 08:00:00	MSFT	Stock	62.5	62.5	62.31	62.31	341.0
2017-01-19 09:00:00	MSFT	Stock	62.29	62.29	62.21	62.22	9756.0
2017-01-19 09:30:00	MSFT	Stock	62.31	62.98	62.23	62.91	2756442.0
2017-01-19 10:00:00	MSFT	Stock	62.915	62.945	62.57	62.636	1501447.0
2017-01-19 10:30:00	MSFT	Stock	62.635	62.655	62.5	62.555	918410.0
2017-01-19 11:00:00	MSFT	Stock	62.55	62.59	62.405	62.59	954585.0
2017-01-19 11:30:00	MSFT	Stock	62.59	62.615	62.53	62.545	549427.0
2017-01-19 12:00:00	MSFT	Stock	62.54	62.58	62.445	62.56	703645.0
2017-01-19 12:30:00	MSFT	Stock	62.565	62.57	62.473	62.515	426654.0
2017-01-19 13:00:00	MSFT	Stock	62.515	62.57	62.36	62.36	769393.0
2017-01-19 13:30:00	MSFT	Stock	62.36	62.46	62.36	62.395	729188.0
2017-01-19 14:00:00	MSFT	Stock	62.395	62.41	62.23	62.32	1174282.0
2017-01-19 14:30:00	MSFT	Stock	62.32	62.325	62.205	62.21	948106.0
2017-01-19 15:00:00	MSFT	Stock	62.213	62.36	62.195	62.35	1227427.0
2017-01-19 15:30:00	MSFT	Stock	62.35	62.39	62.26	62.29	2209648.0
2017-01-19 16:00:00	MSFT	Stock	62.3	62.49	62.25	62.3	2153599.0
2017-01-19 16:30:00	MSFT	Stock	62.33	62.45	62.21	62.21	1814.0
2017-01-19 17:00:00	MSFT	Stock	62.4	62.42	62.4	62.42	1000.0
2017-01-19 18:00:00	MSFT	Stock	62.35	62.35	62.35	62.35	100.0

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

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