PREVIEW / stock_30min / 2019-03-20

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-20.parquet
  size:    1.7 MB
  rows:    84,108
  symbols: 2,642

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-03-20 04:00:00	AAPL	Stock	46.525	46.6875	46.5075	46.625	9388.0
2019-03-20 04:30:00	AAPL	Stock	46.67	46.6875	46.67	46.6875	1620.0
2019-03-20 05:00:00	AAPL	Stock	46.6825	46.6825	46.665	46.675	14976.0
2019-03-20 05:30:00	AAPL	Stock	46.68	46.695	46.625	46.67	19220.0
2019-03-20 06:00:00	AAPL	Stock	46.6325	46.7375	46.6325	46.65	5176.0
2019-03-20 06:30:00	AAPL	Stock	46.675	46.7075	46.625	46.625	2628.0
2019-03-20 07:00:00	AAPL	Stock	46.625	46.6275	46.535	46.55	33764.0
2019-03-20 07:30:00	AAPL	Stock	46.5525	46.625	46.5525	46.625	28076.0
2019-03-20 08:00:00	AAPL	Stock	46.575	46.7475	46.5335	46.625	92656.0
2019-03-20 08:30:00	AAPL	Stock	46.66	46.6625	46.545	46.55	65244.0
2019-03-20 09:00:00	AAPL	Stock	46.56	46.655	46.5275	46.5575	55844.0
2019-03-20 09:30:00	AAPL	Stock	46.57	46.645	46.1825	46.355	13745320.0
2019-03-20 10:00:00	AAPL	Stock	46.3575	46.78	46.3525	46.7425	8045492.0
2019-03-20 10:30:00	AAPL	Stock	46.75	46.8442	46.7075	46.7725	4817260.0
2019-03-20 11:00:00	AAPL	Stock	46.7725	46.81	46.5375	46.6225	5023068.0
2019-03-20 11:30:00	AAPL	Stock	46.6175	46.675	46.58	46.5825	3860304.0
2019-03-20 12:00:00	AAPL	Stock	46.5825	46.79	46.5825	46.785	3359540.0
2019-03-20 12:30:00	AAPL	Stock	46.7838	46.8	46.6175	46.737	5184016.0
2019-03-20 13:00:00	AAPL	Stock	46.735	46.7575	46.6925	46.7075	2407488.0
2019-03-20 13:30:00	AAPL	Stock	46.705	46.79	46.7025	46.79	2267836.0
2019-03-20 14:00:00	AAPL	Stock	46.79	47.3125	46.77	47.2962	11692432.0
2019-03-20 14:30:00	AAPL	Stock	47.2975	47.3725	47.18	47.2028	8444324.0
2019-03-20 15:00:00	AAPL	Stock	47.205	47.245	47.1	47.2012	6460160.0
2019-03-20 15:30:00	AAPL	Stock	47.2012	47.22	46.9675	47.0425	11033944.0
2019-03-20 16:00:00	AAPL	Stock	47.04	47.04	46.965	47.005	13732964.0
2019-03-20 16:30:00	AAPL	Stock	47.005	47.04	46.955	46.995	63648.0
2019-03-20 17:00:00	AAPL	Stock	46.955	46.995	46.955	46.975	12208.0
2019-03-20 17:30:00	AAPL	Stock	46.995	47.0	46.955	46.9975	18696.0
2019-03-20 18:00:00	AAPL	Stock	47.0	47.0	46.965	47.0	15732.0
2019-03-20 18:30:00	AAPL	Stock	47.0	47.0325	47.0	47.025	11132.0
2019-03-20 19:00:00	AAPL	Stock	47.0325	47.095	47.0325	47.09	11724.0
2019-03-20 19:30:00	AAPL	Stock	47.0975	47.1225	47.05	47.1225	20956.0
2019-03-20 04:00:00	MSFT	Stock	117.5	117.5	117.5	117.5	305.0
2019-03-20 04:30:00	MSFT	Stock	117.53	117.53	117.53	117.53	200.0
2019-03-20 05:00:00	MSFT	Stock	117.58	117.63	117.58	117.63	200.0
2019-03-20 06:00:00	MSFT	Stock	117.65	117.71	117.65	117.65	687.0
2019-03-20 06:30:00	MSFT	Stock	117.6	117.65	117.6	117.65	680.0
2019-03-20 07:00:00	MSFT	Stock	117.53	117.53	117.53	117.53	200.0
2019-03-20 07:30:00	MSFT	Stock	117.43	117.48	117.4	117.48	1028.0
2019-03-20 08:00:00	MSFT	Stock	117.3	117.55	117.3	117.44	6627.0
2019-03-20 08:30:00	MSFT	Stock	117.5	117.59	117.3	117.3	2776.0
2019-03-20 09:00:00	MSFT	Stock	117.3	117.53	116.94	117.3	33277.0
2019-03-20 09:30:00	MSFT	Stock	117.3	117.46	116.71	116.88	2401903.0
2019-03-20 10:00:00	MSFT	Stock	116.88	117.545	116.86	117.44	1548939.0
2019-03-20 10:30:00	MSFT	Stock	117.44	117.545	117.22	117.33	1051043.0
2019-03-20 11:00:00	MSFT	Stock	117.35	117.56	117.32	117.558	893212.0
2019-03-20 11:30:00	MSFT	Stock	117.56	117.59	117.035	117.105	1121506.0
2019-03-20 12:00:00	MSFT	Stock	117.11	117.535	117.11	117.37	911352.0
2019-03-20 12:30:00	MSFT	Stock	117.37	117.37	116.965	117.28	1340981.0
2019-03-20 13:00:00	MSFT	Stock	117.27	117.31	117.16	117.197	438859.0

> showing 50 of 84,108 rows — these rows as CSV

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