PREVIEW / stock_30min / 2017-06-23

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-23.parquet
  size:    1.6 MB
  rows:    81,938
  symbols: 3,005

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
2017-06-23 06:00:00	AAPL	Stock	36.4875	36.4875	36.4125	36.4125	6400.0
2017-06-23 06:30:00	AAPL	Stock	36.4	36.4	36.365	36.38	5188.0
2017-06-23 07:00:00	AAPL	Stock	36.365	36.3925	36.3625	36.3675	17708.0
2017-06-23 07:30:00	AAPL	Stock	36.3675	36.3675	36.355	36.355	7448.0
2017-06-23 08:00:00	AAPL	Stock	36.3625	36.3875	36.3525	36.3575	45152.0
2017-06-23 08:30:00	AAPL	Stock	36.3575	36.38	36.325	36.38	49964.0
2017-06-23 09:00:00	AAPL	Stock	36.38	36.3875	36.265	36.2925	126204.0
2017-06-23 09:30:00	AAPL	Stock	36.2875	36.4775	36.2775	36.4525	8410884.0
2017-06-23 10:00:00	AAPL	Stock	36.45	36.4575	36.29	36.4288	4770376.0
2017-06-23 10:30:00	AAPL	Stock	36.4288	36.575	36.4263	36.53	4911744.0
2017-06-23 11:00:00	AAPL	Stock	36.53	36.5975	36.525	36.58	3650828.0
2017-06-23 11:30:00	AAPL	Stock	36.5775	36.7275	36.5575	36.715	4918724.0
2017-06-23 12:00:00	AAPL	Stock	36.715	36.725	36.6425	36.7225	3809992.0
2017-06-23 12:30:00	AAPL	Stock	36.7225	36.7562	36.7138	36.725	3046384.0
2017-06-23 13:00:00	AAPL	Stock	36.7225	36.735	36.66	36.7162	2308548.0
2017-06-23 13:30:00	AAPL	Stock	36.7152	36.79	36.7028	36.7537	3439100.0
2017-06-23 14:00:00	AAPL	Stock	36.755	36.77	36.71	36.7158	3036188.0
2017-06-23 14:30:00	AAPL	Stock	36.715	36.7275	36.65	36.6675	3531444.0
2017-06-23 15:00:00	AAPL	Stock	36.6675	36.6775	36.55	36.575	6461392.0
2017-06-23 15:30:00	AAPL	Stock	36.575	36.6838	36.5675	36.5725	12875928.0
2017-06-23 16:00:00	AAPL	Stock	36.5925	36.6125	36.55	36.6075	51172736.0
2017-06-23 16:30:00	AAPL	Stock	36.605	36.6225	36.57	36.6225	702808.0
2017-06-23 17:00:00	AAPL	Stock	36.6075	36.6175	36.605	36.61	29140.0
2017-06-23 17:30:00	AAPL	Stock	36.6075	36.61	36.5775	36.5875	33344.0
2017-06-23 18:00:00	AAPL	Stock	36.5775	36.5875	36.5775	36.5875	1440.0
2017-06-23 18:30:00	AAPL	Stock	36.595	36.595	36.5875	36.595	8600.0
2017-06-23 19:00:00	AAPL	Stock	36.595	36.595	36.595	36.595	1540.0
2017-06-23 19:30:00	AAPL	Stock	36.5775	36.595	36.57	36.595	19356.0
2017-06-23 06:30:00	MSFT	Stock	70.2	70.2	70.2	70.2	106.0
2017-06-23 07:30:00	MSFT	Stock	70.2	70.2	70.2	70.2	4100.0
2017-06-23 08:00:00	MSFT	Stock	70.26	70.28	70.26	70.28	600.0
2017-06-23 08:30:00	MSFT	Stock	70.2	70.2	70.2	70.2	212.0
2017-06-23 09:00:00	MSFT	Stock	70.35	70.35	70.0	70.0	1961.0
2017-06-23 09:30:00	MSFT	Stock	70.08	70.32	69.92	70.22	1785095.0
2017-06-23 10:00:00	MSFT	Stock	70.225	70.375	70.09	70.33	835932.0
2017-06-23 10:30:00	MSFT	Stock	70.33	70.58	70.32	70.46	1322911.0
2017-06-23 11:00:00	MSFT	Stock	70.46	70.6	70.45	70.56	613330.0
2017-06-23 11:30:00	MSFT	Stock	70.57	70.58	70.43	70.51	499233.0
2017-06-23 12:00:00	MSFT	Stock	70.51	70.81	70.475	70.798	1572398.0
2017-06-23 12:30:00	MSFT	Stock	70.795	70.856	70.75	70.76	529237.0
2017-06-23 13:00:00	MSFT	Stock	70.77	70.86	70.75	70.85	696164.0
2017-06-23 13:30:00	MSFT	Stock	70.85	70.99	70.83	70.975	792892.0
2017-06-23 14:00:00	MSFT	Stock	70.975	71.06	70.97	70.98	1337452.0
2017-06-23 14:30:00	MSFT	Stock	70.985	71.06	70.94	70.95	1202211.0
2017-06-23 15:00:00	MSFT	Stock	70.95	71.02	70.78	70.85	1527050.0
2017-06-23 15:30:00	MSFT	Stock	70.86	71.25	70.85	71.23	5386320.0
2017-06-23 16:00:00	MSFT	Stock	71.23	71.23	70.99	71.06	6175702.0
2017-06-23 16:30:00	MSFT	Stock	71.07	71.1	71.0	71.1	12021.0
2017-06-23 17:00:00	MSFT	Stock	71.08	71.1	71.07	71.07	1167.0
2017-06-23 17:30:00	MSFT	Stock	71.07	71.21	71.02	71.21	545151.0

> showing 50 of 81,938 rows — these rows as CSV

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