PREVIEW / stock_30min / 2017-07-27

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-27.parquet
  size:    1.6 MB
  rows:    80,948
  symbols: 3,001

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-07-27 04:00:00	AAPL	Stock	38.4975	38.5025	38.4975	38.5025	2800.0
2017-07-27 04:30:00	AAPL	Stock	38.5125	38.55	38.5025	38.55	14760.0
2017-07-27 05:00:00	AAPL	Stock	38.555	38.555	38.555	38.555	456.0
2017-07-27 05:30:00	AAPL	Stock	38.55	38.55	38.5375	38.5375	1024.0
2017-07-27 06:00:00	AAPL	Stock	38.5125	38.53	38.5	38.53	3348.0
2017-07-27 06:30:00	AAPL	Stock	38.5025	38.535	38.5025	38.535	13160.0
2017-07-27 07:00:00	AAPL	Stock	38.505	38.5125	38.485	38.5025	37444.0
2017-07-27 07:30:00	AAPL	Stock	38.5125	38.53	38.4975	38.5025	30632.0
2017-07-27 08:00:00	AAPL	Stock	38.5125	38.53	38.5	38.5	185928.0
2017-07-27 08:30:00	AAPL	Stock	38.5125	38.57	38.51	38.555	85852.0
2017-07-27 09:00:00	AAPL	Stock	38.5575	38.5975	38.4425	38.4425	368752.0
2017-07-27 09:30:00	AAPL	Stock	38.445	38.4975	38.2275	38.2522	12338308.0
2017-07-27 10:00:00	AAPL	Stock	38.2562	38.4125	38.2425	38.4012	5188828.0
2017-07-27 10:30:00	AAPL	Stock	38.4	38.4712	38.3825	38.3825	4397904.0
2017-07-27 11:00:00	AAPL	Stock	38.385	38.395	38.2825	38.3198	4217608.0
2017-07-27 11:30:00	AAPL	Stock	38.3175	38.375	38.3125	38.33	2649272.0
2017-07-27 12:00:00	AAPL	Stock	38.3275	38.3462	38.27	38.2925	2651152.0
2017-07-27 12:30:00	AAPL	Stock	38.2925	38.305	37.59	37.69	11318792.0
2017-07-27 13:00:00	AAPL	Stock	37.69	37.8222	37.1675	37.3175	17441020.0
2017-07-27 13:30:00	AAPL	Stock	37.3225	37.4675	36.825	37.3888	16834528.0
2017-07-27 14:00:00	AAPL	Stock	37.39	37.5175	37.2725	37.47	8703140.0
2017-07-27 14:30:00	AAPL	Stock	37.47	37.5175	37.3125	37.505	5788444.0
2017-07-27 15:00:00	AAPL	Stock	37.505	37.5175	37.3875	37.4925	5976268.0
2017-07-27 15:30:00	AAPL	Stock	37.495	37.6575	37.4675	37.6375	12548180.0
2017-07-27 16:00:00	AAPL	Stock	37.64	37.64	37.55	37.6	8519004.0
2017-07-27 16:30:00	AAPL	Stock	37.5625	37.64	37.5625	37.6075	184236.0
2017-07-27 17:00:00	AAPL	Stock	37.6025	37.64	37.5625	37.59	127800.0
2017-07-27 17:30:00	AAPL	Stock	37.5775	37.595	37.57	37.57	14672.0
2017-07-27 18:00:00	AAPL	Stock	37.6	37.6	37.46	37.4975	44628.0
2017-07-27 18:30:00	AAPL	Stock	37.475	37.55	37.46	37.5025	22624.0
2017-07-27 19:00:00	AAPL	Stock	37.5125	37.5375	37.5125	37.5375	11744.0
2017-07-27 19:30:00	AAPL	Stock	37.5125	37.535	37.4975	37.5	14140.0
2017-07-27 04:00:00	MSFT	Stock	74.12	74.22	74.12	74.21	1128.0
2017-07-27 06:00:00	MSFT	Stock	74.2	74.2	74.2	74.2	600.0
2017-07-27 07:00:00	MSFT	Stock	74.2	74.2	73.9	74.0	2234.0
2017-07-27 07:30:00	MSFT	Stock	74.0	74.03	73.89	73.9	15480.0
2017-07-27 08:00:00	MSFT	Stock	73.9	73.9	73.8	73.9	20632.0
2017-07-27 08:30:00	MSFT	Stock	73.9	73.9	73.7	73.73	22316.0
2017-07-27 09:00:00	MSFT	Stock	73.75	74.01	73.73	73.76	23836.0
2017-07-27 09:30:00	MSFT	Stock	73.76	74.13	73.53	74.016	3228347.0
2017-07-27 10:00:00	MSFT	Stock	74.014	74.155	73.965	74.15	1295468.0
2017-07-27 10:30:00	MSFT	Stock	74.15	74.22	74.09	74.17	1151474.0
2017-07-27 11:00:00	MSFT	Stock	74.17	74.27	74.02	74.255	1480733.0
2017-07-27 11:30:00	MSFT	Stock	74.25	74.42	74.19	74.22	801290.0
2017-07-27 12:00:00	MSFT	Stock	74.215	74.22	74.02	74.03	1181971.0
2017-07-27 12:30:00	MSFT	Stock	74.04	74.09	73.38	73.58	2399754.0
2017-07-27 13:00:00	MSFT	Stock	73.58	73.64	72.62	72.91	2322656.0
2017-07-27 13:30:00	MSFT	Stock	72.92	73.02	72.51	72.735	3112864.0
2017-07-27 14:00:00	MSFT	Stock	72.74	72.91	72.32	72.821	2817643.0
2017-07-27 14:30:00	MSFT	Stock	72.83	72.85	72.48	72.76	1857231.0

> showing 50 of 80,948 rows — these rows as CSV

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