PREVIEW / stock_30min / 2017-06-27

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-27.parquet
  size:    1.6 MB
  rows:    81,746
  symbols: 3,013

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-06-27 04:00:00	AAPL	Stock	36.3025	36.305	36.265	36.265	5460.0
2017-06-27 04:30:00	AAPL	Stock	36.285	36.285	36.285	36.285	2000.0
2017-06-27 05:00:00	AAPL	Stock	36.285	36.285	36.235	36.235	6196.0
2017-06-27 05:30:00	AAPL	Stock	36.325	36.325	36.225	36.225	16800.0
2017-06-27 06:00:00	AAPL	Stock	36.2	36.205	36.185	36.205	23732.0
2017-06-27 06:30:00	AAPL	Stock	36.2075	36.25	36.2075	36.2475	25200.0
2017-06-27 07:00:00	AAPL	Stock	36.25	36.2825	36.2325	36.2475	76476.0
2017-06-27 07:30:00	AAPL	Stock	36.255	36.325	36.255	36.305	39160.0
2017-06-27 08:00:00	AAPL	Stock	36.3125	36.3575	36.25	36.33	129628.0
2017-06-27 08:30:00	AAPL	Stock	36.345	36.3625	36.265	36.31	87696.0
2017-06-27 09:00:00	AAPL	Stock	36.2975	36.3125	36.25	36.255	109192.0
2017-06-27 09:30:00	AAPL	Stock	36.2525	36.4148	36.1925	36.325	11685060.0
2017-06-27 10:00:00	AAPL	Stock	36.325	36.5225	36.3125	36.385	6558260.0
2017-06-27 10:30:00	AAPL	Stock	36.3875	36.54	36.3875	36.4575	3943304.0
2017-06-27 11:00:00	AAPL	Stock	36.4575	36.5	36.4025	36.42	3570864.0
2017-06-27 11:30:00	AAPL	Stock	36.42	36.4575	36.3625	36.4075	2937428.0
2017-06-27 12:00:00	AAPL	Stock	36.4075	36.48	36.39	36.4425	2524264.0
2017-06-27 12:30:00	AAPL	Stock	36.4425	36.4425	36.235	36.2688	5829260.0
2017-06-27 13:00:00	AAPL	Stock	36.2688	36.295	36.1525	36.2725	5647356.0
2017-06-27 13:30:00	AAPL	Stock	36.275	36.2938	35.9875	36.1225	8710160.0
2017-06-27 14:00:00	AAPL	Stock	36.1225	36.165	36.0375	36.131	5670628.0
2017-06-27 14:30:00	AAPL	Stock	36.1325	36.17	36.0675	36.1425	4733428.0
2017-06-27 15:00:00	AAPL	Stock	36.1425	36.195	36.0425	36.09	6585448.0
2017-06-27 15:30:00	AAPL	Stock	36.0888	36.1155	35.905	35.945	14384424.0
2017-06-27 16:00:00	AAPL	Stock	35.9325	35.9875	35.9125	35.9475	7061784.0
2017-06-27 16:30:00	AAPL	Stock	35.9425	35.9575	35.875	35.9325	213624.0
2017-06-27 17:00:00	AAPL	Stock	35.935	35.9525	35.9125	35.9125	100004.0
2017-06-27 17:30:00	AAPL	Stock	35.945	35.945	35.9025	35.905	19352.0
2017-06-27 18:00:00	AAPL	Stock	35.905	35.9375	35.905	35.9125	21524.0
2017-06-27 18:30:00	AAPL	Stock	35.9125	35.9375	35.9125	35.9375	6200.0
2017-06-27 19:00:00	AAPL	Stock	35.925	35.9325	35.905	35.9325	6708.0
2017-06-27 19:30:00	AAPL	Stock	35.9	35.925	35.83	35.85	37356.0
2017-06-27 04:00:00	MSFT	Stock	70.53	70.53	70.45	70.45	2141.0
2017-06-27 07:00:00	MSFT	Stock	70.15	70.15	70.15	70.15	284.0
2017-06-27 07:30:00	MSFT	Stock	70.25	70.25	70.25	70.25	617.0
2017-06-27 08:00:00	MSFT	Stock	70.35	70.35	70.22	70.27	3799.0
2017-06-27 08:30:00	MSFT	Stock	70.27	70.31	70.16	70.16	2521.0
2017-06-27 09:00:00	MSFT	Stock	70.15	70.33	70.07	70.11	22420.0
2017-06-27 09:30:00	MSFT	Stock	70.11	70.16	69.81	69.86	2590600.0
2017-06-27 10:00:00	MSFT	Stock	69.85	70.11	69.81	69.825	1617122.0
2017-06-27 10:30:00	MSFT	Stock	69.83	70.08	69.825	70.04	1256067.0
2017-06-27 11:00:00	MSFT	Stock	70.04	70.18	69.94	69.961	1004419.0
2017-06-27 11:30:00	MSFT	Stock	69.96	70.17	69.96	70.015	881076.0
2017-06-27 12:00:00	MSFT	Stock	70.02	70.07	69.935	70.03	756332.0
2017-06-27 12:30:00	MSFT	Stock	70.03	70.04	69.67	69.749	1256800.0
2017-06-27 13:00:00	MSFT	Stock	69.75	69.81	69.585	69.71	1200789.0
2017-06-27 13:30:00	MSFT	Stock	69.72	69.75	69.325	69.41	2030939.0
2017-06-27 14:00:00	MSFT	Stock	69.41	69.662	69.21	69.6	1747323.0
2017-06-27 14:30:00	MSFT	Stock	69.6	69.69	69.51	69.53	920120.0
2017-06-27 15:00:00	MSFT	Stock	69.53	69.66	69.31	69.363	1439620.0

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

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