PREVIEW / stock_30min / 2019-10-08

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-08.parquet
  size:    1.7 MB
  rows:    82,298
  symbols: 2,499

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-08 04:00:00	AAPL	Stock	56.755	56.8125	56.755	56.79	9600.0
2019-10-08 04:30:00	AAPL	Stock	56.8675	56.885	56.8025	56.8325	13448.0
2019-10-08 05:00:00	AAPL	Stock	56.8675	56.8875	56.785	56.785	26028.0
2019-10-08 05:30:00	AAPL	Stock	56.785	56.785	56.7	56.75	22724.0
2019-10-08 06:00:00	AAPL	Stock	56.7175	56.7175	56.3675	56.445	48424.0
2019-10-08 06:30:00	AAPL	Stock	56.475	56.4825	56.4	56.46	21896.0
2019-10-08 07:00:00	AAPL	Stock	56.475	56.5	56.2275	56.32	241556.0
2019-10-08 07:30:00	AAPL	Stock	56.3175	56.5175	56.3175	56.405	65564.0
2019-10-08 08:00:00	AAPL	Stock	56.355	56.625	56.2225	56.395	174788.0
2019-10-08 08:30:00	AAPL	Stock	56.4	56.4	56.27	56.3675	169056.0
2019-10-08 09:00:00	AAPL	Stock	56.385	56.4825	56.35	56.4575	206516.0
2019-10-08 09:30:00	AAPL	Stock	56.47	56.805	56.3625	56.4575	13838872.0
2019-10-08 10:00:00	AAPL	Stock	56.4575	56.595	56.265	56.535	9162784.0
2019-10-08 10:30:00	AAPL	Stock	56.53	56.6212	56.375	56.565	7815752.0
2019-10-08 11:00:00	AAPL	Stock	56.5625	56.6562	56.39	56.4425	5166988.0
2019-10-08 11:30:00	AAPL	Stock	56.4475	56.5775	56.33	56.525	3928620.0
2019-10-08 12:00:00	AAPL	Stock	56.525	56.555	56.405	56.51	3177780.0
2019-10-08 12:30:00	AAPL	Stock	56.5125	56.87	56.46	56.6875	4188688.0
2019-10-08 13:00:00	AAPL	Stock	56.6875	56.7715	56.6325	56.741	2782500.0
2019-10-08 13:30:00	AAPL	Stock	56.7425	56.8725	56.68	56.7378	3767716.0
2019-10-08 14:00:00	AAPL	Stock	56.7375	56.7725	56.525	56.6475	3339816.0
2019-10-08 14:30:00	AAPL	Stock	56.645	57.015	56.2875	56.5675	8565348.0
2019-10-08 15:00:00	AAPL	Stock	56.5575	56.7225	56.325	56.505	5820112.0
2019-10-08 15:30:00	AAPL	Stock	56.5025	56.5625	56.0825	56.0975	10056404.0
2019-10-08 16:00:00	AAPL	Stock	56.1	56.1625	55.795	55.875	9804052.0
2019-10-08 16:30:00	AAPL	Stock	55.8025	56.1	55.785	56.0	173464.0
2019-10-08 17:00:00	AAPL	Stock	56.0	56.1	55.875	55.9125	206344.0
2019-10-08 17:30:00	AAPL	Stock	55.9225	55.995	55.9225	55.9775	45476.0
2019-10-08 18:00:00	AAPL	Stock	56.01	56.0525	55.9625	55.965	16128.0
2019-10-08 18:30:00	AAPL	Stock	56.0	56.0	55.9	55.9125	57960.0
2019-10-08 19:00:00	AAPL	Stock	55.9125	55.98	55.9	55.95	69584.0
2019-10-08 19:30:00	AAPL	Stock	55.9525	55.975	55.9075	55.925	46212.0
2019-10-08 04:00:00	MSFT	Stock	137.88	138.09	137.88	137.9	9868.0
2019-10-08 04:30:00	MSFT	Stock	138.18	138.18	138.18	138.18	100.0
2019-10-08 05:00:00	MSFT	Stock	138.05	138.13	137.91	137.91	400.0
2019-10-08 05:30:00	MSFT	Stock	137.8	137.81	137.8	137.8	700.0
2019-10-08 06:00:00	MSFT	Stock	137.81	137.81	137.2	137.44	13501.0
2019-10-08 06:30:00	MSFT	Stock	137.23	137.4	137.22	137.3	7345.0
2019-10-08 07:00:00	MSFT	Stock	137.47	137.47	136.75	137.25	20600.0
2019-10-08 07:30:00	MSFT	Stock	137.16	137.5	137.16	137.25	14312.0
2019-10-08 08:00:00	MSFT	Stock	137.0	137.5	136.82	137.16	38971.0
2019-10-08 08:30:00	MSFT	Stock	137.35	137.35	137.1	137.25	16055.0
2019-10-08 09:00:00	MSFT	Stock	137.25	137.4	137.08	137.1	35728.0
2019-10-08 09:30:00	MSFT	Stock	137.1	137.52	136.2	136.24	3034407.0
2019-10-08 10:00:00	MSFT	Stock	136.25	136.55	135.9	136.47	1839576.0
2019-10-08 10:30:00	MSFT	Stock	136.475	136.94	136.36	136.9	1603548.0
2019-10-08 11:00:00	MSFT	Stock	136.895	137.37	136.78	137.025	1442378.0
2019-10-08 11:30:00	MSFT	Stock	137.03	137.23	136.79	136.96	1054406.0
2019-10-08 12:00:00	MSFT	Stock	136.95	137.28	136.83	137.19	778897.0
2019-10-08 12:30:00	MSFT	Stock	137.2	137.73	137.0	137.3	901360.0

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

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