PREVIEW / stock_1min / 2009-06-22

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-06-22.parquet
  size:    13.1 MB
  rows:    1,004,941
  symbols: 2,718

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
2009-06-22 04:15:00	AAPL	Stock	4.9811	4.9857	4.9811	4.9857	19600.0
2009-06-22 06:01:00	AAPL	Stock	4.9343	4.9482	4.9325	4.9482	19180.0
2009-06-22 06:06:00	AAPL	Stock	4.9496	4.9496	4.9496	4.9496	2800.0
2009-06-22 06:15:00	AAPL	Stock	4.9457	4.9457	4.9457	4.9457	5600.0
2009-06-22 06:28:00	AAPL	Stock	4.935	4.935	4.9325	4.9325	16800.0
2009-06-22 07:00:00	AAPL	Stock	4.9325	4.9325	4.9286	4.9325	48300.0
2009-06-22 07:04:00	AAPL	Stock	4.9429	4.9429	4.9429	4.9429	2800.0
2009-06-22 07:05:00	AAPL	Stock	4.9379	4.9379	4.9379	4.9379	2800.0
2009-06-22 07:06:00	AAPL	Stock	4.9329	4.9621	4.9329	4.9621	5600.0
2009-06-22 07:07:00	AAPL	Stock	4.9379	4.9379	4.9379	4.9379	2800.0
2009-06-22 07:19:00	AAPL	Stock	4.9325	4.9325	4.9325	4.9325	8400.0
2009-06-22 07:23:00	AAPL	Stock	4.9393	4.9393	4.9393	4.9393	2800.0
2009-06-22 07:25:00	AAPL	Stock	4.9393	4.9393	4.9393	4.9393	11200.0
2009-06-22 07:27:00	AAPL	Stock	4.9393	4.9393	4.9393	4.9393	2800.0
2009-06-22 07:29:00	AAPL	Stock	4.9339	4.9339	4.9325	4.9325	30072.0
2009-06-22 07:33:00	AAPL	Stock	4.9264	4.9264	4.9204	4.9204	42952.0
2009-06-22 07:34:00	AAPL	Stock	4.9257	4.9286	4.9257	4.9286	8400.0
2009-06-22 07:36:00	AAPL	Stock	4.9264	4.9286	4.9264	4.9286	16800.0
2009-06-22 07:38:00	AAPL	Stock	4.9286	4.9286	4.9286	4.9286	2800.0
2009-06-22 07:44:00	AAPL	Stock	4.93	4.93	4.93	4.93	27636.0
2009-06-22 07:45:00	AAPL	Stock	4.9314	4.9314	4.9314	4.9314	5600.0
2009-06-22 07:50:00	AAPL	Stock	4.9321	4.9321	4.9321	4.9321	5600.0
2009-06-22 07:55:00	AAPL	Stock	4.9382	4.9382	4.9382	4.9382	2800.0
2009-06-22 08:00:00	AAPL	Stock	4.9371	4.945	4.9339	4.9339	28000.0
2009-06-22 08:01:00	AAPL	Stock	4.9357	4.9357	4.9357	4.9357	8400.0
2009-06-22 08:03:00	AAPL	Stock	4.9357	4.9361	4.9357	4.9361	18200.0
2009-06-22 08:04:00	AAPL	Stock	4.9361	4.9429	4.9361	4.9429	14840.0
2009-06-22 08:05:00	AAPL	Stock	4.9429	4.9429	4.9311	4.9414	48468.0
2009-06-22 08:06:00	AAPL	Stock	4.9371	4.9393	4.9357	4.9357	11200.0
2009-06-22 08:08:00	AAPL	Stock	4.9339	4.9339	4.9264	4.9268	238812.0
2009-06-22 08:09:00	AAPL	Stock	4.9264	4.9264	4.9221	4.9225	96712.0
2009-06-22 08:10:00	AAPL	Stock	4.9286	4.9357	4.925	4.9357	240100.0
2009-06-22 08:11:00	AAPL	Stock	4.9411	4.95	4.9386	4.9411	111888.0
2009-06-22 08:12:00	AAPL	Stock	4.9386	4.9404	4.9293	4.9293	317744.0
2009-06-22 08:13:00	AAPL	Stock	4.9293	4.9321	4.9293	4.9321	45864.0
2009-06-22 08:14:00	AAPL	Stock	4.9304	4.9336	4.9304	4.9304	43960.0
2009-06-22 08:15:00	AAPL	Stock	4.9321	4.9321	4.9268	4.9268	63532.0
2009-06-22 08:16:00	AAPL	Stock	4.9268	4.9296	4.9268	4.9293	56000.0
2009-06-22 08:17:00	AAPL	Stock	4.9304	4.9304	4.9289	4.9289	28560.0
2009-06-22 08:18:00	AAPL	Stock	4.9293	4.9293	4.9289	4.9289	16660.0
2009-06-22 08:19:00	AAPL	Stock	4.9296	4.9296	4.9296	4.9296	2800.0
2009-06-22 08:21:00	AAPL	Stock	4.9289	4.9289	4.9286	4.9286	65800.0
2009-06-22 08:22:00	AAPL	Stock	4.9286	4.9289	4.9286	4.9289	50400.0
2009-06-22 08:23:00	AAPL	Stock	4.9286	4.9286	4.9286	4.9286	2800.0
2009-06-22 08:24:00	AAPL	Stock	4.9282	4.9304	4.9257	4.9257	34720.0
2009-06-22 08:25:00	AAPL	Stock	4.9254	4.9254	4.9221	4.9232	46200.0
2009-06-22 08:26:00	AAPL	Stock	4.9289	4.9289	4.9236	4.9239	8904.0
2009-06-22 08:27:00	AAPL	Stock	4.9268	4.9268	4.9268	4.9268	5600.0
2009-06-22 08:28:00	AAPL	Stock	4.9293	4.9293	4.9271	4.9271	5600.0
2009-06-22 08:29:00	AAPL	Stock	4.9304	4.9314	4.9304	4.9304	24304.0

> showing 50 of 1,004,941 rows — these rows as CSV

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