PREVIEW / stock_30min / 2017-12-26

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-26.parquet
  size:    1.6 MB
  rows:    81,738
  symbols: 2,889

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-12-26 04:00:00	AAPL	Stock	43.625	43.625	43.1	43.125	18324.0
2017-12-26 04:30:00	AAPL	Stock	43.185	43.185	42.9375	42.9375	10532.0
2017-12-26 05:00:00	AAPL	Stock	42.9375	42.9425	42.9375	42.9375	2588.0
2017-12-26 05:30:00	AAPL	Stock	43.0275	43.0275	43.0275	43.0275	1800.0
2017-12-26 06:00:00	AAPL	Stock	43.005	43.0575	42.9925	42.9925	20964.0
2017-12-26 06:30:00	AAPL	Stock	42.9975	43.0	42.6875	42.7975	109744.0
2017-12-26 07:00:00	AAPL	Stock	42.895	42.925	42.5875	42.6375	464216.0
2017-12-26 07:30:00	AAPL	Stock	42.605	42.635	42.4375	42.5625	698740.0
2017-12-26 08:00:00	AAPL	Stock	42.575	42.9	42.4525	42.65	762788.0
2017-12-26 08:30:00	AAPL	Stock	42.65	42.735	42.625	42.68	477376.0
2017-12-26 09:00:00	AAPL	Stock	42.6725	42.6825	42.5375	42.65	908120.0
2017-12-26 09:30:00	AAPL	Stock	42.665	42.8675	42.4198	42.55	32605156.0
2017-12-26 10:00:00	AAPL	Stock	42.55	42.8	42.4975	42.7962	12426464.0
2017-12-26 10:30:00	AAPL	Stock	42.795	42.8475	42.6075	42.6525	9020936.0
2017-12-26 11:00:00	AAPL	Stock	42.65	42.6825	42.615	42.635	6698084.0
2017-12-26 11:30:00	AAPL	Stock	42.6325	42.645	42.555	42.585	6498792.0
2017-12-26 12:00:00	AAPL	Stock	42.585	42.625	42.5525	42.595	4883764.0
2017-12-26 12:30:00	AAPL	Stock	42.5925	42.71	42.59	42.6425	4872628.0
2017-12-26 13:00:00	AAPL	Stock	42.64	42.6625	42.5625	42.6425	5098112.0
2017-12-26 13:30:00	AAPL	Stock	42.6425	42.66	42.575	42.64	4186664.0
2017-12-26 14:00:00	AAPL	Stock	42.6375	42.65	42.5925	42.635	3299188.0
2017-12-26 14:30:00	AAPL	Stock	42.6325	42.6738	42.6	42.622	3532292.0
2017-12-26 15:00:00	AAPL	Stock	42.6225	42.65	42.58	42.5825	4672504.0
2017-12-26 15:30:00	AAPL	Stock	42.58	42.645	42.5275	42.6425	12325452.0
2017-12-26 16:00:00	AAPL	Stock	42.6425	42.6425	42.575	42.6175	6357672.0
2017-12-26 16:30:00	AAPL	Stock	42.625	42.65	42.6175	42.635	99636.0
2017-12-26 17:00:00	AAPL	Stock	42.6425	42.7025	42.63	42.7025	134972.0
2017-12-26 17:30:00	AAPL	Stock	42.7075	42.735	42.6425	42.7225	163600.0
2017-12-26 18:00:00	AAPL	Stock	42.7175	42.725	42.675	42.6775	24200.0
2017-12-26 18:30:00	AAPL	Stock	42.6775	42.6775	42.6525	42.67	26504.0
2017-12-26 19:00:00	AAPL	Stock	42.67	42.675	42.665	42.675	8240.0
2017-12-26 19:30:00	AAPL	Stock	42.675	42.675	42.6425	42.65	21576.0
2017-12-26 07:00:00	MSFT	Stock	85.25	85.25	85.2	85.2	800.0
2017-12-26 07:30:00	MSFT	Stock	85.15	85.15	85.0	85.0	6013.0
2017-12-26 08:00:00	MSFT	Stock	85.22	85.49	85.01	85.05	1560.0
2017-12-26 08:30:00	MSFT	Stock	85.15	85.22	85.1	85.12	1775.0
2017-12-26 09:00:00	MSFT	Stock	85.25	85.48	85.14	85.33	5274.0
2017-12-26 09:30:00	MSFT	Stock	85.31	85.44	85.03	85.32	1208798.0
2017-12-26 10:00:00	MSFT	Stock	85.31	85.495	85.28	85.484	546559.0
2017-12-26 10:30:00	MSFT	Stock	85.49	85.535	85.326	85.35	545748.0
2017-12-26 11:00:00	MSFT	Stock	85.35	85.44	85.26	85.29	491318.0
2017-12-26 11:30:00	MSFT	Stock	85.29	85.32	85.23	85.29	529996.0
2017-12-26 12:00:00	MSFT	Stock	85.3	85.39	85.29	85.335	372613.0
2017-12-26 12:30:00	MSFT	Stock	85.335	85.41	85.31	85.38	479542.0
2017-12-26 13:00:00	MSFT	Stock	85.375	85.4	85.32	85.357	499673.0
2017-12-26 13:30:00	MSFT	Stock	85.36	85.39	85.27	85.385	369665.0
2017-12-26 14:00:00	MSFT	Stock	85.38	85.4	85.31	85.34	389836.0
2017-12-26 14:30:00	MSFT	Stock	85.34	85.36	85.28	85.29	342947.0
2017-12-26 15:00:00	MSFT	Stock	85.3	85.32	85.19	85.205	370686.0
2017-12-26 15:30:00	MSFT	Stock	85.205	85.43	85.2	85.4	1199737.0

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

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