PREVIEW / stock_30min / 2019-10-09

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-09.parquet
  size:    1.7 MB
  rows:    82,867
  symbols: 2,481

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-10-09 04:00:00	AAPL	Stock	56.25	56.375	56.25	56.375	51920.0
2019-10-09 04:30:00	AAPL	Stock	56.3625	56.4725	56.3625	56.425	16700.0
2019-10-09 05:00:00	AAPL	Stock	56.415	56.68	56.415	56.6375	47532.0
2019-10-09 05:30:00	AAPL	Stock	56.615	56.75	56.5775	56.75	41188.0
2019-10-09 06:00:00	AAPL	Stock	56.6425	56.75	56.6425	56.7375	13304.0
2019-10-09 06:30:00	AAPL	Stock	56.765	56.8375	56.7375	56.8075	26116.0
2019-10-09 07:00:00	AAPL	Stock	56.7575	56.83	56.6625	56.785	221524.0
2019-10-09 07:30:00	AAPL	Stock	56.775	56.8125	56.7	56.775	183340.0
2019-10-09 08:00:00	AAPL	Stock	56.704	56.8125	56.6625	56.7	350664.0
2019-10-09 08:30:00	AAPL	Stock	56.7125	56.77	56.6	56.69	200196.0
2019-10-09 09:00:00	AAPL	Stock	56.69	56.755	56.5875	56.755	190540.0
2019-10-09 09:30:00	AAPL	Stock	56.7575	56.8375	56.4675	56.55	10596864.0
2019-10-09 10:00:00	AAPL	Stock	56.555	56.67	56.46	56.585	4732076.0
2019-10-09 10:30:00	AAPL	Stock	56.5825	56.6088	56.4375	56.5075	3649916.0
2019-10-09 11:00:00	AAPL	Stock	56.515	56.55	56.41	56.4925	3787264.0
2019-10-09 11:30:00	AAPL	Stock	56.4925	56.7275	56.465	56.6782	4167532.0
2019-10-09 12:00:00	AAPL	Stock	56.6775	56.735	56.65	56.7	2240996.0
2019-10-09 12:30:00	AAPL	Stock	56.7025	56.813	56.6975	56.78	3610236.0
2019-10-09 13:00:00	AAPL	Stock	56.781	56.8775	56.6762	56.6988	3666008.0
2019-10-09 13:30:00	AAPL	Stock	56.7	56.775	56.6888	56.7125	1755692.0
2019-10-09 14:00:00	AAPL	Stock	56.715	56.7825	56.6525	56.742	2009392.0
2019-10-09 14:30:00	AAPL	Stock	56.745	56.905	56.7388	56.8275	2911344.0
2019-10-09 15:00:00	AAPL	Stock	56.8225	56.9225	56.8075	56.8675	3502252.0
2019-10-09 15:30:00	AAPL	Stock	56.865	56.9475	56.6725	56.75	10190856.0
2019-10-09 16:00:00	AAPL	Stock	56.7575	56.775	56.68	56.7575	4939864.0
2019-10-09 16:30:00	AAPL	Stock	56.7575	56.8	56.6875	56.7725	118980.0
2019-10-09 17:00:00	AAPL	Stock	56.775	56.7875	56.7625	56.785	14084.0
2019-10-09 17:30:00	AAPL	Stock	56.7575	56.775	56.75	56.77	12172.0
2019-10-09 18:00:00	AAPL	Stock	56.775	56.8025	55.96	55.96	193768.0
2019-10-09 18:30:00	AAPL	Stock	55.9625	56.1925	55.7825	55.8175	327548.0
2019-10-09 19:00:00	AAPL	Stock	55.815	56.0	55.805	55.9875	166564.0
2019-10-09 19:30:00	AAPL	Stock	55.9825	56.1	55.975	56.075	177608.0
2019-10-09 05:00:00	MSFT	Stock	136.58	137.56	136.58	136.9	1234.0
2019-10-09 05:30:00	MSFT	Stock	137.07	137.57	136.72	137.39	4307.0
2019-10-09 06:00:00	MSFT	Stock	137.47	137.5	137.06	137.3	5905.0
2019-10-09 06:30:00	MSFT	Stock	137.39	137.39	137.2	137.28	900.0
2019-10-09 07:00:00	MSFT	Stock	137.21	137.21	136.8	137.01	37192.0
2019-10-09 07:30:00	MSFT	Stock	137.0	137.1	136.9	137.05	14703.0
2019-10-09 08:00:00	MSFT	Stock	137.0	137.2	136.81	136.93	32278.0
2019-10-09 08:30:00	MSFT	Stock	136.977	136.977	136.82	136.86	5970.0
2019-10-09 09:00:00	MSFT	Stock	136.93	137.5	136.61	137.5	44403.0
2019-10-09 09:30:00	MSFT	Stock	137.48	137.662	136.97	137.29	2388015.0
2019-10-09 10:00:00	MSFT	Stock	137.28	137.79	137.25	137.71	1298635.0
2019-10-09 10:30:00	MSFT	Stock	137.705	137.776	137.48	137.67	870416.0
2019-10-09 11:00:00	MSFT	Stock	137.68	137.74	137.26	137.42	908732.0
2019-10-09 11:30:00	MSFT	Stock	137.42	137.93	137.405	137.799	866716.0
2019-10-09 12:00:00	MSFT	Stock	137.8	137.93	137.74	137.86	540420.0
2019-10-09 12:30:00	MSFT	Stock	137.86	138.07	137.85	138.06	703535.0
2019-10-09 13:00:00	MSFT	Stock	138.06	138.276	137.95	138.03	968526.0
2019-10-09 13:30:00	MSFT	Stock	138.04	138.27	138.01	138.15	420214.0

> showing 50 of 82,867 rows — these rows as CSV

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