PREVIEW / stock_1min / 2007-11-20

all stock 1-min files

  file:    by_date/stock_1min/2007/2007-11-20.parquet
  size:    12.9 MB
  rows:    1,039,803
  symbols: 2,622

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-11-20 06:43:00	AAPL	Stock	5.9525	5.9525	5.9525	5.9525	24164.0
2007-11-20 06:47:00	AAPL	Stock	5.9686	5.9686	5.9643	5.9643	13160.0
2007-11-20 06:50:00	AAPL	Stock	5.9896	5.9896	5.9896	5.9896	16800.0
2007-11-20 06:51:00	AAPL	Stock	5.9982	5.9982	5.9982	5.9982	14000.0
2007-11-20 06:53:00	AAPL	Stock	6.0	6.0	6.0	6.0	35000.0
2007-11-20 06:54:00	AAPL	Stock	6.0121	6.0121	6.0121	6.0121	14000.0
2007-11-20 06:56:00	AAPL	Stock	6.0139	6.0139	6.0139	6.0139	25200.0
2007-11-20 06:57:00	AAPL	Stock	6.0129	6.0129	6.0121	6.0121	14000.0
2007-11-20 06:58:00	AAPL	Stock	6.0175	6.0175	6.0175	6.0175	16800.0
2007-11-20 07:00:00	AAPL	Stock	6.0175	6.0175	6.0121	6.0175	107352.0
2007-11-20 07:02:00	AAPL	Stock	6.0107	6.0121	6.0093	6.0121	22400.0
2007-11-20 07:03:00	AAPL	Stock	6.0118	6.0118	6.0118	6.0118	14000.0
2007-11-20 07:04:00	AAPL	Stock	5.9911	5.9911	5.9911	5.9911	2800.0
2007-11-20 07:05:00	AAPL	Stock	5.9911	5.9929	5.9911	5.9911	33600.0
2007-11-20 07:06:00	AAPL	Stock	6.0036	6.0036	6.0036	6.0036	13664.0
2007-11-20 07:08:00	AAPL	Stock	6.0036	6.0036	6.0036	6.0036	5600.0
2007-11-20 07:09:00	AAPL	Stock	6.0036	6.0036	6.0036	6.0036	8400.0
2007-11-20 07:10:00	AAPL	Stock	6.0054	6.0054	6.0054	6.0054	35392.0
2007-11-20 07:11:00	AAPL	Stock	6.0036	6.0036	6.0036	6.0036	3920.0
2007-11-20 07:12:00	AAPL	Stock	5.9964	5.9964	5.9964	5.9964	2800.0
2007-11-20 07:13:00	AAPL	Stock	5.9964	5.9964	5.9964	5.9964	11200.0
2007-11-20 07:14:00	AAPL	Stock	5.9964	5.9964	5.9964	5.9964	2800.0
2007-11-20 07:18:00	AAPL	Stock	5.9964	5.9964	5.9964	5.9964	5600.0
2007-11-20 07:19:00	AAPL	Stock	5.9982	5.9982	5.9982	5.9982	2800.0
2007-11-20 07:20:00	AAPL	Stock	5.9982	5.9982	5.9982	5.9982	2800.0
2007-11-20 07:23:00	AAPL	Stock	5.9982	5.9982	5.9982	5.9982	28000.0
2007-11-20 07:24:00	AAPL	Stock	5.9982	5.9982	5.9979	5.9979	56000.0
2007-11-20 07:25:00	AAPL	Stock	5.9911	5.9911	5.9911	5.9911	14000.0
2007-11-20 07:27:00	AAPL	Stock	5.9982	5.9982	5.9982	5.9982	8400.0
2007-11-20 07:28:00	AAPL	Stock	5.9982	5.9982	5.9982	5.9982	67200.0
2007-11-20 07:30:00	AAPL	Stock	5.9982	5.9982	5.9982	5.9982	56000.0
2007-11-20 07:31:00	AAPL	Stock	5.9964	5.9964	5.9964	5.9964	5572.0
2007-11-20 07:32:00	AAPL	Stock	6.0	6.0	6.0	6.0	44800.0
2007-11-20 07:33:00	AAPL	Stock	5.9929	5.9929	5.9929	5.9929	5600.0
2007-11-20 07:36:00	AAPL	Stock	5.9946	6.0004	5.9946	5.9946	84000.0
2007-11-20 07:37:00	AAPL	Stock	5.9946	5.9946	5.9807	5.9807	143472.0
2007-11-20 07:38:00	AAPL	Stock	5.9679	5.9679	5.9679	5.9679	28000.0
2007-11-20 07:39:00	AAPL	Stock	5.9679	5.9679	5.9679	5.9679	2800.0
2007-11-20 07:40:00	AAPL	Stock	5.9821	5.9821	5.9821	5.9821	14000.0
2007-11-20 07:42:00	AAPL	Stock	5.9696	5.9696	5.9696	5.9696	14000.0
2007-11-20 07:43:00	AAPL	Stock	5.9696	5.9696	5.9696	5.9696	9520.0
2007-11-20 07:44:00	AAPL	Stock	5.9679	5.9679	5.9625	5.9625	16800.0
2007-11-20 07:45:00	AAPL	Stock	5.9643	5.9643	5.9643	5.9643	31920.0
2007-11-20 07:46:00	AAPL	Stock	5.9643	5.9643	5.9575	5.9575	58800.0
2007-11-20 07:48:00	AAPL	Stock	5.9643	5.9643	5.9643	5.9643	16800.0
2007-11-20 07:50:00	AAPL	Stock	5.9643	5.9643	5.95	5.95	60620.0
2007-11-20 07:51:00	AAPL	Stock	5.9482	5.9504	5.9464	5.9482	75600.0
2007-11-20 07:52:00	AAPL	Stock	5.9536	5.9536	5.9411	5.9429	57260.0
2007-11-20 07:53:00	AAPL	Stock	5.9332	5.9332	5.9214	5.9268	92736.0
2007-11-20 07:54:00	AAPL	Stock	5.9179	5.9479	5.9179	5.9479	27244.0

> showing 50 of 1,039,803 rows — these rows as CSV

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