PREVIEW / stock_30min / 2017-12-28

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-28.parquet
  size:    1.6 MB
  rows:    82,911
  symbols: 2,920

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
2017-12-28 04:00:00	AAPL	Stock	42.69	42.7125	42.63	42.675	4668.0
2017-12-28 04:30:00	AAPL	Stock	42.6375	42.6375	42.6375	42.6375	400.0
2017-12-28 05:00:00	AAPL	Stock	42.6575	42.675	42.625	42.625	11856.0
2017-12-28 05:30:00	AAPL	Stock	42.6975	42.6975	42.6325	42.6325	1192.0
2017-12-28 06:00:00	AAPL	Stock	42.675	42.69	42.675	42.69	2100.0
2017-12-28 06:30:00	AAPL	Stock	42.7125	42.725	42.7125	42.725	4280.0
2017-12-28 07:00:00	AAPL	Stock	42.7225	42.7925	42.6825	42.77	92164.0
2017-12-28 07:30:00	AAPL	Stock	42.7725	42.7875	42.75	42.75	30616.0
2017-12-28 08:00:00	AAPL	Stock	42.745	42.7875	42.725	42.7375	73788.0
2017-12-28 08:30:00	AAPL	Stock	42.7375	42.7475	42.7	42.7375	131652.0
2017-12-28 09:00:00	AAPL	Stock	42.7375	42.7725	42.7	42.74	205948.0
2017-12-28 09:30:00	AAPL	Stock	42.75	42.9325	42.725	42.8875	12024684.0
2017-12-28 10:00:00	AAPL	Stock	42.8875	42.9625	42.8775	42.91	6116636.0
2017-12-28 10:30:00	AAPL	Stock	42.9075	42.915	42.8325	42.87	3751572.0
2017-12-28 11:00:00	AAPL	Stock	42.87	42.885	42.835	42.8475	2728016.0
2017-12-28 11:30:00	AAPL	Stock	42.845	42.8625	42.8075	42.8275	2570080.0
2017-12-28 12:00:00	AAPL	Stock	42.8275	42.8475	42.8025	42.82	2023248.0
2017-12-28 12:30:00	AAPL	Stock	42.8175	42.825	42.7525	42.7575	2537224.0
2017-12-28 13:00:00	AAPL	Stock	42.76	42.7625	42.7275	42.7325	2359052.0
2017-12-28 13:30:00	AAPL	Stock	42.731	42.7475	42.675	42.7088	2520132.0
2017-12-28 14:00:00	AAPL	Stock	42.7098	42.7175	42.6725	42.6875	2304800.0
2017-12-28 14:30:00	AAPL	Stock	42.6862	42.69	42.62	42.6338	2692540.0
2017-12-28 15:00:00	AAPL	Stock	42.6338	42.6775	42.625	42.656	2941696.0
2017-12-28 15:30:00	AAPL	Stock	42.6565	42.7675	42.6375	42.7675	8673532.0
2017-12-28 16:00:00	AAPL	Stock	42.765	42.77	42.6875	42.6975	5644612.0
2017-12-28 16:30:00	AAPL	Stock	42.695	42.7025	42.6875	42.6875	22888.0
2017-12-28 17:00:00	AAPL	Stock	42.7	42.71	42.6875	42.7	28652.0
2017-12-28 17:30:00	AAPL	Stock	42.7075	42.7075	42.6775	42.6875	29040.0
2017-12-28 18:00:00	AAPL	Stock	42.6875	42.725	42.6875	42.725	23080.0
2017-12-28 18:30:00	AAPL	Stock	42.7125	42.725	42.7125	42.715	5000.0
2017-12-28 19:00:00	AAPL	Stock	42.715	42.7225	42.7075	42.7225	16116.0
2017-12-28 19:30:00	AAPL	Stock	42.7125	42.7225	42.705	42.71	13952.0
2017-12-28 04:00:00	MSFT	Stock	86.02	86.02	86.02	86.02	200.0
2017-12-28 04:30:00	MSFT	Stock	86.02	86.02	86.02	86.02	100.0
2017-12-28 07:00:00	MSFT	Stock	85.95	85.95	85.95	85.95	935.0
2017-12-28 08:00:00	MSFT	Stock	85.95	85.95	85.9	85.95	1420.0
2017-12-28 08:30:00	MSFT	Stock	85.95	85.98	85.95	85.98	2916.0
2017-12-28 09:00:00	MSFT	Stock	85.9	86.0	85.9	85.94	4790.0
2017-12-28 09:30:00	MSFT	Stock	85.9	85.93	85.61	85.72	1367174.0
2017-12-28 10:00:00	MSFT	Stock	85.72	85.74	85.55	85.695	874106.0
2017-12-28 10:30:00	MSFT	Stock	85.7	85.76	85.66	85.725	438554.0
2017-12-28 11:00:00	MSFT	Stock	85.73	85.76	85.66	85.72	493693.0
2017-12-28 11:30:00	MSFT	Stock	85.724	85.724	85.61	85.655	389633.0
2017-12-28 12:00:00	MSFT	Stock	85.655	85.67	85.59	85.645	263081.0
2017-12-28 12:30:00	MSFT	Stock	85.64	85.656	85.58	85.62	298371.0
2017-12-28 13:00:00	MSFT	Stock	85.619	85.66	85.58	85.63	314758.0
2017-12-28 13:30:00	MSFT	Stock	85.635	85.68	85.566	85.68	350194.0
2017-12-28 14:00:00	MSFT	Stock	85.68	85.69	85.58	85.59	347622.0
2017-12-28 14:30:00	MSFT	Stock	85.585	85.67	85.57	85.645	406935.0
2017-12-28 15:00:00	MSFT	Stock	85.64	85.7	85.64	85.68	551551.0

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

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