PREVIEW / stock_1min / 2009-05-05

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-05-05.parquet
  size:    13.4 MB
  rows:    1,027,786
  symbols: 2,724

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-05 07:27:00	AAPL	Stock	4.69	4.69	4.69	4.69	2800.0
2009-05-05 07:28:00	AAPL	Stock	4.6864	4.69	4.6786	4.6786	90636.0
2009-05-05 07:29:00	AAPL	Stock	4.6857	4.6857	4.6857	4.6857	11200.0
2009-05-05 07:36:00	AAPL	Stock	4.6868	4.6868	4.6868	4.6868	2800.0
2009-05-05 07:37:00	AAPL	Stock	4.6868	4.6868	4.6868	4.6868	11200.0
2009-05-05 07:38:00	AAPL	Stock	4.6864	4.6864	4.6864	4.6864	2800.0
2009-05-05 07:49:00	AAPL	Stock	4.6893	4.6893	4.6893	4.6893	5600.0
2009-05-05 07:51:00	AAPL	Stock	4.6857	4.6857	4.6857	4.6857	5600.0
2009-05-05 08:00:00	AAPL	Stock	4.7	4.7132	4.7	4.7111	28616.0
2009-05-05 08:01:00	AAPL	Stock	4.6964	4.6964	4.6964	4.6964	2800.0
2009-05-05 08:02:00	AAPL	Stock	4.7071	4.7071	4.7071	4.7071	14000.0
2009-05-05 08:05:00	AAPL	Stock	4.7071	4.7071	4.7071	4.7071	12880.0
2009-05-05 08:07:00	AAPL	Stock	4.6971	4.7018	4.6971	4.7018	18256.0
2009-05-05 08:08:00	AAPL	Stock	4.6971	4.6971	4.6971	4.6971	8400.0
2009-05-05 08:10:00	AAPL	Stock	4.6996	4.7	4.6964	4.7	14084.0
2009-05-05 08:12:00	AAPL	Stock	4.7	4.7	4.7	4.7	2800.0
2009-05-05 08:13:00	AAPL	Stock	4.6982	4.6982	4.6982	4.6982	14560.0
2009-05-05 08:14:00	AAPL	Stock	4.7036	4.7036	4.7036	4.7036	5600.0
2009-05-05 08:15:00	AAPL	Stock	4.7036	4.7036	4.7036	4.7036	7560.0
2009-05-05 08:19:00	AAPL	Stock	4.7039	4.7075	4.7039	4.7039	17864.0
2009-05-05 08:20:00	AAPL	Stock	4.7075	4.7075	4.7075	4.7075	7560.0
2009-05-05 08:21:00	AAPL	Stock	4.7075	4.7075	4.7046	4.7046	42420.0
2009-05-05 08:22:00	AAPL	Stock	4.7039	4.7039	4.7036	4.7036	14000.0
2009-05-05 08:23:00	AAPL	Stock	4.7036	4.7036	4.7036	4.7036	8400.0
2009-05-05 08:24:00	AAPL	Stock	4.7036	4.7036	4.7036	4.7036	10976.0
2009-05-05 08:31:00	AAPL	Stock	4.7036	4.7036	4.7036	4.7036	5600.0
2009-05-05 08:32:00	AAPL	Stock	4.7054	4.7054	4.7036	4.7036	6664.0
2009-05-05 08:34:00	AAPL	Stock	4.7054	4.7068	4.7054	4.7068	16800.0
2009-05-05 08:35:00	AAPL	Stock	4.7014	4.7014	4.7014	4.7014	2800.0
2009-05-05 08:39:00	AAPL	Stock	4.7036	4.7036	4.7036	4.7036	2800.0
2009-05-05 08:40:00	AAPL	Stock	4.7004	4.7004	4.7004	4.7004	10920.0
2009-05-05 08:41:00	AAPL	Stock	4.7004	4.7032	4.6896	4.6896	216300.0
2009-05-05 08:42:00	AAPL	Stock	4.6893	4.6929	4.6786	4.6807	222628.0
2009-05-05 08:43:00	AAPL	Stock	4.6857	4.6857	4.6829	4.6829	30800.0
2009-05-05 08:44:00	AAPL	Stock	4.6857	4.6968	4.685	4.6964	132664.0
2009-05-05 08:45:00	AAPL	Stock	4.6929	4.6964	4.6929	4.6964	33516.0
2009-05-05 08:48:00	AAPL	Stock	4.6914	4.6929	4.6914	4.6929	10024.0
2009-05-05 08:49:00	AAPL	Stock	4.6964	4.7036	4.6964	4.6964	26376.0
2009-05-05 08:50:00	AAPL	Stock	4.6964	4.7139	4.6964	4.7136	166964.0
2009-05-05 08:51:00	AAPL	Stock	4.7018	4.7021	4.7018	4.7021	5600.0
2009-05-05 08:53:00	AAPL	Stock	4.6964	4.7039	4.6957	4.7039	22400.0
2009-05-05 08:54:00	AAPL	Stock	4.7054	4.7054	4.7054	4.7054	25200.0
2009-05-05 08:56:00	AAPL	Stock	4.6968	4.7043	4.6968	4.7043	5600.0
2009-05-05 08:58:00	AAPL	Stock	4.7061	4.7068	4.7061	4.7068	5600.0
2009-05-05 09:00:00	AAPL	Stock	4.7018	4.7018	4.7018	4.7018	7000.0
2009-05-05 09:04:00	AAPL	Stock	4.7036	4.7036	4.7036	4.7036	36680.0
2009-05-05 09:06:00	AAPL	Stock	4.7061	4.7071	4.7061	4.7071	31892.0
2009-05-05 09:07:00	AAPL	Stock	4.7018	4.7018	4.6964	4.6968	33600.0
2009-05-05 09:08:00	AAPL	Stock	4.6964	4.6989	4.6964	4.6989	11200.0
2009-05-05 09:09:00	AAPL	Stock	4.6986	4.6986	4.6957	4.6957	109872.0

> showing 50 of 1,027,786 rows — these rows as CSV

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