PREVIEW / stock_30min / 2019-03-11

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-11.parquet
  size:    1.7 MB
  rows:    84,800
  symbols: 2,657

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-11 04:00:00	AAPL	Stock	43.3425	43.3425	43.3425	43.3425	400.0
2019-03-11 04:30:00	AAPL	Stock	43.325	43.325	43.325	43.325	400.0
2019-03-11 05:00:00	AAPL	Stock	43.325	43.325	43.325	43.325	7400.0
2019-03-11 05:30:00	AAPL	Stock	43.35	43.3725	43.35	43.35	7268.0
2019-03-11 06:00:00	AAPL	Stock	43.3725	44.075	43.3725	43.95	164588.0
2019-03-11 06:30:00	AAPL	Stock	43.9625	44.085	43.925	44.0475	67060.0
2019-03-11 07:00:00	AAPL	Stock	43.965	44.0	43.855	43.93	111616.0
2019-03-11 07:30:00	AAPL	Stock	43.91	43.995	43.9	43.975	116492.0
2019-03-11 08:00:00	AAPL	Stock	44.0	44.045	43.8375	43.9175	256764.0
2019-03-11 08:30:00	AAPL	Stock	43.9275	44.06	43.9125	44.0	329612.0
2019-03-11 09:00:00	AAPL	Stock	44.0125	44.04	43.8325	43.8725	549900.0
2019-03-11 09:30:00	AAPL	Stock	43.8725	44.3375	43.8375	44.3338	18397772.0
2019-03-11 10:00:00	AAPL	Stock	44.335	44.42	44.2525	44.375	10408532.0
2019-03-11 10:30:00	AAPL	Stock	44.375	44.5425	44.3575	44.533	9775720.0
2019-03-11 11:00:00	AAPL	Stock	44.5325	44.655	44.5	44.6375	6876468.0
2019-03-11 11:30:00	AAPL	Stock	44.6375	44.7275	44.5775	44.6938	6895076.0
2019-03-11 12:00:00	AAPL	Stock	44.695	44.745	44.635	44.6375	5362424.0
2019-03-11 12:30:00	AAPL	Stock	44.6375	44.6875	44.6175	44.635	3805400.0
2019-03-11 13:00:00	AAPL	Stock	44.6375	44.71	44.615	44.71	4479784.0
2019-03-11 13:30:00	AAPL	Stock	44.7082	44.7375	44.6875	44.71	3134496.0
2019-03-11 14:00:00	AAPL	Stock	44.71	44.7152	44.64	44.6625	3609820.0
2019-03-11 14:30:00	AAPL	Stock	44.6675	44.705	44.6275	44.66	4219140.0
2019-03-11 15:00:00	AAPL	Stock	44.66	44.735	44.6125	44.7125	6817524.0
2019-03-11 15:30:00	AAPL	Stock	44.7125	44.78	44.6875	44.745	12349884.0
2019-03-11 16:00:00	AAPL	Stock	44.725	44.78	44.7225	44.7625	11369608.0
2019-03-11 16:30:00	AAPL	Stock	44.78	44.875	44.725	44.85	123152.0
2019-03-11 17:00:00	AAPL	Stock	44.86	44.86	44.83	44.84	17404.0
2019-03-11 17:30:00	AAPL	Stock	44.85	44.85	44.7975	44.825	22452.0
2019-03-11 18:00:00	AAPL	Stock	44.7975	44.845	44.7975	44.845	30288.0
2019-03-11 18:30:00	AAPL	Stock	44.8425	44.95	44.83	44.95	70272.0
2019-03-11 19:00:00	AAPL	Stock	44.935	44.95	44.8875	44.9375	40184.0
2019-03-11 19:30:00	AAPL	Stock	44.9225	44.96	44.9	44.96	34132.0
2019-03-11 04:00:00	MSFT	Stock	110.81	110.81	110.81	110.81	100.0
2019-03-11 06:00:00	MSFT	Stock	110.82	110.82	110.53	110.7	3726.0
2019-03-11 06:30:00	MSFT	Stock	110.75	110.77	110.73	110.75	4471.0
2019-03-11 07:00:00	MSFT	Stock	110.75	110.77	110.55	110.55	3288.0
2019-03-11 07:30:00	MSFT	Stock	110.69	110.96	110.59	110.87	7554.0
2019-03-11 08:00:00	MSFT	Stock	110.8	110.93	110.7	110.8	9469.0
2019-03-11 08:30:00	MSFT	Stock	110.86	111.21	110.7	111.17	19286.0
2019-03-11 09:00:00	MSFT	Stock	111.11	111.19	110.85	110.99	11976.0
2019-03-11 09:30:00	MSFT	Stock	110.99	112.29	110.98	112.09	2728739.0
2019-03-11 10:00:00	MSFT	Stock	112.09	112.355	112.05	112.165	1255668.0
2019-03-11 10:30:00	MSFT	Stock	112.17	112.45	112.04	112.425	1450518.0
2019-03-11 11:00:00	MSFT	Stock	112.43	112.54	112.22	112.52	1330672.0
2019-03-11 11:30:00	MSFT	Stock	112.52	112.86	112.48	112.685	1197150.0
2019-03-11 12:00:00	MSFT	Stock	112.685	112.79	112.54	112.69	959678.0
2019-03-11 12:30:00	MSFT	Stock	112.68	112.93	112.55	112.565	1051074.0
2019-03-11 13:00:00	MSFT	Stock	112.57	112.8	112.47	112.79	801081.0
2019-03-11 13:30:00	MSFT	Stock	112.799	112.94	112.74	112.795	779367.0
2019-03-11 14:00:00	MSFT	Stock	112.799	112.82	112.51	112.51	832162.0

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

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