PREVIEW / stock_1min / 2007-04-27

all stock 1-min files

  file:    by_date/stock_1min/2007/2007-04-27.parquet
  size:    9.9 MB
  rows:    799,272
  symbols: 2,136

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-04-27 05:10:00	AAPL	Stock	3.5221	3.5221	3.5221	3.5221	2800.0
2007-04-27 05:18:00	AAPL	Stock	3.5221	3.5221	3.5221	3.5221	5600.0
2007-04-27 05:37:00	AAPL	Stock	3.5225	3.5225	3.5225	3.5225	2800.0
2007-04-27 06:34:00	AAPL	Stock	3.53	3.53	3.53	3.53	5600.0
2007-04-27 06:39:00	AAPL	Stock	3.53	3.53	3.53	3.53	5600.0
2007-04-27 07:00:00	AAPL	Stock	3.5304	3.5304	3.5304	3.5304	5600.0
2007-04-27 07:02:00	AAPL	Stock	3.5214	3.5218	3.5214	3.5214	19600.0
2007-04-27 07:04:00	AAPL	Stock	3.5204	3.5204	3.5204	3.5204	2800.0
2007-04-27 07:21:00	AAPL	Stock	3.5214	3.5214	3.5214	3.5214	14000.0
2007-04-27 07:23:00	AAPL	Stock	3.5214	3.5214	3.5214	3.5214	5600.0
2007-04-27 07:24:00	AAPL	Stock	3.5286	3.5286	3.5286	3.5286	2800.0
2007-04-27 07:30:00	AAPL	Stock	3.5321	3.5321	3.5321	3.5321	2800.0
2007-04-27 07:31:00	AAPL	Stock	3.5321	3.5321	3.5321	3.5321	5600.0
2007-04-27 07:35:00	AAPL	Stock	3.5232	3.5232	3.5232	3.5232	14000.0
2007-04-27 07:41:00	AAPL	Stock	3.5232	3.5232	3.5207	3.5207	26600.0
2007-04-27 07:43:00	AAPL	Stock	3.5182	3.5182	3.5182	3.5182	5600.0
2007-04-27 07:48:00	AAPL	Stock	3.5161	3.5161	3.5161	3.5161	5600.0
2007-04-27 07:49:00	AAPL	Stock	3.5179	3.5179	3.5179	3.5179	10080.0
2007-04-27 07:53:00	AAPL	Stock	3.5179	3.5179	3.5179	3.5179	2800.0
2007-04-27 07:54:00	AAPL	Stock	3.5179	3.5179	3.5168	3.5168	17528.0
2007-04-27 07:57:00	AAPL	Stock	3.5179	3.5179	3.5179	3.5179	17332.0
2007-04-27 07:58:00	AAPL	Stock	3.5179	3.5179	3.5168	3.5168	31472.0
2007-04-27 07:59:00	AAPL	Stock	3.5171	3.5171	3.5164	3.5164	14000.0
2007-04-27 08:00:00	AAPL	Stock	3.5214	3.5214	3.5082	3.5179	144620.0
2007-04-27 08:01:00	AAPL	Stock	3.5179	3.5207	3.5171	3.5179	28084.0
2007-04-27 08:02:00	AAPL	Stock	3.5171	3.5171	3.5129	3.5143	109928.0
2007-04-27 08:03:00	AAPL	Stock	3.5136	3.5136	3.5071	3.5071	86856.0
2007-04-27 08:04:00	AAPL	Stock	3.5071	3.5075	3.5061	3.5071	82852.0
2007-04-27 08:05:00	AAPL	Stock	3.5071	3.5096	3.5061	3.5096	92792.0
2007-04-27 08:06:00	AAPL	Stock	3.5089	3.5096	3.5089	3.5096	27300.0
2007-04-27 08:07:00	AAPL	Stock	3.5096	3.5096	3.5071	3.5071	31500.0
2007-04-27 08:08:00	AAPL	Stock	3.5071	3.5071	3.5046	3.5046	33600.0
2007-04-27 08:09:00	AAPL	Stock	3.5061	3.5061	3.5046	3.5046	60368.0
2007-04-27 08:10:00	AAPL	Stock	3.5036	3.5036	3.5	3.5036	102760.0
2007-04-27 08:11:00	AAPL	Stock	3.5071	3.5071	3.5054	3.5054	16800.0
2007-04-27 08:12:00	AAPL	Stock	3.5054	3.5071	3.5039	3.5071	56000.0
2007-04-27 08:13:00	AAPL	Stock	3.5043	3.5068	3.5039	3.5068	57400.0
2007-04-27 08:14:00	AAPL	Stock	3.5046	3.5071	3.5046	3.5071	14000.0
2007-04-27 08:15:00	AAPL	Stock	3.5071	3.5082	3.5071	3.5071	37800.0
2007-04-27 08:16:00	AAPL	Stock	3.5071	3.5089	3.5071	3.5089	14000.0
2007-04-27 08:18:00	AAPL	Stock	3.5089	3.5089	3.5071	3.5071	30100.0
2007-04-27 08:19:00	AAPL	Stock	3.5054	3.5054	3.5046	3.5046	40040.0
2007-04-27 08:20:00	AAPL	Stock	3.5046	3.5046	3.5046	3.5046	14000.0
2007-04-27 08:21:00	AAPL	Stock	3.5046	3.5071	3.5046	3.5071	101752.0
2007-04-27 08:22:00	AAPL	Stock	3.5071	3.5071	3.5071	3.5071	5600.0
2007-04-27 08:23:00	AAPL	Stock	3.5071	3.5071	3.5071	3.5071	137200.0
2007-04-27 08:24:00	AAPL	Stock	3.5071	3.5071	3.5046	3.5046	22736.0
2007-04-27 08:25:00	AAPL	Stock	3.5071	3.5071	3.5046	3.5071	40348.0
2007-04-27 08:26:00	AAPL	Stock	3.5086	3.5086	3.5071	3.5071	28000.0
2007-04-27 08:27:00	AAPL	Stock	3.5071	3.5071	3.5071	3.5071	14000.0

> showing 50 of 799,272 rows — these rows as CSV

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