PREVIEW / stock_30min / 2019-09-23

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-23.parquet
  size:    1.7 MB
  rows:    85,995
  symbols: 2,561

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-09-23 04:00:00	AAPL	Stock	54.5625	54.7225	54.4325	54.445	20288.0
2019-09-23 04:30:00	AAPL	Stock	54.435	54.435	54.35	54.35	8372.0
2019-09-23 05:00:00	AAPL	Stock	54.35	54.3625	54.35	54.35	8396.0
2019-09-23 05:30:00	AAPL	Stock	54.5275	54.5275	54.5275	54.5275	400.0
2019-09-23 06:00:00	AAPL	Stock	54.5625	54.5625	54.5625	54.5625	400.0
2019-09-23 06:30:00	AAPL	Stock	54.5625	54.6175	54.515	54.515	14148.0
2019-09-23 07:00:00	AAPL	Stock	54.65	54.7175	54.5175	54.5925	87684.0
2019-09-23 07:30:00	AAPL	Stock	54.6	54.6125	54.515	54.515	72988.0
2019-09-23 08:00:00	AAPL	Stock	54.625	54.7175	54.5125	54.525	119032.0
2019-09-23 08:30:00	AAPL	Stock	54.52	54.6275	54.4325	54.6275	151344.0
2019-09-23 09:00:00	AAPL	Stock	54.62	54.8025	54.5125	54.7475	194356.0
2019-09-23 09:30:00	AAPL	Stock	54.7275	54.8725	54.53	54.6338	11272724.0
2019-09-23 10:00:00	AAPL	Stock	54.64	54.6612	54.4125	54.545	6994968.0
2019-09-23 10:30:00	AAPL	Stock	54.5462	54.685	54.47	54.53	4251488.0
2019-09-23 11:00:00	AAPL	Stock	54.53	54.7575	54.5175	54.7375	4305836.0
2019-09-23 11:30:00	AAPL	Stock	54.7398	54.7825	54.6425	54.68	3594736.0
2019-09-23 12:00:00	AAPL	Stock	54.6825	54.805	54.68	54.75	3122332.0
2019-09-23 12:30:00	AAPL	Stock	54.749	54.7625	54.635	54.69	1676628.0
2019-09-23 13:00:00	AAPL	Stock	54.69	54.8	54.6425	54.795	1939692.0
2019-09-23 13:30:00	AAPL	Stock	54.794	54.8438	54.756	54.8125	1992324.0
2019-09-23 14:00:00	AAPL	Stock	54.815	54.918	54.7925	54.871	2702544.0
2019-09-23 14:30:00	AAPL	Stock	54.8702	54.9375	54.8475	54.8525	1825372.0
2019-09-23 15:00:00	AAPL	Stock	54.85	54.96	54.8462	54.9025	2310824.0
2019-09-23 15:30:00	AAPL	Stock	54.9	54.9575	54.65	54.67	7754080.0
2019-09-23 16:00:00	AAPL	Stock	54.68	54.7175	54.6625	54.6875	9141372.0
2019-09-23 16:30:00	AAPL	Stock	54.7	54.8125	54.6125	54.8125	157248.0
2019-09-23 17:00:00	AAPL	Stock	54.775	54.815	54.77	54.8075	15656.0
2019-09-23 17:30:00	AAPL	Stock	54.8075	54.8175	54.68	54.68	10836.0
2019-09-23 18:00:00	AAPL	Stock	54.8175	54.84	54.8125	54.84	39140.0
2019-09-23 18:30:00	AAPL	Stock	54.8375	54.85	54.815	54.815	4000.0
2019-09-23 19:00:00	AAPL	Stock	54.8375	54.9775	54.8375	54.95	61004.0
2019-09-23 19:30:00	AAPL	Stock	54.9025	54.98	54.9025	54.9625	34700.0
2019-09-23 04:00:00	MSFT	Stock	139.5	139.5	139.43	139.43	1190.0
2019-09-23 04:30:00	MSFT	Stock	139.15	139.15	139.01	139.01	910.0
2019-09-23 05:00:00	MSFT	Stock	139.0	139.15	139.0	139.15	1192.0
2019-09-23 05:30:00	MSFT	Stock	139.0	139.3	139.0	139.3	2893.0
2019-09-23 06:00:00	MSFT	Stock	139.31	139.31	139.31	139.31	659.0
2019-09-23 06:30:00	MSFT	Stock	139.37	139.4	139.35	139.4	3570.0
2019-09-23 07:00:00	MSFT	Stock	139.25	139.6	139.25	139.6	3925.0
2019-09-23 07:30:00	MSFT	Stock	139.55	139.59	139.3	139.3	2049.0
2019-09-23 08:00:00	MSFT	Stock	139.69	139.69	139.1	139.1	17804.0
2019-09-23 08:30:00	MSFT	Stock	139.14	139.44	139.1	139.26	4407.0
2019-09-23 09:00:00	MSFT	Stock	139.3	139.4	139.05	139.16	22537.0
2019-09-23 09:30:00	MSFT	Stock	139.27	139.46	138.44	138.77	1702151.0
2019-09-23 10:00:00	MSFT	Stock	138.78	139.32	138.51	139.314	947398.0
2019-09-23 10:30:00	MSFT	Stock	139.32	139.47	138.84	139.0	829643.0
2019-09-23 11:00:00	MSFT	Stock	139.01	139.42	138.96	139.38	731336.0
2019-09-23 11:30:00	MSFT	Stock	139.38	139.63	139.33	139.37	812274.0
2019-09-23 12:00:00	MSFT	Stock	139.39	139.62	139.315	139.402	754201.0
2019-09-23 12:30:00	MSFT	Stock	139.406	139.49	139.12	139.22	483307.0

> showing 50 of 85,995 rows — these rows as CSV

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