PREVIEW / stock_30min / 2019-10-29

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-29.parquet
  size:    1.7 MB
  rows:    83,706
  symbols: 2,507

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-29 04:00:00	AAPL	Stock	62.2625	62.3	62.2625	62.3	26536.0
2019-10-29 04:30:00	AAPL	Stock	62.22	62.225	62.175	62.175	4016.0
2019-10-29 05:00:00	AAPL	Stock	62.225	62.2375	62.1625	62.1625	4960.0
2019-10-29 05:30:00	AAPL	Stock	62.2	62.2125	62.14	62.15	9716.0
2019-10-29 06:00:00	AAPL	Stock	62.16	62.165	62.16	62.165	1388.0
2019-10-29 06:30:00	AAPL	Stock	62.19	62.1925	62.19	62.1925	1600.0
2019-10-29 07:00:00	AAPL	Stock	62.22	62.22	62.125	62.125	61888.0
2019-10-29 07:30:00	AAPL	Stock	62.145	62.2225	62.145	62.2075	29444.0
2019-10-29 08:00:00	AAPL	Stock	62.2032	62.23	62.1075	62.2275	155284.0
2019-10-29 08:30:00	AAPL	Stock	62.225	62.25	62.2	62.2225	99140.0
2019-10-29 09:00:00	AAPL	Stock	62.2328	62.2625	62.19	62.2525	161936.0
2019-10-29 09:30:00	AAPL	Stock	62.2525	62.4375	61.965	61.9772	13184676.0
2019-10-29 10:00:00	AAPL	Stock	61.9738	62.005	61.5438	61.579	10386368.0
2019-10-29 10:30:00	AAPL	Stock	61.58	61.73	61.3525	61.375	10124884.0
2019-10-29 11:00:00	AAPL	Stock	61.3825	61.4475	60.9125	60.9735	15058024.0
2019-10-29 11:30:00	AAPL	Stock	60.9732	61.0375	60.7075	60.7952	11455268.0
2019-10-29 12:00:00	AAPL	Stock	60.8	61.1825	60.73	61.105	8253192.0
2019-10-29 12:30:00	AAPL	Stock	61.1125	61.174	60.8875	60.8928	5465992.0
2019-10-29 13:00:00	AAPL	Stock	60.8925	60.9925	60.805	60.9275	4955240.0
2019-10-29 13:30:00	AAPL	Stock	60.93	60.9725	60.7375	60.9162	5945572.0
2019-10-29 14:00:00	AAPL	Stock	60.9125	60.965	60.8125	60.9325	4076908.0
2019-10-29 14:30:00	AAPL	Stock	60.9325	60.95	60.6425	60.6688	5639624.0
2019-10-29 15:00:00	AAPL	Stock	60.6675	61.0975	60.6632	60.93	6937668.0
2019-10-29 15:30:00	AAPL	Stock	60.9288	60.9875	60.7925	60.8225	10280800.0
2019-10-29 16:00:00	AAPL	Stock	60.8225	60.8725	60.8025	60.8725	5142612.0
2019-10-29 16:30:00	AAPL	Stock	60.865	60.89	60.5	60.875	223840.0
2019-10-29 17:00:00	AAPL	Stock	60.8725	60.9	60.8225	60.9	2482632.0
2019-10-29 17:30:00	AAPL	Stock	60.9025	60.965	60.8875	60.9525	49420.0
2019-10-29 18:00:00	AAPL	Stock	60.975	61.0	60.95	60.985	81536.0
2019-10-29 18:30:00	AAPL	Stock	60.9875	61.0	60.9625	60.975	27596.0
2019-10-29 19:00:00	AAPL	Stock	60.955	60.965	60.95	60.955	36136.0
2019-10-29 19:30:00	AAPL	Stock	60.95	60.9675	60.9275	60.9575	55820.0
2019-10-29 04:00:00	MSFT	Stock	144.18	144.18	144.02	144.02	1018.0
2019-10-29 05:30:00	MSFT	Stock	144.11	144.11	144.11	144.11	200.0
2019-10-29 06:00:00	MSFT	Stock	144.05	144.05	144.04	144.04	499.0
2019-10-29 06:30:00	MSFT	Stock	144.05	144.05	144.02	144.05	871.0
2019-10-29 07:00:00	MSFT	Stock	144.13	144.14	143.71	143.75	14007.0
2019-10-29 07:30:00	MSFT	Stock	143.86	143.91	143.78	143.9	3450.0
2019-10-29 08:00:00	MSFT	Stock	144.1	144.14	143.75	143.84	12382.0
2019-10-29 08:30:00	MSFT	Stock	143.92	144.1	143.85	144.0	4133.0
2019-10-29 09:00:00	MSFT	Stock	144.0	144.08	143.843	144.08	7180.0
2019-10-29 09:30:00	MSFT	Stock	144.07	144.5	143.81	144.08	2615899.0
2019-10-29 10:00:00	MSFT	Stock	144.08	144.12	143.64	143.79	1238387.0
2019-10-29 10:30:00	MSFT	Stock	143.78	144.0	143.315	143.42	1404013.0
2019-10-29 11:00:00	MSFT	Stock	143.43	143.72	142.9	143.035	1239379.0
2019-10-29 11:30:00	MSFT	Stock	143.04	143.52	142.96	143.16	1017912.0
2019-10-29 12:00:00	MSFT	Stock	143.16	143.63	143.05	143.56	903406.0
2019-10-29 12:30:00	MSFT	Stock	143.57	143.725	143.47	143.525	612511.0
2019-10-29 13:00:00	MSFT	Stock	143.53	143.61	143.07	143.104	534372.0
2019-10-29 13:30:00	MSFT	Stock	143.1	143.16	142.79	142.85	959200.0

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

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