PREVIEW / stock_30min / 2018-05-18

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-18.parquet
  size:    1.7 MB
  rows:    83,292
  symbols: 2,837

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-05-18 04:00:00	AAPL	Stock	46.7975	46.8425	46.7975	46.8425	3600.0
2018-05-18 04:30:00	AAPL	Stock	46.8425	46.8425	46.8425	46.8425	984.0
2018-05-18 05:00:00	AAPL	Stock	46.845	46.8725	46.845	46.8725	24384.0
2018-05-18 05:30:00	AAPL	Stock	46.9	46.9	46.875	46.875	6284.0
2018-05-18 06:00:00	AAPL	Stock	46.875	46.875	46.875	46.875	6000.0
2018-05-18 06:30:00	AAPL	Stock	46.8675	46.8675	46.8675	46.8675	400.0
2018-05-18 07:00:00	AAPL	Stock	46.825	46.95	46.7775	46.8375	84864.0
2018-05-18 07:30:00	AAPL	Stock	46.8375	46.8725	46.8375	46.8375	25264.0
2018-05-18 08:00:00	AAPL	Stock	46.8475	46.875	46.7375	46.775	97912.0
2018-05-18 08:30:00	AAPL	Stock	46.755	46.775	46.6375	46.64	165268.0
2018-05-18 09:00:00	AAPL	Stock	46.6375	46.8925	46.625	46.7825	282516.0
2018-05-18 09:30:00	AAPL	Stock	46.7975	46.84	46.62	46.68	11366424.0
2018-05-18 10:00:00	AAPL	Stock	46.6825	46.9525	46.615	46.8728	7491904.0
2018-05-18 10:30:00	AAPL	Stock	46.87	46.8725	46.6475	46.725	6038512.0
2018-05-18 11:00:00	AAPL	Stock	46.725	46.8975	46.7225	46.8502	3928900.0
2018-05-18 11:30:00	AAPL	Stock	46.8625	46.9425	46.81	46.845	3450048.0
2018-05-18 12:00:00	AAPL	Stock	46.8468	46.875	46.765	46.8425	2743488.0
2018-05-18 12:30:00	AAPL	Stock	46.8425	46.865	46.7778	46.8338	2066728.0
2018-05-18 13:00:00	AAPL	Stock	46.835	46.87	46.78	46.8432	1869524.0
2018-05-18 13:30:00	AAPL	Stock	46.8438	46.8438	46.6725	46.7025	3309512.0
2018-05-18 14:00:00	AAPL	Stock	46.7012	46.727	46.6525	46.71	2134512.0
2018-05-18 14:30:00	AAPL	Stock	46.7075	46.73	46.665	46.72	1858596.0
2018-05-18 15:00:00	AAPL	Stock	46.7225	46.7275	46.635	46.6575	2628176.0
2018-05-18 15:30:00	AAPL	Stock	46.66	46.6675	46.5325	46.5725	7333036.0
2018-05-18 16:00:00	AAPL	Stock	46.575	46.615	46.575	46.6	7173600.0
2018-05-18 16:30:00	AAPL	Stock	46.5775	46.605	46.5775	46.5775	68420.0
2018-05-18 17:00:00	AAPL	Stock	46.59	46.635	46.59	46.6025	23116.0
2018-05-18 17:30:00	AAPL	Stock	46.6125	46.6225	46.5975	46.5975	3516.0
2018-05-18 18:00:00	AAPL	Stock	46.595	46.615	46.565	46.565	9380.0
2018-05-18 18:30:00	AAPL	Stock	46.55	46.62	46.55	46.5625	8456.0
2018-05-18 19:00:00	AAPL	Stock	46.5775	46.5775	46.55	46.55	3452.0
2018-05-18 19:30:00	AAPL	Stock	46.575	46.6025	46.575	46.6025	2052.0
2018-05-18 04:00:00	MSFT	Stock	96.35	96.35	96.35	96.35	100.0
2018-05-18 07:00:00	MSFT	Stock	96.45	96.45	96.29	96.29	845.0
2018-05-18 08:00:00	MSFT	Stock	96.34	96.35	96.02	96.15	8432.0
2018-05-18 08:30:00	MSFT	Stock	96.1	96.1	95.88	95.9	13488.0
2018-05-18 09:00:00	MSFT	Stock	95.9	96.45	95.82	96.25	90037.0
2018-05-18 09:30:00	MSFT	Stock	96.01	96.84	96.01	96.52	3295184.0
2018-05-18 10:00:00	MSFT	Stock	96.53	96.87	96.31	96.77	1166367.0
2018-05-18 10:30:00	MSFT	Stock	96.775	96.78	96.3	96.62	949745.0
2018-05-18 11:00:00	MSFT	Stock	96.62	96.93	96.56	96.76	784309.0
2018-05-18 11:30:00	MSFT	Stock	96.78	96.88	96.69	96.774	835045.0
2018-05-18 12:00:00	MSFT	Stock	96.78	96.78	96.55	96.58	541822.0
2018-05-18 12:30:00	MSFT	Stock	96.585	96.755	96.51	96.72	499194.0
2018-05-18 13:00:00	MSFT	Stock	96.725	96.737	96.56	96.65	471444.0
2018-05-18 13:30:00	MSFT	Stock	96.645	96.66	96.43	96.54	529669.0
2018-05-18 14:00:00	MSFT	Stock	96.54	96.54	96.4	96.49	381248.0
2018-05-18 14:30:00	MSFT	Stock	96.49	96.6	96.42	96.525	434621.0
2018-05-18 15:00:00	MSFT	Stock	96.525	96.55	96.375	96.45	555252.0
2018-05-18 15:30:00	MSFT	Stock	96.45	96.6	96.33	96.36	2115005.0

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

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