PREVIEW / stock_1min / 2012-04-17

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-04-17.parquet
  size:    12.9 MB
  rows:    962,511
  symbols: 2,863

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-04-17 04:00:00	AAPL	Stock	20.6679	20.6679	20.2679	20.2679	39256.0
2012-04-17 04:01:00	AAPL	Stock	20.3214	20.3214	20.3214	20.3214	2800.0
2012-04-17 04:02:00	AAPL	Stock	20.2857	20.3532	20.2857	20.3036	39200.0
2012-04-17 04:03:00	AAPL	Stock	20.3036	20.3214	20.3036	20.3214	25452.0
2012-04-17 04:04:00	AAPL	Stock	20.3211	20.3214	20.3211	20.3211	14532.0
2012-04-17 04:05:00	AAPL	Stock	20.3214	20.3489	20.3214	20.3489	17444.0
2012-04-17 04:06:00	AAPL	Stock	20.3286	20.3321	20.3286	20.3321	5600.0
2012-04-17 04:07:00	AAPL	Stock	20.3286	20.3393	20.3286	20.3393	9100.0
2012-04-17 04:08:00	AAPL	Stock	20.3525	20.425	20.3375	20.425	65968.0
2012-04-17 04:09:00	AAPL	Stock	20.3893	20.3893	20.375	20.375	8400.0
2012-04-17 04:10:00	AAPL	Stock	20.4071	20.4071	20.4071	20.4071	4508.0
2012-04-17 04:11:00	AAPL	Stock	20.4246	20.4286	20.4107	20.4286	95200.0
2012-04-17 04:12:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	14000.0
2012-04-17 04:13:00	AAPL	Stock	20.4286	20.4286	20.4286	20.4286	8400.0
2012-04-17 04:14:00	AAPL	Stock	20.4429	20.4429	20.4429	20.4429	25200.0
2012-04-17 04:17:00	AAPL	Stock	20.4286	20.4286	20.3964	20.4107	8400.0
2012-04-17 04:18:00	AAPL	Stock	20.3929	20.3929	20.3929	20.3929	26040.0
2012-04-17 04:19:00	AAPL	Stock	20.4014	20.4014	20.4014	20.4014	2800.0
2012-04-17 04:20:00	AAPL	Stock	20.3946	20.3946	20.3946	20.3946	14000.0
2012-04-17 04:23:00	AAPL	Stock	20.4	20.4018	20.4	20.4018	11788.0
2012-04-17 04:24:00	AAPL	Stock	20.3964	20.3964	20.3964	20.3964	2800.0
2012-04-17 04:25:00	AAPL	Stock	20.4018	20.425	20.4018	20.4107	33712.0
2012-04-17 04:26:00	AAPL	Stock	20.4425	20.4425	20.4425	20.4425	5600.0
2012-04-17 04:27:00	AAPL	Stock	20.4425	20.4425	20.4425	20.4425	2800.0
2012-04-17 04:28:00	AAPL	Stock	20.4429	20.4464	20.4429	20.4464	18648.0
2012-04-17 04:29:00	AAPL	Stock	20.4464	20.4464	20.4464	20.4464	3752.0
2012-04-17 04:30:00	AAPL	Stock	20.4639	20.4639	20.4361	20.4361	19600.0
2012-04-17 04:31:00	AAPL	Stock	20.4429	20.4568	20.4429	20.4568	11200.0
2012-04-17 04:32:00	AAPL	Stock	20.4568	20.4568	20.4568	20.4568	2800.0
2012-04-17 04:34:00	AAPL	Stock	20.4571	20.4643	20.4571	20.4643	14000.0
2012-04-17 04:35:00	AAPL	Stock	20.4643	20.4643	20.4643	20.4643	3864.0
2012-04-17 04:36:00	AAPL	Stock	20.4911	20.4911	20.4911	20.4911	2800.0
2012-04-17 04:40:00	AAPL	Stock	20.4789	20.5311	20.4789	20.5311	14084.0
2012-04-17 04:41:00	AAPL	Stock	20.53	20.53	20.53	20.53	2800.0
2012-04-17 04:45:00	AAPL	Stock	20.5268	20.5271	20.5268	20.5271	12600.0
2012-04-17 04:47:00	AAPL	Stock	20.5286	20.5286	20.5268	20.5268	16800.0
2012-04-17 04:48:00	AAPL	Stock	20.5304	20.5304	20.5304	20.5304	5600.0
2012-04-17 04:53:00	AAPL	Stock	20.5179	20.5179	20.5179	20.5179	2800.0
2012-04-17 05:00:00	AAPL	Stock	20.5143	20.5321	20.5143	20.5321	11788.0
2012-04-17 05:03:00	AAPL	Stock	20.5354	20.5354	20.5354	20.5354	2800.0
2012-04-17 05:04:00	AAPL	Stock	20.5429	20.5429	20.5429	20.5429	5600.0
2012-04-17 05:05:00	AAPL	Stock	20.5496	20.55	20.5496	20.55	5600.0
2012-04-17 05:06:00	AAPL	Stock	20.5625	20.5679	20.5625	20.5679	36400.0
2012-04-17 05:08:00	AAPL	Stock	20.5921	20.5921	20.5796	20.5796	5600.0
2012-04-17 05:09:00	AAPL	Stock	20.5857	20.5857	20.5857	20.5857	8400.0
2012-04-17 05:10:00	AAPL	Stock	20.6036	20.6157	20.6036	20.6157	16800.0
2012-04-17 05:11:00	AAPL	Stock	20.6161	20.6161	20.6157	20.6157	14000.0
2012-04-17 05:14:00	AAPL	Stock	20.6214	20.6214	20.6214	20.6214	2800.0
2012-04-17 05:17:00	AAPL	Stock	20.6071	20.6071	20.6071	20.6071	2800.0
2012-04-17 05:18:00	AAPL	Stock	20.6071	20.6071	20.6071	20.6071	2940.0

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

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