PREVIEW / stock_30min / 2016-05-04

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-04.parquet
  size:    1.6 MB
  rows:    81,936
  symbols: 3,291

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-05-04 04:00:00	AAPL	Stock	23.8875	23.8875	23.815	23.83	27216.0
2016-05-04 04:30:00	AAPL	Stock	23.8375	23.8375	23.795	23.795	14628.0
2016-05-04 05:00:00	AAPL	Stock	23.795	23.795	23.75	23.75	9216.0
2016-05-04 05:30:00	AAPL	Stock	23.7025	23.7025	23.64	23.64	12400.0
2016-05-04 06:00:00	AAPL	Stock	23.64	23.64	23.6225	23.635	6856.0
2016-05-04 06:30:00	AAPL	Stock	23.625	23.65	23.6125	23.6275	16568.0
2016-05-04 07:00:00	AAPL	Stock	23.625	23.65	23.6125	23.65	58972.0
2016-05-04 07:30:00	AAPL	Stock	23.635	23.67	23.635	23.6675	22368.0
2016-05-04 08:00:00	AAPL	Stock	23.67	23.745	23.6125	23.725	303400.0
2016-05-04 08:30:00	AAPL	Stock	23.725	23.75	23.7	23.715	158876.0
2016-05-04 09:00:00	AAPL	Stock	23.6925	23.81	23.6925	23.8	285636.0
2016-05-04 09:30:00	AAPL	Stock	23.7975	23.975	23.745	23.79	26998096.0
2016-05-04 10:00:00	AAPL	Stock	23.7875	23.82	23.585	23.595	18975960.0
2016-05-04 10:30:00	AAPL	Stock	23.595	23.6225	23.525	23.575	14921216.0
2016-05-04 11:00:00	AAPL	Stock	23.575	23.6375	23.53	23.5525	9006904.0
2016-05-04 11:30:00	AAPL	Stock	23.5538	23.59	23.53	23.5625	7760992.0
2016-05-04 12:00:00	AAPL	Stock	23.5628	23.5962	23.5425	23.5625	6100984.0
2016-05-04 12:30:00	AAPL	Stock	23.5625	23.58	23.5	23.5025	7364912.0
2016-05-04 13:00:00	AAPL	Stock	23.505	23.5225	23.455	23.52	7171472.0
2016-05-04 13:30:00	AAPL	Stock	23.52	23.5475	23.4825	23.5075	5922172.0
2016-05-04 14:00:00	AAPL	Stock	23.5075	23.565	23.4775	23.559	6453192.0
2016-05-04 14:30:00	AAPL	Stock	23.5572	23.5875	23.535	23.55	5258052.0
2016-05-04 15:00:00	AAPL	Stock	23.55	23.6075	23.5275	23.595	7176096.0
2016-05-04 15:30:00	AAPL	Stock	23.5962	23.61	23.5425	23.5475	11382032.0
2016-05-04 16:00:00	AAPL	Stock	23.5475	23.575	23.5093	23.555	12059572.0
2016-05-04 16:30:00	AAPL	Stock	23.5525	23.575	23.5475	23.575	531768.0
2016-05-04 17:00:00	AAPL	Stock	23.575	23.5825	23.5725	23.5825	25000.0
2016-05-04 17:30:00	AAPL	Stock	23.5825	23.59	23.575	23.585	20800.0
2016-05-04 18:00:00	AAPL	Stock	23.6	23.61	23.5875	23.59	51048.0
2016-05-04 18:30:00	AAPL	Stock	23.59	23.5975	23.5475	23.5975	7308.0
2016-05-04 19:00:00	AAPL	Stock	23.6	23.6	23.575	23.59	28712.0
2016-05-04 19:30:00	AAPL	Stock	23.5975	23.62	23.5875	23.595	16984.0
2016-05-04 07:00:00	MSFT	Stock	49.54	49.56	49.48	49.55	3578.0
2016-05-04 07:30:00	MSFT	Stock	49.52	49.55	49.5	49.55	2900.0
2016-05-04 08:00:00	MSFT	Stock	49.54	49.92	49.48	49.55	16101.0
2016-05-04 08:30:00	MSFT	Stock	49.58	49.6	49.58	49.6	5215.0
2016-05-04 09:00:00	MSFT	Stock	49.64	49.94	49.58	49.92	56908.0
2016-05-04 09:30:00	MSFT	Stock	49.91	49.92	49.46	49.75	2860217.0
2016-05-04 10:00:00	MSFT	Stock	49.74	49.91	49.62	49.905	1579083.0
2016-05-04 10:30:00	MSFT	Stock	49.905	49.995	49.8	49.83	1869651.0
2016-05-04 11:00:00	MSFT	Stock	49.835	49.9	49.69	49.76	1094916.0
2016-05-04 11:30:00	MSFT	Stock	49.76	49.96	49.71	49.95	1249111.0
2016-05-04 12:00:00	MSFT	Stock	49.942	50.06	49.88	50.006	1333599.0
2016-05-04 12:30:00	MSFT	Stock	50.0	50.02	49.95	49.975	1099190.0
2016-05-04 13:00:00	MSFT	Stock	49.975	50.05	49.89	49.97	1365740.0
2016-05-04 13:30:00	MSFT	Stock	49.97	49.99	49.87	49.875	1163296.0
2016-05-04 14:00:00	MSFT	Stock	49.88	49.945	49.8	49.895	1052746.0
2016-05-04 14:30:00	MSFT	Stock	49.89	49.985	49.815	49.849	1185772.0
2016-05-04 15:00:00	MSFT	Stock	49.84	49.94	49.78	49.875	1166552.0
2016-05-04 15:30:00	MSFT	Stock	49.87	50.01	49.85	49.87	2797431.0

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

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