PREVIEW / stock_30min / 2018-05-07

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-07.parquet
  size:    1.7 MB
  rows:    83,235
  symbols: 2,866

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-07 04:00:00	AAPL	Stock	46.115	46.1975	46.0575	46.1725	27972.0
2018-05-07 04:30:00	AAPL	Stock	46.1725	46.215	46.1725	46.185	14932.0
2018-05-07 05:00:00	AAPL	Stock	46.2	46.2	46.175	46.1975	3516.0
2018-05-07 05:30:00	AAPL	Stock	46.1625	46.2225	46.125	46.125	41720.0
2018-05-07 06:00:00	AAPL	Stock	46.125	46.2	46.125	46.2	9152.0
2018-05-07 06:30:00	AAPL	Stock	46.16	46.16	46.115	46.115	8572.0
2018-05-07 07:00:00	AAPL	Stock	46.1475	46.22	46.1125	46.18	343912.0
2018-05-07 07:30:00	AAPL	Stock	46.1875	46.225	46.125	46.175	275492.0
2018-05-07 08:00:00	AAPL	Stock	46.1925	46.375	46.13	46.2375	1137912.0
2018-05-07 08:30:00	AAPL	Stock	46.245	46.3175	46.215	46.27	367788.0
2018-05-07 09:00:00	AAPL	Stock	46.27	46.37	46.2575	46.3	1002360.0
2018-05-07 09:30:00	AAPL	Stock	46.295	46.72	46.2775	46.6175	30266240.0
2018-05-07 10:00:00	AAPL	Stock	46.6225	46.88	46.4775	46.84	20487528.0
2018-05-07 10:30:00	AAPL	Stock	46.8425	46.9175	46.765	46.8412	11546180.0
2018-05-07 11:00:00	AAPL	Stock	46.845	46.87	46.7525	46.8275	7930792.0
2018-05-07 11:30:00	AAPL	Stock	46.8285	46.85	46.705	46.8452	6336728.0
2018-05-07 12:00:00	AAPL	Stock	46.8462	46.8528	46.69	46.7225	5716356.0
2018-05-07 12:30:00	AAPL	Stock	46.72	46.745	46.2925	46.4175	12674048.0
2018-05-07 13:00:00	AAPL	Stock	46.42	46.42	46.2075	46.3825	8428664.0
2018-05-07 13:30:00	AAPL	Stock	46.3825	46.6	46.3625	46.565	6252028.0
2018-05-07 14:00:00	AAPL	Stock	46.5675	46.645	46.4625	46.5775	6362204.0
2018-05-07 14:30:00	AAPL	Stock	46.5798	46.605	46.3225	46.3775	6767192.0
2018-05-07 15:00:00	AAPL	Stock	46.3772	46.495	46.1875	46.3525	10612764.0
2018-05-07 15:30:00	AAPL	Stock	46.3525	46.405	46.2375	46.2825	11143304.0
2018-05-07 16:00:00	AAPL	Stock	46.29	46.5698	46.265	46.285	6392524.0
2018-05-07 16:30:00	AAPL	Stock	46.29	46.29	46.2525	46.275	58204.0
2018-05-07 17:00:00	AAPL	Stock	46.275	46.275	46.25	46.27	29988.0
2018-05-07 17:30:00	AAPL	Stock	46.25	46.27	46.2275	46.2275	39640.0
2018-05-07 18:00:00	AAPL	Stock	46.23	46.25	46.2275	46.23	11892.0
2018-05-07 18:30:00	AAPL	Stock	46.2425	46.25	46.23	46.25	33128.0
2018-05-07 19:00:00	AAPL	Stock	46.25	46.27	46.245	46.27	17044.0
2018-05-07 19:30:00	AAPL	Stock	46.27	46.275	46.2375	46.2375	54764.0
2018-05-07 04:00:00	MSFT	Stock	95.48	95.48	95.48	95.48	100.0
2018-05-07 06:30:00	MSFT	Stock	95.6	95.6	95.6	95.6	300.0
2018-05-07 07:00:00	MSFT	Stock	95.57	95.69	95.56	95.66	7233.0
2018-05-07 07:30:00	MSFT	Stock	95.66	95.79	95.66	95.75	6732.0
2018-05-07 08:00:00	MSFT	Stock	95.7	95.85	95.55	95.6	9545.0
2018-05-07 08:30:00	MSFT	Stock	95.64	95.64	95.48	95.58	20328.0
2018-05-07 09:00:00	MSFT	Stock	95.51	95.58	95.16	95.29	30943.0
2018-05-07 09:30:00	MSFT	Stock	95.3	96.29	95.1	96.05	3366996.0
2018-05-07 10:00:00	MSFT	Stock	96.05	96.195	95.78	96.145	1498664.0
2018-05-07 10:30:00	MSFT	Stock	96.15	96.26	95.83	96.13	1181939.0
2018-05-07 11:00:00	MSFT	Stock	96.135	96.49	95.93	96.465	1787458.0
2018-05-07 11:30:00	MSFT	Stock	96.47	96.55	96.21	96.488	1289486.0
2018-05-07 12:00:00	MSFT	Stock	96.49	96.53	96.253	96.49	1098372.0
2018-05-07 12:30:00	MSFT	Stock	96.485	96.62	96.36	96.46	1098571.0
2018-05-07 13:00:00	MSFT	Stock	96.458	96.58	96.27	96.546	963163.0
2018-05-07 13:30:00	MSFT	Stock	96.54	96.71	96.51	96.605	1074833.0
2018-05-07 14:00:00	MSFT	Stock	96.605	96.675	96.45	96.58	860911.0
2018-05-07 14:30:00	MSFT	Stock	96.58	96.69	96.11	96.255	1213061.0

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

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