PREVIEW / stock_1min / 2009-12-18

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-12-18.parquet
  size:    13.4 MB
  rows:    1,007,483
  symbols: 2,803

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-12-18 04:22:00	AAPL	Stock	6.9089	6.9089	6.9089	6.9089	2800.0
2009-12-18 06:47:00	AAPL	Stock	6.8893	6.8893	6.8893	6.8893	2800.0
2009-12-18 07:00:00	AAPL	Stock	6.9018	6.9079	6.9018	6.9079	5600.0
2009-12-18 07:04:00	AAPL	Stock	6.9096	6.9096	6.9096	6.9096	2800.0
2009-12-18 07:12:00	AAPL	Stock	6.9107	6.9107	6.9107	6.9107	25200.0
2009-12-18 07:13:00	AAPL	Stock	6.9054	6.9054	6.9054	6.9054	18200.0
2009-12-18 07:14:00	AAPL	Stock	6.8964	6.8964	6.8964	6.8964	7196.0
2009-12-18 07:22:00	AAPL	Stock	6.9004	6.9004	6.9004	6.9004	2800.0
2009-12-18 07:30:00	AAPL	Stock	6.9004	6.9004	6.9004	6.9004	2800.0
2009-12-18 07:31:00	AAPL	Stock	6.9004	6.9004	6.9	6.9	19600.0
2009-12-18 07:32:00	AAPL	Stock	6.9071	6.9071	6.9071	6.9071	2800.0
2009-12-18 07:35:00	AAPL	Stock	6.8957	6.8964	6.8957	6.8964	14000.0
2009-12-18 07:37:00	AAPL	Stock	6.8954	6.8954	6.8954	6.8954	2800.0
2009-12-18 07:44:00	AAPL	Stock	6.9046	6.9046	6.9046	6.9046	2800.0
2009-12-18 07:48:00	AAPL	Stock	6.9029	6.9032	6.9029	6.9032	8400.0
2009-12-18 07:49:00	AAPL	Stock	6.9036	6.9036	6.9036	6.9036	2800.0
2009-12-18 07:50:00	AAPL	Stock	6.9036	6.9036	6.9036	6.9036	2800.0
2009-12-18 07:53:00	AAPL	Stock	6.9071	6.9071	6.9054	6.9054	5600.0
2009-12-18 07:54:00	AAPL	Stock	6.9054	6.9054	6.9054	6.9054	2800.0
2009-12-18 07:55:00	AAPL	Stock	6.9054	6.9054	6.9036	6.9036	39900.0
2009-12-18 07:56:00	AAPL	Stock	6.9036	6.9036	6.9036	6.9036	5600.0
2009-12-18 07:58:00	AAPL	Stock	6.8961	6.8961	6.8957	6.8961	19600.0
2009-12-18 07:59:00	AAPL	Stock	6.8946	6.8961	6.8946	6.8961	14000.0
2009-12-18 08:00:00	AAPL	Stock	6.8996	6.91	6.8996	6.9071	192640.0
2009-12-18 08:01:00	AAPL	Stock	6.9071	6.92	6.9071	6.9143	59724.0
2009-12-18 08:02:00	AAPL	Stock	6.9161	6.9179	6.9125	6.9125	124600.0
2009-12-18 08:03:00	AAPL	Stock	6.9164	6.9171	6.9146	6.9146	11200.0
2009-12-18 08:04:00	AAPL	Stock	6.9136	6.9143	6.9071	6.9071	115080.0
2009-12-18 08:05:00	AAPL	Stock	6.9082	6.9089	6.9036	6.9036	30800.0
2009-12-18 08:06:00	AAPL	Stock	6.9032	6.9071	6.9032	6.9071	8400.0
2009-12-18 08:07:00	AAPL	Stock	6.9068	6.9068	6.8996	6.9	86716.0
2009-12-18 08:08:00	AAPL	Stock	6.8946	6.8946	6.8893	6.8893	5600.0
2009-12-18 08:09:00	AAPL	Stock	6.8964	6.8996	6.8929	6.8932	47600.0
2009-12-18 08:10:00	AAPL	Stock	6.8929	6.8946	6.8929	6.8929	21000.0
2009-12-18 08:11:00	AAPL	Stock	6.8957	6.9036	6.8957	6.9	30100.0
2009-12-18 08:12:00	AAPL	Stock	6.9	6.9036	6.8964	6.9036	16800.0
2009-12-18 08:13:00	AAPL	Stock	6.9046	6.905	6.9018	6.9018	14000.0
2009-12-18 08:14:00	AAPL	Stock	6.9036	6.9054	6.9032	6.9054	227416.0
2009-12-18 08:15:00	AAPL	Stock	6.9057	6.9064	6.9057	6.9064	25200.0
2009-12-18 08:16:00	AAPL	Stock	6.9064	6.9079	6.9057	6.9061	29288.0
2009-12-18 08:17:00	AAPL	Stock	6.9054	6.9061	6.9054	6.9054	12600.0
2009-12-18 08:18:00	AAPL	Stock	6.9043	6.9043	6.9039	6.9039	5600.0
2009-12-18 08:19:00	AAPL	Stock	6.9036	6.9054	6.9032	6.9054	26012.0
2009-12-18 08:20:00	AAPL	Stock	6.9036	6.9071	6.9036	6.9071	59808.0
2009-12-18 08:23:00	AAPL	Stock	6.9032	6.9079	6.9032	6.9079	60088.0
2009-12-18 08:25:00	AAPL	Stock	6.9036	6.9036	6.8946	6.8982	87836.0
2009-12-18 08:26:00	AAPL	Stock	6.8946	6.8946	6.8946	6.8946	5600.0
2009-12-18 08:27:00	AAPL	Stock	6.8982	6.9032	6.8982	6.9032	46200.0
2009-12-18 08:29:00	AAPL	Stock	6.9029	6.9054	6.9025	6.9054	56980.0
2009-12-18 08:30:00	AAPL	Stock	6.9054	6.9079	6.9054	6.9079	23800.0

> showing 50 of 1,007,483 rows — these rows as CSV

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