PREVIEW / stock_1min / 2009-05-01

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-05-01.parquet
  size:    12.6 MB
  rows:    971,137
  symbols: 2,692

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-05-01 05:55:00	AAPL	Stock	4.4964	4.4964	4.4964	4.4964	5600.0
2009-05-01 07:28:00	AAPL	Stock	4.5071	4.5071	4.5071	4.5071	2800.0
2009-05-01 08:00:00	AAPL	Stock	4.5079	4.5079	4.5071	4.5071	16240.0
2009-05-01 08:01:00	AAPL	Stock	4.5071	4.5071	4.5071	4.5071	14000.0
2009-05-01 08:02:00	AAPL	Stock	4.5154	4.5157	4.5154	4.5157	6580.0
2009-05-01 08:04:00	AAPL	Stock	4.5154	4.5154	4.5154	4.5154	2800.0
2009-05-01 08:05:00	AAPL	Stock	4.5071	4.5071	4.5071	4.5071	2800.0
2009-05-01 08:07:00	AAPL	Stock	4.5071	4.5071	4.5071	4.5071	2800.0
2009-05-01 08:08:00	AAPL	Stock	4.5121	4.5143	4.5121	4.5143	52360.0
2009-05-01 08:11:00	AAPL	Stock	4.5125	4.5193	4.5125	4.5193	175560.0
2009-05-01 08:12:00	AAPL	Stock	4.5179	4.5179	4.5179	4.5179	2800.0
2009-05-01 08:14:00	AAPL	Stock	4.5179	4.5179	4.5179	4.5179	5600.0
2009-05-01 08:15:00	AAPL	Stock	4.5179	4.5179	4.5179	4.5179	5600.0
2009-05-01 08:16:00	AAPL	Stock	4.5179	4.5179	4.5179	4.5179	5600.0
2009-05-01 08:17:00	AAPL	Stock	4.5189	4.5193	4.5189	4.5189	173600.0
2009-05-01 08:18:00	AAPL	Stock	4.5189	4.5189	4.5129	4.5129	56000.0
2009-05-01 08:19:00	AAPL	Stock	4.5171	4.5171	4.5171	4.5171	3500.0
2009-05-01 08:21:00	AAPL	Stock	4.5157	4.5179	4.5157	4.5179	72800.0
2009-05-01 08:27:00	AAPL	Stock	4.5179	4.5179	4.5179	4.5179	16800.0
2009-05-01 08:32:00	AAPL	Stock	4.5121	4.5121	4.5121	4.5121	2800.0
2009-05-01 08:38:00	AAPL	Stock	4.51	4.51	4.51	4.51	2800.0
2009-05-01 08:40:00	AAPL	Stock	4.5089	4.5089	4.5089	4.5089	5600.0
2009-05-01 08:42:00	AAPL	Stock	4.5089	4.5089	4.5089	4.5089	2800.0
2009-05-01 08:44:00	AAPL	Stock	4.5071	4.5089	4.5071	4.5071	29260.0
2009-05-01 08:46:00	AAPL	Stock	4.5029	4.5029	4.5029	4.5029	2800.0
2009-05-01 08:47:00	AAPL	Stock	4.5036	4.5036	4.5036	4.5036	14000.0
2009-05-01 08:48:00	AAPL	Stock	4.5025	4.5025	4.5007	4.5007	56000.0
2009-05-01 08:49:00	AAPL	Stock	4.5	4.5	4.5	4.5	2800.0
2009-05-01 08:51:00	AAPL	Stock	4.5007	4.5007	4.5007	4.5007	2800.0
2009-05-01 08:55:00	AAPL	Stock	4.5011	4.5011	4.5	4.5004	50400.0
2009-05-01 08:56:00	AAPL	Stock	4.4982	4.5	4.4971	4.4971	19684.0
2009-05-01 08:57:00	AAPL	Stock	4.4964	4.4964	4.4961	4.4961	14000.0
2009-05-01 08:59:00	AAPL	Stock	4.4964	4.4964	4.4964	4.4964	16100.0
2009-05-01 09:00:00	AAPL	Stock	4.4968	4.4968	4.4968	4.4968	2800.0
2009-05-01 09:01:00	AAPL	Stock	4.4939	4.4939	4.4939	4.4939	85092.0
2009-05-01 09:04:00	AAPL	Stock	4.4975	4.4975	4.4975	4.4975	14000.0
2009-05-01 09:06:00	AAPL	Stock	4.4982	4.4982	4.4982	4.4982	2800.0
2009-05-01 09:07:00	AAPL	Stock	4.4975	4.4979	4.4961	4.4979	39760.0
2009-05-01 09:08:00	AAPL	Stock	4.4979	4.4979	4.4979	4.4979	2800.0
2009-05-01 09:12:00	AAPL	Stock	4.4957	4.4957	4.4921	4.4921	5600.0
2009-05-01 09:19:00	AAPL	Stock	4.4918	4.4918	4.4907	4.4907	16800.0
2009-05-01 09:20:00	AAPL	Stock	4.4957	4.4957	4.4957	4.4957	2800.0
2009-05-01 09:23:00	AAPL	Stock	4.4889	4.49	4.4886	4.4896	33600.0
2009-05-01 09:26:00	AAPL	Stock	4.4889	4.4889	4.4889	4.4889	11200.0
2009-05-01 09:29:00	AAPL	Stock	4.4907	4.4954	4.4907	4.4954	61544.0
2009-05-01 09:30:00	AAPL	Stock	4.4929	4.5157	4.4929	4.5118	2572304.0
2009-05-01 09:31:00	AAPL	Stock	4.5129	4.515	4.4975	4.505	1371328.0
2009-05-01 09:32:00	AAPL	Stock	4.5054	4.5086	4.4937	4.4964	1237376.0
2009-05-01 09:33:00	AAPL	Stock	4.4979	4.5057	4.4954	4.5046	1064588.0
2009-05-01 09:34:00	AAPL	Stock	4.505	4.5054	4.4943	4.5018	875196.0

> showing 50 of 971,137 rows — these rows as CSV

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