PREVIEW / stock_1min / 2012-06-27

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-06-27.parquet
  size:    12.7 MB
  rows:    958,479
  symbols: 2,831

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-06-27 05:20:00	AAPL	Stock	20.4357	20.4357	20.4357	20.4357	2800.0
2012-06-27 05:26:00	AAPL	Stock	20.4296	20.4296	20.4296	20.4296	11200.0
2012-06-27 05:27:00	AAPL	Stock	20.4296	20.4296	20.4296	20.4296	8400.0
2012-06-27 06:02:00	AAPL	Stock	20.445	20.4464	20.445	20.4464	16800.0
2012-06-27 06:17:00	AAPL	Stock	20.4732	20.4732	20.4732	20.4732	8232.0
2012-06-27 06:32:00	AAPL	Stock	20.4732	20.4732	20.4732	20.4732	4368.0
2012-06-27 06:46:00	AAPL	Stock	20.4818	20.4821	20.4818	20.4821	5600.0
2012-06-27 07:01:00	AAPL	Stock	20.4643	20.4821	20.4607	20.4607	16800.0
2012-06-27 07:02:00	AAPL	Stock	20.4489	20.4489	20.4489	20.4489	2800.0
2012-06-27 07:04:00	AAPL	Stock	20.4639	20.4639	20.4639	20.4639	2800.0
2012-06-27 07:08:00	AAPL	Stock	20.4639	20.4639	20.4639	20.4639	22400.0
2012-06-27 07:16:00	AAPL	Stock	20.4643	20.4643	20.4643	20.4643	2800.0
2012-06-27 07:20:00	AAPL	Stock	20.4643	20.4643	20.4643	20.4643	2800.0
2012-06-27 07:22:00	AAPL	Stock	20.4704	20.4714	20.4704	20.4714	8400.0
2012-06-27 07:27:00	AAPL	Stock	20.4821	20.4821	20.4804	20.4818	24024.0
2012-06-27 07:35:00	AAPL	Stock	20.4954	20.5004	20.4954	20.5	61600.0
2012-06-27 07:36:00	AAPL	Stock	20.5	20.5	20.5	20.5	8400.0
2012-06-27 07:37:00	AAPL	Stock	20.5071	20.5071	20.5064	20.5068	8400.0
2012-06-27 07:40:00	AAPL	Stock	20.5011	20.5107	20.5	20.5107	23968.0
2012-06-27 07:41:00	AAPL	Stock	20.5	20.5	20.5	20.5	5600.0
2012-06-27 07:53:00	AAPL	Stock	20.4961	20.4964	20.4961	20.4964	28000.0
2012-06-27 07:55:00	AAPL	Stock	20.4825	20.4825	20.4825	20.4825	2800.0
2012-06-27 07:56:00	AAPL	Stock	20.4975	20.4982	20.4975	20.4982	8400.0
2012-06-27 07:57:00	AAPL	Stock	20.4825	20.4825	20.4825	20.4825	2800.0
2012-06-27 07:59:00	AAPL	Stock	20.4982	20.5	20.4982	20.5	61040.0
2012-06-27 08:00:00	AAPL	Stock	20.5	20.5011	20.4821	20.4939	76720.0
2012-06-27 08:01:00	AAPL	Stock	20.5	20.5	20.4911	20.5	104720.0
2012-06-27 08:02:00	AAPL	Stock	20.5	20.5029	20.5	20.5	25648.0
2012-06-27 08:03:00	AAPL	Stock	20.5011	20.5107	20.5011	20.5107	28868.0
2012-06-27 08:04:00	AAPL	Stock	20.5071	20.5196	20.5025	20.5179	117768.0
2012-06-27 08:05:00	AAPL	Stock	20.5179	20.53	20.5179	20.53	57484.0
2012-06-27 08:06:00	AAPL	Stock	20.5286	20.5364	20.5286	20.5307	127960.0
2012-06-27 08:07:00	AAPL	Stock	20.5346	20.5354	20.5336	20.535	22400.0
2012-06-27 08:08:00	AAPL	Stock	20.5336	20.5336	20.5236	20.5304	19600.0
2012-06-27 08:09:00	AAPL	Stock	20.5311	20.5357	20.5311	20.5357	109480.0
2012-06-27 08:10:00	AAPL	Stock	20.5304	20.5357	20.5304	20.5357	25200.0
2012-06-27 08:11:00	AAPL	Stock	20.5393	20.5464	20.5393	20.5418	47460.0
2012-06-27 08:12:00	AAPL	Stock	20.5421	20.5425	20.5232	20.5232	70784.0
2012-06-27 08:14:00	AAPL	Stock	20.5214	20.525	20.5214	20.525	30800.0
2012-06-27 08:19:00	AAPL	Stock	20.5179	20.525	20.5175	20.525	39900.0
2012-06-27 08:22:00	AAPL	Stock	20.5232	20.5232	20.5232	20.5232	8400.0
2012-06-27 08:24:00	AAPL	Stock	20.5118	20.5118	20.5111	20.5111	14000.0
2012-06-27 08:25:00	AAPL	Stock	20.5143	20.5143	20.5143	20.5143	7000.0
2012-06-27 08:26:00	AAPL	Stock	20.5214	20.525	20.5214	20.525	25200.0
2012-06-27 08:27:00	AAPL	Stock	20.525	20.525	20.5146	20.5196	33600.0
2012-06-27 08:28:00	AAPL	Stock	20.5182	20.5211	20.5054	20.5054	36092.0
2012-06-27 08:29:00	AAPL	Stock	20.5171	20.5236	20.5171	20.5236	14000.0
2012-06-27 08:30:00	AAPL	Stock	20.5211	20.5243	20.5118	20.5186	30800.0
2012-06-27 08:31:00	AAPL	Stock	20.5186	20.5186	20.5186	20.5186	2800.0
2012-06-27 08:32:00	AAPL	Stock	20.5182	20.5243	20.5179	20.5243	57680.0

> showing 50 of 958,479 rows — these rows as CSV

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