PREVIEW / stock_1min / 2011-07-01

all stock 1-min files

  file:    by_date/stock_1min/2011/2011-07-01.parquet
  size:    13.1 MB
  rows:    987,564
  symbols: 2,843

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-07-01 07:01:00	AAPL	Stock	11.975	12.0357	11.975	11.975	16800.0
2011-07-01 07:19:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	11200.0
2011-07-01 07:20:00	AAPL	Stock	11.9793	11.9793	11.9786	11.9786	25200.0
2011-07-01 07:24:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	2800.0
2011-07-01 07:26:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	28000.0
2011-07-01 07:27:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	2800.0
2011-07-01 07:39:00	AAPL	Stock	11.9839	11.9839	11.9825	11.9825	9100.0
2011-07-01 07:48:00	AAPL	Stock	11.9882	11.9893	11.9882	11.9893	11060.0
2011-07-01 07:51:00	AAPL	Stock	11.9889	11.9889	11.9821	11.9821	37800.0
2011-07-01 07:54:00	AAPL	Stock	11.9839	11.9839	11.9821	11.9821	10780.0
2011-07-01 08:00:00	AAPL	Stock	11.9882	11.9882	11.9882	11.9882	56000.0
2011-07-01 08:03:00	AAPL	Stock	11.9768	11.9768	11.9661	11.9661	39200.0
2011-07-01 08:04:00	AAPL	Stock	11.9664	11.9664	11.9646	11.9646	14980.0
2011-07-01 08:06:00	AAPL	Stock	11.9714	11.9714	11.9714	11.9714	18760.0
2011-07-01 08:08:00	AAPL	Stock	11.9714	11.9714	11.9714	11.9714	4732.0
2011-07-01 08:09:00	AAPL	Stock	11.9714	11.9768	11.9714	11.9768	5600.0
2011-07-01 08:12:00	AAPL	Stock	11.9786	11.9786	11.9786	11.9786	4340.0
2011-07-01 08:13:00	AAPL	Stock	11.9714	11.9714	11.9689	11.9689	7280.0
2011-07-01 08:16:00	AAPL	Stock	11.9807	11.9807	11.9807	11.9807	2800.0
2011-07-01 08:19:00	AAPL	Stock	11.9725	11.9732	11.9725	11.9732	10080.0
2011-07-01 08:20:00	AAPL	Stock	11.9725	11.9725	11.9689	11.9689	6300.0
2011-07-01 08:21:00	AAPL	Stock	11.9689	11.9689	11.9689	11.9689	4592.0
2011-07-01 08:24:00	AAPL	Stock	11.9682	11.9714	11.9682	11.9714	5600.0
2011-07-01 08:25:00	AAPL	Stock	11.9714	11.9714	11.9714	11.9714	2800.0
2011-07-01 08:26:00	AAPL	Stock	11.9732	11.9732	11.9732	11.9732	20076.0
2011-07-01 08:28:00	AAPL	Stock	11.9804	11.9804	11.9804	11.9804	2800.0
2011-07-01 08:30:00	AAPL	Stock	11.9804	11.9804	11.9804	11.9804	25200.0
2011-07-01 08:31:00	AAPL	Stock	11.9821	11.9829	11.9821	11.9821	30576.0
2011-07-01 08:37:00	AAPL	Stock	11.9768	11.9768	11.9768	11.9768	11032.0
2011-07-01 08:39:00	AAPL	Stock	11.9882	11.9882	11.9882	11.9882	340200.0
2011-07-01 08:47:00	AAPL	Stock	11.9882	11.9882	11.9882	11.9882	8400.0
2011-07-01 08:48:00	AAPL	Stock	11.9804	11.9804	11.9804	11.9804	2800.0
2011-07-01 08:55:00	AAPL	Stock	11.9857	11.9857	11.9857	11.9857	2800.0
2011-07-01 08:56:00	AAPL	Stock	11.9857	11.9868	11.9857	11.9857	14000.0
2011-07-01 09:02:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	2800.0
2011-07-01 09:03:00	AAPL	Stock	11.9821	11.9821	11.9821	11.9821	2800.0
2011-07-01 09:05:00	AAPL	Stock	11.985	11.985	11.985	11.985	4200.0
2011-07-01 09:06:00	AAPL	Stock	11.9864	11.9929	11.9814	11.9929	164416.0
2011-07-01 09:07:00	AAPL	Stock	11.995	11.995	11.9882	11.9882	30436.0
2011-07-01 09:08:00	AAPL	Stock	11.9918	11.9918	11.9896	11.9904	8400.0
2011-07-01 09:09:00	AAPL	Stock	11.9882	11.9902	11.9882	11.9896	33600.0
2011-07-01 09:10:00	AAPL	Stock	11.9904	11.9921	11.9904	11.9921	53200.0
2011-07-01 09:11:00	AAPL	Stock	11.9896	11.9896	11.9882	11.9896	81200.0
2011-07-01 09:12:00	AAPL	Stock	11.9914	11.995	11.9896	11.995	92316.0
2011-07-01 09:14:00	AAPL	Stock	11.9893	11.9893	11.9893	11.9893	14000.0
2011-07-01 09:15:00	AAPL	Stock	11.9882	11.9932	11.9882	11.9929	96516.0
2011-07-01 09:16:00	AAPL	Stock	11.9929	11.9968	11.9929	11.9929	33600.0
2011-07-01 09:18:00	AAPL	Stock	11.9964	11.9964	11.9964	11.9964	2800.0
2011-07-01 09:19:00	AAPL	Stock	11.9882	11.9982	11.9882	11.9964	110768.0
2011-07-01 09:20:00	AAPL	Stock	11.9964	11.9975	11.9964	11.9975	25200.0

> showing 50 of 987,564 rows — these rows as CSV

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