PREVIEW / stock_30min / 2018-03-12

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-12.parquet
  size:    1.7 MB
  rows:    83,622
  symbols: 2,882

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-03-12 04:00:00	AAPL	Stock	45.025	45.25	45.025	45.245	13876.0
2018-03-12 04:30:00	AAPL	Stock	45.1825	45.2125	45.1825	45.2125	7668.0
2018-03-12 05:00:00	AAPL	Stock	45.215	45.2275	45.2125	45.2125	5444.0
2018-03-12 05:30:00	AAPL	Stock	45.2125	45.2225	45.1375	45.2225	14000.0
2018-03-12 06:00:00	AAPL	Stock	45.22	45.22	45.22	45.22	400.0
2018-03-12 06:30:00	AAPL	Stock	45.2	45.2	45.1575	45.1575	9200.0
2018-03-12 07:00:00	AAPL	Stock	45.185	45.2	45.125	45.1875	185616.0
2018-03-12 07:30:00	AAPL	Stock	45.185	45.2	45.155	45.1625	139100.0
2018-03-12 08:00:00	AAPL	Stock	45.1625	45.2	45.1025	45.1225	207952.0
2018-03-12 08:30:00	AAPL	Stock	45.1025	45.125	45.075	45.0975	150744.0
2018-03-12 09:00:00	AAPL	Stock	45.09	45.1475	45.0325	45.08	350052.0
2018-03-12 09:30:00	AAPL	Stock	45.075	45.48	45.0525	45.3475	19301484.0
2018-03-12 10:00:00	AAPL	Stock	45.35	45.5	45.3475	45.465	10423744.0
2018-03-12 10:30:00	AAPL	Stock	45.465	45.55	45.395	45.3975	13075792.0
2018-03-12 11:00:00	AAPL	Stock	45.4	45.47	45.22	45.25	8020644.0
2018-03-12 11:30:00	AAPL	Stock	45.2525	45.4712	45.2475	45.4712	6237556.0
2018-03-12 12:00:00	AAPL	Stock	45.4712	45.52	45.4525	45.4875	6340096.0
2018-03-12 12:30:00	AAPL	Stock	45.4875	45.5	45.4125	45.4375	4074420.0
2018-03-12 13:00:00	AAPL	Stock	45.4375	45.53	45.4325	45.507	5254576.0
2018-03-12 13:30:00	AAPL	Stock	45.5065	45.545	45.402	45.4125	5279792.0
2018-03-12 14:00:00	AAPL	Stock	45.4165	45.45	45.265	45.3798	6348800.0
2018-03-12 14:30:00	AAPL	Stock	45.3775	45.4275	45.2825	45.4263	4916796.0
2018-03-12 15:00:00	AAPL	Stock	45.425	45.4975	45.385	45.4725	5630576.0
2018-03-12 15:30:00	AAPL	Stock	45.4725	45.5975	45.4275	45.4325	16027120.0
2018-03-12 16:00:00	AAPL	Stock	45.4325	45.4975	45.43	45.44	6226276.0
2018-03-12 16:30:00	AAPL	Stock	45.4375	45.4575	45.43	45.45	41656.0
2018-03-12 17:00:00	AAPL	Stock	45.4575	45.475	45.45	45.4725	24692.0
2018-03-12 17:30:00	AAPL	Stock	45.46	45.465	45.445	45.4625	7256.0
2018-03-12 18:00:00	AAPL	Stock	45.465	45.4725	45.4625	45.4725	3744.0
2018-03-12 18:30:00	AAPL	Stock	45.475	45.475	45.4525	45.475	9420.0
2018-03-12 19:00:00	AAPL	Stock	45.475	45.475	45.4475	45.465	9180.0
2018-03-12 19:30:00	AAPL	Stock	45.4525	45.475	45.445	45.4725	20016.0
2018-03-12 04:00:00	MSFT	Stock	97.0	97.0	96.86	96.86	1261.0
2018-03-12 04:30:00	MSFT	Stock	96.96	96.96	96.86	96.86	411.0
2018-03-12 05:30:00	MSFT	Stock	96.95	96.95	96.83	96.83	999.0
2018-03-12 06:00:00	MSFT	Stock	96.83	96.88	96.8	96.82	2093.0
2018-03-12 06:30:00	MSFT	Stock	96.95	96.95	96.95	96.95	1118.0
2018-03-12 07:00:00	MSFT	Stock	96.96	97.1	96.96	97.0	11881.0
2018-03-12 07:30:00	MSFT	Stock	96.92	96.92	96.78	96.81	9087.0
2018-03-12 08:00:00	MSFT	Stock	96.79	97.1	96.75	96.75	21205.0
2018-03-12 08:30:00	MSFT	Stock	96.75	96.85	96.72	96.76	14634.0
2018-03-12 09:00:00	MSFT	Stock	96.8	96.87	96.41	96.5	79376.0
2018-03-12 09:30:00	MSFT	Stock	96.57	96.91	96.04	96.88	2797804.0
2018-03-12 10:00:00	MSFT	Stock	96.885	96.9	96.435	96.6	1766272.0
2018-03-12 10:30:00	MSFT	Stock	96.605	96.605	96.23	96.31	1514863.0
2018-03-12 11:00:00	MSFT	Stock	96.32	96.5	96.065	96.23	1151833.0
2018-03-12 11:30:00	MSFT	Stock	96.23	96.525	96.2	96.5	1047843.0
2018-03-12 12:00:00	MSFT	Stock	96.505	96.85	96.495	96.762	1036336.0
2018-03-12 12:30:00	MSFT	Stock	96.76	96.85	96.61	96.75	711345.0
2018-03-12 13:00:00	MSFT	Stock	96.755	97.05	96.74	97.01	994561.0

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

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