PREVIEW / stock_30min / 2018-01-29

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-29.parquet
  size:    1.7 MB
  rows:    86,071
  symbols: 2,913

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
2018-01-29 04:00:00	AAPL	Stock	42.8725	43.1225	42.8725	43.1225	37248.0
2018-01-29 04:30:00	AAPL	Stock	43.1275	43.15	42.95	42.9975	60848.0
2018-01-29 05:00:00	AAPL	Stock	42.9525	43.05	42.75	42.8	101380.0
2018-01-29 05:30:00	AAPL	Stock	42.795	42.795	42.705	42.7275	32588.0
2018-01-29 06:00:00	AAPL	Stock	42.7125	42.7125	42.615	42.625	61776.0
2018-01-29 06:30:00	AAPL	Stock	42.6625	42.7275	42.63	42.7275	26976.0
2018-01-29 07:00:00	AAPL	Stock	42.73	42.7375	42.6625	42.675	245492.0
2018-01-29 07:30:00	AAPL	Stock	42.675	42.7	42.63	42.685	174332.0
2018-01-29 08:00:00	AAPL	Stock	42.665	42.7375	42.575	42.575	465900.0
2018-01-29 08:30:00	AAPL	Stock	42.575	42.5975	42.5125	42.535	483848.0
2018-01-29 09:00:00	AAPL	Stock	42.5325	42.575	42.3725	42.4675	921468.0
2018-01-29 09:30:00	AAPL	Stock	42.54	42.54	41.81	42.1662	34479936.0
2018-01-29 10:00:00	AAPL	Stock	42.1675	42.181	41.9275	41.9912	18175312.0
2018-01-29 10:30:00	AAPL	Stock	41.9925	42.135	41.7675	42.08	20074352.0
2018-01-29 11:00:00	AAPL	Stock	42.081	42.3175	41.98	42.2425	12945668.0
2018-01-29 11:30:00	AAPL	Stock	42.24	42.3125	42.1525	42.298	7739872.0
2018-01-29 12:00:00	AAPL	Stock	42.3	42.3025	42.12	42.13	6567656.0
2018-01-29 12:30:00	AAPL	Stock	42.1325	42.2225	42.11	42.195	4796304.0
2018-01-29 13:00:00	AAPL	Stock	42.1975	42.25	42.175	42.215	4370528.0
2018-01-29 13:30:00	AAPL	Stock	42.2175	42.2425	42.1125	42.1252	5796188.0
2018-01-29 14:00:00	AAPL	Stock	42.125	42.135	42.0175	42.04	6190588.0
2018-01-29 14:30:00	AAPL	Stock	42.0375	42.0525	41.94	42.0525	8819772.0
2018-01-29 15:00:00	AAPL	Stock	42.0513	42.135	42.03	42.035	8347596.0
2018-01-29 15:30:00	AAPL	Stock	42.0325	42.0875	41.9517	41.99	16721840.0
2018-01-29 16:00:00	AAPL	Stock	42.0125	42.3062	41.97	41.99	10839600.0
2018-01-29 16:30:00	AAPL	Stock	41.975	41.99	41.955	41.9775	75040.0
2018-01-29 17:00:00	AAPL	Stock	41.9775	41.995	41.9375	41.95	76496.0
2018-01-29 17:30:00	AAPL	Stock	41.94	41.985	41.94	41.955	79364.0
2018-01-29 18:00:00	AAPL	Stock	41.95	42.01	41.95	41.98	82272.0
2018-01-29 18:30:00	AAPL	Stock	41.995	42.0275	41.995	42.025	42920.0
2018-01-29 19:00:00	AAPL	Stock	42.02	42.05	42.0	42.0025	17584.0
2018-01-29 19:30:00	AAPL	Stock	42.05	42.05	42.0	42.0225	12980.0
2018-01-29 04:00:00	MSFT	Stock	94.23	94.53	94.0	94.49	10006.0
2018-01-29 04:30:00	MSFT	Stock	94.49	94.5	94.2	94.3	6974.0
2018-01-29 05:30:00	MSFT	Stock	94.3	94.32	94.3	94.32	2727.0
2018-01-29 06:00:00	MSFT	Stock	94.43	94.43	94.2	94.29	7673.0
2018-01-29 06:30:00	MSFT	Stock	94.29	94.49	94.29	94.49	1120.0
2018-01-29 07:00:00	MSFT	Stock	94.48	94.8	94.42	94.78	22717.0
2018-01-29 07:30:00	MSFT	Stock	94.75	95.32	94.71	95.26	46440.0
2018-01-29 08:00:00	MSFT	Stock	94.5	95.5	94.25	95.25	187224.0
2018-01-29 08:30:00	MSFT	Stock	95.25	95.45	95.06	95.07	26454.0
2018-01-29 09:00:00	MSFT	Stock	95.07	95.47	95.0	95.13	48506.0
2018-01-29 09:30:00	MSFT	Stock	95.13	95.45	94.02	94.465	4915568.0
2018-01-29 10:00:00	MSFT	Stock	94.47	94.52	94.0	94.45	2636448.0
2018-01-29 10:30:00	MSFT	Stock	94.46	94.46	93.76	93.96	1995657.0
2018-01-29 11:00:00	MSFT	Stock	93.96	94.08	93.77	93.95	1580488.0
2018-01-29 11:30:00	MSFT	Stock	93.95	94.13	93.873	93.94	1062015.0
2018-01-29 12:00:00	MSFT	Stock	93.94	94.0	93.81	93.97	961726.0
2018-01-29 12:30:00	MSFT	Stock	93.97	94.07	93.78	93.96	945463.0
2018-01-29 13:00:00	MSFT	Stock	93.96	94.05	93.898	93.94	754117.0

> showing 50 of 86,071 rows — these rows as CSV

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