PREVIEW / stock_1min / 2012-02-27

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-02-27.parquet
  size:    13.1 MB
  rows:    964,661
  symbols: 2,862

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-02-27 04:14:00	AAPL	Stock	18.5804	18.5804	18.5804	18.5804	11200.0
2012-02-27 04:16:00	AAPL	Stock	18.5804	18.5804	18.5804	18.5804	16800.0
2012-02-27 04:18:00	AAPL	Stock	18.5804	18.5804	18.5804	18.5804	2800.0
2012-02-27 04:21:00	AAPL	Stock	18.5804	18.5804	18.5804	18.5804	2800.0
2012-02-27 05:16:00	AAPL	Stock	18.5804	18.5804	18.5804	18.5804	5600.0
2012-02-27 05:34:00	AAPL	Stock	18.565	18.565	18.565	18.565	2800.0
2012-02-27 05:35:00	AAPL	Stock	18.565	18.565	18.565	18.565	5600.0
2012-02-27 05:40:00	AAPL	Stock	18.5571	18.5571	18.5571	18.5571	2800.0
2012-02-27 06:20:00	AAPL	Stock	18.565	18.565	18.565	18.565	5572.0
2012-02-27 06:26:00	AAPL	Stock	18.5714	18.5714	18.5714	18.5714	2800.0
2012-02-27 06:40:00	AAPL	Stock	18.5714	18.5714	18.5714	18.5714	2800.0
2012-02-27 06:42:00	AAPL	Stock	18.5714	18.5714	18.5714	18.5714	5908.0
2012-02-27 06:56:00	AAPL	Stock	18.5579	18.5579	18.5571	18.5571	11200.0
2012-02-27 06:57:00	AAPL	Stock	18.5571	18.5571	18.5571	18.5571	2800.0
2012-02-27 07:05:00	AAPL	Stock	18.5675	18.5675	18.5675	18.5675	2800.0
2012-02-27 07:11:00	AAPL	Stock	18.5761	18.5893	18.5761	18.5893	18956.0
2012-02-27 07:12:00	AAPL	Stock	18.6032	18.6032	18.6032	18.6032	2800.0
2012-02-27 07:13:00	AAPL	Stock	18.5964	18.5968	18.5964	18.5964	11200.0
2012-02-27 07:14:00	AAPL	Stock	18.5961	18.5961	18.5739	18.5739	20552.0
2012-02-27 07:17:00	AAPL	Stock	18.5779	18.5779	18.5779	18.5779	5600.0
2012-02-27 07:18:00	AAPL	Stock	18.5789	18.5789	18.5789	18.5789	5600.0
2012-02-27 07:21:00	AAPL	Stock	18.5714	18.5714	18.5714	18.5714	9520.0
2012-02-27 07:25:00	AAPL	Stock	18.5732	18.5732	18.5714	18.5714	16800.0
2012-02-27 07:26:00	AAPL	Stock	18.5732	18.5732	18.5732	18.5732	2912.0
2012-02-27 07:27:00	AAPL	Stock	18.5636	18.5636	18.5575	18.5589	11200.0
2012-02-27 07:29:00	AAPL	Stock	18.5643	18.5643	18.5643	18.5643	2800.0
2012-02-27 07:32:00	AAPL	Stock	18.5643	18.5643	18.5643	18.5643	8400.0
2012-02-27 07:38:00	AAPL	Stock	18.5679	18.5679	18.5679	18.5679	2800.0
2012-02-27 07:39:00	AAPL	Stock	18.5732	18.5732	18.5732	18.5732	2800.0
2012-02-27 07:40:00	AAPL	Stock	18.5732	18.5732	18.5732	18.5732	8400.0
2012-02-27 07:41:00	AAPL	Stock	18.5732	18.5732	18.5732	18.5732	5600.0
2012-02-27 07:44:00	AAPL	Stock	18.5754	18.5754	18.5754	18.5754	2800.0
2012-02-27 07:45:00	AAPL	Stock	18.5714	18.5714	18.5714	18.5714	25452.0
2012-02-27 07:48:00	AAPL	Stock	18.575	18.575	18.5711	18.5711	22540.0
2012-02-27 07:49:00	AAPL	Stock	18.5711	18.5711	18.5682	18.5696	19600.0
2012-02-27 07:52:00	AAPL	Stock	18.5643	18.5643	18.5643	18.5643	5600.0
2012-02-27 07:53:00	AAPL	Stock	18.5643	18.5675	18.5643	18.5643	11200.0
2012-02-27 07:54:00	AAPL	Stock	18.5621	18.5696	18.5571	18.5696	21924.0
2012-02-27 07:55:00	AAPL	Stock	18.5711	18.5711	18.5711	18.5711	2800.0
2012-02-27 07:56:00	AAPL	Stock	18.5625	18.5625	18.5571	18.5571	55356.0
2012-02-27 07:57:00	AAPL	Stock	18.5596	18.5596	18.5596	18.5596	2800.0
2012-02-27 07:58:00	AAPL	Stock	18.5693	18.5693	18.5693	18.5693	5320.0
2012-02-27 07:59:00	AAPL	Stock	18.5711	18.5711	18.5711	18.5711	2800.0
2012-02-27 08:00:00	AAPL	Stock	18.5714	18.6036	18.5714	18.5739	193200.0
2012-02-27 08:01:00	AAPL	Stock	18.5832	18.585	18.5796	18.585	37604.0
2012-02-27 08:02:00	AAPL	Stock	18.5918	18.5929	18.5893	18.5893	33516.0
2012-02-27 08:03:00	AAPL	Stock	18.5829	18.5975	18.5829	18.5975	53900.0
2012-02-27 08:04:00	AAPL	Stock	18.5961	18.5961	18.5911	18.5911	11480.0
2012-02-27 08:05:00	AAPL	Stock	18.5896	18.5968	18.5896	18.5968	7980.0
2012-02-27 08:06:00	AAPL	Stock	18.5936	18.5982	18.5896	18.5982	56000.0

> showing 50 of 964,661 rows — these rows as CSV

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