PREVIEW / stock_30min / 2018-03-29

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-29.parquet
  size:    1.6 MB
  rows:    83,038
  symbols: 2,890

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
2018-03-29 04:00:00	AAPL	Stock	41.95	41.95	41.87	41.87	3520.0
2018-03-29 04:30:00	AAPL	Stock	41.875	41.875	41.87	41.87	2400.0
2018-03-29 05:00:00	AAPL	Stock	41.9225	41.925	41.9	41.925	9220.0
2018-03-29 05:30:00	AAPL	Stock	41.9125	41.9725	41.9125	41.9725	2800.0
2018-03-29 06:00:00	AAPL	Stock	42.0175	42.0175	42.0175	42.0175	400.0
2018-03-29 06:30:00	AAPL	Stock	41.9325	41.9625	41.9325	41.9625	1800.0
2018-03-29 07:00:00	AAPL	Stock	41.875	41.96	41.7775	41.88	94116.0
2018-03-29 07:30:00	AAPL	Stock	41.89	42.0375	41.885	41.995	134420.0
2018-03-29 08:00:00	AAPL	Stock	42.0125	42.0375	41.9	41.97	244144.0
2018-03-29 08:30:00	AAPL	Stock	41.98	42.0225	41.89	41.99	273580.0
2018-03-29 09:00:00	AAPL	Stock	41.9625	42.03	41.9375	42.0175	160468.0
2018-03-29 09:30:00	AAPL	Stock	42.0075	42.2025	41.7325	41.813	13646376.0
2018-03-29 10:00:00	AAPL	Stock	41.815	42.14	41.725	42.1175	8782020.0
2018-03-29 10:30:00	AAPL	Stock	42.12	42.5975	42.0975	42.5875	9508920.0
2018-03-29 11:00:00	AAPL	Stock	42.5875	42.6575	42.3605	42.4525	8411256.0
2018-03-29 11:30:00	AAPL	Stock	42.4525	42.47	42.275	42.4487	4858152.0
2018-03-29 12:00:00	AAPL	Stock	42.45	42.5125	42.27	42.5118	4455060.0
2018-03-29 12:30:00	AAPL	Stock	42.515	42.55	42.38	42.5125	4105488.0
2018-03-29 13:00:00	AAPL	Stock	42.51	42.555	42.3075	42.5245	3389240.0
2018-03-29 13:30:00	AAPL	Stock	42.5272	42.7475	42.48	42.673	4991148.0
2018-03-29 14:00:00	AAPL	Stock	42.6718	42.75	42.565	42.6987	4593724.0
2018-03-29 14:30:00	AAPL	Stock	42.6987	42.895	42.6862	42.8325	5773300.0
2018-03-29 15:00:00	AAPL	Stock	42.8375	42.9375	42.5625	42.6875	7207280.0
2018-03-29 15:30:00	AAPL	Stock	42.685	42.735	41.9725	41.9775	23521656.0
2018-03-29 16:00:00	AAPL	Stock	41.9725	42.1225	41.9125	42.0	25700336.0
2018-03-29 16:30:00	AAPL	Stock	42.0	42.0575	41.945	42.045	557120.0
2018-03-29 17:00:00	AAPL	Stock	42.0475	42.085	42.04	42.0625	282028.0
2018-03-29 17:30:00	AAPL	Stock	42.0625	42.1	42.05	42.0725	109884.0
2018-03-29 18:00:00	AAPL	Stock	42.0725	42.1125	42.0725	42.085	173360.0
2018-03-29 18:30:00	AAPL	Stock	42.075	42.12	42.075	42.1	40576.0
2018-03-29 19:00:00	AAPL	Stock	42.07	42.0975	42.045	42.075	23732.0
2018-03-29 19:30:00	AAPL	Stock	42.05	42.0625	42.0425	42.0425	55720.0
2018-03-29 04:30:00	MSFT	Stock	90.1	90.3	90.1	90.3	1138.0
2018-03-29 05:00:00	MSFT	Stock	90.35	90.35	90.02	90.02	424.0
2018-03-29 06:00:00	MSFT	Stock	90.24	90.24	90.24	90.24	200.0
2018-03-29 06:30:00	MSFT	Stock	90.18	90.18	90.1	90.15	1050.0
2018-03-29 07:00:00	MSFT	Stock	90.1	90.25	90.1	90.23	6474.0
2018-03-29 07:30:00	MSFT	Stock	90.2	90.39	90.1	90.22	15022.0
2018-03-29 08:00:00	MSFT	Stock	90.3	90.46	89.99	90.2	85038.0
2018-03-29 08:30:00	MSFT	Stock	90.23	90.48	90.19	90.32	27423.0
2018-03-29 09:00:00	MSFT	Stock	90.25	90.38	90.18	90.18	30771.0
2018-03-29 09:30:00	MSFT	Stock	90.18	90.37	88.4	88.66	4741820.0
2018-03-29 10:00:00	MSFT	Stock	88.665	89.31	88.49	89.08	3372116.0
2018-03-29 10:30:00	MSFT	Stock	89.075	90.36	88.99	90.355	4063431.0
2018-03-29 11:00:00	MSFT	Stock	90.35	90.58	89.79	89.89	3218346.0
2018-03-29 11:30:00	MSFT	Stock	89.89	90.16	89.61	90.09	1675640.0
2018-03-29 12:00:00	MSFT	Stock	90.095	90.26	89.63	90.25	1617763.0
2018-03-29 12:30:00	MSFT	Stock	90.26	90.725	90.09	90.48	1451592.0
2018-03-29 13:00:00	MSFT	Stock	90.49	90.61	90.06	90.57	1113933.0
2018-03-29 13:30:00	MSFT	Stock	90.57	91.42	90.47	91.27	1700704.0

> showing 50 of 83,038 rows — these rows as CSV

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