PREVIEW / stock_30min / 2007-11-16

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-16.parquet
  size:    1.2 MB
  rows:    68,093
  symbols: 3,190

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
2007-11-16 05:00:00	AAPL	Stock	5.8707	5.8707	5.8707	5.8707	2800.0
2007-11-16 06:00:00	AAPL	Stock	5.8839	5.8839	5.8839	5.8839	5600.0
2007-11-16 06:30:00	AAPL	Stock	5.8571	5.8571	5.8571	5.8571	15120.0
2007-11-16 07:00:00	AAPL	Stock	5.8843	5.9286	5.8843	5.9286	295064.0
2007-11-16 07:30:00	AAPL	Stock	5.9268	5.9464	5.9036	5.9214	324576.0
2007-11-16 08:00:00	AAPL	Stock	5.9282	5.9707	5.9143	5.9261	4322052.0
2007-11-16 08:30:00	AAPL	Stock	5.925	5.9679	5.925	5.9371	5033840.0
2007-11-16 09:00:00	AAPL	Stock	5.9375	5.9446	5.8846	5.9036	7709436.0
2007-11-16 09:30:00	AAPL	Stock	5.9021	5.9464	5.7836	5.7868	198029580.0
2007-11-16 10:00:00	AAPL	Stock	5.7879	5.8121	5.7007	5.7071	153265084.0
2007-11-16 10:30:00	AAPL	Stock	5.7071	5.7936	5.6904	5.7739	113470364.0
2007-11-16 11:00:00	AAPL	Stock	5.7729	5.8604	5.7721	5.8179	101052840.0
2007-11-16 11:30:00	AAPL	Stock	5.8179	5.9286	5.8175	5.8964	106213072.0
2007-11-16 12:00:00	AAPL	Stock	5.8968	5.955	5.8886	5.9068	83967828.0
2007-11-16 12:30:00	AAPL	Stock	5.9071	5.9129	5.8436	5.8529	69234872.0
2007-11-16 13:00:00	AAPL	Stock	5.8525	5.8796	5.8164	5.8329	62607048.0
2007-11-16 13:30:00	AAPL	Stock	5.8336	5.9004	5.8221	5.8654	73676456.0
2007-11-16 14:00:00	AAPL	Stock	5.8646	5.8868	5.8046	5.8818	84341488.0
2007-11-16 14:30:00	AAPL	Stock	5.8825	5.9004	5.8214	5.8832	86398956.0
2007-11-16 15:00:00	AAPL	Stock	5.8836	5.8929	5.85	5.8661	73252116.0
2007-11-16 15:30:00	AAPL	Stock	5.8668	5.965	5.8525	5.94	136010868.0
2007-11-16 16:00:00	AAPL	Stock	5.9404	5.9571	5.847	5.9425	20787928.0
2007-11-16 16:30:00	AAPL	Stock	5.9464	5.9589	5.8849	5.9554	1886248.0
2007-11-16 17:00:00	AAPL	Stock	5.9586	5.9679	5.847	5.9668	1808800.0
2007-11-16 17:30:00	AAPL	Stock	5.9625	5.9679	5.9468	5.9582	301700.0
2007-11-16 18:00:00	AAPL	Stock	5.9582	5.96	5.9514	5.96	111916.0
2007-11-16 18:30:00	AAPL	Stock	5.9561	5.9579	5.9461	5.9568	197932.0
2007-11-16 19:00:00	AAPL	Stock	5.9571	5.9589	5.9529	5.9589	63280.0
2007-11-16 19:30:00	AAPL	Stock	5.9604	5.9604	5.9536	5.9554	148120.0
2007-11-16 07:00:00	MSFT	Stock	33.56	33.56	33.56	33.56	400.0
2007-11-16 07:30:00	MSFT	Stock	33.79	33.81	33.79	33.81	1400.0
2007-11-16 08:00:00	MSFT	Stock	33.78	33.95	33.78	33.89	25334.0
2007-11-16 08:30:00	MSFT	Stock	33.84	33.89	33.84	33.88	7309.0
2007-11-16 09:00:00	MSFT	Stock	33.88	33.99	33.76	33.89	274052.0
2007-11-16 09:30:00	MSFT	Stock	33.87	33.99	33.725	33.76	14105591.0
2007-11-16 10:00:00	MSFT	Stock	33.76	34.01	33.71	33.79	6479560.0
2007-11-16 10:30:00	MSFT	Stock	33.79	33.87	33.71	33.84	4257948.0
2007-11-16 11:00:00	MSFT	Stock	33.84	34.02	33.84	33.9	4023075.0
2007-11-16 11:30:00	MSFT	Stock	33.89	34.19	33.89	34.11	4708117.0
2007-11-16 12:00:00	MSFT	Stock	34.11	34.26	34.07	34.08	4202445.0
2007-11-16 12:30:00	MSFT	Stock	34.07	34.132	33.85	34.04	3921380.0
2007-11-16 13:00:00	MSFT	Stock	34.04	34.17	34.03	34.1	2151188.0
2007-11-16 13:30:00	MSFT	Stock	34.092	34.18	34.07	34.08	2276635.0
2007-11-16 14:00:00	MSFT	Stock	34.08	34.09	33.84	33.94	4959839.0
2007-11-16 14:30:00	MSFT	Stock	33.94	33.95	33.72	33.88	4711002.0
2007-11-16 15:00:00	MSFT	Stock	33.88	33.94	33.8	33.83	3387954.0
2007-11-16 15:30:00	MSFT	Stock	33.83	34.12	33.81	34.05	7776478.0
2007-11-16 16:00:00	MSFT	Stock	34.04	34.09	33.71	34.09	3505090.0
2007-11-16 16:30:00	MSFT	Stock	34.06	34.09	33.99	34.006	183734.0
2007-11-16 17:00:00	MSFT	Stock	34.09	34.09	33.952	34.08	154726.0

> showing 50 of 68,093 rows — these rows as CSV

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