PREVIEW / stock_30min / 2016-06-13

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-13.parquet
  size:    1.6 MB
  rows:    82,668
  symbols: 3,296

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
2016-06-13 04:00:00	AAPL	Stock	24.71	24.71	24.6125	24.6125	10072.0
2016-06-13 04:30:00	AAPL	Stock	24.5625	24.5625	24.525	24.525	5528.0
2016-06-13 05:00:00	AAPL	Stock	24.505	24.505	24.475	24.475	2104.0
2016-06-13 05:30:00	AAPL	Stock	24.49	24.49	24.4875	24.4875	800.0
2016-06-13 06:00:00	AAPL	Stock	24.525	24.55	24.525	24.55	13924.0
2016-06-13 06:30:00	AAPL	Stock	24.5625	24.5625	24.55	24.55	3600.0
2016-06-13 07:00:00	AAPL	Stock	24.5625	24.575	24.3725	24.4625	185036.0
2016-06-13 07:30:00	AAPL	Stock	24.4625	24.52	24.4625	24.52	45556.0
2016-06-13 08:00:00	AAPL	Stock	24.5125	24.5625	24.425	24.5275	153976.0
2016-06-13 08:30:00	AAPL	Stock	24.5375	24.575	24.5375	24.5625	135652.0
2016-06-13 09:00:00	AAPL	Stock	24.5525	24.6725	24.5375	24.65	291124.0
2016-06-13 09:30:00	AAPL	Stock	24.65	24.78	24.3825	24.42	23127532.0
2016-06-13 10:00:00	AAPL	Stock	24.42	24.475	24.275	24.3288	16512764.0
2016-06-13 10:30:00	AAPL	Stock	24.3275	24.4612	24.325	24.4078	12481160.0
2016-06-13 11:00:00	AAPL	Stock	24.41	24.4725	24.385	24.425	6852340.0
2016-06-13 11:30:00	AAPL	Stock	24.425	24.44	24.35	24.3675	8384172.0
2016-06-13 12:00:00	AAPL	Stock	24.365	24.3875	24.33	24.335	6804184.0
2016-06-13 12:30:00	AAPL	Stock	24.3368	24.41	24.3275	24.39	5786588.0
2016-06-13 13:00:00	AAPL	Stock	24.3925	24.4075	24.3525	24.395	5548332.0
2016-06-13 13:30:00	AAPL	Stock	24.395	24.4075	24.337	24.3425	6195552.0
2016-06-13 14:00:00	AAPL	Stock	24.341	24.43	24.3125	24.4212	7174952.0
2016-06-13 14:30:00	AAPL	Stock	24.421	24.5125	24.41	24.435	9810424.0
2016-06-13 15:00:00	AAPL	Stock	24.4375	24.455	24.365	24.3975	7666440.0
2016-06-13 15:30:00	AAPL	Stock	24.396	24.415	24.31	24.335	13567252.0
2016-06-13 16:00:00	AAPL	Stock	24.335	24.389	24.31	24.3175	7399524.0
2016-06-13 16:30:00	AAPL	Stock	24.315	24.315	24.3025	24.31	15692.0
2016-06-13 17:00:00	AAPL	Stock	24.31	24.3125	24.29	24.3025	60668.0
2016-06-13 17:30:00	AAPL	Stock	24.3025	24.3025	24.2875	24.3	1021928.0
2016-06-13 18:00:00	AAPL	Stock	24.2925	24.315	24.28	24.2825	90580.0
2016-06-13 18:30:00	AAPL	Stock	24.2875	24.3	24.2875	24.2925	18488.0
2016-06-13 19:00:00	AAPL	Stock	24.3	24.3	24.2875	24.3	14596.0
2016-06-13 19:30:00	AAPL	Stock	24.3025	24.3125	24.2875	24.3125	37364.0
2016-06-13 05:30:00	MSFT	Stock	51.25	51.25	51.04	51.25	303.0
2016-06-13 06:00:00	MSFT	Stock	51.25	51.29	51.25	51.29	580.0
2016-06-13 07:30:00	MSFT	Stock	51.29	51.29	51.29	51.29	1000.0
2016-06-13 08:00:00	MSFT	Stock	51.3	51.3	51.15	51.3	2700.0
2016-06-13 08:30:00	MSFT	Stock	48.03	51.0	48.03	49.89	1258066.0
2016-06-13 09:00:00	MSFT	Stock	49.85	50.15	49.02	49.57	3354181.0
2016-06-13 09:30:00	MSFT	Stock	49.58	49.95	49.06	49.75	20505766.0
2016-06-13 10:00:00	MSFT	Stock	49.75	50.23	49.38	50.18	10930281.0
2016-06-13 10:30:00	MSFT	Stock	50.175	50.36	50.07	50.29	5646618.0
2016-06-13 11:00:00	MSFT	Stock	50.295	50.715	50.29	50.684	4737505.0
2016-06-13 11:30:00	MSFT	Stock	50.685	50.699	49.95	49.99	5446131.0
2016-06-13 12:00:00	MSFT	Stock	49.99	50.12	49.89	49.995	3946586.0
2016-06-13 12:30:00	MSFT	Stock	49.995	50.25	49.985	50.14	2539533.0
2016-06-13 13:00:00	MSFT	Stock	50.135	50.19	49.99	50.1	2223699.0
2016-06-13 13:30:00	MSFT	Stock	50.095	50.13	49.96	50.075	2076138.0
2016-06-13 14:00:00	MSFT	Stock	50.07	50.17	50.02	50.16	1692271.0
2016-06-13 14:30:00	MSFT	Stock	50.16	50.27	50.03	50.045	2064147.0
2016-06-13 15:00:00	MSFT	Stock	50.045	50.28	49.995	50.19	3975778.0

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

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