PREVIEW / stock_30min / 2019-11-11

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-11.parquet
  size:    1.7 MB
  rows:    83,164
  symbols: 2,482

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-11 04:00:00	AAPL	Stock	64.775	64.775	64.5475	64.6375	19296.0
2019-11-11 04:30:00	AAPL	Stock	64.6475	64.67	64.5925	64.5925	12360.0
2019-11-11 05:00:00	AAPL	Stock	64.625	64.6875	64.625	64.6875	5600.0
2019-11-11 05:30:00	AAPL	Stock	64.625	64.625	64.545	64.5875	22440.0
2019-11-11 06:00:00	AAPL	Stock	64.5875	64.6375	64.5875	64.6375	3600.0
2019-11-11 06:30:00	AAPL	Stock	64.6125	64.65	64.6125	64.65	7828.0
2019-11-11 07:00:00	AAPL	Stock	64.66	64.6725	64.5875	64.6125	34332.0
2019-11-11 07:30:00	AAPL	Stock	64.62	64.65	64.6125	64.625	59520.0
2019-11-11 08:00:00	AAPL	Stock	64.6125	64.6875	64.5925	64.625	128532.0
2019-11-11 08:30:00	AAPL	Stock	64.6175	64.6875	64.6175	64.6375	89692.0
2019-11-11 09:00:00	AAPL	Stock	64.6425	64.7075	64.5675	64.5875	209748.0
2019-11-11 09:30:00	AAPL	Stock	64.575	64.9	64.57	64.825	10255332.0
2019-11-11 10:00:00	AAPL	Stock	64.825	65.0425	64.7675	64.9925	5378756.0
2019-11-11 10:30:00	AAPL	Stock	64.995	65.1475	64.9925	65.0225	5090416.0
2019-11-11 11:00:00	AAPL	Stock	65.0238	65.18	65.015	65.079	3756128.0
2019-11-11 11:30:00	AAPL	Stock	65.0825	65.1625	65.0475	65.122	2884468.0
2019-11-11 12:00:00	AAPL	Stock	65.1275	65.3	65.095	65.2728	4031276.0
2019-11-11 12:30:00	AAPL	Stock	65.275	65.3888	65.2575	65.3762	4002320.0
2019-11-11 13:00:00	AAPL	Stock	65.3775	65.5325	65.3575	65.5248	3806160.0
2019-11-11 13:30:00	AAPL	Stock	65.5275	65.6175	65.4625	65.571	4662092.0
2019-11-11 14:00:00	AAPL	Stock	65.5675	65.5675	65.3675	65.3882	3304888.0
2019-11-11 14:30:00	AAPL	Stock	65.39	65.48	65.3738	65.4	2615572.0
2019-11-11 15:00:00	AAPL	Stock	65.4025	65.4925	65.3925	65.4425	2732576.0
2019-11-11 15:30:00	AAPL	Stock	65.445	65.5575	65.385	65.55	5915568.0
2019-11-11 16:00:00	AAPL	Stock	65.55	65.58	65.5175	65.555	3424608.0
2019-11-11 16:30:00	AAPL	Stock	65.5625	65.5875	65.55	65.5875	48224.0
2019-11-11 17:00:00	AAPL	Stock	65.5825	65.6075	65.55	65.58	2807424.0
2019-11-11 17:30:00	AAPL	Stock	65.57	65.595	65.565	65.585	13900.0
2019-11-11 18:00:00	AAPL	Stock	65.585	65.595	65.57	65.58	34480.0
2019-11-11 18:30:00	AAPL	Stock	65.58	65.6	65.5775	65.5775	31064.0
2019-11-11 19:00:00	AAPL	Stock	65.575	65.5775	65.5375	65.5775	49272.0
2019-11-11 19:30:00	AAPL	Stock	65.57	65.6125	65.57	65.6	83792.0
2019-11-11 04:00:00	MSFT	Stock	145.51	145.51	145.3	145.3	546.0
2019-11-11 04:30:00	MSFT	Stock	145.59	145.59	145.59	145.59	100.0
2019-11-11 05:30:00	MSFT	Stock	145.43	145.45	145.22	145.45	2978.0
2019-11-11 06:00:00	MSFT	Stock	145.45	145.45	145.4	145.4	270.0
2019-11-11 06:30:00	MSFT	Stock	145.55	145.74	145.46	145.5	5122.0
2019-11-11 07:00:00	MSFT	Stock	145.59	145.7	145.38	145.45	11266.0
2019-11-11 07:30:00	MSFT	Stock	145.47	145.55	145.47	145.55	7588.0
2019-11-11 08:00:00	MSFT	Stock	145.533	145.73	145.36	145.5	21047.0
2019-11-11 08:30:00	MSFT	Stock	145.45	145.7	145.45	145.6	26982.0
2019-11-11 09:00:00	MSFT	Stock	145.6	145.7	145.32	145.32	27096.0
2019-11-11 09:30:00	MSFT	Stock	145.34	145.78	144.73	145.62	2367975.0
2019-11-11 10:00:00	MSFT	Stock	145.62	145.78	145.27	145.689	771948.0
2019-11-11 10:30:00	MSFT	Stock	145.69	145.94	145.58	145.665	801839.0
2019-11-11 11:00:00	MSFT	Stock	145.67	145.76	145.435	145.68	614365.0
2019-11-11 11:30:00	MSFT	Stock	145.67	145.88	145.562	145.845	536441.0
2019-11-11 12:00:00	MSFT	Stock	145.84	145.98	145.77	145.94	507008.0
2019-11-11 12:30:00	MSFT	Stock	145.945	146.15	145.91	146.087	714427.0
2019-11-11 13:00:00	MSFT	Stock	146.085	146.185	146.075	146.18	603158.0

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

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