PREVIEW / stock_30min / 2016-09-22

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-22.parquet
  size:    1.6 MB
  rows:    82,706
  symbols: 3,242

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-09-22 04:00:00	AAPL	Stock	28.455	28.455	28.455	28.455	400.0
2016-09-22 05:00:00	AAPL	Stock	28.4675	28.4925	28.4675	28.4925	1736.0
2016-09-22 05:30:00	AAPL	Stock	28.5	28.5	28.5	28.5	5912.0
2016-09-22 06:30:00	AAPL	Stock	28.5325	28.5325	28.5325	28.5325	3860.0
2016-09-22 07:00:00	AAPL	Stock	28.5325	28.5325	28.5	28.5	33320.0
2016-09-22 07:30:00	AAPL	Stock	28.505	28.525	28.4775	28.5225	43480.0
2016-09-22 08:00:00	AAPL	Stock	28.5225	28.53	28.4875	28.505	283432.0
2016-09-22 08:30:00	AAPL	Stock	28.5	28.525	28.5	28.515	101116.0
2016-09-22 09:00:00	AAPL	Stock	28.515	28.5825	28.5	28.5825	515064.0
2016-09-22 09:30:00	AAPL	Stock	28.58	28.7175	28.5	28.6975	24459332.0
2016-09-22 10:00:00	AAPL	Stock	28.6998	28.7325	28.5975	28.72	11401832.0
2016-09-22 10:30:00	AAPL	Stock	28.7188	28.735	28.595	28.6138	10619492.0
2016-09-22 11:00:00	AAPL	Stock	28.6125	28.6875	28.6075	28.6575	6513584.0
2016-09-22 11:30:00	AAPL	Stock	28.658	28.705	28.6425	28.655	5001424.0
2016-09-22 12:00:00	AAPL	Stock	28.6575	28.67	28.605	28.6472	5209612.0
2016-09-22 12:30:00	AAPL	Stock	28.645	28.66	28.6175	28.6425	4524652.0
2016-09-22 13:00:00	AAPL	Stock	28.645	28.68	28.63	28.65	3901892.0
2016-09-22 13:30:00	AAPL	Stock	28.65	28.6775	28.645	28.67	3717788.0
2016-09-22 14:00:00	AAPL	Stock	28.6675	28.68	28.5725	28.615	6352444.0
2016-09-22 14:30:00	AAPL	Stock	28.615	28.6425	28.555	28.6312	5621140.0
2016-09-22 15:00:00	AAPL	Stock	28.6325	28.6625	28.6112	28.6525	7494136.0
2016-09-22 15:30:00	AAPL	Stock	28.6525	28.6975	28.6425	28.6525	11397880.0
2016-09-22 16:00:00	AAPL	Stock	28.6525	28.675	28.64	28.65	8448252.0
2016-09-22 16:30:00	AAPL	Stock	28.6425	28.675	28.6425	28.6575	55728.0
2016-09-22 17:00:00	AAPL	Stock	28.6625	28.6725	28.6625	28.6675	9808.0
2016-09-22 17:30:00	AAPL	Stock	28.6625	28.6675	28.6625	28.6625	8008.0
2016-09-22 18:00:00	AAPL	Stock	28.6625	28.6675	28.6625	28.6675	5600.0
2016-09-22 18:30:00	AAPL	Stock	28.6625	28.6725	28.6625	28.6675	12324.0
2016-09-22 19:00:00	AAPL	Stock	28.6625	28.6625	28.6625	28.6625	2000.0
2016-09-22 19:30:00	AAPL	Stock	28.67	28.67	28.65	28.65	48352.0
2016-09-22 07:30:00	MSFT	Stock	57.76	57.76	57.63	57.63	490.0
2016-09-22 08:00:00	MSFT	Stock	57.97	57.98	57.83	57.94	1300.0
2016-09-22 08:30:00	MSFT	Stock	57.94	58.0	57.92	57.92	4557.0
2016-09-22 09:00:00	MSFT	Stock	57.94	57.98	57.9	57.92	24601.0
2016-09-22 09:30:00	MSFT	Stock	57.95	58.0	57.83	57.92	2720199.0
2016-09-22 10:00:00	MSFT	Stock	57.92	57.94	57.87	57.925	1373459.0
2016-09-22 10:30:00	MSFT	Stock	57.925	58.0	57.85	57.89	1348487.0
2016-09-22 11:00:00	MSFT	Stock	57.89	57.95	57.82	57.84	1184157.0
2016-09-22 11:30:00	MSFT	Stock	57.84	57.9	57.82	57.865	771783.0
2016-09-22 12:00:00	MSFT	Stock	57.87	57.9	57.81	57.85	619200.0
2016-09-22 12:30:00	MSFT	Stock	57.86	57.89	57.81	57.837	672594.0
2016-09-22 13:00:00	MSFT	Stock	57.83	57.89	57.8	57.82	903768.0
2016-09-22 13:30:00	MSFT	Stock	57.82	57.895	57.815	57.86	995317.0
2016-09-22 14:00:00	MSFT	Stock	57.855	57.88	57.63	57.645	1409273.0
2016-09-22 14:30:00	MSFT	Stock	57.64	57.805	57.64	57.745	1150002.0
2016-09-22 15:00:00	MSFT	Stock	57.74	57.86	57.73	57.845	1143934.0
2016-09-22 15:30:00	MSFT	Stock	57.845	57.9	57.77	57.79	2853483.0
2016-09-22 16:00:00	MSFT	Stock	57.82	57.82	57.79	57.79	1441209.0
2016-09-22 16:30:00	MSFT	Stock	57.82	57.85	57.82	57.85	63590.0
2016-09-22 17:00:00	MSFT	Stock	57.85	57.85	57.82	57.82	1300.0

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

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