PREVIEW / stock_1min / 2012-03-09

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-03-09.parquet
  size:    12.9 MB
  rows:    961,688
  symbols: 2,835

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
2012-03-09 04:00:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	2800.0
2012-03-09 04:01:00	AAPL	Stock	19.4068	19.4068	19.3932	19.3932	16800.0
2012-03-09 04:02:00	AAPL	Stock	19.3929	19.405	19.3929	19.3929	16800.0
2012-03-09 04:03:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	16800.0
2012-03-09 04:05:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	14000.0
2012-03-09 04:16:00	AAPL	Stock	19.4107	19.4107	19.4107	19.4107	8400.0
2012-03-09 04:22:00	AAPL	Stock	19.4321	19.4321	19.4321	19.4321	6440.0
2012-03-09 04:32:00	AAPL	Stock	19.4143	19.4143	19.4143	19.4143	5572.0
2012-03-09 05:01:00	AAPL	Stock	19.4243	19.4243	19.4243	19.4243	8400.0
2012-03-09 05:11:00	AAPL	Stock	19.4196	19.4196	19.4196	19.4196	2800.0
2012-03-09 05:40:00	AAPL	Stock	19.4429	19.4429	19.4429	19.4429	2800.0
2012-03-09 05:43:00	AAPL	Stock	19.4429	19.4429	19.4429	19.4429	8400.0
2012-03-09 05:47:00	AAPL	Stock	19.4214	19.4214	19.4179	19.4179	25060.0
2012-03-09 05:48:00	AAPL	Stock	19.4179	19.4179	19.4179	19.4179	8540.0
2012-03-09 05:58:00	AAPL	Stock	19.4196	19.4196	19.4196	19.4196	5600.0
2012-03-09 06:02:00	AAPL	Stock	19.3964	19.3964	19.3929	19.3929	11200.0
2012-03-09 06:04:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	11200.0
2012-03-09 06:05:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	11200.0
2012-03-09 06:07:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	5600.0
2012-03-09 06:13:00	AAPL	Stock	19.3839	19.3839	19.3839	19.3839	11200.0
2012-03-09 06:14:00	AAPL	Stock	19.3839	19.3839	19.3839	19.3839	2800.0
2012-03-09 06:16:00	AAPL	Stock	19.375	19.3821	19.375	19.3821	9800.0
2012-03-09 06:26:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	8400.0
2012-03-09 06:31:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	56000.0
2012-03-09 07:00:00	AAPL	Stock	19.4054	19.4054	19.4054	19.4054	2800.0
2012-03-09 07:02:00	AAPL	Stock	19.4036	19.4036	19.3964	19.3964	28000.0
2012-03-09 07:03:00	AAPL	Stock	19.3964	19.4	19.3964	19.4	5600.0
2012-03-09 07:06:00	AAPL	Stock	19.4	19.4	19.3929	19.3929	25200.0
2012-03-09 07:07:00	AAPL	Stock	19.3857	19.3857	19.3839	19.3839	11200.0
2012-03-09 07:09:00	AAPL	Stock	19.3843	19.3843	19.3839	19.3839	30800.0
2012-03-09 07:10:00	AAPL	Stock	19.3918	19.3929	19.3839	19.3839	22400.0
2012-03-09 07:13:00	AAPL	Stock	19.3857	19.3857	19.3843	19.3857	14000.0
2012-03-09 07:16:00	AAPL	Stock	19.3921	19.3921	19.3857	19.3857	6300.0
2012-03-09 07:17:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	2800.0
2012-03-09 07:19:00	AAPL	Stock	19.3921	19.3929	19.3921	19.3929	26600.0
2012-03-09 07:20:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	33600.0
2012-03-09 07:21:00	AAPL	Stock	19.3961	19.4032	19.3961	19.4032	5600.0
2012-03-09 07:24:00	AAPL	Stock	19.4029	19.4036	19.4029	19.4036	14000.0
2012-03-09 07:26:00	AAPL	Stock	19.4036	19.4036	19.4036	19.4036	5600.0
2012-03-09 07:27:00	AAPL	Stock	19.4029	19.4029	19.4029	19.4029	2800.0
2012-03-09 07:30:00	AAPL	Stock	19.4014	19.4014	19.3861	19.3929	36400.0
2012-03-09 07:32:00	AAPL	Stock	19.3975	19.3975	19.3975	19.3975	2800.0
2012-03-09 07:34:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	5600.0
2012-03-09 07:36:00	AAPL	Stock	19.3975	19.3975	19.3975	19.3975	2800.0
2012-03-09 07:38:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	2800.0
2012-03-09 07:41:00	AAPL	Stock	19.3875	19.3875	19.3857	19.3857	8400.0
2012-03-09 07:42:00	AAPL	Stock	19.3846	19.3857	19.3839	19.3839	29680.0
2012-03-09 07:45:00	AAPL	Stock	19.3839	19.3839	19.3839	19.3839	2800.0
2012-03-09 07:47:00	AAPL	Stock	19.3875	19.3875	19.3875	19.3875	5180.0
2012-03-09 07:48:00	AAPL	Stock	19.3875	19.3875	19.3804	19.3804	37940.0

> showing 50 of 961,688 rows — these rows as CSV

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