PREVIEW / stock_30min / 2019-03-29

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-29.parquet
  size:    1.7 MB
  rows:    86,094
  symbols: 2,654

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
2019-03-29 04:00:00	AAPL	Stock	47.47	47.5	47.415	47.415	14400.0
2019-03-29 04:30:00	AAPL	Stock	47.4475	47.4475	47.36	47.36	4684.0
2019-03-29 05:00:00	AAPL	Stock	47.375	47.375	47.375	47.375	2800.0
2019-03-29 05:30:00	AAPL	Stock	47.415	47.425	47.415	47.425	3200.0
2019-03-29 06:00:00	AAPL	Stock	47.3775	47.3775	47.3	47.3	6320.0
2019-03-29 06:30:00	AAPL	Stock	47.3	47.4225	47.3	47.4225	4144.0
2019-03-29 07:00:00	AAPL	Stock	47.3775	47.5	47.3775	47.4525	83108.0
2019-03-29 07:30:00	AAPL	Stock	47.47	47.4875	47.4625	47.4875	42100.0
2019-03-29 08:00:00	AAPL	Stock	47.4372	47.525	47.3	47.4825	317372.0
2019-03-29 08:30:00	AAPL	Stock	47.475	47.525	47.45	47.5	158552.0
2019-03-29 09:00:00	AAPL	Stock	47.5	47.585	47.4525	47.4525	252100.0
2019-03-29 09:30:00	AAPL	Stock	47.4875	47.52	47.195	47.305	10018900.0
2019-03-29 10:00:00	AAPL	Stock	47.305	47.43	47.27	47.4025	6731840.0
2019-03-29 10:30:00	AAPL	Stock	47.4	47.4075	47.135	47.1975	5827096.0
2019-03-29 11:00:00	AAPL	Stock	47.195	47.31	47.1775	47.2875	3908152.0
2019-03-29 11:30:00	AAPL	Stock	47.2875	47.3998	47.27	47.3425	4857744.0
2019-03-29 12:00:00	AAPL	Stock	47.3425	47.3575	47.2375	47.315	3575672.0
2019-03-29 12:30:00	AAPL	Stock	47.315	47.3525	47.25	47.33	2551856.0
2019-03-29 13:00:00	AAPL	Stock	47.3325	47.34	47.2725	47.2975	2119196.0
2019-03-29 13:30:00	AAPL	Stock	47.295	47.3575	47.2775	47.3162	2382400.0
2019-03-29 14:00:00	AAPL	Stock	47.319	47.385	47.285	47.3775	2612556.0
2019-03-29 14:30:00	AAPL	Stock	47.38	47.46	47.325	47.456	3924768.0
2019-03-29 15:00:00	AAPL	Stock	47.4575	47.485	47.3175	47.3475	4697260.0
2019-03-29 15:30:00	AAPL	Stock	47.3475	47.5	47.33	47.485	13484256.0
2019-03-29 16:00:00	AAPL	Stock	47.4875	47.5125	47.3875	47.5025	14839052.0
2019-03-29 16:30:00	AAPL	Stock	47.5	47.52	47.4875	47.51	1427588.0
2019-03-29 17:00:00	AAPL	Stock	47.51	47.5175	47.5025	47.5025	60232.0
2019-03-29 17:30:00	AAPL	Stock	47.5025	47.5175	47.4775	47.5	7940.0
2019-03-29 18:00:00	AAPL	Stock	47.49	47.49	47.49	47.49	1284.0
2019-03-29 18:30:00	AAPL	Stock	47.4875	47.49	47.4875	47.4875	2572.0
2019-03-29 19:00:00	AAPL	Stock	47.5	47.5125	47.49	47.5125	11584.0
2019-03-29 19:30:00	AAPL	Stock	47.5025	47.5375	47.4875	47.515	38560.0
2019-03-29 04:00:00	MSFT	Stock	117.5	117.5	117.5	117.5	170.0
2019-03-29 04:30:00	MSFT	Stock	117.34	117.34	117.01	117.01	3101.0
2019-03-29 05:30:00	MSFT	Stock	117.32	117.32	117.29	117.29	200.0
2019-03-29 06:00:00	MSFT	Stock	117.05	117.05	117.0	117.0	2096.0
2019-03-29 06:30:00	MSFT	Stock	117.2	117.3	117.2	117.3	702.0
2019-03-29 07:00:00	MSFT	Stock	117.22	117.6	117.2	117.51	11870.0
2019-03-29 07:30:00	MSFT	Stock	117.48	117.53	117.45	117.53	1074.0
2019-03-29 08:00:00	MSFT	Stock	117.598	117.598	117.35	117.57	17889.0
2019-03-29 08:30:00	MSFT	Stock	117.58	117.75	117.42	117.75	15806.0
2019-03-29 09:00:00	MSFT	Stock	117.65	118.05	117.61	118.04	23864.0
2019-03-29 09:30:00	MSFT	Stock	118.04	118.32	117.22	117.41	1971600.0
2019-03-29 10:00:00	MSFT	Stock	117.42	117.84	117.32	117.83	843746.0
2019-03-29 10:30:00	MSFT	Stock	117.84	117.849	116.96	117.15	1217174.0
2019-03-29 11:00:00	MSFT	Stock	117.15	117.53	117.13	117.515	1069159.0
2019-03-29 11:30:00	MSFT	Stock	117.52	117.72	117.45	117.48	837385.0
2019-03-29 12:00:00	MSFT	Stock	117.47	117.57	117.185	117.55	811752.0
2019-03-29 12:30:00	MSFT	Stock	117.552	117.65	117.32	117.48	620843.0
2019-03-29 13:00:00	MSFT	Stock	117.48	117.51	117.34	117.375	537217.0

> showing 50 of 86,094 rows — these rows as CSV

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