PREVIEW / stock_1min / 2012-07-24

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-07-24.parquet
  size:    12.7 MB
  rows:    935,436
  symbols: 2,806

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-24 04:13:00	AAPL	Stock	21.5536	21.5536	21.5536	21.5536	2800.0
2012-07-24 04:24:00	AAPL	Stock	21.5711	21.5711	21.5711	21.5711	2800.0
2012-07-24 04:40:00	AAPL	Stock	21.6	21.6	21.6	21.6	6440.0
2012-07-24 04:44:00	AAPL	Stock	21.6	21.6	21.6	21.6	2800.0
2012-07-24 04:57:00	AAPL	Stock	21.5986	21.6	21.5986	21.6	16800.0
2012-07-24 05:29:00	AAPL	Stock	21.5821	21.5821	21.5821	21.5821	2800.0
2012-07-24 05:57:00	AAPL	Stock	21.5961	21.5961	21.5961	21.5961	2800.0
2012-07-24 05:58:00	AAPL	Stock	21.5964	21.5964	21.5964	21.5964	28000.0
2012-07-24 06:06:00	AAPL	Stock	21.5982	21.5982	21.5982	21.5982	2800.0
2012-07-24 06:09:00	AAPL	Stock	21.5914	21.5914	21.5911	21.5911	5600.0
2012-07-24 06:10:00	AAPL	Stock	21.5911	21.5911	21.5911	21.5911	5600.0
2012-07-24 06:16:00	AAPL	Stock	21.5804	21.5804	21.5804	21.5804	2800.0
2012-07-24 06:17:00	AAPL	Stock	21.5786	21.5786	21.5786	21.5786	16520.0
2012-07-24 06:26:00	AAPL	Stock	21.5714	21.5714	21.5714	21.5714	22400.0
2012-07-24 06:30:00	AAPL	Stock	21.5821	21.5821	21.5821	21.5821	2800.0
2012-07-24 07:00:00	AAPL	Stock	21.5714	21.5782	21.5714	21.5714	17500.0
2012-07-24 07:01:00	AAPL	Stock	21.5804	21.5804	21.5804	21.5804	2800.0
2012-07-24 07:02:00	AAPL	Stock	21.5625	21.5625	21.5625	21.5625	8400.0
2012-07-24 07:03:00	AAPL	Stock	21.5714	21.5714	21.5714	21.5714	2800.0
2012-07-24 07:05:00	AAPL	Stock	21.5821	21.5821	21.58	21.5821	28000.0
2012-07-24 07:06:00	AAPL	Stock	21.5821	21.5821	21.5789	21.5789	5600.0
2012-07-24 07:07:00	AAPL	Stock	21.5893	21.5893	21.5893	21.5893	5600.0
2012-07-24 07:08:00	AAPL	Stock	21.5893	21.5964	21.5893	21.5964	16800.0
2012-07-24 07:11:00	AAPL	Stock	21.5946	21.5971	21.5946	21.5971	5600.0
2012-07-24 07:12:00	AAPL	Stock	21.5979	21.5982	21.5946	21.5946	67200.0
2012-07-24 07:13:00	AAPL	Stock	21.5929	21.5964	21.5893	21.5964	18200.0
2012-07-24 07:15:00	AAPL	Stock	21.5893	21.5893	21.5893	21.5893	12068.0
2012-07-24 07:19:00	AAPL	Stock	21.5893	21.5893	21.5893	21.5893	4760.0
2012-07-24 07:20:00	AAPL	Stock	21.5889	21.5889	21.5671	21.5671	28280.0
2012-07-24 07:21:00	AAPL	Stock	21.5711	21.5711	21.5589	21.5589	82880.0
2012-07-24 07:22:00	AAPL	Stock	21.5589	21.5607	21.5589	21.5607	22400.0
2012-07-24 07:23:00	AAPL	Stock	21.5611	21.5611	21.5607	21.5607	11200.0
2012-07-24 07:24:00	AAPL	Stock	21.5607	21.5607	21.5536	21.5596	85568.0
2012-07-24 07:27:00	AAPL	Stock	21.5554	21.5554	21.5554	21.5554	2800.0
2012-07-24 07:29:00	AAPL	Stock	21.5696	21.5711	21.5561	21.5561	19600.0
2012-07-24 07:30:00	AAPL	Stock	21.5704	21.5707	21.5704	21.5707	5600.0
2012-07-24 07:32:00	AAPL	Stock	21.5693	21.5707	21.5693	21.5707	15540.0
2012-07-24 07:33:00	AAPL	Stock	21.5764	21.5764	21.5714	21.5729	33600.0
2012-07-24 07:34:00	AAPL	Stock	21.5796	21.5796	21.5786	21.5786	8400.0
2012-07-24 07:35:00	AAPL	Stock	21.5786	21.5786	21.5161	21.5161	155708.0
2012-07-24 07:36:00	AAPL	Stock	21.5314	21.5357	21.5214	21.5357	22400.0
2012-07-24 07:37:00	AAPL	Stock	21.5571	21.5571	21.5571	21.5571	2800.0
2012-07-24 07:38:00	AAPL	Stock	21.5554	21.5632	21.5536	21.5536	19600.0
2012-07-24 07:41:00	AAPL	Stock	21.5511	21.5511	21.5511	21.5511	5600.0
2012-07-24 07:43:00	AAPL	Stock	21.5468	21.5468	21.5182	21.5375	137900.0
2012-07-24 07:44:00	AAPL	Stock	21.5354	21.5354	21.5354	21.5354	3640.0
2012-07-24 07:46:00	AAPL	Stock	21.5361	21.5446	21.5361	21.5446	7560.0
2012-07-24 07:47:00	AAPL	Stock	21.5361	21.5361	21.5314	21.5314	60312.0
2012-07-24 07:48:00	AAPL	Stock	21.535	21.5536	21.4971	21.4971	46760.0
2012-07-24 07:49:00	AAPL	Stock	21.5343	21.5343	21.5343	21.5343	2800.0

> showing 50 of 935,436 rows — these rows as CSV

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