PREVIEW / stock_30min / 2019-02-26

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-26.parquet
  size:    1.7 MB
  rows:    85,145
  symbols: 2,674

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-02-26 04:00:00	AAPL	Stock	43.4	43.4	43.305	43.305	2400.0
2019-02-26 04:30:00	AAPL	Stock	43.315	43.315	43.305	43.305	5968.0
2019-02-26 05:00:00	AAPL	Stock	43.33	43.385	43.325	43.385	5600.0
2019-02-26 05:30:00	AAPL	Stock	43.365	43.385	43.365	43.385	844.0
2019-02-26 06:00:00	AAPL	Stock	43.39	43.39	43.385	43.385	3600.0
2019-02-26 06:30:00	AAPL	Stock	43.375	43.4125	43.33	43.4125	7056.0
2019-02-26 07:00:00	AAPL	Stock	43.4075	43.425	43.4075	43.425	7088.0
2019-02-26 07:30:00	AAPL	Stock	43.4125	43.42	43.4	43.4	15944.0
2019-02-26 08:00:00	AAPL	Stock	43.4125	43.425	43.35	43.4225	87964.0
2019-02-26 08:30:00	AAPL	Stock	43.4125	43.425	43.325	43.325	80808.0
2019-02-26 09:00:00	AAPL	Stock	43.3375	43.425	43.3375	43.425	42412.0
2019-02-26 09:30:00	AAPL	Stock	43.4275	43.75	43.2932	43.71	10928056.0
2019-02-26 10:00:00	AAPL	Stock	43.715	43.825	43.628	43.6342	6152244.0
2019-02-26 10:30:00	AAPL	Stock	43.6338	43.65	43.4425	43.445	5095428.0
2019-02-26 11:00:00	AAPL	Stock	43.445	43.6475	43.415	43.585	4791460.0
2019-02-26 11:30:00	AAPL	Stock	43.5875	43.6375	43.525	43.5575	2980516.0
2019-02-26 12:00:00	AAPL	Stock	43.5575	43.5925	43.5075	43.53	2078908.0
2019-02-26 12:30:00	AAPL	Stock	43.5315	43.5775	43.485	43.5543	2985412.0
2019-02-26 13:00:00	AAPL	Stock	43.5525	43.64	43.545	43.6075	2482644.0
2019-02-26 13:30:00	AAPL	Stock	43.6075	43.625	43.535	43.5588	2418336.0
2019-02-26 14:00:00	AAPL	Stock	43.56	43.5975	43.55	43.565	1689484.0
2019-02-26 14:30:00	AAPL	Stock	43.5675	43.6462	43.5612	43.638	2686092.0
2019-02-26 15:00:00	AAPL	Stock	43.6375	43.72	43.6375	43.6575	3211796.0
2019-02-26 15:30:00	AAPL	Stock	43.655	43.7	43.54	43.5875	5468564.0
2019-02-26 16:00:00	AAPL	Stock	43.585	43.585	43.535	43.5425	8369436.0
2019-02-26 16:30:00	AAPL	Stock	43.55	43.5625	43.515	43.515	32256.0
2019-02-26 17:00:00	AAPL	Stock	43.5	43.525	43.5	43.5225	41776.0
2019-02-26 17:30:00	AAPL	Stock	43.5225	43.54	43.5225	43.5275	24200.0
2019-02-26 18:00:00	AAPL	Stock	43.5275	43.5275	43.4775	43.4875	71776.0
2019-02-26 18:30:00	AAPL	Stock	43.5125	43.55	43.51	43.525	39280.0
2019-02-26 19:00:00	AAPL	Stock	43.545	43.56	43.5375	43.5525	12128.0
2019-02-26 19:30:00	AAPL	Stock	43.555	43.5625	43.5525	43.5525	7928.0
2019-02-26 04:00:00	MSFT	Stock	111.34	111.34	111.3	111.3	1274.0
2019-02-26 05:00:00	MSFT	Stock	111.1	111.1	111.06	111.06	200.0
2019-02-26 07:00:00	MSFT	Stock	111.15	111.37	111.15	111.37	1530.0
2019-02-26 07:30:00	MSFT	Stock	111.34	111.36	111.26	111.26	1102.0
2019-02-26 08:00:00	MSFT	Stock	111.25	111.3	111.23	111.25	2326.0
2019-02-26 08:30:00	MSFT	Stock	111.25	111.25	111.05	111.05	4647.0
2019-02-26 09:00:00	MSFT	Stock	111.11	111.28	111.012	111.21	18579.0
2019-02-26 09:30:00	MSFT	Stock	111.23	112.35	111.17	112.045	2424345.0
2019-02-26 10:00:00	MSFT	Stock	112.045	112.7	112.005	112.67	1753137.0
2019-02-26 10:30:00	MSFT	Stock	112.67	112.785	112.48	112.53	1613430.0
2019-02-26 11:00:00	MSFT	Stock	112.52	113.16	112.475	113.15	1591435.0
2019-02-26 11:30:00	MSFT	Stock	113.16	113.24	112.65	112.973	1238082.0
2019-02-26 12:00:00	MSFT	Stock	112.97	113.01	112.695	112.72	791454.0
2019-02-26 12:30:00	MSFT	Stock	112.71	112.78	112.51	112.633	848871.0
2019-02-26 13:00:00	MSFT	Stock	112.645	112.9	112.639	112.72	677982.0
2019-02-26 13:30:00	MSFT	Stock	112.715	112.81	112.57	112.675	770801.0
2019-02-26 14:00:00	MSFT	Stock	112.685	112.77	112.52	112.58	678459.0
2019-02-26 14:30:00	MSFT	Stock	112.585	112.73	112.57	112.61	780055.0

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

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