PREVIEW / stock_30min / 2018-11-09

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-09.parquet
  size:    1.7 MB
  rows:    82,572
  symbols: 2,733

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
2018-11-09 04:00:00	AAPL	Stock	51.72	51.72	51.6	51.625	13008.0
2018-11-09 04:30:00	AAPL	Stock	51.6075	51.6075	51.6075	51.6075	400.0
2018-11-09 05:00:00	AAPL	Stock	51.6175	51.725	51.6175	51.675	11760.0
2018-11-09 05:30:00	AAPL	Stock	51.65	51.65	51.6	51.625	6096.0
2018-11-09 06:00:00	AAPL	Stock	51.585	51.5875	51.5175	51.5625	10784.0
2018-11-09 06:30:00	AAPL	Stock	51.5375	51.6225	51.48	51.5125	22924.0
2018-11-09 07:00:00	AAPL	Stock	51.565	51.64	51.4825	51.5	202844.0
2018-11-09 07:30:00	AAPL	Stock	51.5075	51.5625	51.395	51.425	241548.0
2018-11-09 08:00:00	AAPL	Stock	51.5375	51.66	51.375	51.4875	282536.0
2018-11-09 08:30:00	AAPL	Stock	51.48	51.4925	51.425	51.485	229224.0
2018-11-09 09:00:00	AAPL	Stock	51.4675	51.5	51.3775	51.3775	369752.0
2018-11-09 09:30:00	AAPL	Stock	51.3875	51.5025	51.025	51.3288	18443392.0
2018-11-09 10:00:00	AAPL	Stock	51.3225	51.435	51.1375	51.1793	8582976.0
2018-11-09 10:30:00	AAPL	Stock	51.1825	51.3175	50.98	51.0475	7706156.0
2018-11-09 11:00:00	AAPL	Stock	51.05	51.13	50.8125	50.8683	9453648.0
2018-11-09 11:30:00	AAPL	Stock	50.865	50.94	50.79	50.86	6605288.0
2018-11-09 12:00:00	AAPL	Stock	50.86	51.01	50.775	50.8	5342516.0
2018-11-09 12:30:00	AAPL	Stock	50.8025	50.9625	50.77	50.8925	3718744.0
2018-11-09 13:00:00	AAPL	Stock	50.8925	50.91	50.715	50.7775	3790176.0
2018-11-09 13:30:00	AAPL	Stock	50.7725	50.775	50.6605	50.6625	3665852.0
2018-11-09 14:00:00	AAPL	Stock	50.6625	50.715	50.5625	50.6125	4660324.0
2018-11-09 14:30:00	AAPL	Stock	50.61	51.0	50.61	50.92	6557804.0
2018-11-09 15:00:00	AAPL	Stock	50.93	51.1175	50.9	51.075	6167736.0
2018-11-09 15:30:00	AAPL	Stock	51.075	51.195	51.0275	51.1175	10717092.0
2018-11-09 16:00:00	AAPL	Stock	51.1175	51.1425	51.0175	51.035	20113540.0
2018-11-09 16:30:00	AAPL	Stock	51.035	51.1175	51.0275	51.0425	650596.0
2018-11-09 17:00:00	AAPL	Stock	51.04	51.045	51.015	51.015	32464.0
2018-11-09 17:30:00	AAPL	Stock	51.0125	51.025	50.99	51.0	22712.0
2018-11-09 18:00:00	AAPL	Stock	50.985	50.9975	50.975	50.985	27740.0
2018-11-09 18:30:00	AAPL	Stock	50.98	50.985	50.9525	50.955	67600.0
2018-11-09 19:00:00	AAPL	Stock	50.9525	50.96	50.925	50.925	21184.0
2018-11-09 19:30:00	AAPL	Stock	50.9225	50.945	50.8825	50.925	26640.0
2018-11-09 05:30:00	MSFT	Stock	111.08	111.08	111.08	111.08	100.0
2018-11-09 06:00:00	MSFT	Stock	111.4	111.48	111.0	111.0	625.0
2018-11-09 06:30:00	MSFT	Stock	110.87	111.0	110.87	110.95	2440.0
2018-11-09 07:00:00	MSFT	Stock	110.85	111.06	110.85	110.86	4151.0
2018-11-09 07:30:00	MSFT	Stock	110.86	111.0	110.85	110.95	3632.0
2018-11-09 08:00:00	MSFT	Stock	110.93	111.2	110.85	111.08	5962.0
2018-11-09 08:30:00	MSFT	Stock	111.02	111.13	110.96	111.0	10033.0
2018-11-09 09:00:00	MSFT	Stock	111.0	111.15	110.75	110.84	19803.0
2018-11-09 09:30:00	MSFT	Stock	110.9	111.45	110.26	110.49	3461424.0
2018-11-09 10:00:00	MSFT	Stock	110.49	110.78	109.32	109.518	2541460.0
2018-11-09 10:30:00	MSFT	Stock	109.528	109.72	109.06	109.336	1827842.0
2018-11-09 11:00:00	MSFT	Stock	109.33	110.0	109.26	109.9	2530138.0
2018-11-09 11:30:00	MSFT	Stock	109.89	110.03	109.11	109.18	1438681.0
2018-11-09 12:00:00	MSFT	Stock	109.165	109.43	108.95	109.26	1195012.0
2018-11-09 12:30:00	MSFT	Stock	109.27	109.415	109.15	109.15	842098.0
2018-11-09 13:00:00	MSFT	Stock	109.16	109.31	108.76	109.04	1168570.0
2018-11-09 13:30:00	MSFT	Stock	109.04	109.125	108.87	109.05	1169563.0
2018-11-09 14:00:00	MSFT	Stock	109.04	109.2	108.88	109.01	1418328.0

> showing 50 of 82,572 rows — these rows as CSV

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