PREVIEW / stock_30min / 2018-11-19

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-19.parquet
  size:    1.7 MB
  rows:    83,742
  symbols: 2,764

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-11-19 04:00:00	AAPL	Stock	48.6775	48.7	48.0	48.0	43504.0
2018-11-19 04:30:00	AAPL	Stock	48.0225	48.06	47.8575	47.9	18552.0
2018-11-19 05:00:00	AAPL	Stock	47.9	47.9	47.875	47.8875	9304.0
2018-11-19 05:30:00	AAPL	Stock	47.8725	47.8725	47.62	47.62	23984.0
2018-11-19 06:00:00	AAPL	Stock	47.68	47.685	47.4325	47.5375	77788.0
2018-11-19 06:30:00	AAPL	Stock	47.5325	47.545	47.35	47.4425	56756.0
2018-11-19 07:00:00	AAPL	Stock	47.47	47.8	47.375	47.65	507512.0
2018-11-19 07:30:00	AAPL	Stock	47.6775	47.6775	47.5375	47.595	162884.0
2018-11-19 08:00:00	AAPL	Stock	47.595	47.7775	47.375	47.55	798824.0
2018-11-19 08:30:00	AAPL	Stock	47.56	47.58	47.395	47.4275	570044.0
2018-11-19 09:00:00	AAPL	Stock	47.45	47.5575	47.3625	47.4975	471496.0
2018-11-19 09:30:00	AAPL	Stock	47.4975	47.675	46.965	47.0455	24170404.0
2018-11-19 10:00:00	AAPL	Stock	47.035	47.0575	46.8025	46.955	12852740.0
2018-11-19 10:30:00	AAPL	Stock	46.9525	47.08	46.725	46.99	9930516.0
2018-11-19 11:00:00	AAPL	Stock	46.9875	47.05	46.565	46.651	9107052.0
2018-11-19 11:30:00	AAPL	Stock	46.645	46.7675	46.4075	46.561	9852704.0
2018-11-19 12:00:00	AAPL	Stock	46.5625	46.6875	46.42	46.655	7983332.0
2018-11-19 12:30:00	AAPL	Stock	46.65	46.765	46.5175	46.5425	5947588.0
2018-11-19 13:00:00	AAPL	Stock	46.5425	46.6562	46.4275	46.565	5893096.0
2018-11-19 13:30:00	AAPL	Stock	46.56	46.745	46.4475	46.5065	5348440.0
2018-11-19 14:00:00	AAPL	Stock	46.51	46.645	46.3775	46.615	5768944.0
2018-11-19 14:30:00	AAPL	Stock	46.6125	46.705	46.4975	46.6382	5367648.0
2018-11-19 15:00:00	AAPL	Stock	46.6325	46.7725	46.49	46.5338	7373180.0
2018-11-19 15:30:00	AAPL	Stock	46.5325	46.5775	46.2475	46.4625	17197816.0
2018-11-19 16:00:00	AAPL	Stock	46.465	46.5375	46.4425	46.4475	15452628.0
2018-11-19 16:30:00	AAPL	Stock	46.45	46.5	46.4425	46.5	556196.0
2018-11-19 17:00:00	AAPL	Stock	46.4625	46.475	46.405	46.425	46004.0
2018-11-19 17:30:00	AAPL	Stock	46.4075	46.425	46.1725	46.3375	144784.0
2018-11-19 18:00:00	AAPL	Stock	46.3125	46.465	46.1275	46.1625	129156.0
2018-11-19 18:30:00	AAPL	Stock	46.175	46.31	46.15	46.2625	89484.0
2018-11-19 19:00:00	AAPL	Stock	46.275	46.275	46.1575	46.2025	79508.0
2018-11-19 19:30:00	AAPL	Stock	46.225	46.25	46.18	46.225	52936.0
2018-11-19 04:00:00	MSFT	Stock	108.33	108.33	108.33	108.33	145.0
2018-11-19 07:00:00	MSFT	Stock	108.23	108.59	108.04	108.35	6700.0
2018-11-19 07:30:00	MSFT	Stock	108.35	108.45	108.2	108.3	9450.0
2018-11-19 08:00:00	MSFT	Stock	108.25	108.59	108.0	108.54	5025.0
2018-11-19 08:30:00	MSFT	Stock	108.43	108.43	107.9	107.9	19318.0
2018-11-19 09:00:00	MSFT	Stock	107.97	108.29	107.66	108.21	17323.0
2018-11-19 09:30:00	MSFT	Stock	108.27	108.56	106.83	107.14	2468148.0
2018-11-19 10:00:00	MSFT	Stock	107.14	107.202	105.14	105.29	3559516.0
2018-11-19 10:30:00	MSFT	Stock	105.29	105.85	104.79	105.815	3031960.0
2018-11-19 11:00:00	MSFT	Stock	105.81	105.94	104.963	105.02	2267907.0
2018-11-19 11:30:00	MSFT	Stock	105.01	105.18	104.51	104.88	2615246.0
2018-11-19 12:00:00	MSFT	Stock	104.85	104.98	104.295	104.47	2894924.0
2018-11-19 12:30:00	MSFT	Stock	104.465	104.63	104.08	104.26	1819341.0
2018-11-19 13:00:00	MSFT	Stock	104.265	104.42	103.69	103.97	2320230.0
2018-11-19 13:30:00	MSFT	Stock	103.98	104.6	103.55	104.09	2120575.0
2018-11-19 14:00:00	MSFT	Stock	104.085	104.2	103.69	104.03	2088846.0
2018-11-19 14:30:00	MSFT	Stock	104.025	104.57	103.89	104.46	1995721.0
2018-11-19 15:00:00	MSFT	Stock	104.465	105.09	104.29	104.69	2212287.0

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

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