PREVIEW / stock_30min / 2019-11-19

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-19.parquet
  size:    1.7 MB
  rows:    86,030
  symbols: 2,511

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-11-19 04:00:00	AAPL	Stock	67.0	67.0075	66.95	66.985	8292.0
2019-11-19 04:30:00	AAPL	Stock	66.9975	67.08	66.9975	67.075	26116.0
2019-11-19 05:00:00	AAPL	Stock	67.06	67.0625	67.0375	67.05	6776.0
2019-11-19 05:30:00	AAPL	Stock	67.065	67.1	67.0525	67.0875	40028.0
2019-11-19 06:00:00	AAPL	Stock	67.0525	67.14	67.0525	67.105	38976.0
2019-11-19 06:30:00	AAPL	Stock	67.1225	67.14	67.0575	67.0825	17936.0
2019-11-19 07:00:00	AAPL	Stock	67.0825	67.12	66.98	67.0025	128028.0
2019-11-19 07:30:00	AAPL	Stock	67.0025	67.055	66.995	67.0175	29976.0
2019-11-19 08:00:00	AAPL	Stock	67.05	67.1112	66.9625	67.0375	261184.0
2019-11-19 08:30:00	AAPL	Stock	67.015	67.0275	66.9375	66.9748	115848.0
2019-11-19 09:00:00	AAPL	Stock	66.9775	67.0225	66.9625	66.975	181224.0
2019-11-19 09:30:00	AAPL	Stock	66.975	67.0	66.645	66.7225	10046156.0
2019-11-19 10:00:00	AAPL	Stock	66.7148	67.0	66.585	66.6925	6737456.0
2019-11-19 10:30:00	AAPL	Stock	66.6925	66.75	66.4115	66.413	5031756.0
2019-11-19 11:00:00	AAPL	Stock	66.4142	66.57	66.3482	66.5525	4486268.0
2019-11-19 11:30:00	AAPL	Stock	66.5502	66.715	66.53	66.5975	3299192.0
2019-11-19 12:00:00	AAPL	Stock	66.5975	66.63	66.455	66.5675	2473216.0
2019-11-19 12:30:00	AAPL	Stock	66.569	66.575	66.4525	66.4745	1782100.0
2019-11-19 13:00:00	AAPL	Stock	66.4738	66.5417	66.4175	66.5255	1962776.0
2019-11-19 13:30:00	AAPL	Stock	66.525	66.6262	66.51	66.5975	1791428.0
2019-11-19 14:00:00	AAPL	Stock	66.6	66.7938	66.6	66.7698	2743832.0
2019-11-19 14:30:00	AAPL	Stock	66.77	66.775	66.6325	66.6952	2415212.0
2019-11-19 15:00:00	AAPL	Stock	66.695	66.7625	66.58	66.6	2002316.0
2019-11-19 15:30:00	AAPL	Stock	66.598	66.7075	66.4875	66.5725	4850212.0
2019-11-19 16:00:00	AAPL	Stock	66.5725	66.5875	66.5225	66.5425	12644500.0
2019-11-19 16:30:00	AAPL	Stock	66.55	66.5725	66.54	66.56	19396.0
2019-11-19 17:00:00	AAPL	Stock	66.5725	66.5725	66.5425	66.545	70400.0
2019-11-19 17:30:00	AAPL	Stock	66.54	66.54	66.5	66.505	28224.0
2019-11-19 18:00:00	AAPL	Stock	66.505	66.5125	66.375	66.375	57944.0
2019-11-19 18:30:00	AAPL	Stock	66.385	66.4225	66.3625	66.375	26276.0
2019-11-19 19:00:00	AAPL	Stock	66.4	66.485	66.4	66.4625	6736.0
2019-11-19 19:30:00	AAPL	Stock	66.435	66.4875	66.43	66.4425	28396.0
2019-11-19 04:00:00	MSFT	Stock	150.67	150.9	150.67	150.89	1635.0
2019-11-19 04:30:00	MSFT	Stock	150.9	151.04	150.9	151.04	2410.0
2019-11-19 05:00:00	MSFT	Stock	151.05	151.05	150.97	150.99	2755.0
2019-11-19 05:30:00	MSFT	Stock	151.0	151.04	151.0	151.04	626.0
2019-11-19 06:00:00	MSFT	Stock	151.05	151.14	150.95	151.13	1516.0
2019-11-19 06:30:00	MSFT	Stock	151.0	151.0	150.92	150.95	2890.0
2019-11-19 07:00:00	MSFT	Stock	150.99	151.02	150.84	150.9	5780.0
2019-11-19 07:30:00	MSFT	Stock	150.9	151.0	150.9	150.96	3500.0
2019-11-19 08:00:00	MSFT	Stock	150.9	151.08	150.81	150.91	16969.0
2019-11-19 08:30:00	MSFT	Stock	150.95	150.95	150.81	150.85	8040.0
2019-11-19 09:00:00	MSFT	Stock	150.9	151.1	150.87	150.87	31786.0
2019-11-19 09:30:00	MSFT	Stock	150.88	151.13	150.195	150.34	2650751.0
2019-11-19 10:00:00	MSFT	Stock	150.34	151.07	150.275	150.89	1444300.0
2019-11-19 10:30:00	MSFT	Stock	150.88	150.9	150.27	150.447	1170709.0
2019-11-19 11:00:00	MSFT	Stock	150.44	150.675	150.275	150.674	969043.0
2019-11-19 11:30:00	MSFT	Stock	150.68	151.27	150.64	151.07	1563123.0
2019-11-19 12:00:00	MSFT	Stock	151.06	151.33	150.86	151.2	719710.0
2019-11-19 12:30:00	MSFT	Stock	151.201	151.205	150.86	150.99	729204.0

> showing 50 of 86,030 rows — these rows as CSV

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