PREVIEW / stock_30min / 2017-10-03

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-03.parquet
  size:    1.6 MB
  rows:    82,250
  symbols: 2,977

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-10-03 04:00:00	AAPL	Stock	38.4425	38.4425	38.4425	38.4425	3200.0
2017-10-03 05:30:00	AAPL	Stock	38.4625	38.4625	38.4625	38.4625	400.0
2017-10-03 07:00:00	AAPL	Stock	38.4625	38.4625	38.4375	38.4625	46732.0
2017-10-03 07:30:00	AAPL	Stock	38.45	38.45	38.4425	38.445	8000.0
2017-10-03 08:00:00	AAPL	Stock	38.4425	38.505	38.44	38.49	57132.0
2017-10-03 08:30:00	AAPL	Stock	38.4925	38.4925	38.4525	38.4725	35248.0
2017-10-03 09:00:00	AAPL	Stock	38.47	38.5025	38.465	38.5	74944.0
2017-10-03 09:30:00	AAPL	Stock	38.4825	38.755	38.4775	38.578	11480248.0
2017-10-03 10:00:00	AAPL	Stock	38.5795	38.65	38.5088	38.54	5923592.0
2017-10-03 10:30:00	AAPL	Stock	38.548	38.65	38.54	38.6028	3456796.0
2017-10-03 11:00:00	AAPL	Stock	38.6	38.6625	38.5825	38.6525	3381952.0
2017-10-03 11:30:00	AAPL	Stock	38.652	38.6825	38.6062	38.67	2850440.0
2017-10-03 12:00:00	AAPL	Stock	38.67	38.7725	38.67	38.7065	5045872.0
2017-10-03 12:30:00	AAPL	Stock	38.7075	38.7125	38.65	38.6785	2595552.0
2017-10-03 13:00:00	AAPL	Stock	38.6788	38.6838	38.6287	38.6525	2125188.0
2017-10-03 13:30:00	AAPL	Stock	38.6538	38.6875	38.64	38.685	1698932.0
2017-10-03 14:00:00	AAPL	Stock	38.6862	38.7385	38.6838	38.72	2594824.0
2017-10-03 14:30:00	AAPL	Stock	38.72	38.73	38.66	38.685	2302936.0
2017-10-03 15:00:00	AAPL	Stock	38.6872	38.6888	38.6052	38.6275	3202732.0
2017-10-03 15:30:00	AAPL	Stock	38.6287	38.6575	38.5775	38.6175	7963652.0
2017-10-03 16:00:00	AAPL	Stock	38.62	38.625	38.5975	38.62	3765132.0
2017-10-03 16:30:00	AAPL	Stock	38.6325	38.6375	38.6325	38.6325	9736.0
2017-10-03 17:00:00	AAPL	Stock	38.6325	38.6425	38.6325	38.6425	18032.0
2017-10-03 17:30:00	AAPL	Stock	38.6325	38.6425	38.6275	38.6275	12840.0
2017-10-03 18:00:00	AAPL	Stock	38.6425	38.6425	38.625	38.625	7528.0
2017-10-03 18:30:00	AAPL	Stock	38.6275	38.6275	38.625	38.625	1268.0
2017-10-03 19:00:00	AAPL	Stock	38.625	38.625	38.625	38.625	3600.0
2017-10-03 19:30:00	AAPL	Stock	38.625	38.625	38.625	38.625	14000.0
2017-10-03 04:00:00	MSFT	Stock	74.74	74.74	74.74	74.74	200.0
2017-10-03 07:30:00	MSFT	Stock	74.61	74.61	74.61	74.61	100.0
2017-10-03 08:00:00	MSFT	Stock	74.73	74.73	74.73	74.73	200.0
2017-10-03 08:30:00	MSFT	Stock	74.59	74.7	74.58	74.69	1538.0
2017-10-03 09:00:00	MSFT	Stock	74.6	74.6	74.48	74.55	10753.0
2017-10-03 09:30:00	MSFT	Stock	74.67	74.88	74.46	74.81	1140040.0
2017-10-03 10:00:00	MSFT	Stock	74.82	74.85	74.52	74.53	705954.0
2017-10-03 10:30:00	MSFT	Stock	74.52	74.67	74.46	74.61	670634.0
2017-10-03 11:00:00	MSFT	Stock	74.61	74.63	74.45	74.51	506611.0
2017-10-03 11:30:00	MSFT	Stock	74.51	74.593	74.41	74.41	440559.0
2017-10-03 12:00:00	MSFT	Stock	74.41	74.42	74.33	74.33	447375.0
2017-10-03 12:30:00	MSFT	Stock	74.33	74.4	74.31	74.354	417740.0
2017-10-03 13:00:00	MSFT	Stock	74.35	74.41	74.33	74.34	461143.0
2017-10-03 13:30:00	MSFT	Stock	74.344	74.37	74.23	74.243	672314.0
2017-10-03 14:00:00	MSFT	Stock	74.25	74.345	74.24	74.28	533595.0
2017-10-03 14:30:00	MSFT	Stock	74.285	74.31	74.23	74.23	622372.0
2017-10-03 15:00:00	MSFT	Stock	74.231	74.27	74.195	74.255	748748.0
2017-10-03 15:30:00	MSFT	Stock	74.255	74.345	74.2	74.27	2277750.0
2017-10-03 16:00:00	MSFT	Stock	74.26	74.26	74.25	74.26	1161378.0
2017-10-03 16:30:00	MSFT	Stock	74.26	74.34	74.26	74.34	185600.0
2017-10-03 17:00:00	MSFT	Stock	74.29	74.29	74.29	74.29	340.0
2017-10-03 18:00:00	MSFT	Stock	74.29	74.29	74.26	74.29	3220.0

> showing 50 of 82,250 rows — these rows as CSV

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