PREVIEW / stock_30min / 2018-03-09

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-09.parquet
  size:    1.7 MB
  rows:    83,573
  symbols: 2,868

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-09 04:00:00	AAPL	Stock	44.2675	44.2675	44.2675	44.2675	972.0
2018-03-09 04:30:00	AAPL	Stock	44.335	44.335	44.335	44.335	400.0
2018-03-09 05:00:00	AAPL	Stock	44.2375	44.3475	44.2375	44.335	6172.0
2018-03-09 05:30:00	AAPL	Stock	44.235	44.235	44.235	44.235	4200.0
2018-03-09 06:00:00	AAPL	Stock	44.2475	44.2475	44.2475	44.2475	1600.0
2018-03-09 06:30:00	AAPL	Stock	44.2475	44.2475	44.235	44.235	800.0
2018-03-09 07:00:00	AAPL	Stock	44.23	44.3175	44.23	44.3175	101848.0
2018-03-09 07:30:00	AAPL	Stock	44.3	44.3	44.2575	44.275	29708.0
2018-03-09 08:00:00	AAPL	Stock	44.275	44.3025	44.15	44.15	190668.0
2018-03-09 08:30:00	AAPL	Stock	44.1425	44.5375	44.125	44.525	659984.0
2018-03-09 09:00:00	AAPL	Stock	44.5125	44.5475	44.42	44.4425	312524.0
2018-03-09 09:30:00	AAPL	Stock	44.49	44.61	44.3475	44.495	14818320.0
2018-03-09 10:00:00	AAPL	Stock	44.495	44.6825	44.485	44.6612	9874784.0
2018-03-09 10:30:00	AAPL	Stock	44.6608	44.7275	44.6148	44.65	6855188.0
2018-03-09 11:00:00	AAPL	Stock	44.65	44.825	44.6425	44.8225	7897632.0
2018-03-09 11:30:00	AAPL	Stock	44.8225	44.9075	44.7775	44.8575	7798244.0
2018-03-09 12:00:00	AAPL	Stock	44.8575	44.9125	44.8075	44.81	5977372.0
2018-03-09 12:30:00	AAPL	Stock	44.81	44.8675	44.7325	44.7725	4741568.0
2018-03-09 13:00:00	AAPL	Stock	44.7775	44.8375	44.765	44.7675	4326032.0
2018-03-09 13:30:00	AAPL	Stock	44.77	44.8825	44.73	44.8728	4949444.0
2018-03-09 14:00:00	AAPL	Stock	44.8775	44.9275	44.8175	44.864	5258472.0
2018-03-09 14:30:00	AAPL	Stock	44.8625	44.9175	44.84	44.91	4231136.0
2018-03-09 15:00:00	AAPL	Stock	44.9125	44.9475	44.89	44.9462	6150192.0
2018-03-09 15:30:00	AAPL	Stock	44.945	45.0	44.89	44.99	18482172.0
2018-03-09 16:00:00	AAPL	Stock	44.995	45.0	44.784	44.975	10701672.0
2018-03-09 16:30:00	AAPL	Stock	44.985	44.985	44.9575	44.975	62140.0
2018-03-09 17:00:00	AAPL	Stock	44.9675	44.975	44.955	44.97	27764.0
2018-03-09 17:30:00	AAPL	Stock	44.985	44.9875	44.9525	44.9525	31272.0
2018-03-09 18:00:00	AAPL	Stock	44.9525	44.955	44.9275	44.955	16968.0
2018-03-09 18:30:00	AAPL	Stock	44.96	44.96	44.925	44.9475	8740.0
2018-03-09 19:00:00	AAPL	Stock	44.9275	44.975	44.925	44.95	20080.0
2018-03-09 19:30:00	AAPL	Stock	44.9625	44.965	44.95	44.9625	19420.0
2018-03-09 05:00:00	MSFT	Stock	94.26	94.26	94.26	94.26	500.0
2018-03-09 07:30:00	MSFT	Stock	94.45	94.45	94.45	94.45	200.0
2018-03-09 08:00:00	MSFT	Stock	94.55	94.55	94.4	94.45	11825.0
2018-03-09 08:30:00	MSFT	Stock	94.48	95.3	94.48	95.21	66056.0
2018-03-09 09:00:00	MSFT	Stock	95.15	95.4	95.15	95.33	30742.0
2018-03-09 09:30:00	MSFT	Stock	95.25	95.59	95.0	95.425	3806720.0
2018-03-09 10:00:00	MSFT	Stock	95.43	95.765	95.21	95.69	2321782.0
2018-03-09 10:30:00	MSFT	Stock	95.69	96.02	95.64	95.89	2490945.0
2018-03-09 11:00:00	MSFT	Stock	95.9	95.95	95.6	95.64	2198985.0
2018-03-09 11:30:00	MSFT	Stock	95.64	95.92	95.62	95.83	1244746.0
2018-03-09 12:00:00	MSFT	Stock	95.83	96.26	95.83	96.045	2710594.0
2018-03-09 12:30:00	MSFT	Stock	96.045	96.21	95.99	96.016	1272082.0
2018-03-09 13:00:00	MSFT	Stock	96.02	96.25	96.015	96.24	1220255.0
2018-03-09 13:30:00	MSFT	Stock	96.25	96.29	96.14	96.195	1375001.0
2018-03-09 14:00:00	MSFT	Stock	96.2	96.355	96.1	96.19	1498535.0
2018-03-09 14:30:00	MSFT	Stock	96.2	96.31	96.06	96.165	1521328.0
2018-03-09 15:00:00	MSFT	Stock	96.165	96.25	96.125	96.24	1997227.0
2018-03-09 15:30:00	MSFT	Stock	96.245	96.54	96.09	96.54	6361564.0

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

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