PREVIEW / stock_30min / 2019-02-19

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-19.parquet
  size:    1.7 MB
  rows:    85,293
  symbols: 2,662

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-02-19 04:00:00	AAPL	Stock	42.6175	42.6175	42.605	42.605	940.0
2019-02-19 04:30:00	AAPL	Stock	42.5	42.5	42.475	42.475	5480.0
2019-02-19 05:00:00	AAPL	Stock	42.5	42.525	42.475	42.475	8172.0
2019-02-19 05:30:00	AAPL	Stock	42.4875	42.4875	42.45	42.475	6528.0
2019-02-19 06:00:00	AAPL	Stock	42.47	42.5	42.4625	42.4625	14900.0
2019-02-19 06:30:00	AAPL	Stock	42.375	42.41	42.375	42.375	5600.0
2019-02-19 07:00:00	AAPL	Stock	42.44	42.495	42.44	42.4575	55316.0
2019-02-19 07:30:00	AAPL	Stock	42.4775	42.5125	42.4525	42.5	32652.0
2019-02-19 08:00:00	AAPL	Stock	42.4578	42.505	42.38	42.3875	137788.0
2019-02-19 08:30:00	AAPL	Stock	42.435	42.525	42.3525	42.4625	151488.0
2019-02-19 09:00:00	AAPL	Stock	42.4675	42.525	42.375	42.425	130320.0
2019-02-19 09:30:00	AAPL	Stock	42.43	42.75	42.3575	42.525	11271336.0
2019-02-19 10:00:00	AAPL	Stock	42.525	42.55	42.3787	42.5175	7924480.0
2019-02-19 10:30:00	AAPL	Stock	42.52	42.5625	42.4452	42.5325	3837620.0
2019-02-19 11:00:00	AAPL	Stock	42.5338	42.5875	42.5145	42.5157	3133876.0
2019-02-19 11:30:00	AAPL	Stock	42.5175	42.6975	42.51	42.6875	4431000.0
2019-02-19 12:00:00	AAPL	Stock	42.68	42.695	42.6275	42.6825	2916192.0
2019-02-19 12:30:00	AAPL	Stock	42.68	42.6975	42.63	42.64	2700588.0
2019-02-19 13:00:00	AAPL	Stock	42.6388	42.6525	42.5775	42.6098	2023676.0
2019-02-19 13:30:00	AAPL	Stock	42.6075	42.675	42.6	42.655	1665696.0
2019-02-19 14:00:00	AAPL	Stock	42.655	42.7365	42.65	42.735	2517828.0
2019-02-19 14:30:00	AAPL	Stock	42.7345	42.86	42.72	42.852	4024984.0
2019-02-19 15:00:00	AAPL	Stock	42.8525	42.855	42.745	42.775	3432620.0
2019-02-19 15:30:00	AAPL	Stock	42.7725	42.81	42.685	42.735	6335988.0
2019-02-19 16:00:00	AAPL	Stock	42.7325	42.7328	42.5998	42.5998	5691696.0
2019-02-19 16:30:00	AAPL	Stock	42.7125	42.7325	42.5868	42.7325	1812684.0
2019-02-19 17:00:00	AAPL	Stock	42.725	42.7325	42.725	42.725	11844.0
2019-02-19 17:30:00	AAPL	Stock	42.725	42.7325	42.715	42.7175	10220.0
2019-02-19 18:00:00	AAPL	Stock	42.7125	42.7325	42.7125	42.7125	9476.0
2019-02-19 18:30:00	AAPL	Stock	42.7325	42.735	42.7075	42.71	5076.0
2019-02-19 19:00:00	AAPL	Stock	42.7075	42.745	42.7075	42.71	10988.0
2019-02-19 19:30:00	AAPL	Stock	42.71	42.75	42.7075	42.75	11868.0
2019-02-19 04:00:00	MSFT	Stock	108.23	108.23	108.1	108.1	600.0
2019-02-19 05:00:00	MSFT	Stock	108.03	108.03	108.0	108.0	369.0
2019-02-19 05:30:00	MSFT	Stock	108.1	108.1	108.1	108.1	100.0
2019-02-19 06:00:00	MSFT	Stock	107.95	108.0	107.95	108.0	300.0
2019-02-19 07:00:00	MSFT	Stock	107.93	108.0	107.87	107.92	3488.0
2019-02-19 07:30:00	MSFT	Stock	107.96	108.03	107.96	108.03	1700.0
2019-02-19 08:00:00	MSFT	Stock	107.98	108.1	107.857	107.87	7105.0
2019-02-19 08:30:00	MSFT	Stock	107.93	108.06	107.85	108.06	4530.0
2019-02-19 09:00:00	MSFT	Stock	107.92	108.0	107.72	107.8	15488.0
2019-02-19 09:30:00	MSFT	Stock	107.79	108.21	107.78	108.043	2065471.0
2019-02-19 10:00:00	MSFT	Stock	108.05	108.28	108.04	108.215	1127557.0
2019-02-19 10:30:00	MSFT	Stock	108.215	108.23	107.95	108.19	819697.0
2019-02-19 11:00:00	MSFT	Stock	108.19	108.27	107.98	108.02	974010.0
2019-02-19 11:30:00	MSFT	Stock	108.025	108.61	108.008	108.59	1109447.0
2019-02-19 12:00:00	MSFT	Stock	108.59	108.65	108.47	108.63	686063.0
2019-02-19 12:30:00	MSFT	Stock	108.63	108.66	108.45	108.45	713232.0
2019-02-19 13:00:00	MSFT	Stock	108.46	108.48	108.31	108.33	551870.0
2019-02-19 13:30:00	MSFT	Stock	108.33	108.39	108.215	108.3	640568.0

> showing 50 of 85,293 rows — these rows as CSV

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