PREVIEW / stock_30min / 2019-09-24

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-24.parquet
  size:    1.7 MB
  rows:    84,987
  symbols: 2,561

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-24 04:00:00	AAPL	Stock	54.975	55.075	54.95	55.075	10000.0
2019-09-24 04:30:00	AAPL	Stock	55.075	55.1675	55.0075	55.0825	28852.0
2019-09-24 05:00:00	AAPL	Stock	55.08	55.08	55.0375	55.0375	1600.0
2019-09-24 05:30:00	AAPL	Stock	55.08	55.115	55.075	55.1	13800.0
2019-09-24 06:00:00	AAPL	Stock	55.08	55.1	55.08	55.0875	22744.0
2019-09-24 06:30:00	AAPL	Stock	55.08	55.12	55.075	55.12	18568.0
2019-09-24 07:00:00	AAPL	Stock	55.08	55.205	55.08	55.185	88640.0
2019-09-24 07:30:00	AAPL	Stock	55.1625	55.1875	55.1375	55.16	81616.0
2019-09-24 08:00:00	AAPL	Stock	55.1675	55.2	55.125	55.1825	219396.0
2019-09-24 08:30:00	AAPL	Stock	55.15	55.225	55.1	55.2	221936.0
2019-09-24 09:00:00	AAPL	Stock	55.175	55.3225	55.17	55.29	454056.0
2019-09-24 09:30:00	AAPL	Stock	55.285	55.6225	55.18	55.47	15338856.0
2019-09-24 10:00:00	AAPL	Stock	55.4675	55.475	55.045	55.17	8927300.0
2019-09-24 10:30:00	AAPL	Stock	55.1775	55.2775	55.03	55.1725	4847240.0
2019-09-24 11:00:00	AAPL	Stock	55.1725	55.2248	54.98	55.08	5185504.0
2019-09-24 11:30:00	AAPL	Stock	55.0825	55.0925	54.6875	54.7875	6753684.0
2019-09-24 12:00:00	AAPL	Stock	54.78	54.9525	54.39	54.5435	6700248.0
2019-09-24 12:30:00	AAPL	Stock	54.535	54.6375	54.325	54.374	6430852.0
2019-09-24 13:00:00	AAPL	Stock	54.3725	54.5275	54.3028	54.31	4513260.0
2019-09-24 13:30:00	AAPL	Stock	54.31	54.57	54.2975	54.4275	4031736.0
2019-09-24 14:00:00	AAPL	Stock	54.43	54.925	54.3525	54.855	6569348.0
2019-09-24 14:30:00	AAPL	Stock	54.8575	54.875	54.54	54.5875	5022016.0
2019-09-24 15:00:00	AAPL	Stock	54.585	54.665	54.3948	54.4988	4620024.0
2019-09-24 15:30:00	AAPL	Stock	54.495	54.605	54.3875	54.42	9668248.0
2019-09-24 16:00:00	AAPL	Stock	54.42	54.51	54.415	54.4525	11701344.0
2019-09-24 16:30:00	AAPL	Stock	54.48	54.48	54.42	54.4625	34528.0
2019-09-24 17:00:00	AAPL	Stock	54.45	54.45	54.39	54.395	63956.0
2019-09-24 17:30:00	AAPL	Stock	54.4125	54.4625	54.39	54.4375	66744.0
2019-09-24 18:00:00	AAPL	Stock	54.4625	54.55	54.4125	54.515	46384.0
2019-09-24 18:30:00	AAPL	Stock	54.5175	54.5375	54.4775	54.5375	23512.0
2019-09-24 19:00:00	AAPL	Stock	54.525	54.5525	54.4875	54.5425	20764.0
2019-09-24 19:30:00	AAPL	Stock	54.54	54.615	54.525	54.575	33108.0
2019-09-24 04:00:00	MSFT	Stock	139.85	139.85	139.85	139.85	200.0
2019-09-24 04:30:00	MSFT	Stock	139.63	139.85	139.63	139.73	1587.0
2019-09-24 05:00:00	MSFT	Stock	139.82	139.82	139.82	139.82	207.0
2019-09-24 05:30:00	MSFT	Stock	139.97	139.97	139.95	139.95	200.0
2019-09-24 06:00:00	MSFT	Stock	139.78	139.89	139.55	139.63	874.0
2019-09-24 06:30:00	MSFT	Stock	139.8	139.84	139.8	139.84	299.0
2019-09-24 07:00:00	MSFT	Stock	139.9	139.95	139.82	139.82	10391.0
2019-09-24 07:30:00	MSFT	Stock	139.78	139.86	139.6	139.75	9127.0
2019-09-24 08:00:00	MSFT	Stock	139.94	139.94	139.6	139.61	17562.0
2019-09-24 08:30:00	MSFT	Stock	139.68	139.68	139.39	139.63	51311.0
2019-09-24 09:00:00	MSFT	Stock	139.51	140.35	139.39	139.91	54772.0
2019-09-24 09:30:00	MSFT	Stock	140.35	140.69	139.85	140.468	2794122.0
2019-09-24 10:00:00	MSFT	Stock	140.465	140.51	139.845	140.02	1792902.0
2019-09-24 10:30:00	MSFT	Stock	140.03	140.2	139.55	139.955	1202800.0
2019-09-24 11:00:00	MSFT	Stock	139.96	139.97	139.5	139.53	866057.0
2019-09-24 11:30:00	MSFT	Stock	139.547	139.555	138.44	138.717	1309967.0
2019-09-24 12:00:00	MSFT	Stock	138.7	138.965	137.48	137.731	1331638.0
2019-09-24 12:30:00	MSFT	Stock	137.73	137.86	137.12	137.21	2020674.0

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

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