PREVIEW / stock_30min / 2019-09-09

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-09.parquet
  size:    1.7 MB
  rows:    84,226
  symbols: 2,565

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-09-09 04:00:00	AAPL	Stock	53.425	53.425	53.3475	53.3475	2000.0
2019-09-09 04:30:00	AAPL	Stock	53.3975	53.45	53.3975	53.45	4652.0
2019-09-09 05:30:00	AAPL	Stock	53.415	53.45	53.415	53.45	1600.0
2019-09-09 06:00:00	AAPL	Stock	53.5325	53.575	53.5325	53.56	8784.0
2019-09-09 06:30:00	AAPL	Stock	53.55	53.55	53.55	53.55	640.0
2019-09-09 07:00:00	AAPL	Stock	53.5225	53.6	53.5	53.6	83448.0
2019-09-09 07:30:00	AAPL	Stock	53.575	53.64	53.575	53.585	61564.0
2019-09-09 08:00:00	AAPL	Stock	53.55	53.675	53.5	53.675	199376.0
2019-09-09 08:30:00	AAPL	Stock	53.6875	53.69	53.625	53.65	75656.0
2019-09-09 09:00:00	AAPL	Stock	53.6575	53.71	53.64	53.71	217664.0
2019-09-09 09:30:00	AAPL	Stock	53.715	54.01	53.6062	53.8038	15014732.0
2019-09-09 10:00:00	AAPL	Stock	53.8025	53.87	53.66	53.78	6167724.0
2019-09-09 10:30:00	AAPL	Stock	53.7825	53.8475	53.7275	53.83	4694604.0
2019-09-09 11:00:00	AAPL	Stock	53.8325	54.11	53.795	54.0975	5868340.0
2019-09-09 11:30:00	AAPL	Stock	54.095	54.095	53.9375	54.0838	3498516.0
2019-09-09 12:00:00	AAPL	Stock	54.085	54.095	53.34	53.6985	6246548.0
2019-09-09 12:30:00	AAPL	Stock	53.6975	53.83	53.5575	53.7825	6487644.0
2019-09-09 13:00:00	AAPL	Stock	53.7842	53.8	53.5375	53.5425	2773104.0
2019-09-09 13:30:00	AAPL	Stock	53.5422	53.695	53.4625	53.6425	4257548.0
2019-09-09 14:00:00	AAPL	Stock	53.6425	53.6425	53.4675	53.515	4194252.0
2019-09-09 14:30:00	AAPL	Stock	53.5175	53.625	53.4875	53.5712	3156888.0
2019-09-09 15:00:00	AAPL	Stock	53.5705	53.725	53.5125	53.635	3939836.0
2019-09-09 15:30:00	AAPL	Stock	53.6375	53.662	52.7675	53.5375	7696284.0
2019-09-09 16:00:00	AAPL	Stock	53.5425	53.59	53.5025	53.5175	9732636.0
2019-09-09 16:30:00	AAPL	Stock	53.5175	53.59	53.5125	53.55	83412.0
2019-09-09 17:00:00	AAPL	Stock	53.57	53.57	53.5425	53.5425	15036.0
2019-09-09 17:30:00	AAPL	Stock	53.5425	53.6048	53.5425	53.6048	14268.0
2019-09-09 18:00:00	AAPL	Stock	53.605	53.625	53.605	53.605	7592.0
2019-09-09 18:30:00	AAPL	Stock	53.65	53.65	53.625	53.645	5436.0
2019-09-09 19:00:00	AAPL	Stock	53.635	53.65	53.6125	53.6125	8120.0
2019-09-09 19:30:00	AAPL	Stock	53.6425	53.65	53.6325	53.6375	23612.0
2019-09-09 04:00:00	MSFT	Stock	139.55	139.55	139.5	139.5	250.0
2019-09-09 05:30:00	MSFT	Stock	139.6	139.6	139.6	139.6	391.0
2019-09-09 06:00:00	MSFT	Stock	139.6	139.7	139.6	139.7	2016.0
2019-09-09 06:30:00	MSFT	Stock	139.6	139.6	139.55	139.55	600.0
2019-09-09 07:00:00	MSFT	Stock	139.43	139.59	139.43	139.5	1163.0
2019-09-09 07:30:00	MSFT	Stock	139.59	139.6	139.43	139.5	5082.0
2019-09-09 08:00:00	MSFT	Stock	139.4	139.66	139.37	139.65	6493.0
2019-09-09 08:30:00	MSFT	Stock	139.75	139.75	139.557	139.7	8455.0
2019-09-09 09:00:00	MSFT	Stock	139.7	139.77	139.6	139.63	17126.0
2019-09-09 09:30:00	MSFT	Stock	139.59	139.75	137.27	137.46	3544249.0
2019-09-09 10:00:00	MSFT	Stock	137.45	137.77	137.01	137.32	3027044.0
2019-09-09 10:30:00	MSFT	Stock	137.32	138.05	137.26	138.01	1413375.0
2019-09-09 11:00:00	MSFT	Stock	138.0	138.1	137.63	137.95	905750.0
2019-09-09 11:30:00	MSFT	Stock	137.94	138.05	137.635	137.905	789798.0
2019-09-09 12:00:00	MSFT	Stock	137.91	137.97	137.03	137.09	1013198.0
2019-09-09 12:30:00	MSFT	Stock	137.08	137.14	136.63	137.094	1511642.0
2019-09-09 13:00:00	MSFT	Stock	137.09	137.179	136.6	136.7	609622.0
2019-09-09 13:30:00	MSFT	Stock	136.7	137.09	136.46	136.84	1017379.0
2019-09-09 14:00:00	MSFT	Stock	136.847	136.889	136.565	136.61	651213.0

> showing 50 of 84,226 rows — these rows as CSV

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