PREVIEW / stock_30min / 2019-02-28

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-28.parquet
  size:    1.7 MB
  rows:    84,640
  symbols: 2,666

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-28 04:00:00	AAPL	Stock	43.5625	43.5625	43.43	43.4575	5980.0
2019-02-28 04:30:00	AAPL	Stock	43.5225	43.5225	43.5025	43.5025	1468.0
2019-02-28 05:00:00	AAPL	Stock	43.5075	43.5075	43.5	43.5	1900.0
2019-02-28 06:00:00	AAPL	Stock	43.5575	43.5875	43.5575	43.5875	4056.0
2019-02-28 06:30:00	AAPL	Stock	43.5875	43.5875	43.565	43.565	13896.0
2019-02-28 07:00:00	AAPL	Stock	43.62	43.62	43.5625	43.5825	15136.0
2019-02-28 07:30:00	AAPL	Stock	43.5875	43.6525	43.575	43.6525	26052.0
2019-02-28 08:00:00	AAPL	Stock	43.6125	43.6625	43.575	43.6	53580.0
2019-02-28 08:30:00	AAPL	Stock	43.6325	43.6875	43.6	43.6125	69788.0
2019-02-28 09:00:00	AAPL	Stock	43.62	43.6375	43.575	43.585	38956.0
2019-02-28 09:30:00	AAPL	Stock	43.58	43.7275	43.4875	43.5725	9903992.0
2019-02-28 10:00:00	AAPL	Stock	43.5712	43.5712	43.4325	43.4625	7018888.0
2019-02-28 10:30:00	AAPL	Stock	43.4625	43.5478	43.3975	43.43	4934148.0
2019-02-28 11:00:00	AAPL	Stock	43.4275	43.5275	43.35	43.495	4029168.0
2019-02-28 11:30:00	AAPL	Stock	43.495	43.605	43.475	43.5425	3258320.0
2019-02-28 12:00:00	AAPL	Stock	43.545	43.555	43.455	43.52	2823796.0
2019-02-28 12:30:00	AAPL	Stock	43.52	43.5925	43.495	43.5725	2203256.0
2019-02-28 13:00:00	AAPL	Stock	43.57	43.5825	43.5125	43.525	1837492.0
2019-02-28 13:30:00	AAPL	Stock	43.5262	43.57	43.5162	43.555	2112176.0
2019-02-28 14:00:00	AAPL	Stock	43.555	43.5875	43.505	43.5675	2583812.0
2019-02-28 14:30:00	AAPL	Stock	43.5675	43.57	43.4775	43.5275	3152380.0
2019-02-28 15:00:00	AAPL	Stock	43.5262	43.5275	43.46	43.5025	3914680.0
2019-02-28 15:30:00	AAPL	Stock	43.5025	43.5425	43.23	43.3	13395448.0
2019-02-28 16:00:00	AAPL	Stock	43.2875	43.3475	43.2775	43.3025	29822980.0
2019-02-28 16:30:00	AAPL	Stock	43.3025	43.3175	43.3	43.3125	18880.0
2019-02-28 17:00:00	AAPL	Stock	43.3125	43.3125	43.29	43.3125	9576.0
2019-02-28 17:30:00	AAPL	Stock	43.3125	43.325	43.2875	43.31	54660.0
2019-02-28 18:00:00	AAPL	Stock	43.32	43.32	43.2725	43.2725	9400.0
2019-02-28 18:30:00	AAPL	Stock	43.27	43.315	43.27	43.2875	15416.0
2019-02-28 19:00:00	AAPL	Stock	43.3175	43.3675	43.3175	43.325	4648.0
2019-02-28 19:30:00	AAPL	Stock	43.325	43.36	43.3125	43.36	32800.0
2019-02-28 04:00:00	MSFT	Stock	111.99	111.99	111.85	111.85	3500.0
2019-02-28 05:30:00	MSFT	Stock	111.89	111.89	111.89	111.89	200.0
2019-02-28 06:00:00	MSFT	Stock	111.77	111.77	111.77	111.77	100.0
2019-02-28 07:00:00	MSFT	Stock	111.85	111.93	111.83	111.9	1543.0
2019-02-28 07:30:00	MSFT	Stock	111.95	112.1	111.95	112.01	1832.0
2019-02-28 08:00:00	MSFT	Stock	111.95	112.05	111.8	111.89	9985.0
2019-02-28 08:30:00	MSFT	Stock	112.09	112.236	111.98	112.02	3708.0
2019-02-28 09:00:00	MSFT	Stock	112.02	112.1	111.99	111.99	12211.0
2019-02-28 09:30:00	MSFT	Stock	112.04	112.88	111.93	112.39	2525857.0
2019-02-28 10:00:00	MSFT	Stock	112.38	112.42	111.91	112.225	1565965.0
2019-02-28 10:30:00	MSFT	Stock	112.22	112.368	111.91	112.03	1029366.0
2019-02-28 11:00:00	MSFT	Stock	112.035	112.2	111.835	112.075	925627.0
2019-02-28 11:30:00	MSFT	Stock	112.08	112.45	112.06	112.31	758120.0
2019-02-28 12:00:00	MSFT	Stock	112.319	112.55	112.21	112.54	3673918.0
2019-02-28 12:30:00	MSFT	Stock	112.548	112.61	112.44	112.6	523909.0
2019-02-28 13:00:00	MSFT	Stock	112.6	112.62	112.38	112.495	739209.0
2019-02-28 13:30:00	MSFT	Stock	112.49	112.6	112.41	112.42	681310.0
2019-02-28 14:00:00	MSFT	Stock	112.415	112.53	112.32	112.47	631775.0
2019-02-28 14:30:00	MSFT	Stock	112.465	112.467	112.17	112.28	746850.0

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

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