PREVIEW / stock_1min / 2012-07-27

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-07-27.parquet
  size:    13.0 MB
  rows:    956,962
  symbols: 2,814

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-07-27 04:00:00	AAPL	Stock	20.5611	20.6071	20.5611	20.6071	16800.0
2012-07-27 04:02:00	AAPL	Stock	20.6	20.6	20.6	20.6	3360.0
2012-07-27 04:08:00	AAPL	Stock	20.6164	20.6164	20.6164	20.6164	2800.0
2012-07-27 04:14:00	AAPL	Stock	20.6425	20.6425	20.6425	20.6425	2800.0
2012-07-27 04:16:00	AAPL	Stock	20.6418	20.6418	20.6418	20.6418	2800.0
2012-07-27 04:17:00	AAPL	Stock	20.6421	20.6421	20.6421	20.6421	2800.0
2012-07-27 04:23:00	AAPL	Stock	20.5954	20.6025	20.5954	20.6025	5600.0
2012-07-27 04:38:00	AAPL	Stock	20.5936	20.5936	20.5893	20.5893	19600.0
2012-07-27 04:47:00	AAPL	Stock	20.5611	20.5611	20.5611	20.5611	2800.0
2012-07-27 04:49:00	AAPL	Stock	20.5575	20.5575	20.5575	20.5575	2800.0
2012-07-27 05:15:00	AAPL	Stock	20.5414	20.5414	20.5414	20.5414	2800.0
2012-07-27 05:45:00	AAPL	Stock	20.6071	20.6071	20.6071	20.6071	25200.0
2012-07-27 06:51:00	AAPL	Stock	20.6068	20.6071	20.6068	20.6071	16520.0
2012-07-27 06:52:00	AAPL	Stock	20.6071	20.6071	20.6071	20.6071	5600.0
2012-07-27 06:57:00	AAPL	Stock	20.6036	20.6036	20.6036	20.6036	2800.0
2012-07-27 06:58:00	AAPL	Stock	20.6068	20.6068	20.6068	20.6068	2800.0
2012-07-27 06:59:00	AAPL	Stock	20.6071	20.6071	20.6071	20.6071	2800.0
2012-07-27 07:02:00	AAPL	Stock	20.6054	20.6054	20.6054	20.6054	2800.0
2012-07-27 07:06:00	AAPL	Stock	20.5907	20.5907	20.5893	20.5893	5600.0
2012-07-27 07:07:00	AAPL	Stock	20.5893	20.5893	20.5893	20.5893	9100.0
2012-07-27 07:15:00	AAPL	Stock	20.5893	20.6	20.5893	20.6	37464.0
2012-07-27 07:16:00	AAPL	Stock	20.6036	20.6036	20.6036	20.6036	5600.0
2012-07-27 07:17:00	AAPL	Stock	20.6068	20.6068	20.6068	20.6068	8400.0
2012-07-27 07:19:00	AAPL	Stock	20.5982	20.6018	20.5982	20.6018	5600.0
2012-07-27 07:20:00	AAPL	Stock	20.6032	20.6071	20.6032	20.6071	39508.0
2012-07-27 07:21:00	AAPL	Stock	20.6071	20.6071	20.6032	20.6032	87080.0
2012-07-27 07:41:00	AAPL	Stock	20.5954	20.5954	20.5954	20.5954	4956.0
2012-07-27 07:45:00	AAPL	Stock	20.5718	20.5718	20.5718	20.5718	2800.0
2012-07-27 07:47:00	AAPL	Stock	20.5611	20.5611	20.5571	20.5571	22764.0
2012-07-27 07:49:00	AAPL	Stock	20.5657	20.5657	20.5657	20.5657	2800.0
2012-07-27 07:53:00	AAPL	Stock	20.5675	20.5679	20.5675	20.5679	28000.0
2012-07-27 07:58:00	AAPL	Stock	20.5607	20.5607	20.5607	20.5607	2800.0
2012-07-27 07:59:00	AAPL	Stock	20.5571	20.5571	20.5571	20.5571	2800.0
2012-07-27 08:00:00	AAPL	Stock	20.5536	20.5536	20.5457	20.5464	14000.0
2012-07-27 08:01:00	AAPL	Stock	20.545	20.545	20.5364	20.5364	16800.0
2012-07-27 08:02:00	AAPL	Stock	20.5357	20.5357	20.5357	20.5357	38360.0
2012-07-27 08:05:00	AAPL	Stock	20.535	20.5396	20.535	20.5389	77868.0
2012-07-27 08:06:00	AAPL	Stock	20.5439	20.5571	20.5425	20.5571	108920.0
2012-07-27 08:11:00	AAPL	Stock	20.5536	20.5536	20.5536	20.5536	3360.0
2012-07-27 08:13:00	AAPL	Stock	20.5525	20.5529	20.5525	20.5529	8400.0
2012-07-27 08:14:00	AAPL	Stock	20.5464	20.5482	20.5464	20.5482	14000.0
2012-07-27 08:16:00	AAPL	Stock	20.5411	20.5411	20.5411	20.5411	2800.0
2012-07-27 08:17:00	AAPL	Stock	20.5429	20.5432	20.5429	20.5432	44800.0
2012-07-27 08:18:00	AAPL	Stock	20.5357	20.5357	20.5357	20.5357	22932.0
2012-07-27 08:19:00	AAPL	Stock	20.5307	20.5393	20.5268	20.5393	153104.0
2012-07-27 08:24:00	AAPL	Stock	20.5254	20.5304	20.525	20.525	19600.0
2012-07-27 08:25:00	AAPL	Stock	20.5236	20.5236	20.5182	20.5182	8400.0
2012-07-27 08:26:00	AAPL	Stock	20.5325	20.5325	20.5325	20.5325	2800.0
2012-07-27 08:27:00	AAPL	Stock	20.5286	20.5314	20.5279	20.5314	8400.0
2012-07-27 08:28:00	AAPL	Stock	20.5279	20.5332	20.5279	20.5332	11200.0

> showing 50 of 956,962 rows — these rows as CSV

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