PREVIEW / stock_30min / 2017-02-08

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-08.parquet
  size:    1.6 MB
  rows:    82,853
  symbols: 3,097

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-02-08 05:00:00	AAPL	Stock	32.9125	32.9375	32.8975	32.8975	7916.0
2017-02-08 05:30:00	AAPL	Stock	32.9475	32.9475	32.9475	32.9475	800.0
2017-02-08 06:00:00	AAPL	Stock	32.9475	32.95	32.9475	32.95	2400.0
2017-02-08 06:30:00	AAPL	Stock	32.9475	32.97	32.92	32.9325	11944.0
2017-02-08 07:00:00	AAPL	Stock	32.925	32.925	32.9025	32.9125	19844.0
2017-02-08 07:30:00	AAPL	Stock	32.915	32.9325	32.9	32.9	61848.0
2017-02-08 08:00:00	AAPL	Stock	32.925	32.925	32.8	32.8875	84612.0
2017-02-08 08:30:00	AAPL	Stock	32.88	32.9125	32.84	32.8975	117936.0
2017-02-08 09:00:00	AAPL	Stock	32.8975	32.9	32.8125	32.83	265020.0
2017-02-08 09:30:00	AAPL	Stock	32.835	32.95	32.805	32.8375	15760784.0
2017-02-08 10:00:00	AAPL	Stock	32.8375	32.905	32.805	32.86	5629052.0
2017-02-08 10:30:00	AAPL	Stock	32.86	32.895	32.8175	32.8685	5968916.0
2017-02-08 11:00:00	AAPL	Stock	32.869	32.9	32.8625	32.8725	3340684.0
2017-02-08 11:30:00	AAPL	Stock	32.8725	32.89	32.855	32.855	3394240.0
2017-02-08 12:00:00	AAPL	Stock	32.8562	32.925	32.8552	32.89	4735720.0
2017-02-08 12:30:00	AAPL	Stock	32.8925	32.8925	32.865	32.8775	2963384.0
2017-02-08 13:00:00	AAPL	Stock	32.875	32.92	32.8675	32.9075	3141052.0
2017-02-08 13:30:00	AAPL	Stock	32.9065	32.925	32.9	32.919	2453488.0
2017-02-08 14:00:00	AAPL	Stock	32.9188	32.9375	32.9125	32.9263	3347220.0
2017-02-08 14:30:00	AAPL	Stock	32.925	32.9575	32.9225	32.9388	3022892.0
2017-02-08 15:00:00	AAPL	Stock	32.9375	33.0125	32.935	32.9963	7102544.0
2017-02-08 15:30:00	AAPL	Stock	32.995	33.055	32.9925	33.01	11322240.0
2017-02-08 16:00:00	AAPL	Stock	33.01	33.025	33.0025	33.01	3940096.0
2017-02-08 16:30:00	AAPL	Stock	33.01	33.025	33.01	33.015	35240.0
2017-02-08 17:00:00	AAPL	Stock	33.015	33.025	33.01	33.0125	94548.0
2017-02-08 17:30:00	AAPL	Stock	33.01	33.0325	33.01	33.0325	1492416.0
2017-02-08 18:00:00	AAPL	Stock	33.03	33.0325	33.0275	33.0275	14660.0
2017-02-08 18:30:00	AAPL	Stock	33.0275	33.0375	33.0275	33.0375	27404.0
2017-02-08 19:00:00	AAPL	Stock	33.045	33.0475	33.0275	33.035	17520.0
2017-02-08 19:30:00	AAPL	Stock	33.04	33.05	33.025	33.025	50544.0
2017-02-08 08:00:00	MSFT	Stock	63.44	63.45	63.44	63.45	2145.0
2017-02-08 08:30:00	MSFT	Stock	63.44	63.58	63.42	63.58	4310.0
2017-02-08 09:00:00	MSFT	Stock	63.55	63.57	63.5	63.56	7481.0
2017-02-08 09:30:00	MSFT	Stock	63.56	63.81	63.22	63.445	2230228.0
2017-02-08 10:00:00	MSFT	Stock	63.446	63.73	63.4	63.495	1620184.0
2017-02-08 10:30:00	MSFT	Stock	63.5	63.626	63.45	63.6	1503853.0
2017-02-08 11:00:00	MSFT	Stock	63.6	63.62	63.5	63.505	698382.0
2017-02-08 11:30:00	MSFT	Stock	63.51	63.534	63.45	63.48	889583.0
2017-02-08 12:00:00	MSFT	Stock	63.48	63.59	63.48	63.5	672348.0
2017-02-08 12:30:00	MSFT	Stock	63.495	63.5	63.41	63.42	522085.0
2017-02-08 13:00:00	MSFT	Stock	63.41	63.5	63.39	63.475	966800.0
2017-02-08 13:30:00	MSFT	Stock	63.475	63.54	63.47	63.5	667919.0
2017-02-08 14:00:00	MSFT	Stock	63.49	63.53	63.435	63.5	636602.0
2017-02-08 14:30:00	MSFT	Stock	63.49	63.53	63.35	63.35	1043796.0
2017-02-08 15:00:00	MSFT	Stock	63.35	63.46	63.28	63.46	818895.0
2017-02-08 15:30:00	MSFT	Stock	63.455	63.48	63.31	63.33	1956352.0
2017-02-08 16:00:00	MSFT	Stock	63.34	63.34	63.34	63.34	2176532.0
2017-02-08 16:30:00	MSFT	Stock	63.33	63.33	63.29	63.3	5890.0
2017-02-08 17:00:00	MSFT	Stock	63.36	63.38	63.34	63.34	2887.0
2017-02-08 17:30:00	MSFT	Stock	63.34	63.37	63.34	63.37	199558.0

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

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