PREVIEW / stock_30min / 2016-01-08

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-08.parquet
  size:    1.6 MB
  rows:    83,904
  symbols: 3,397

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
2016-01-08 04:00:00	AAPL	Stock	24.165	24.3875	24.165	24.35	57540.0
2016-01-08 04:30:00	AAPL	Stock	24.35	24.385	24.35	24.385	10600.0
2016-01-08 05:00:00	AAPL	Stock	24.38	24.3825	24.31	24.335	36760.0
2016-01-08 05:30:00	AAPL	Stock	24.3325	24.335	24.285	24.2875	36360.0
2016-01-08 06:00:00	AAPL	Stock	24.2675	24.2875	24.235	24.2625	140876.0
2016-01-08 06:30:00	AAPL	Stock	24.275	24.2875	24.1625	24.2875	249856.0
2016-01-08 07:00:00	AAPL	Stock	24.2875	24.4225	24.255	24.385	430616.0
2016-01-08 07:30:00	AAPL	Stock	24.375	24.375	24.315	24.35	136712.0
2016-01-08 08:00:00	AAPL	Stock	24.355	24.41	24.225	24.4	764168.0
2016-01-08 08:30:00	AAPL	Stock	24.375	24.5525	24.375	24.425	1773168.0
2016-01-08 09:00:00	AAPL	Stock	24.425	24.635	24.335	24.5825	2174376.0
2016-01-08 09:30:00	AAPL	Stock	24.61	24.7775	24.425	24.7712	47600856.0
2016-01-08 10:00:00	AAPL	Stock	24.77	24.775	24.409	24.4738	23391048.0
2016-01-08 10:30:00	AAPL	Stock	24.475	24.5425	24.3275	24.4088	16038412.0
2016-01-08 11:00:00	AAPL	Stock	24.41	24.4875	24.27	24.3225	18031892.0
2016-01-08 11:30:00	AAPL	Stock	24.3225	24.485	24.19	24.485	17915244.0
2016-01-08 12:00:00	AAPL	Stock	24.4825	24.7275	24.455	24.7035	23954668.0
2016-01-08 12:30:00	AAPL	Stock	24.705	24.7075	24.5428	24.6212	12154600.0
2016-01-08 13:00:00	AAPL	Stock	24.62	24.68	24.56	24.605	10941472.0
2016-01-08 13:30:00	AAPL	Stock	24.605	24.7375	24.589	24.6225	10663444.0
2016-01-08 14:00:00	AAPL	Stock	24.623	24.6403	24.355	24.3725	13566864.0
2016-01-08 14:30:00	AAPL	Stock	24.37	24.52	24.3625	24.41	10467908.0
2016-01-08 15:00:00	AAPL	Stock	24.4075	24.4975	24.3395	24.3625	9938640.0
2016-01-08 15:30:00	AAPL	Stock	24.36	24.361	24.225	24.245	26942316.0
2016-01-08 16:00:00	AAPL	Stock	24.24	24.2625	24.2375	24.255	14254520.0
2016-01-08 16:30:00	AAPL	Stock	24.25	24.2525	24.2375	24.24	324964.0
2016-01-08 17:00:00	AAPL	Stock	24.2475	24.255	24.235	24.255	67316.0
2016-01-08 17:30:00	AAPL	Stock	24.2525	24.2675	24.2475	24.25	108564.0
2016-01-08 18:00:00	AAPL	Stock	24.265	24.295	24.25	24.2675	57532.0
2016-01-08 18:30:00	AAPL	Stock	24.2625	24.2675	24.25	24.2575	14968.0
2016-01-08 19:00:00	AAPL	Stock	24.265	24.265	24.25	24.265	17680.0
2016-01-08 19:30:00	AAPL	Stock	24.2625	24.2675	24.2525	24.2525	41576.0
2016-01-08 05:00:00	MSFT	Stock	52.9	52.9	52.9	52.9	510.0
2016-01-08 05:30:00	MSFT	Stock	52.77	52.77	52.77	52.77	900.0
2016-01-08 06:30:00	MSFT	Stock	52.56	52.56	52.51	52.51	1475.0
2016-01-08 07:00:00	MSFT	Stock	52.52	52.64	52.52	52.63	5721.0
2016-01-08 07:30:00	MSFT	Stock	52.55	52.65	52.55	52.62	23838.0
2016-01-08 08:00:00	MSFT	Stock	52.65	52.77	52.55	52.77	47780.0
2016-01-08 08:30:00	MSFT	Stock	52.77	53.1	52.68	52.72	109282.0
2016-01-08 09:00:00	MSFT	Stock	52.78	52.85	52.17	52.45	286824.0
2016-01-08 09:30:00	MSFT	Stock	52.37	52.97	52.25	52.96	7632519.0
2016-01-08 10:00:00	MSFT	Stock	52.96	53.105	52.64	52.926	3930164.0
2016-01-08 10:30:00	MSFT	Stock	52.93	53.02	52.42	52.5	2772625.0
2016-01-08 11:00:00	MSFT	Stock	52.5	52.73	52.29	52.35	2622542.0
2016-01-08 11:30:00	MSFT	Stock	52.35	52.95	52.15	52.92	2542657.0
2016-01-08 12:00:00	MSFT	Stock	52.92	53.22	52.91	53.02	2480369.0
2016-01-08 12:30:00	MSFT	Stock	53.02	53.12	52.81	53.079	1890070.0
2016-01-08 13:00:00	MSFT	Stock	53.07	53.1	52.875	53.01	2578005.0
2016-01-08 13:30:00	MSFT	Stock	53.0	53.28	52.94	52.97	3108143.0
2016-01-08 14:00:00	MSFT	Stock	52.98	53.05	52.76	52.82	2463376.0

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

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