PREVIEW / stock_30min / 2019-11-12

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-12.parquet
  size:    1.7 MB
  rows:    83,308
  symbols: 2,489

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-12 04:00:00	AAPL	Stock	65.55	65.65	65.55	65.55	20952.0
2019-11-12 04:30:00	AAPL	Stock	65.57	65.575	65.52	65.5625	9880.0
2019-11-12 05:00:00	AAPL	Stock	65.5625	65.6	65.5625	65.6	11200.0
2019-11-12 05:30:00	AAPL	Stock	65.6	65.6375	65.6	65.6375	17492.0
2019-11-12 06:00:00	AAPL	Stock	65.68	65.6925	65.64	65.64	17532.0
2019-11-12 06:30:00	AAPL	Stock	65.625	65.65	65.6	65.625	9640.0
2019-11-12 07:00:00	AAPL	Stock	65.65	65.65	65.5775	65.6075	71436.0
2019-11-12 07:30:00	AAPL	Stock	65.59	65.6125	65.59	65.61	8684.0
2019-11-12 08:00:00	AAPL	Stock	65.5925	65.645	65.573	65.595	152748.0
2019-11-12 08:30:00	AAPL	Stock	65.6025	65.6125	65.2775	65.315	615040.0
2019-11-12 09:00:00	AAPL	Stock	65.325	65.4125	65.26	65.4	616820.0
2019-11-12 09:30:00	AAPL	Stock	65.3875	65.5625	65.27	65.3425	10849544.0
2019-11-12 10:00:00	AAPL	Stock	65.3425	65.555	65.23	65.4875	8777288.0
2019-11-12 10:30:00	AAPL	Stock	65.4888	65.4975	65.3325	65.355	5776040.0
2019-11-12 11:00:00	AAPL	Stock	65.3558	65.67	65.2675	65.615	6059280.0
2019-11-12 11:30:00	AAPL	Stock	65.615	65.62	65.4375	65.47	3457756.0
2019-11-12 12:00:00	AAPL	Stock	65.4725	65.625	65.435	65.5475	3556720.0
2019-11-12 12:30:00	AAPL	Stock	65.5425	65.5825	65.45	65.5425	2874132.0
2019-11-12 13:00:00	AAPL	Stock	65.54	65.645	65.525	65.5728	2571872.0
2019-11-12 13:30:00	AAPL	Stock	65.5738	65.6975	65.55	65.6787	3184400.0
2019-11-12 14:00:00	AAPL	Stock	65.6775	65.6775	65.285	65.4975	5008992.0
2019-11-12 14:30:00	AAPL	Stock	65.4975	65.525	65.34	65.4225	3799820.0
2019-11-12 15:00:00	AAPL	Stock	65.4225	65.525	65.42	65.4738	3188372.0
2019-11-12 15:30:00	AAPL	Stock	65.4725	65.5325	65.3825	65.495	5973080.0
2019-11-12 16:00:00	AAPL	Stock	65.49	65.5375	65.3775	65.5125	7568640.0
2019-11-12 16:30:00	AAPL	Stock	65.475	65.52	65.475	65.475	74704.0
2019-11-12 17:00:00	AAPL	Stock	65.495	65.495	65.4625	65.485	10460.0
2019-11-12 17:30:00	AAPL	Stock	65.4625	65.4975	65.4475	65.455	38412.0
2019-11-12 18:00:00	AAPL	Stock	65.455	65.455	65.4125	65.425	16960.0
2019-11-12 18:30:00	AAPL	Stock	65.425	65.4475	65.425	65.4475	5104.0
2019-11-12 19:00:00	AAPL	Stock	65.45	65.45	65.405	65.425	9288.0
2019-11-12 19:30:00	AAPL	Stock	65.4425	65.4425	65.3775	65.425	47000.0
2019-11-12 04:00:00	MSFT	Stock	146.6	146.6	146.23	146.23	600.0
2019-11-12 05:30:00	MSFT	Stock	146.63	146.63	146.63	146.63	202.0
2019-11-12 06:30:00	MSFT	Stock	146.47	146.47	146.4	146.4	1099.0
2019-11-12 07:00:00	MSFT	Stock	146.5	146.59	146.48	146.54	2477.0
2019-11-12 07:30:00	MSFT	Stock	146.52	146.52	146.47	146.48	1185.0
2019-11-12 08:00:00	MSFT	Stock	146.5	146.53	146.36	146.53	11079.0
2019-11-12 08:30:00	MSFT	Stock	146.46	146.53	146.4	146.45	6462.0
2019-11-12 09:00:00	MSFT	Stock	146.45	146.48	146.25	146.26	7974.0
2019-11-12 09:30:00	MSFT	Stock	146.28	147.16	146.06	147.12	2074406.0
2019-11-12 10:00:00	MSFT	Stock	147.13	147.49	146.91	147.36	1473259.0
2019-11-12 10:30:00	MSFT	Stock	147.36	147.46	147.194	147.355	932586.0
2019-11-12 11:00:00	MSFT	Stock	147.36	147.57	147.11	147.36	897216.0
2019-11-12 11:30:00	MSFT	Stock	147.37	147.46	147.14	147.22	688327.0
2019-11-12 12:00:00	MSFT	Stock	147.21	147.32	146.95	147.187	648420.0
2019-11-12 12:30:00	MSFT	Stock	147.19	147.5	147.13	147.45	726025.0
2019-11-12 13:00:00	MSFT	Stock	147.46	147.48	147.205	147.22	528454.0
2019-11-12 13:30:00	MSFT	Stock	147.225	147.41	147.12	147.2	519006.0
2019-11-12 14:00:00	MSFT	Stock	147.205	147.22	146.76	146.835	1024227.0

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

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