PREVIEW / stock_1min / 2012-02-24

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-02-24.parquet
  size:    12.7 MB
  rows:    940,070
  symbols: 2,865

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-24 04:00:00	AAPL	Stock	18.48	18.5	18.48	18.5	37940.0
2012-02-24 04:01:00	AAPL	Stock	18.4996	18.5	18.4996	18.5	12600.0
2012-02-24 04:02:00	AAPL	Stock	18.5	18.5268	18.5	18.5268	18060.0
2012-02-24 04:05:00	AAPL	Stock	18.535	18.5354	18.535	18.5354	13720.0
2012-02-24 04:13:00	AAPL	Stock	18.5343	18.5354	18.5343	18.5354	17080.0
2012-02-24 04:18:00	AAPL	Stock	18.5357	18.5357	18.5357	18.5357	2800.0
2012-02-24 04:30:00	AAPL	Stock	18.5461	18.5461	18.5461	18.5461	2800.0
2012-02-24 04:49:00	AAPL	Stock	18.5361	18.5361	18.5361	18.5361	2800.0
2012-02-24 04:51:00	AAPL	Stock	18.5357	18.5357	18.5357	18.5357	2800.0
2012-02-24 04:52:00	AAPL	Stock	18.5361	18.5361	18.5361	18.5361	2800.0
2012-02-24 04:53:00	AAPL	Stock	18.5514	18.5514	18.5514	18.5514	2800.0
2012-02-24 05:09:00	AAPL	Stock	18.5511	18.5514	18.5511	18.5514	15120.0
2012-02-24 05:11:00	AAPL	Stock	18.5536	18.5536	18.5536	18.5536	2800.0
2012-02-24 05:13:00	AAPL	Stock	18.5714	18.5714	18.5714	18.5714	11200.0
2012-02-24 05:22:00	AAPL	Stock	18.5643	18.5643	18.5643	18.5643	2800.0
2012-02-24 05:47:00	AAPL	Stock	18.5475	18.5475	18.5464	18.5464	8680.0
2012-02-24 05:48:00	AAPL	Stock	18.5429	18.5571	18.5429	18.5571	30660.0
2012-02-24 05:53:00	AAPL	Stock	18.5571	18.5571	18.5571	18.5571	10920.0
2012-02-24 05:57:00	AAPL	Stock	18.5571	18.5571	18.5571	18.5571	3080.0
2012-02-24 05:59:00	AAPL	Stock	18.5393	18.5571	18.5393	18.5571	28000.0
2012-02-24 06:29:00	AAPL	Stock	18.5393	18.5393	18.5357	18.5357	16800.0
2012-02-24 06:30:00	AAPL	Stock	18.5357	18.5568	18.5357	18.5568	7140.0
2012-02-24 06:43:00	AAPL	Stock	18.5646	18.5646	18.5646	18.5646	5600.0
2012-02-24 06:44:00	AAPL	Stock	18.5625	18.5625	18.5625	18.5625	2800.0
2012-02-24 06:45:00	AAPL	Stock	18.5714	18.5714	18.5714	18.5714	2800.0
2012-02-24 06:46:00	AAPL	Stock	18.5714	18.5714	18.5714	18.5714	2800.0
2012-02-24 06:48:00	AAPL	Stock	18.5571	18.5571	18.5536	18.5536	8400.0
2012-02-24 06:53:00	AAPL	Stock	18.5411	18.5411	18.54	18.54	5600.0
2012-02-24 07:00:00	AAPL	Stock	18.5411	18.5621	18.5357	18.5621	37240.0
2012-02-24 07:01:00	AAPL	Stock	18.56	18.5636	18.545	18.545	44800.0
2012-02-24 07:02:00	AAPL	Stock	18.5536	18.5536	18.5536	18.5536	14000.0
2012-02-24 07:04:00	AAPL	Stock	18.5607	18.5607	18.5607	18.5607	5488.0
2012-02-24 07:05:00	AAPL	Stock	18.56	18.5614	18.5475	18.5475	41132.0
2012-02-24 07:07:00	AAPL	Stock	18.54	18.54	18.5357	18.5357	41944.0
2012-02-24 07:08:00	AAPL	Stock	18.5321	18.5321	18.5232	18.5232	8400.0
2012-02-24 07:09:00	AAPL	Stock	18.525	18.525	18.525	18.525	5600.0
2012-02-24 07:11:00	AAPL	Stock	18.5314	18.5425	18.5314	18.5382	72940.0
2012-02-24 07:12:00	AAPL	Stock	18.5357	18.5429	18.5357	18.5429	14000.0
2012-02-24 07:13:00	AAPL	Stock	18.5429	18.5496	18.5357	18.5496	64288.0
2012-02-24 07:14:00	AAPL	Stock	18.5464	18.55	18.5464	18.5482	50988.0
2012-02-24 07:15:00	AAPL	Stock	18.5561	18.5571	18.5561	18.5571	14000.0
2012-02-24 07:16:00	AAPL	Stock	18.5571	18.5571	18.5571	18.5571	19600.0
2012-02-24 07:17:00	AAPL	Stock	18.5607	18.5636	18.5604	18.5607	15260.0
2012-02-24 07:18:00	AAPL	Stock	18.5643	18.5714	18.5643	18.5711	144620.0
2012-02-24 07:19:00	AAPL	Stock	18.5711	18.5714	18.5711	18.5714	18760.0
2012-02-24 07:20:00	AAPL	Stock	18.5786	18.5786	18.5786	18.5786	14000.0
2012-02-24 07:23:00	AAPL	Stock	18.5732	18.5732	18.5732	18.5732	3640.0
2012-02-24 07:24:00	AAPL	Stock	18.5714	18.5721	18.5714	18.5714	148680.0
2012-02-24 07:25:00	AAPL	Stock	18.5718	18.5718	18.5718	18.5718	5600.0
2012-02-24 07:26:00	AAPL	Stock	18.5764	18.5764	18.5679	18.5711	135100.0

> showing 50 of 940,070 rows — these rows as CSV

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