PREVIEW / stock_30min / 2016-06-01

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-01.parquet
  size:    1.6 MB
  rows:    82,203
  symbols: 3,303

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-01 04:00:00	AAPL	Stock	24.97	24.995	24.97	24.995	1360.0
2016-06-01 04:30:00	AAPL	Stock	24.9025	24.9025	24.825	24.875	5008.0
2016-06-01 05:00:00	AAPL	Stock	24.845	24.88	24.845	24.875	9672.0
2016-06-01 05:30:00	AAPL	Stock	24.85	24.85	24.8175	24.825	7200.0
2016-06-01 06:00:00	AAPL	Stock	24.8375	24.8425	24.7525	24.8425	19660.0
2016-06-01 06:30:00	AAPL	Stock	24.79	24.8425	24.79	24.815	17896.0
2016-06-01 07:00:00	AAPL	Stock	24.85	24.875	24.85	24.875	23036.0
2016-06-01 07:30:00	AAPL	Stock	24.875	24.9225	24.875	24.9225	34024.0
2016-06-01 08:00:00	AAPL	Stock	24.85	24.925	24.85	24.905	127880.0
2016-06-01 08:30:00	AAPL	Stock	24.9125	24.9125	24.8775	24.8775	78032.0
2016-06-01 09:00:00	AAPL	Stock	24.8875	24.89	24.745	24.7525	469080.0
2016-06-01 09:30:00	AAPL	Stock	24.755	24.873	24.69	24.7475	16900316.0
2016-06-01 10:00:00	AAPL	Stock	24.7475	24.8625	24.7175	24.7925	9712028.0
2016-06-01 10:30:00	AAPL	Stock	24.7925	24.8475	24.7575	24.826	6505132.0
2016-06-01 11:00:00	AAPL	Stock	24.8275	24.885	24.79	24.7902	8226044.0
2016-06-01 11:30:00	AAPL	Stock	24.79	24.805	24.72	24.7925	8237064.0
2016-06-01 12:00:00	AAPL	Stock	24.79	24.8025	24.765	24.78	4124572.0
2016-06-01 12:30:00	AAPL	Stock	24.7788	24.8065	24.7638	24.805	2998732.0
2016-06-01 13:00:00	AAPL	Stock	24.805	24.81	24.745	24.762	4129148.0
2016-06-01 13:30:00	AAPL	Stock	24.76	24.7738	24.7225	24.7475	4367552.0
2016-06-01 14:00:00	AAPL	Stock	24.75	24.795	24.725	24.7775	5243372.0
2016-06-01 14:30:00	AAPL	Stock	24.7775	24.7775	24.7275	24.7512	4291068.0
2016-06-01 15:00:00	AAPL	Stock	24.7525	24.7575	24.695	24.7075	6842992.0
2016-06-01 15:30:00	AAPL	Stock	24.71	24.71	24.5825	24.6125	20392120.0
2016-06-01 16:00:00	AAPL	Stock	24.615	24.784	24.6	24.6025	5739472.0
2016-06-01 16:30:00	AAPL	Stock	24.6025	24.6075	24.5775	24.595	26444.0
2016-06-01 17:00:00	AAPL	Stock	24.5925	24.595	24.5625	24.5875	69380.0
2016-06-01 17:30:00	AAPL	Stock	24.5825	24.615	24.57	24.57	21468.0
2016-06-01 18:00:00	AAPL	Stock	24.57	24.595	24.565	24.575	30756.0
2016-06-01 18:30:00	AAPL	Stock	24.5875	24.5875	24.5675	24.575	9460.0
2016-06-01 19:00:00	AAPL	Stock	24.575	24.585	24.565	24.5775	12644.0
2016-06-01 19:30:00	AAPL	Stock	24.575	24.585	24.575	24.575	22300.0
2016-06-01 04:00:00	MSFT	Stock	52.75	52.81	52.75	52.78	1699.0
2016-06-01 04:30:00	MSFT	Stock	52.61	52.61	52.6	52.6	400.0
2016-06-01 05:00:00	MSFT	Stock	52.73	52.73	52.73	52.73	100.0
2016-06-01 06:30:00	MSFT	Stock	52.51	52.51	52.51	52.51	1000.0
2016-06-01 07:30:00	MSFT	Stock	52.68	52.68	52.58	52.58	1875.0
2016-06-01 08:00:00	MSFT	Stock	52.6	53.0	52.55	53.0	3507.0
2016-06-01 08:30:00	MSFT	Stock	52.6	53.0	52.41	53.0	15371.0
2016-06-01 09:00:00	MSFT	Stock	52.6	52.6	52.5	52.5	670.0
2016-06-01 09:30:00	MSFT	Stock	52.44	52.76	52.44	52.702	2176546.0
2016-06-01 10:00:00	MSFT	Stock	52.685	52.88	52.67	52.78	1760682.0
2016-06-01 10:30:00	MSFT	Stock	52.78	52.9	52.735	52.87	1409569.0
2016-06-01 11:00:00	MSFT	Stock	52.87	52.95	52.69	52.7	1592955.0
2016-06-01 11:30:00	MSFT	Stock	52.69	52.74	52.59	52.685	1168536.0
2016-06-01 12:00:00	MSFT	Stock	52.69	52.77	52.67	52.69	954408.0
2016-06-01 12:30:00	MSFT	Stock	52.69	52.82	52.65	52.805	991648.0
2016-06-01 13:00:00	MSFT	Stock	52.805	52.83	52.652	52.67	670365.0
2016-06-01 13:30:00	MSFT	Stock	52.68	52.69	52.55	52.605	831293.0
2016-06-01 14:00:00	MSFT	Stock	52.6	52.89	52.54	52.86	1720509.0

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

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