PREVIEW / stock_30min / 2019-01-17

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-17.parquet
  size:    1.7 MB
  rows:    83,836
  symbols: 2,683

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-01-17 04:00:00	AAPL	Stock	38.5	38.5	38.4375	38.475	17352.0
2019-01-17 04:30:00	AAPL	Stock	38.475	38.48	38.4	38.4	10688.0
2019-01-17 05:00:00	AAPL	Stock	38.4	38.4	38.4	38.4	400.0
2019-01-17 05:30:00	AAPL	Stock	38.425	38.425	38.4225	38.425	5112.0
2019-01-17 06:00:00	AAPL	Stock	38.425	38.45	38.4175	38.45	10752.0
2019-01-17 06:30:00	AAPL	Stock	38.48	38.48	38.425	38.45	21924.0
2019-01-17 07:00:00	AAPL	Stock	38.48	38.5025	38.425	38.46	35736.0
2019-01-17 07:30:00	AAPL	Stock	38.465	38.525	38.45	38.485	33416.0
2019-01-17 08:00:00	AAPL	Stock	38.735	38.735	38.425	38.525	284052.0
2019-01-17 08:30:00	AAPL	Stock	38.5125	38.625	38.5075	38.5475	122664.0
2019-01-17 09:00:00	AAPL	Stock	38.5475	38.735	38.5275	38.56	74576.0
2019-01-17 09:30:00	AAPL	Stock	38.555	38.58	38.315	38.4308	13719724.0
2019-01-17 10:00:00	AAPL	Stock	38.433	38.5525	38.3675	38.4808	8353160.0
2019-01-17 10:30:00	AAPL	Stock	38.4825	38.5125	38.365	38.47	4812136.0
2019-01-17 11:00:00	AAPL	Stock	38.47	38.535	38.4012	38.465	4014568.0
2019-01-17 11:30:00	AAPL	Stock	38.4662	38.6575	38.455	38.5375	4762044.0
2019-01-17 12:00:00	AAPL	Stock	38.5375	38.5725	38.4938	38.565	2900248.0
2019-01-17 12:30:00	AAPL	Stock	38.5675	38.65	38.525	38.5668	3187572.0
2019-01-17 13:00:00	AAPL	Stock	38.5675	38.715	38.5675	38.6625	3721076.0
2019-01-17 13:30:00	AAPL	Stock	38.6675	38.7175	38.6325	38.6575	2680976.0
2019-01-17 14:00:00	AAPL	Stock	38.655	38.7025	38.59	38.5942	2806076.0
2019-01-17 14:30:00	AAPL	Stock	38.59	39.415	38.515	38.9425	26987816.0
2019-01-17 15:00:00	AAPL	Stock	38.945	38.9625	38.77	38.9335	9334836.0
2019-01-17 15:30:00	AAPL	Stock	38.9325	38.9675	38.825	38.965	11240776.0
2019-01-17 16:00:00	AAPL	Stock	38.965	38.975	38.75	38.875	7607116.0
2019-01-17 16:30:00	AAPL	Stock	38.89	38.97	38.83	38.9575	57972.0
2019-01-17 17:00:00	AAPL	Stock	38.9575	38.9625	38.9	38.905	50352.0
2019-01-17 17:30:00	AAPL	Stock	38.925	38.965	38.9	38.95	23368.0
2019-01-17 18:00:00	AAPL	Stock	38.95	38.9525	38.9125	38.95	39632.0
2019-01-17 18:30:00	AAPL	Stock	38.955	38.96	38.925	38.95	35180.0
2019-01-17 19:00:00	AAPL	Stock	38.9525	39.0	38.95	39.0	29404.0
2019-01-17 19:30:00	AAPL	Stock	39.0	39.1225	38.98	39.0	79364.0
2019-01-17 04:30:00	MSFT	Stock	104.75	104.75	104.75	104.75	100.0
2019-01-17 05:00:00	MSFT	Stock	104.55	104.73	104.55	104.73	200.0
2019-01-17 07:00:00	MSFT	Stock	105.0	105.0	104.75	104.83	2561.0
2019-01-17 07:30:00	MSFT	Stock	104.81	104.83	104.81	104.83	228.0
2019-01-17 08:00:00	MSFT	Stock	105.38	105.38	104.73	105.01	46049.0
2019-01-17 08:30:00	MSFT	Stock	105.13	105.2	105.05	105.18	5771.0
2019-01-17 09:00:00	MSFT	Stock	105.2	105.38	105.0	105.06	15291.0
2019-01-17 09:30:00	MSFT	Stock	105.0	106.08	104.76	106.02	2872508.0
2019-01-17 10:00:00	MSFT	Stock	106.028	106.129	105.03	105.44	2386380.0
2019-01-17 10:30:00	MSFT	Stock	105.44	105.5	105.09	105.365	1426959.0
2019-01-17 11:00:00	MSFT	Stock	105.37	105.54	105.34	105.353	1223812.0
2019-01-17 11:30:00	MSFT	Stock	105.35	105.53	105.3	105.505	1000661.0
2019-01-17 12:00:00	MSFT	Stock	105.505	105.73	105.39	105.51	898925.0
2019-01-17 12:30:00	MSFT	Stock	105.51	105.64	105.24	105.32	895010.0
2019-01-17 13:00:00	MSFT	Stock	105.32	105.549	105.3	105.499	849237.0
2019-01-17 13:30:00	MSFT	Stock	105.495	105.575	105.35	105.56	704358.0
2019-01-17 14:00:00	MSFT	Stock	105.55	105.57	105.38	105.47	673850.0
2019-01-17 14:30:00	MSFT	Stock	105.47	106.625	105.35	105.91	3398915.0

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

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