PREVIEW / stock_30min / 2016-08-05

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-05.parquet
  size:    1.6 MB
  rows:    81,443
  symbols: 3,257

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-08-05 04:00:00	AAPL	Stock	24.9125	26.5425	24.9125	26.5425	5500.0
2016-08-05 04:30:00	AAPL	Stock	26.5425	26.5425	26.455	26.495	4004.0
2016-08-05 05:00:00	AAPL	Stock	26.525	26.525	26.525	26.525	852.0
2016-08-05 06:00:00	AAPL	Stock	26.5	26.53	26.5	26.53	6060.0
2016-08-05 06:30:00	AAPL	Stock	26.5475	26.5575	26.54	26.54	4880.0
2016-08-05 07:00:00	AAPL	Stock	26.54	26.55	26.5075	26.5075	23040.0
2016-08-05 07:30:00	AAPL	Stock	26.5075	26.5075	26.49	26.49	29920.0
2016-08-05 08:00:00	AAPL	Stock	26.535	26.545	26.48	26.525	148308.0
2016-08-05 08:30:00	AAPL	Stock	26.525	26.6125	26.525	26.6125	251460.0
2016-08-05 09:00:00	AAPL	Stock	26.615	26.625	26.5525	26.5525	228020.0
2016-08-05 09:30:00	AAPL	Stock	26.56	26.76	26.545	26.7475	22172996.0
2016-08-05 10:00:00	AAPL	Stock	26.7475	26.8175	26.7448	26.815	10952880.0
2016-08-05 10:30:00	AAPL	Stock	26.814	26.8612	26.8075	26.8388	9494944.0
2016-08-05 11:00:00	AAPL	Stock	26.8375	26.8425	26.8075	26.8175	6374552.0
2016-08-05 11:30:00	AAPL	Stock	26.8175	26.8875	26.8	26.8725	9346176.0
2016-08-05 12:00:00	AAPL	Stock	26.8725	26.9075	26.86	26.9	5497796.0
2016-08-05 12:30:00	AAPL	Stock	26.9025	26.91	26.8675	26.8825	5126940.0
2016-08-05 13:00:00	AAPL	Stock	26.8838	26.8988	26.8775	26.89	4083144.0
2016-08-05 13:30:00	AAPL	Stock	26.89	26.9125	26.885	26.91	8492464.0
2016-08-05 14:00:00	AAPL	Stock	26.91	26.9125	26.88	26.8875	5375612.0
2016-08-05 14:30:00	AAPL	Stock	26.8875	26.895	26.8425	26.86	8428600.0
2016-08-05 15:00:00	AAPL	Stock	26.86	26.895	26.84	26.8875	6931816.0
2016-08-05 15:30:00	AAPL	Stock	26.8888	26.9	26.855	26.8675	13830424.0
2016-08-05 16:00:00	AAPL	Stock	26.8662	26.8775	26.8325	26.87	17906708.0
2016-08-05 16:30:00	AAPL	Stock	26.87	26.87	26.8425	26.85	104568.0
2016-08-05 17:00:00	AAPL	Stock	26.87	26.87	26.8425	26.85	610892.0
2016-08-05 17:30:00	AAPL	Stock	26.845	26.86	26.845	26.8575	21056.0
2016-08-05 18:00:00	AAPL	Stock	26.86	26.87	26.855	26.865	3827040.0
2016-08-05 18:30:00	AAPL	Stock	26.8675	26.8675	26.86	26.86	14044.0
2016-08-05 19:00:00	AAPL	Stock	26.86	26.8725	26.8575	26.87	88392.0
2016-08-05 19:30:00	AAPL	Stock	26.87	26.885	26.865	26.8825	57868.0
2016-08-05 08:00:00	MSFT	Stock	57.42	57.5	57.42	57.5	1200.0
2016-08-05 08:30:00	MSFT	Stock	57.5	57.65	57.5	57.64	6170.0
2016-08-05 09:00:00	MSFT	Stock	57.64	57.7	57.64	57.68	10770.0
2016-08-05 09:30:00	MSFT	Stock	57.65	58.21	57.45	58.04	5014239.0
2016-08-05 10:00:00	MSFT	Stock	58.04	58.11	57.925	57.96	1891930.0
2016-08-05 10:30:00	MSFT	Stock	57.955	58.05	57.93	57.994	2026140.0
2016-08-05 11:00:00	MSFT	Stock	58.0	58.02	57.95	57.96	1282129.0
2016-08-05 11:30:00	MSFT	Stock	57.97	57.99	57.88	57.945	981317.0
2016-08-05 12:00:00	MSFT	Stock	57.945	57.98	57.89	57.97	682855.0
2016-08-05 12:30:00	MSFT	Stock	57.97	58.0	57.95	58.0	831332.0
2016-08-05 13:00:00	MSFT	Stock	58.0	58.01	57.93	57.955	767446.0
2016-08-05 13:30:00	MSFT	Stock	57.96	58.0	57.94	57.96	1232971.0
2016-08-05 14:00:00	MSFT	Stock	57.96	57.99	57.92	57.94	737512.0
2016-08-05 14:30:00	MSFT	Stock	57.94	57.98	57.88	57.94	1433469.0
2016-08-05 15:00:00	MSFT	Stock	57.94	58.03	57.94	57.995	1395658.0
2016-08-05 15:30:00	MSFT	Stock	57.99	58.0	57.83	57.95	3368688.0
2016-08-05 16:00:00	MSFT	Stock	57.96	57.99	57.96	57.96	4683705.0
2016-08-05 16:30:00	MSFT	Stock	57.95	57.95	57.95	57.95	1000.0
2016-08-05 17:00:00	MSFT	Stock	57.97	57.99	57.96	57.99	1200.0

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

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