PREVIEW / stock_1min / 2011-05-18

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-05-18.parquet
  size:    13.3 MB
  rows:    1,005,043
  symbols: 2,886

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
2011-05-18 04:00:00	AAPL	Stock	12.0714	12.0714	12.0714	12.0714	2800.0
2011-05-18 07:00:00	AAPL	Stock	12.0404	12.0404	12.0404	12.0404	2800.0
2011-05-18 07:04:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	3304.0
2011-05-18 07:07:00	AAPL	Stock	12.0379	12.0379	12.0225	12.0225	33180.0
2011-05-18 07:08:00	AAPL	Stock	12.0229	12.0229	12.0229	12.0229	2800.0
2011-05-18 07:10:00	AAPL	Stock	12.025	12.0268	12.025	12.0268	25200.0
2011-05-18 07:17:00	AAPL	Stock	12.0268	12.0268	12.0143	12.0143	11200.0
2011-05-18 07:18:00	AAPL	Stock	12.0143	12.0143	12.0143	12.0143	16800.0
2011-05-18 07:19:00	AAPL	Stock	12.0196	12.0196	12.0196	12.0196	2800.0
2011-05-18 07:22:00	AAPL	Stock	12.0132	12.0132	12.0086	12.0086	19600.0
2011-05-18 07:23:00	AAPL	Stock	12.005	12.005	12.0046	12.0046	8400.0
2011-05-18 07:24:00	AAPL	Stock	12.005	12.005	12.005	12.005	8400.0
2011-05-18 07:32:00	AAPL	Stock	12.0146	12.0146	12.0146	12.0146	22400.0
2011-05-18 07:37:00	AAPL	Stock	12.0179	12.0179	12.0089	12.0089	33600.0
2011-05-18 07:40:00	AAPL	Stock	12.0179	12.0179	12.0179	12.0179	2800.0
2011-05-18 07:41:00	AAPL	Stock	12.0175	12.0175	12.0175	12.0175	2800.0
2011-05-18 07:45:00	AAPL	Stock	12.0161	12.0161	12.0161	12.0161	2800.0
2011-05-18 07:46:00	AAPL	Stock	12.0161	12.0161	12.0161	12.0161	2800.0
2011-05-18 07:48:00	AAPL	Stock	12.0071	12.0071	12.0	12.0	30800.0
2011-05-18 07:49:00	AAPL	Stock	11.9964	11.9964	11.9964	11.9964	2800.0
2011-05-18 07:53:00	AAPL	Stock	12.0	12.0	12.0	12.0	14000.0
2011-05-18 07:54:00	AAPL	Stock	12.0	12.0	12.0	12.0	14000.0
2011-05-18 07:55:00	AAPL	Stock	11.9893	11.9893	11.9893	11.9893	2800.0
2011-05-18 07:58:00	AAPL	Stock	11.9914	11.9918	11.9911	11.9911	12600.0
2011-05-18 08:00:00	AAPL	Stock	12.0	12.0	11.9982	12.0	102508.0
2011-05-18 08:01:00	AAPL	Stock	12.0071	12.0071	12.0018	12.0054	28336.0
2011-05-18 08:02:00	AAPL	Stock	12.0018	12.0061	12.0	12.0	132216.0
2011-05-18 08:04:00	AAPL	Stock	12.0	12.0018	12.0	12.0	11200.0
2011-05-18 08:05:00	AAPL	Stock	12.0	12.0	11.9954	11.9954	25200.0
2011-05-18 08:07:00	AAPL	Stock	11.9982	11.9982	11.9964	11.9964	5600.0
2011-05-18 08:08:00	AAPL	Stock	11.9875	11.9875	11.9821	11.9821	14000.0
2011-05-18 08:09:00	AAPL	Stock	11.9821	11.9821	11.98	11.9821	32200.0
2011-05-18 08:13:00	AAPL	Stock	11.9796	11.9796	11.9796	11.9796	2800.0
2011-05-18 08:14:00	AAPL	Stock	11.9796	11.9857	11.9796	11.9857	8400.0
2011-05-18 08:15:00	AAPL	Stock	11.9857	11.9857	11.9857	11.9857	10780.0
2011-05-18 08:16:00	AAPL	Stock	11.9821	11.9821	11.9714	11.9714	52360.0
2011-05-18 08:18:00	AAPL	Stock	11.9764	11.9768	11.9764	11.9768	19600.0
2011-05-18 08:19:00	AAPL	Stock	11.9786	11.9857	11.9771	11.9771	21000.0
2011-05-18 08:20:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	2800.0
2011-05-18 08:25:00	AAPL	Stock	11.9768	11.9768	11.9768	11.9768	11200.0
2011-05-18 08:26:00	AAPL	Stock	11.9775	11.9814	11.9775	11.9814	16800.0
2011-05-18 08:27:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	25200.0
2011-05-18 08:28:00	AAPL	Stock	11.9857	11.9857	11.9857	11.9857	3332.0
2011-05-18 08:31:00	AAPL	Stock	11.9857	11.9946	11.9857	11.9946	10192.0
2011-05-18 08:32:00	AAPL	Stock	11.9946	11.9946	11.9946	11.9946	12012.0
2011-05-18 08:36:00	AAPL	Stock	11.9825	11.9825	11.9825	11.9825	7000.0
2011-05-18 08:37:00	AAPL	Stock	11.9825	11.9825	11.9825	11.9825	2800.0
2011-05-18 08:38:00	AAPL	Stock	11.9857	11.9857	11.9857	11.9857	8400.0
2011-05-18 08:39:00	AAPL	Stock	11.9857	11.9857	11.9825	11.9825	18788.0
2011-05-18 08:43:00	AAPL	Stock	11.9832	11.9832	11.9821	11.9821	41020.0

> showing 50 of 1,005,043 rows — these rows as CSV

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