PREVIEW / stock_30min / 2017-10-10

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-10.parquet
  size:    1.6 MB
  rows:    81,613
  symbols: 2,947

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-10 04:00:00	AAPL	Stock	38.93	38.99	38.93	38.99	1968.0
2017-10-10 05:30:00	AAPL	Stock	38.9925	39.025	38.9925	39.025	9600.0
2017-10-10 06:00:00	AAPL	Stock	39.0325	39.0325	39.0	39.0	4388.0
2017-10-10 06:30:00	AAPL	Stock	39.025	39.025	38.975	38.975	9216.0
2017-10-10 07:00:00	AAPL	Stock	38.995	39.015	38.96	38.9625	103280.0
2017-10-10 07:30:00	AAPL	Stock	38.94	38.96	38.9	38.95	49752.0
2017-10-10 08:00:00	AAPL	Stock	38.95	39.025	38.9375	39.025	98084.0
2017-10-10 08:30:00	AAPL	Stock	39.025	39.0375	39.0	39.025	98696.0
2017-10-10 09:00:00	AAPL	Stock	39.025	39.0375	38.9875	38.99	87684.0
2017-10-10 09:30:00	AAPL	Stock	39.0	39.5	38.9775	39.025	10740216.0
2017-10-10 10:00:00	AAPL	Stock	39.0325	39.0462	38.775	38.9175	7827096.0
2017-10-10 10:30:00	AAPL	Stock	38.92	38.9625	38.87	38.8992	3782288.0
2017-10-10 11:00:00	AAPL	Stock	38.8988	38.955	38.8532	38.8725	3190292.0
2017-10-10 11:30:00	AAPL	Stock	38.8775	38.92	38.82	38.8675	2498204.0
2017-10-10 12:00:00	AAPL	Stock	38.8612	38.925	38.8125	38.904	3398376.0
2017-10-10 12:30:00	AAPL	Stock	38.904	39.005	38.9	38.995	2551224.0
2017-10-10 13:00:00	AAPL	Stock	38.9925	39.045	38.945	38.9775	3015708.0
2017-10-10 13:30:00	AAPL	Stock	38.9775	39.035	38.9475	38.9575	2534028.0
2017-10-10 14:00:00	AAPL	Stock	38.9525	38.9825	38.9125	38.9425	1882296.0
2017-10-10 14:30:00	AAPL	Stock	38.945	38.9692	38.9375	38.9475	1610836.0
2017-10-10 15:00:00	AAPL	Stock	38.9475	38.985	38.915	38.915	2338288.0
2017-10-10 15:30:00	AAPL	Stock	38.915	38.98	38.905	38.975	5273816.0
2017-10-10 16:00:00	AAPL	Stock	38.975	38.975	38.9275	38.95	5409936.0
2017-10-10 16:30:00	AAPL	Stock	38.9375	38.96	38.9325	38.96	8992.0
2017-10-10 17:00:00	AAPL	Stock	38.9575	38.96	38.9575	38.9575	4504.0
2017-10-10 17:30:00	AAPL	Stock	38.9375	38.94	38.9375	38.9375	1996.0
2017-10-10 18:00:00	AAPL	Stock	38.9375	38.9675	38.9375	38.9675	5028.0
2017-10-10 18:30:00	AAPL	Stock	38.965	38.965	38.965	38.965	1600.0
2017-10-10 19:00:00	AAPL	Stock	38.955	38.97	38.95	38.95	14304.0
2017-10-10 19:30:00	AAPL	Stock	38.95	38.95	38.9325	38.9325	8120.0
2017-10-10 07:30:00	MSFT	Stock	76.53	76.53	76.53	76.53	100.0
2017-10-10 08:00:00	MSFT	Stock	76.54	76.54	76.5	76.5	1480.0
2017-10-10 08:30:00	MSFT	Stock	76.43	76.5	76.43	76.5	1350.0
2017-10-10 09:00:00	MSFT	Stock	76.48	76.5	76.32	76.33	6361.0
2017-10-10 09:30:00	MSFT	Stock	76.33	76.63	76.29	76.59	1939570.0
2017-10-10 10:00:00	MSFT	Stock	76.6	76.63	76.35	76.46	1136632.0
2017-10-10 10:30:00	MSFT	Stock	76.47	76.57	76.41	76.51	690752.0
2017-10-10 11:00:00	MSFT	Stock	76.51	76.59	76.4	76.44	738275.0
2017-10-10 11:30:00	MSFT	Stock	76.44	76.51	76.255	76.31	607493.0
2017-10-10 12:00:00	MSFT	Stock	76.31	76.33	76.15	76.26	664266.0
2017-10-10 12:30:00	MSFT	Stock	76.26	76.34	76.215	76.3	506833.0
2017-10-10 13:00:00	MSFT	Stock	76.3	76.44	76.29	76.38	397028.0
2017-10-10 13:30:00	MSFT	Stock	76.38	76.42	76.28	76.29	480666.0
2017-10-10 14:00:00	MSFT	Stock	76.295	76.34	76.23	76.27	453148.0
2017-10-10 14:30:00	MSFT	Stock	76.28	76.34	76.25	76.278	558290.0
2017-10-10 15:00:00	MSFT	Stock	76.275	76.35	76.19	76.19	569421.0
2017-10-10 15:30:00	MSFT	Stock	76.19	76.32	76.14	76.31	1825609.0
2017-10-10 16:00:00	MSFT	Stock	76.31	76.38	76.21	76.22	2109777.0
2017-10-10 16:30:00	MSFT	Stock	76.21	76.34	76.21	76.21	2530.0
2017-10-10 17:00:00	MSFT	Stock	76.34	76.34	76.34	76.34	120.0

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

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