PREVIEW / stock_1min / 2012-07-31

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-07-31.parquet
  size:    12.5 MB
  rows:    930,605
  symbols: 2,822

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-31 04:48:00	AAPL	Stock	21.4107	21.4107	21.4107	21.4107	14000.0
2012-07-31 05:15:00	AAPL	Stock	21.4286	21.4286	21.4286	21.4286	7000.0
2012-07-31 05:17:00	AAPL	Stock	21.4643	21.4643	21.4643	21.4643	27300.0
2012-07-31 05:26:00	AAPL	Stock	21.4643	21.4643	21.4643	21.4643	2800.0
2012-07-31 06:01:00	AAPL	Stock	21.4643	21.4643	21.4643	21.4643	2800.0
2012-07-31 06:04:00	AAPL	Stock	21.4643	21.4643	21.4643	21.4643	8400.0
2012-07-31 06:05:00	AAPL	Stock	21.4643	21.4643	21.4493	21.4493	11200.0
2012-07-31 06:06:00	AAPL	Stock	21.4464	21.4464	21.4464	21.4464	2800.0
2012-07-31 06:09:00	AAPL	Stock	21.4464	21.4464	21.4464	21.4464	2800.0
2012-07-31 06:18:00	AAPL	Stock	21.4286	21.4286	21.4286	21.4286	8120.0
2012-07-31 06:25:00	AAPL	Stock	21.4143	21.4143	21.4143	21.4143	7000.0
2012-07-31 06:40:00	AAPL	Stock	21.4232	21.4232	21.4232	21.4232	5600.0
2012-07-31 06:41:00	AAPL	Stock	21.4089	21.4089	21.4089	21.4089	2800.0
2012-07-31 06:45:00	AAPL	Stock	21.4214	21.4214	21.4214	21.4214	2800.0
2012-07-31 06:53:00	AAPL	Stock	21.4214	21.4214	21.4214	21.4214	2800.0
2012-07-31 07:00:00	AAPL	Stock	21.4196	21.4196	21.4196	21.4196	14000.0
2012-07-31 07:01:00	AAPL	Stock	21.3929	21.4196	21.3929	21.4196	11200.0
2012-07-31 07:03:00	AAPL	Stock	21.4111	21.4111	21.4111	21.4111	2800.0
2012-07-31 07:06:00	AAPL	Stock	21.4196	21.4286	21.4196	21.4286	68040.0
2012-07-31 07:07:00	AAPL	Stock	21.4421	21.4464	21.4414	21.4464	62272.0
2012-07-31 07:08:00	AAPL	Stock	21.4643	21.4821	21.4607	21.4821	73052.0
2012-07-31 07:10:00	AAPL	Stock	21.4821	21.4821	21.4821	21.4821	8400.0
2012-07-31 07:11:00	AAPL	Stock	21.47	21.47	21.47	21.47	2800.0
2012-07-31 07:12:00	AAPL	Stock	21.4818	21.4818	21.4818	21.4818	13300.0
2012-07-31 07:13:00	AAPL	Stock	21.4821	21.5	21.4821	21.5	22400.0
2012-07-31 07:14:00	AAPL	Stock	21.5043	21.5043	21.5	21.5	55720.0
2012-07-31 07:15:00	AAPL	Stock	21.5	21.5043	21.5	21.5043	8400.0
2012-07-31 07:16:00	AAPL	Stock	21.5161	21.5339	21.5161	21.5161	32704.0
2012-07-31 07:17:00	AAPL	Stock	21.5107	21.5179	21.4936	21.4936	154280.0
2012-07-31 07:18:00	AAPL	Stock	21.5	21.5118	21.4914	21.5118	18200.0
2012-07-31 07:19:00	AAPL	Stock	21.5004	21.5004	21.5	21.5	26432.0
2012-07-31 07:20:00	AAPL	Stock	21.4929	21.5136	21.4821	21.4821	212660.0
2012-07-31 07:21:00	AAPL	Stock	21.4996	21.5	21.4996	21.5	14000.0
2012-07-31 07:22:00	AAPL	Stock	21.5	21.5	21.5	21.5	39900.0
2012-07-31 07:23:00	AAPL	Stock	21.5079	21.5079	21.5079	21.5079	2800.0
2012-07-31 07:24:00	AAPL	Stock	21.5	21.5	21.5	21.5	12880.0
2012-07-31 07:25:00	AAPL	Stock	21.5	21.5	21.5	21.5	5600.0
2012-07-31 07:26:00	AAPL	Stock	21.5175	21.5175	21.5175	21.5175	2800.0
2012-07-31 07:27:00	AAPL	Stock	21.5	21.5	21.5	21.5	56000.0
2012-07-31 07:28:00	AAPL	Stock	21.5136	21.5175	21.5136	21.5175	8400.0
2012-07-31 07:29:00	AAPL	Stock	21.5179	21.5286	21.5179	21.5179	87556.0
2012-07-31 07:31:00	AAPL	Stock	21.5164	21.5164	21.5164	21.5164	8400.0
2012-07-31 07:32:00	AAPL	Stock	21.5164	21.5164	21.5164	21.5164	19600.0
2012-07-31 07:35:00	AAPL	Stock	21.5179	21.5179	21.5	21.5004	55552.0
2012-07-31 07:36:00	AAPL	Stock	21.5004	21.5004	21.5004	21.5004	5600.0
2012-07-31 07:37:00	AAPL	Stock	21.5	21.5	21.5	21.5	2800.0
2012-07-31 07:38:00	AAPL	Stock	21.5107	21.5107	21.5107	21.5107	39200.0
2012-07-31 07:39:00	AAPL	Stock	21.5018	21.5018	21.5018	21.5018	6440.0
2012-07-31 07:41:00	AAPL	Stock	21.5004	21.5004	21.5	21.5	7420.0
2012-07-31 07:44:00	AAPL	Stock	21.5	21.5	21.5	21.5	2800.0

> showing 50 of 930,605 rows — these rows as CSV

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