PREVIEW / stock_30min / 2017-02-07

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-07.parquet
  size:    1.6 MB
  rows:    83,111
  symbols: 3,099

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-07 04:00:00	AAPL	Stock	32.5625	32.5625	32.515	32.555	9116.0
2017-02-07 05:00:00	AAPL	Stock	32.5625	32.5625	32.5625	32.5625	1980.0
2017-02-07 05:30:00	AAPL	Stock	32.5625	32.5625	32.5625	32.5625	4984.0
2017-02-07 06:00:00	AAPL	Stock	32.57	32.6125	32.57	32.6125	9600.0
2017-02-07 06:30:00	AAPL	Stock	32.59	32.6325	32.59	32.62	8756.0
2017-02-07 07:00:00	AAPL	Stock	32.6125	32.635	32.61	32.6325	18576.0
2017-02-07 07:30:00	AAPL	Stock	32.6425	32.6725	32.6375	32.6525	72608.0
2017-02-07 08:00:00	AAPL	Stock	32.65	32.67	32.4875	32.625	106836.0
2017-02-07 08:30:00	AAPL	Stock	32.6175	32.6425	32.615	32.62	101904.0
2017-02-07 09:00:00	AAPL	Stock	32.63	32.6475	32.585	32.635	301936.0
2017-02-07 09:30:00	AAPL	Stock	32.635	32.785	32.6125	32.7675	22294028.0
2017-02-07 10:00:00	AAPL	Stock	32.765	32.985	32.765	32.9325	16162204.0
2017-02-07 10:30:00	AAPL	Stock	32.935	33.0	32.9175	32.9638	9728380.0
2017-02-07 11:00:00	AAPL	Stock	32.9625	33.0	32.94	32.989	7311952.0
2017-02-07 11:30:00	AAPL	Stock	32.9888	33.0	32.9525	32.96	4760004.0
2017-02-07 12:00:00	AAPL	Stock	32.9615	32.9875	32.945	32.976	4549768.0
2017-02-07 12:30:00	AAPL	Stock	32.975	33.0225	32.875	32.875	13671316.0
2017-02-07 13:00:00	AAPL	Stock	32.875	32.9688	32.8575	32.96	6118832.0
2017-02-07 13:30:00	AAPL	Stock	32.96	33.01	32.935	32.9375	5666028.0
2017-02-07 14:00:00	AAPL	Stock	32.9392	32.95	32.8275	32.8575	8325212.0
2017-02-07 14:30:00	AAPL	Stock	32.8575	32.8688	32.7925	32.85	7657872.0
2017-02-07 15:00:00	AAPL	Stock	32.8512	32.9075	32.85	32.8925	6978288.0
2017-02-07 15:30:00	AAPL	Stock	32.8912	32.9	32.8488	32.8775	11477444.0
2017-02-07 16:00:00	AAPL	Stock	32.875	32.895	32.865	32.8825	7136756.0
2017-02-07 16:30:00	AAPL	Stock	32.8875	32.8875	32.8575	32.875	146164.0
2017-02-07 17:00:00	AAPL	Stock	32.875	32.875	32.8675	32.8675	51772.0
2017-02-07 17:30:00	AAPL	Stock	32.8675	32.87	32.8675	32.8675	11000.0
2017-02-07 18:00:00	AAPL	Stock	32.8675	32.8675	32.855	32.855	4588.0
2017-02-07 18:30:00	AAPL	Stock	32.875	32.8825	32.875	32.875	7920.0
2017-02-07 19:00:00	AAPL	Stock	32.8825	32.8825	32.8525	32.8525	33848.0
2017-02-07 19:30:00	AAPL	Stock	32.87	32.87	32.845	32.87	22180.0
2017-02-07 06:30:00	MSFT	Stock	63.74	63.75	63.74	63.75	721.0
2017-02-07 08:00:00	MSFT	Stock	63.81	63.81	63.75	63.81	6467.0
2017-02-07 08:30:00	MSFT	Stock	63.71	63.79	63.7	63.7	6824.0
2017-02-07 09:00:00	MSFT	Stock	63.75	63.8	63.64	63.65	17515.0
2017-02-07 09:30:00	MSFT	Stock	63.71	63.8	63.23	63.45	2740938.0
2017-02-07 10:00:00	MSFT	Stock	63.452	63.63	63.34	63.35	1496615.0
2017-02-07 10:30:00	MSFT	Stock	63.35	63.596	63.345	63.54	1096493.0
2017-02-07 11:00:00	MSFT	Stock	63.53	63.55	63.36	63.433	1111427.0
2017-02-07 11:30:00	MSFT	Stock	63.435	63.49	63.37	63.45	602642.0
2017-02-07 12:00:00	MSFT	Stock	63.444	63.51	63.38	63.385	682646.0
2017-02-07 12:30:00	MSFT	Stock	63.39	63.44	63.32	63.405	779189.0
2017-02-07 13:00:00	MSFT	Stock	63.4	63.49	63.35	63.47	641951.0
2017-02-07 13:30:00	MSFT	Stock	63.47	63.49	63.395	63.42	635827.0
2017-02-07 14:00:00	MSFT	Stock	63.43	63.445	63.34	63.36	949352.0
2017-02-07 14:30:00	MSFT	Stock	63.35	63.4	63.33	63.36	785194.0
2017-02-07 15:00:00	MSFT	Stock	63.35	63.43	63.31	63.345	927085.0
2017-02-07 15:30:00	MSFT	Stock	63.345	63.43	63.235	63.42	3266050.0
2017-02-07 16:00:00	MSFT	Stock	63.43	63.54	63.3	63.43	3404462.0
2017-02-07 16:30:00	MSFT	Stock	63.44	63.44	63.35	63.43	3430.0

> showing 50 of 83,111 rows — these rows as CSV

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