PREVIEW / stock_30min / 2017-12-14

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-14.parquet
  size:    1.7 MB
  rows:    83,923
  symbols: 2,931

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-14 06:30:00	AAPL	Stock	43.1275	43.1275	43.1275	43.1275	400.0
2017-12-14 07:00:00	AAPL	Stock	43.1425	43.1625	43.1425	43.15	24876.0
2017-12-14 07:30:00	AAPL	Stock	43.1375	43.1375	43.1	43.125	13668.0
2017-12-14 08:00:00	AAPL	Stock	43.1362	43.1775	43.125	43.13	39960.0
2017-12-14 08:30:00	AAPL	Stock	43.125	43.145	43.1125	43.13	39748.0
2017-12-14 09:00:00	AAPL	Stock	43.1275	43.1475	43.0775	43.11	111644.0
2017-12-14 09:30:00	AAPL	Stock	43.1075	43.2825	43.0775	43.0975	11293500.0
2017-12-14 10:00:00	AAPL	Stock	43.0975	43.2	43.0625	43.0962	6873672.0
2017-12-14 10:30:00	AAPL	Stock	43.1018	43.15	43.0525	43.085	5257028.0
2017-12-14 11:00:00	AAPL	Stock	43.085	43.11	42.9125	43.03	7848600.0
2017-12-14 11:30:00	AAPL	Stock	43.03	43.1275	43.025	43.0712	4132152.0
2017-12-14 12:00:00	AAPL	Stock	43.0688	43.0775	43.015	43.035	2880576.0
2017-12-14 12:30:00	AAPL	Stock	43.035	43.1225	43.0175	43.0295	2808300.0
2017-12-14 13:00:00	AAPL	Stock	43.0275	43.0625	42.9225	43.0075	4596604.0
2017-12-14 13:30:00	AAPL	Stock	43.0075	43.1025	42.98	43.0325	3071812.0
2017-12-14 14:00:00	AAPL	Stock	43.0325	43.0975	42.965	42.975	3179688.0
2017-12-14 14:30:00	AAPL	Stock	42.972	43.075	42.9625	43.0575	3087704.0
2017-12-14 15:00:00	AAPL	Stock	43.05	43.085	43.0125	43.075	2962068.0
2017-12-14 15:30:00	AAPL	Stock	43.0775	43.1075	43.0325	43.055	8355708.0
2017-12-14 16:00:00	AAPL	Stock	43.0625	43.105	43.0525	43.105	5867580.0
2017-12-14 16:30:00	AAPL	Stock	43.1	43.1075	43.075	43.0825	49724.0
2017-12-14 17:00:00	AAPL	Stock	43.075	43.0775	43.025	43.025	22716.0
2017-12-14 17:30:00	AAPL	Stock	43.025	43.08	43.025	43.08	9176.0
2017-12-14 18:00:00	AAPL	Stock	43.075	43.0825	43.065	43.07	16960.0
2017-12-14 18:30:00	AAPL	Stock	43.0775	43.08	43.075	43.08	7792.0
2017-12-14 19:00:00	AAPL	Stock	43.075	43.085	43.06	43.085	74752.0
2017-12-14 19:30:00	AAPL	Stock	43.0875	43.11	43.0875	43.11	6764.0
2017-12-14 05:00:00	MSFT	Stock	85.6	85.6	85.6	85.6	100.0
2017-12-14 07:00:00	MSFT	Stock	85.6	85.6	85.6	85.6	1100.0
2017-12-14 07:30:00	MSFT	Stock	85.6	85.6	85.6	85.6	2699.0
2017-12-14 08:00:00	MSFT	Stock	85.5	85.6	85.5	85.54	2587.0
2017-12-14 08:30:00	MSFT	Stock	85.54	85.54	85.49	85.54	2478.0
2017-12-14 09:00:00	MSFT	Stock	85.55	85.73	85.5	85.67	1619.0
2017-12-14 09:30:00	MSFT	Stock	85.43	85.87	85.353	85.57	1693181.0
2017-12-14 10:00:00	MSFT	Stock	85.56	85.6	85.25	85.425	986498.0
2017-12-14 10:30:00	MSFT	Stock	85.426	85.5	85.305	85.37	644861.0
2017-12-14 11:00:00	MSFT	Stock	85.38	85.42	84.955	85.225	1199925.0
2017-12-14 11:30:00	MSFT	Stock	85.23	85.255	84.98	84.98	707733.0
2017-12-14 12:00:00	MSFT	Stock	84.98	85.05	84.9	84.91	557022.0
2017-12-14 12:30:00	MSFT	Stock	84.9	84.965	84.78	84.82	768630.0
2017-12-14 13:00:00	MSFT	Stock	84.82	84.91	84.637	84.77	901769.0
2017-12-14 13:30:00	MSFT	Stock	84.77	84.96	84.66	84.91	741906.0
2017-12-14 14:00:00	MSFT	Stock	84.91	84.96	84.57	84.59	1091100.0
2017-12-14 14:30:00	MSFT	Stock	84.584	84.765	84.53	84.765	819716.0
2017-12-14 15:00:00	MSFT	Stock	84.761	84.77	84.56	84.685	643589.0
2017-12-14 15:30:00	MSFT	Stock	84.69	84.95	84.67	84.72	2850604.0
2017-12-14 16:00:00	MSFT	Stock	84.69	85.189	84.69	84.8	3960062.0
2017-12-14 16:30:00	MSFT	Stock	84.73	84.73	84.69	84.7	4095.0
2017-12-14 17:00:00	MSFT	Stock	84.5	84.7	84.5	84.5	414.0
2017-12-14 18:00:00	MSFT	Stock	84.65	84.65	84.65	84.65	650.0

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

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