PREVIEW / stock_1min / 2012-07-02

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-07-02.parquet
  size:    12.8 MB
  rows:    960,832
  symbols: 2,819

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-02 04:02:00	AAPL	Stock	20.875	20.875	20.875	20.875	2800.0
2012-07-02 04:09:00	AAPL	Stock	20.8836	20.8836	20.8836	20.8836	11200.0
2012-07-02 04:10:00	AAPL	Stock	20.8821	20.8839	20.8821	20.8839	33600.0
2012-07-02 04:11:00	AAPL	Stock	20.8839	20.8839	20.8839	20.8839	2800.0
2012-07-02 04:12:00	AAPL	Stock	20.8839	20.8875	20.8839	20.8875	30800.0
2012-07-02 04:26:00	AAPL	Stock	20.9286	20.9532	20.9286	20.9532	14000.0
2012-07-02 04:27:00	AAPL	Stock	20.9532	20.9532	20.9464	20.9464	11200.0
2012-07-02 04:28:00	AAPL	Stock	20.9464	20.9464	20.9464	20.9464	19600.0
2012-07-02 05:04:00	AAPL	Stock	20.9532	20.9532	20.9532	20.9532	8120.0
2012-07-02 05:22:00	AAPL	Stock	20.9532	20.9532	20.9532	20.9532	2800.0
2012-07-02 05:28:00	AAPL	Stock	20.9536	20.9536	20.9536	20.9536	2800.0
2012-07-02 05:30:00	AAPL	Stock	20.9482	20.9482	20.9286	20.9286	18200.0
2012-07-02 05:31:00	AAPL	Stock	20.9286	20.9286	20.9286	20.9286	16800.0
2012-07-02 05:33:00	AAPL	Stock	20.9286	20.9286	20.9286	20.9286	5600.0
2012-07-02 06:04:00	AAPL	Stock	20.9214	20.9214	20.9214	20.9214	14000.0
2012-07-02 06:09:00	AAPL	Stock	20.9168	20.9168	20.9168	20.9168	2800.0
2012-07-02 06:15:00	AAPL	Stock	20.9107	20.9107	20.9	20.9	8400.0
2012-07-02 06:31:00	AAPL	Stock	20.8982	20.8982	20.8982	20.8982	2800.0
2012-07-02 06:36:00	AAPL	Stock	20.9107	20.9143	20.9107	20.9143	17080.0
2012-07-02 06:40:00	AAPL	Stock	20.9168	20.9168	20.9168	20.9168	5600.0
2012-07-02 06:44:00	AAPL	Stock	20.9107	20.9107	20.9107	20.9107	2800.0
2012-07-02 06:51:00	AAPL	Stock	20.9018	20.9018	20.9018	20.9018	2800.0
2012-07-02 07:00:00	AAPL	Stock	20.9	20.9018	20.9	20.9018	14000.0
2012-07-02 07:01:00	AAPL	Stock	20.9164	20.9561	20.9164	20.9561	41776.0
2012-07-02 07:03:00	AAPL	Stock	20.9375	20.9375	20.9375	20.9375	2800.0
2012-07-02 07:04:00	AAPL	Stock	20.9429	20.9429	20.9429	20.9429	22120.0
2012-07-02 07:13:00	AAPL	Stock	20.9286	20.9404	20.9286	20.9404	22400.0
2012-07-02 07:23:00	AAPL	Stock	20.9214	20.9214	20.9214	20.9214	2800.0
2012-07-02 07:24:00	AAPL	Stock	20.9214	20.9214	20.9143	20.9143	19516.0
2012-07-02 07:29:00	AAPL	Stock	20.9104	20.9104	20.9104	20.9104	2800.0
2012-07-02 07:30:00	AAPL	Stock	20.9107	20.9107	20.9107	20.9107	2800.0
2012-07-02 07:33:00	AAPL	Stock	20.9139	20.9139	20.9107	20.9107	11200.0
2012-07-02 07:41:00	AAPL	Stock	20.9018	20.9139	20.8929	20.9139	45976.0
2012-07-02 07:49:00	AAPL	Stock	20.8968	20.8968	20.8968	20.8968	5096.0
2012-07-02 07:50:00	AAPL	Stock	20.8975	20.8975	20.8971	20.8971	5600.0
2012-07-02 07:51:00	AAPL	Stock	20.8961	20.8961	20.8961	20.8961	11200.0
2012-07-02 07:52:00	AAPL	Stock	20.8932	20.8932	20.8929	20.8929	21812.0
2012-07-02 07:55:00	AAPL	Stock	20.8929	20.8929	20.8929	20.8929	2800.0
2012-07-02 07:58:00	AAPL	Stock	20.8929	20.8929	20.8929	20.8929	36820.0
2012-07-02 08:00:00	AAPL	Stock	20.8929	20.8982	20.8629	20.8911	83832.0
2012-07-02 08:01:00	AAPL	Stock	20.8571	20.875	20.8571	20.8714	47096.0
2012-07-02 08:02:00	AAPL	Stock	20.8621	20.8621	20.8621	20.8621	13860.0
2012-07-02 08:03:00	AAPL	Stock	20.875	20.875	20.8571	20.8571	70196.0
2012-07-02 08:04:00	AAPL	Stock	20.8625	20.8625	20.8536	20.8571	19320.0
2012-07-02 08:05:00	AAPL	Stock	20.8571	20.8571	20.8571	20.8571	23408.0
2012-07-02 08:06:00	AAPL	Stock	20.8661	20.8661	20.8661	20.8661	2800.0
2012-07-02 08:07:00	AAPL	Stock	20.8661	20.8711	20.8614	20.8625	34552.0
2012-07-02 08:08:00	AAPL	Stock	20.8625	20.8696	20.8614	20.8696	19600.0
2012-07-02 08:09:00	AAPL	Stock	20.8729	20.8729	20.8625	20.8625	5600.0
2012-07-02 08:10:00	AAPL	Stock	20.8661	20.8661	20.8618	20.8643	15344.0

> showing 50 of 960,832 rows — these rows as CSV

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