PREVIEW / stock_30min / 2018-08-29

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-29.parquet
  size:    1.7 MB
  rows:    83,019
  symbols: 2,797

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
2018-08-29 04:00:00	AAPL	Stock	55.0625	55.125	55.015	55.015	9504.0
2018-08-29 04:30:00	AAPL	Stock	55.0575	55.075	55.05	55.05	7632.0
2018-08-29 05:00:00	AAPL	Stock	55.05	55.05	55.0375	55.05	16124.0
2018-08-29 05:30:00	AAPL	Stock	55.05	55.05	54.99	55.05	15124.0
2018-08-29 06:30:00	AAPL	Stock	55.0	55.0	54.9825	54.9825	1404.0
2018-08-29 07:00:00	AAPL	Stock	54.9925	55.0225	54.985	55.0175	22660.0
2018-08-29 07:30:00	AAPL	Stock	55.0225	55.105	55.0025	55.0875	88388.0
2018-08-29 08:00:00	AAPL	Stock	55.0	55.11	54.9875	55.0	320324.0
2018-08-29 08:30:00	AAPL	Stock	54.9875	55.0375	54.9525	55.0225	151076.0
2018-08-29 09:00:00	AAPL	Stock	55.0125	55.0625	55.0125	55.055	122296.0
2018-08-29 09:30:00	AAPL	Stock	55.0625	55.23	54.8525	55.1	14375272.0
2018-08-29 10:00:00	AAPL	Stock	55.0975	55.1875	55.05	55.18	6377940.0
2018-08-29 10:30:00	AAPL	Stock	55.18	55.375	55.15	55.3425	7725436.0
2018-08-29 11:00:00	AAPL	Stock	55.3425	55.495	55.2875	55.49	5420216.0
2018-08-29 11:30:00	AAPL	Stock	55.49	55.5648	55.4075	55.54	6800148.0
2018-08-29 12:00:00	AAPL	Stock	55.5382	55.555	55.4842	55.5175	4444180.0
2018-08-29 12:30:00	AAPL	Stock	55.515	55.525	55.4025	55.44	4712828.0
2018-08-29 13:00:00	AAPL	Stock	55.44	55.5175	55.4025	55.4932	3352668.0
2018-08-29 13:30:00	AAPL	Stock	55.4925	55.545	55.48	55.5228	3702268.0
2018-08-29 14:00:00	AAPL	Stock	55.5225	55.635	55.515	55.61	5113568.0
2018-08-29 14:30:00	AAPL	Stock	55.61	55.705	55.5975	55.6875	5699712.0
2018-08-29 15:00:00	AAPL	Stock	55.6888	55.78	55.6825	55.7575	6561780.0
2018-08-29 15:30:00	AAPL	Stock	55.755	55.8725	55.6925	55.745	11633480.0
2018-08-29 16:00:00	AAPL	Stock	55.7425	55.8075	55.7225	55.7975	8842284.0
2018-08-29 16:30:00	AAPL	Stock	55.7875	55.8675	55.745	55.835	48044.0
2018-08-29 17:00:00	AAPL	Stock	55.84	55.8625	55.7875	55.825	114908.0
2018-08-29 17:30:00	AAPL	Stock	55.85	55.9075	55.8375	55.9075	91800.0
2018-08-29 18:00:00	AAPL	Stock	55.9	55.935	55.85	55.9125	70776.0
2018-08-29 18:30:00	AAPL	Stock	55.9	55.925	55.8775	55.8925	35328.0
2018-08-29 19:00:00	AAPL	Stock	55.875	55.8925	55.855	55.89	7604.0
2018-08-29 19:30:00	AAPL	Stock	55.9175	55.9375	55.8575	55.9375	37124.0
2018-08-29 05:00:00	MSFT	Stock	110.76	110.76	110.76	110.76	400.0
2018-08-29 06:30:00	MSFT	Stock	110.32	110.32	110.32	110.32	233.0
2018-08-29 07:00:00	MSFT	Stock	110.32	110.4	110.17	110.4	2160.0
2018-08-29 07:30:00	MSFT	Stock	110.38	110.39	110.38	110.39	276.0
2018-08-29 08:00:00	MSFT	Stock	110.29	110.46	110.2	110.21	9655.0
2018-08-29 08:30:00	MSFT	Stock	110.23	110.34	110.2	110.25	12151.0
2018-08-29 09:00:00	MSFT	Stock	110.24	110.4	110.24	110.3	5983.0
2018-08-29 09:30:00	MSFT	Stock	110.45	111.35	110.27	111.06	2615054.0
2018-08-29 10:00:00	MSFT	Stock	111.05	111.47	110.945	111.47	1379255.0
2018-08-29 10:30:00	MSFT	Stock	111.47	111.735	111.27	111.62	1222398.0
2018-08-29 11:00:00	MSFT	Stock	111.61	112.0	111.42	111.879	1127851.0
2018-08-29 11:30:00	MSFT	Stock	111.87	111.95	111.66	111.76	902525.0
2018-08-29 12:00:00	MSFT	Stock	111.76	111.77	111.51	111.545	1111394.0
2018-08-29 12:30:00	MSFT	Stock	111.545	111.7	111.505	111.66	626569.0
2018-08-29 13:00:00	MSFT	Stock	111.66	111.67	111.51	111.603	497110.0
2018-08-29 13:30:00	MSFT	Stock	111.605	111.64	111.54	111.58	605668.0
2018-08-29 14:00:00	MSFT	Stock	111.58	111.605	111.5	111.515	688592.0
2018-08-29 14:30:00	MSFT	Stock	111.515	111.63	111.51	111.61	790210.0
2018-08-29 15:00:00	MSFT	Stock	111.61	111.8	111.605	111.68	992258.0

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

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