PREVIEW / stock_1min / 2009-01-20

all stock 1-min files

  file:    by_date/stock_1min/2009/2009-01-20.parquet
  size:    12.5 MB
  rows:    960,990
  symbols: 2,691

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-01-20 07:18:00	AAPL	Stock	2.9004	2.9004	2.9004	2.9004	28000.0
2009-01-20 07:31:00	AAPL	Stock	2.9179	2.9179	2.9179	2.9179	25200.0
2009-01-20 08:00:00	AAPL	Stock	2.9179	2.9236	2.915	2.915	18200.0
2009-01-20 08:01:00	AAPL	Stock	2.9179	2.9179	2.9179	2.9179	14000.0
2009-01-20 08:03:00	AAPL	Stock	2.9143	2.9179	2.9143	2.9179	45584.0
2009-01-20 08:04:00	AAPL	Stock	2.9121	2.9121	2.9107	2.9107	12600.0
2009-01-20 08:05:00	AAPL	Stock	2.9143	2.9143	2.9107	2.9107	28336.0
2009-01-20 08:06:00	AAPL	Stock	2.9107	2.9107	2.9107	2.9107	30464.0
2009-01-20 08:07:00	AAPL	Stock	2.9068	2.9068	2.9068	2.9068	2800.0
2009-01-20 08:08:00	AAPL	Stock	2.9021	2.9039	2.9021	2.9039	5600.0
2009-01-20 08:10:00	AAPL	Stock	2.9039	2.9039	2.9018	2.9018	44800.0
2009-01-20 08:11:00	AAPL	Stock	2.9011	2.9011	2.9011	2.9011	4900.0
2009-01-20 08:12:00	AAPL	Stock	2.9011	2.9018	2.9011	2.9018	32200.0
2009-01-20 08:13:00	AAPL	Stock	2.9018	2.9018	2.8989	2.8989	31500.0
2009-01-20 08:14:00	AAPL	Stock	2.8982	2.8982	2.8982	2.8982	26600.0
2009-01-20 08:16:00	AAPL	Stock	2.8971	2.8982	2.8964	2.8964	57260.0
2009-01-20 08:17:00	AAPL	Stock	2.8939	2.8957	2.8893	2.8893	106540.0
2009-01-20 08:18:00	AAPL	Stock	2.8861	2.8871	2.8857	2.8857	21560.0
2009-01-20 08:20:00	AAPL	Stock	2.8889	2.8889	2.8889	2.8889	4200.0
2009-01-20 08:21:00	AAPL	Stock	2.8882	2.8911	2.8875	2.8893	46480.0
2009-01-20 08:22:00	AAPL	Stock	2.8925	2.8929	2.8925	2.8929	49000.0
2009-01-20 08:23:00	AAPL	Stock	2.8929	2.8929	2.8929	2.8929	72800.0
2009-01-20 08:24:00	AAPL	Stock	2.8929	2.8929	2.8929	2.8929	99820.0
2009-01-20 08:26:00	AAPL	Stock	2.8929	2.8929	2.8925	2.8925	30800.0
2009-01-20 08:28:00	AAPL	Stock	2.8929	2.8929	2.8929	2.8929	14000.0
2009-01-20 08:29:00	AAPL	Stock	2.8929	2.8929	2.8929	2.8929	2800.0
2009-01-20 08:30:00	AAPL	Stock	2.8929	2.8929	2.8904	2.8904	19600.0
2009-01-20 08:31:00	AAPL	Stock	2.8929	2.8929	2.8904	2.8904	8400.0
2009-01-20 08:32:00	AAPL	Stock	2.8925	2.8929	2.8925	2.8929	14000.0
2009-01-20 08:33:00	AAPL	Stock	2.8893	2.8893	2.8879	2.8879	5600.0
2009-01-20 08:34:00	AAPL	Stock	2.8864	2.8864	2.8864	2.8864	27860.0
2009-01-20 08:35:00	AAPL	Stock	2.8879	2.8879	2.8879	2.8879	2800.0
2009-01-20 08:36:00	AAPL	Stock	2.8875	2.8875	2.8875	2.8875	27916.0
2009-01-20 08:37:00	AAPL	Stock	2.8893	2.8893	2.8893	2.8893	2800.0
2009-01-20 08:38:00	AAPL	Stock	2.8893	2.8893	2.8879	2.8893	12460.0
2009-01-20 08:39:00	AAPL	Stock	2.8882	2.8911	2.8864	2.8911	53200.0
2009-01-20 08:40:00	AAPL	Stock	2.8907	2.8921	2.8893	2.8921	16800.0
2009-01-20 08:41:00	AAPL	Stock	2.8954	2.8957	2.8921	2.8921	21784.0
2009-01-20 08:42:00	AAPL	Stock	2.8929	2.8929	2.8929	2.8929	9800.0
2009-01-20 08:44:00	AAPL	Stock	2.8929	2.8946	2.8929	2.8946	227724.0
2009-01-20 08:45:00	AAPL	Stock	2.8946	2.8946	2.8946	2.8946	2800.0
2009-01-20 08:48:00	AAPL	Stock	2.8989	2.9	2.8989	2.8989	193676.0
2009-01-20 08:49:00	AAPL	Stock	2.8989	2.9	2.8982	2.8996	41580.0
2009-01-20 08:50:00	AAPL	Stock	2.9	2.9	2.9	2.9	16380.0
2009-01-20 08:51:00	AAPL	Stock	2.9	2.9	2.9	2.9	165620.0
2009-01-20 08:52:00	AAPL	Stock	2.8996	2.9	2.8996	2.9	58940.0
2009-01-20 08:53:00	AAPL	Stock	2.9	2.9	2.9	2.9	5600.0
2009-01-20 08:54:00	AAPL	Stock	2.9	2.9	2.8989	2.8989	126140.0
2009-01-20 08:56:00	AAPL	Stock	2.8996	2.9	2.8996	2.9	10360.0
2009-01-20 08:57:00	AAPL	Stock	2.8996	2.8996	2.8996	2.8996	2800.0

> showing 50 of 960,990 rows — these rows as CSV

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