PREVIEW / stock_30min / 2019-07-22

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-22.parquet
  size:    1.7 MB
  rows:    83,045
  symbols: 2,594

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-07-22 04:00:00	AAPL	Stock	50.7725	50.875	50.7725	50.875	9300.0
2019-07-22 04:30:00	AAPL	Stock	50.875	50.9575	50.875	50.9575	2400.0
2019-07-22 05:00:00	AAPL	Stock	50.9975	51.1	50.9975	51.0025	16532.0
2019-07-22 05:30:00	AAPL	Stock	51.0375	51.0825	51.0225	51.05	15604.0
2019-07-22 06:00:00	AAPL	Stock	51.0825	51.0875	51.035	51.055	16036.0
2019-07-22 06:30:00	AAPL	Stock	51.05	51.0875	51.05	51.085	19884.0
2019-07-22 07:00:00	AAPL	Stock	51.0325	51.0425	50.8125	50.975	84340.0
2019-07-22 07:30:00	AAPL	Stock	50.96	50.995	50.8125	50.87	86416.0
2019-07-22 08:00:00	AAPL	Stock	51.045	51.045	50.8	50.9425	349640.0
2019-07-22 08:30:00	AAPL	Stock	50.945	50.985	50.9	50.9	109724.0
2019-07-22 09:00:00	AAPL	Stock	50.905	50.9725	50.8	50.9425	253788.0
2019-07-22 09:30:00	AAPL	Stock	50.9125	51.5675	50.9025	51.51	15814580.0
2019-07-22 10:00:00	AAPL	Stock	51.515	51.55	51.4025	51.5412	6228684.0
2019-07-22 10:30:00	AAPL	Stock	51.54	51.5712	51.4375	51.55	5610812.0
2019-07-22 11:00:00	AAPL	Stock	51.5513	51.595	51.46	51.495	4289824.0
2019-07-22 11:30:00	AAPL	Stock	51.4925	51.57	51.4725	51.565	3232836.0
2019-07-22 12:00:00	AAPL	Stock	51.565	51.61	51.5025	51.565	2940928.0
2019-07-22 12:30:00	AAPL	Stock	51.5675	51.5775	51.5075	51.5462	2294060.0
2019-07-22 13:00:00	AAPL	Stock	51.5462	51.5502	51.4675	51.507	2313024.0
2019-07-22 13:30:00	AAPL	Stock	51.505	51.59	51.5025	51.5625	2279408.0
2019-07-22 14:00:00	AAPL	Stock	51.5625	51.6088	51.545	51.5825	2295792.0
2019-07-22 14:30:00	AAPL	Stock	51.5825	51.625	51.535	51.6238	2625932.0
2019-07-22 15:00:00	AAPL	Stock	51.6225	51.7375	51.615	51.7075	5467952.0
2019-07-22 15:30:00	AAPL	Stock	51.7075	51.8075	51.6575	51.805	9020204.0
2019-07-22 16:00:00	AAPL	Stock	51.805	51.8475	51.765	51.805	9920832.0
2019-07-22 16:30:00	AAPL	Stock	51.82	51.875	51.805	51.81	348820.0
2019-07-22 17:00:00	AAPL	Stock	51.8425	51.95	51.815	51.905	60340.0
2019-07-22 17:30:00	AAPL	Stock	51.905	51.935	51.85	51.9125	48756.0
2019-07-22 18:00:00	AAPL	Stock	51.9125	51.9425	51.9125	51.925	27096.0
2019-07-22 18:30:00	AAPL	Stock	51.925	51.9375	51.915	51.93	43040.0
2019-07-22 19:00:00	AAPL	Stock	51.925	51.975	51.92	51.975	31328.0
2019-07-22 19:30:00	AAPL	Stock	51.975	52.0	51.93	52.0	39388.0
2019-07-22 04:00:00	MSFT	Stock	137.01	137.1	136.87	137.1	4748.0
2019-07-22 04:30:00	MSFT	Stock	137.19	137.23	137.19	137.23	761.0
2019-07-22 05:00:00	MSFT	Stock	137.2	137.2	137.0	137.0	1987.0
2019-07-22 05:30:00	MSFT	Stock	136.95	137.1	136.95	137.1	4298.0
2019-07-22 06:00:00	MSFT	Stock	137.09	137.19	137.09	137.19	900.0
2019-07-22 06:30:00	MSFT	Stock	137.15	137.27	137.15	137.15	2427.0
2019-07-22 07:00:00	MSFT	Stock	137.08	137.18	137.05	137.11	19484.0
2019-07-22 07:30:00	MSFT	Stock	137.06	137.1	136.9	136.98	15282.0
2019-07-22 08:00:00	MSFT	Stock	137.15	137.25	136.83	137.05	69689.0
2019-07-22 08:30:00	MSFT	Stock	137.09	137.15	136.97	137.05	20360.0
2019-07-22 09:00:00	MSFT	Stock	137.08	137.87	136.983	137.47	81313.0
2019-07-22 09:30:00	MSFT	Stock	137.39	138.75	137.33	138.67	4142547.0
2019-07-22 10:00:00	MSFT	Stock	138.67	139.19	138.53	138.812	2591347.0
2019-07-22 10:30:00	MSFT	Stock	138.83	139.1	138.31	138.4	1718655.0
2019-07-22 11:00:00	MSFT	Stock	138.4	138.51	138.14	138.355	1105993.0
2019-07-22 11:30:00	MSFT	Stock	138.354	138.64	138.215	138.595	928144.0
2019-07-22 12:00:00	MSFT	Stock	138.59	138.63	138.32	138.45	721228.0
2019-07-22 12:30:00	MSFT	Stock	138.46	138.55	138.31	138.375	584463.0

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

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