PREVIEW / stock_1min / 2009-04-23

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-04-23.parquet
  size:    12.5 MB
  rows:    958,061
  symbols: 2,680

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-04-23 04:33:00	AAPL	Stock	4.4696	4.4696	4.4696	4.4696	2800.0
2009-04-23 05:11:00	AAPL	Stock	4.4793	4.4793	4.4793	4.4793	2800.0
2009-04-23 05:17:00	AAPL	Stock	4.4954	4.4954	4.4954	4.4954	5600.0
2009-04-23 05:18:00	AAPL	Stock	4.4954	4.4954	4.4954	4.4954	11200.0
2009-04-23 05:41:00	AAPL	Stock	4.4957	4.4964	4.4957	4.4964	19488.0
2009-04-23 06:05:00	AAPL	Stock	4.4993	4.4993	4.4993	4.4993	2800.0
2009-04-23 06:07:00	AAPL	Stock	4.4993	4.5057	4.4993	4.5057	30240.0
2009-04-23 06:11:00	AAPL	Stock	4.5	4.5	4.5	4.5	14000.0
2009-04-23 06:18:00	AAPL	Stock	4.5089	4.5089	4.5089	4.5089	2800.0
2009-04-23 06:25:00	AAPL	Stock	4.5089	4.5089	4.5089	4.5089	2800.0
2009-04-23 06:26:00	AAPL	Stock	4.5107	4.5107	4.5107	4.5107	16800.0
2009-04-23 06:27:00	AAPL	Stock	4.5139	4.5139	4.5139	4.5139	8400.0
2009-04-23 06:28:00	AAPL	Stock	4.5139	4.5139	4.5139	4.5139	2800.0
2009-04-23 06:31:00	AAPL	Stock	4.5125	4.5143	4.5125	4.5143	23800.0
2009-04-23 06:33:00	AAPL	Stock	4.5179	4.5179	4.5179	4.5179	2800.0
2009-04-23 06:34:00	AAPL	Stock	4.5179	4.5179	4.5179	4.5179	5600.0
2009-04-23 06:38:00	AAPL	Stock	4.525	4.525	4.525	4.525	2800.0
2009-04-23 06:40:00	AAPL	Stock	4.5268	4.5296	4.5268	4.5296	7000.0
2009-04-23 06:47:00	AAPL	Stock	4.5125	4.5125	4.5125	4.5125	2800.0
2009-04-23 06:53:00	AAPL	Stock	4.5125	4.5125	4.5125	4.5125	2800.0
2009-04-23 06:58:00	AAPL	Stock	4.5129	4.5129	4.5129	4.5129	2800.0
2009-04-23 06:59:00	AAPL	Stock	4.505	4.505	4.505	4.505	2800.0
2009-04-23 07:00:00	AAPL	Stock	4.5043	4.5043	4.4839	4.4839	8400.0
2009-04-23 07:05:00	AAPL	Stock	4.4921	4.4921	4.4921	4.4921	5600.0
2009-04-23 07:07:00	AAPL	Stock	4.5057	4.5057	4.5054	4.5054	25200.0
2009-04-23 07:08:00	AAPL	Stock	4.5004	4.5107	4.5	4.5107	84756.0
2009-04-23 07:09:00	AAPL	Stock	4.5107	4.5107	4.5036	4.5036	128800.0
2009-04-23 07:10:00	AAPL	Stock	4.5021	4.5104	4.5021	4.5104	19600.0
2009-04-23 07:11:00	AAPL	Stock	4.5107	4.5136	4.5036	4.5036	23940.0
2009-04-23 07:14:00	AAPL	Stock	4.5036	4.5071	4.5036	4.5071	16800.0
2009-04-23 07:15:00	AAPL	Stock	4.51	4.5107	4.5071	4.5071	11200.0
2009-04-23 07:17:00	AAPL	Stock	4.5089	4.5143	4.5089	4.5143	30800.0
2009-04-23 07:18:00	AAPL	Stock	4.5143	4.5271	4.5143	4.5271	106680.0
2009-04-23 07:19:00	AAPL	Stock	4.5271	4.5357	4.525	4.5357	162400.0
2009-04-23 07:20:00	AAPL	Stock	4.5343	4.5346	4.5339	4.5339	23828.0
2009-04-23 07:21:00	AAPL	Stock	4.5296	4.5296	4.5296	4.5296	2800.0
2009-04-23 07:23:00	AAPL	Stock	4.5268	4.5268	4.5179	4.5179	21000.0
2009-04-23 07:24:00	AAPL	Stock	4.5182	4.5182	4.5139	4.5161	66108.0
2009-04-23 07:25:00	AAPL	Stock	4.5179	4.5179	4.5179	4.5179	2800.0
2009-04-23 07:27:00	AAPL	Stock	4.5179	4.5179	4.5179	4.5179	5600.0
2009-04-23 07:28:00	AAPL	Stock	4.5179	4.5179	4.5179	4.5179	22260.0
2009-04-23 07:29:00	AAPL	Stock	4.5139	4.5139	4.5129	4.5139	62328.0
2009-04-23 07:30:00	AAPL	Stock	4.5179	4.5179	4.5089	4.5089	33600.0
2009-04-23 07:31:00	AAPL	Stock	4.5168	4.5171	4.5168	4.5171	14000.0
2009-04-23 07:32:00	AAPL	Stock	4.5171	4.5179	4.5171	4.5171	14000.0
2009-04-23 07:33:00	AAPL	Stock	4.5143	4.5143	4.5143	4.5143	28000.0
2009-04-23 07:34:00	AAPL	Stock	4.5086	4.5086	4.5071	4.5071	60900.0
2009-04-23 07:35:00	AAPL	Stock	4.5029	4.5036	4.4954	4.4964	150500.0
2009-04-23 07:36:00	AAPL	Stock	4.4964	4.4964	4.4886	4.4893	103628.0
2009-04-23 07:37:00	AAPL	Stock	4.4893	4.4893	4.4893	4.4893	144900.0

> showing 50 of 958,061 rows — these rows as CSV

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