PREVIEW / stock_30min / 2019-11-14

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-14.parquet
  size:    1.7 MB
  rows:    84,467
  symbols: 2,497

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-14 04:00:00	AAPL	Stock	66.0625	66.1375	65.975	66.1375	14424.0
2019-11-14 04:30:00	AAPL	Stock	66.075	66.075	66.075	66.075	400.0
2019-11-14 05:00:00	AAPL	Stock	66.075	66.15	66.075	66.1375	5868.0
2019-11-14 06:00:00	AAPL	Stock	66.08	66.08	66.0025	66.005	19088.0
2019-11-14 06:30:00	AAPL	Stock	66.0175	66.055	66.0175	66.055	8292.0
2019-11-14 07:00:00	AAPL	Stock	66.085	66.0875	66.0425	66.05	40740.0
2019-11-14 07:30:00	AAPL	Stock	66.0625	66.0675	65.6875	65.7125	460432.0
2019-11-14 08:00:00	AAPL	Stock	66.0875	66.0875	65.655	65.7225	495852.0
2019-11-14 08:30:00	AAPL	Stock	65.7225	65.8	65.615	65.8	350292.0
2019-11-14 09:00:00	AAPL	Stock	65.7675	65.9875	65.7525	65.975	543528.0
2019-11-14 09:30:00	AAPL	Stock	65.97	66.2075	65.88	66.0775	14499012.0
2019-11-14 10:00:00	AAPL	Stock	66.075	66.22	65.9525	66.0075	6357716.0
2019-11-14 10:30:00	AAPL	Stock	66.006	66.05	65.6925	65.695	7162960.0
2019-11-14 11:00:00	AAPL	Stock	65.6925	65.9375	65.655	65.7965	5602932.0
2019-11-14 11:30:00	AAPL	Stock	65.7975	65.8175	65.5575	65.7242	6040440.0
2019-11-14 12:00:00	AAPL	Stock	65.7225	65.765	65.5275	65.69	4421260.0
2019-11-14 12:30:00	AAPL	Stock	65.69	65.835	65.6475	65.7775	3238424.0
2019-11-14 13:00:00	AAPL	Stock	65.7775	65.915	65.73	65.7875	3036384.0
2019-11-14 13:30:00	AAPL	Stock	65.785	65.8	65.525	65.7115	3209664.0
2019-11-14 14:00:00	AAPL	Stock	65.7175	65.75	65.6762	65.72	1966784.0
2019-11-14 14:30:00	AAPL	Stock	65.72	65.7375	65.6292	65.7325	1905632.0
2019-11-14 15:00:00	AAPL	Stock	65.73	65.794	65.6825	65.7425	2651220.0
2019-11-14 15:30:00	AAPL	Stock	65.745	65.755	65.615	65.6725	6789020.0
2019-11-14 16:00:00	AAPL	Stock	65.6875	65.8333	65.565	65.66	5224420.0
2019-11-14 16:30:00	AAPL	Stock	65.565	65.66	65.55	65.625	71636.0
2019-11-14 17:00:00	AAPL	Stock	65.615	65.66	65.3175	65.42	288100.0
2019-11-14 17:30:00	AAPL	Stock	65.425	65.495	65.405	65.4375	56864.0
2019-11-14 18:00:00	AAPL	Stock	65.475	65.475	65.35	65.355	172900.0
2019-11-14 18:30:00	AAPL	Stock	65.355	65.495	65.35	65.45	56268.0
2019-11-14 19:00:00	AAPL	Stock	65.45	65.4525	65.4025	65.415	11832.0
2019-11-14 19:30:00	AAPL	Stock	65.4125	65.66	65.4025	65.66	174172.0
2019-11-14 04:00:00	MSFT	Stock	147.1	147.1	147.1	147.1	180.0
2019-11-14 05:00:00	MSFT	Stock	147.25	147.49	147.25	147.49	1450.0
2019-11-14 06:00:00	MSFT	Stock	147.27	147.31	147.1	147.1	2783.0
2019-11-14 06:30:00	MSFT	Stock	147.11	147.39	147.11	147.31	1219.0
2019-11-14 07:00:00	MSFT	Stock	147.25	147.25	147.25	147.25	1799.0
2019-11-14 07:30:00	MSFT	Stock	147.25	147.26	147.18	147.22	2844.0
2019-11-14 08:00:00	MSFT	Stock	147.141	147.31	147.141	147.31	4064.0
2019-11-14 08:30:00	MSFT	Stock	147.232	147.232	146.91	147.05	7431.0
2019-11-14 09:00:00	MSFT	Stock	147.15	147.2	147.0	147.04	3091.0
2019-11-14 09:30:00	MSFT	Stock	147.02	148.0	147.02	147.87	1858599.0
2019-11-14 10:00:00	MSFT	Stock	147.865	148.09	147.69	147.73	988839.0
2019-11-14 10:30:00	MSFT	Stock	147.732	147.78	147.39	147.438	733874.0
2019-11-14 11:00:00	MSFT	Stock	147.44	147.95	147.43	147.9	722701.0
2019-11-14 11:30:00	MSFT	Stock	147.91	147.93	147.265	147.33	840218.0
2019-11-14 12:00:00	MSFT	Stock	147.33	147.48	147.225	147.462	466265.0
2019-11-14 12:30:00	MSFT	Stock	147.475	147.75	147.38	147.72	565021.0
2019-11-14 13:00:00	MSFT	Stock	147.715	147.8	147.54	147.646	474949.0
2019-11-14 13:30:00	MSFT	Stock	147.66	147.73	147.0	147.5	706272.0
2019-11-14 14:00:00	MSFT	Stock	147.5	147.8	147.42	147.785	456163.0

> showing 50 of 84,467 rows — these rows as CSV

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