PREVIEW / stock_1min / 2012-08-02

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-08-02.parquet
  size:    12.8 MB
  rows:    955,792
  symbols: 2,789

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-08-02 04:04:00	AAPL	Stock	21.7071	21.7071	21.7071	21.7071	2800.0
2012-08-02 04:05:00	AAPL	Stock	21.7	21.7	21.7	21.7	2800.0
2012-08-02 04:09:00	AAPL	Stock	21.7	21.7	21.7	21.7	5600.0
2012-08-02 04:12:00	AAPL	Stock	21.7143	21.7143	21.7143	21.7143	4200.0
2012-08-02 05:57:00	AAPL	Stock	21.7321	21.75	21.7321	21.75	12068.0
2012-08-02 05:59:00	AAPL	Stock	21.75	21.75	21.75	21.75	12292.0
2012-08-02 06:48:00	AAPL	Stock	21.7429	21.7429	21.7429	21.7429	7000.0
2012-08-02 06:57:00	AAPL	Stock	21.75	21.75	21.75	21.75	24528.0
2012-08-02 07:00:00	AAPL	Stock	21.7321	21.75	21.7321	21.75	5600.0
2012-08-02 07:01:00	AAPL	Stock	21.775	21.775	21.75	21.75	22400.0
2012-08-02 07:03:00	AAPL	Stock	21.75	21.75	21.75	21.75	14000.0
2012-08-02 07:06:00	AAPL	Stock	21.7643	21.7643	21.7643	21.7643	7560.0
2012-08-02 07:08:00	AAPL	Stock	21.75	21.75	21.75	21.75	6188.0
2012-08-02 07:09:00	AAPL	Stock	21.7639	21.7639	21.7639	21.7639	5600.0
2012-08-02 07:10:00	AAPL	Stock	21.7675	21.7675	21.7675	21.7675	2800.0
2012-08-02 07:11:00	AAPL	Stock	21.7671	21.7671	21.75	21.75	36400.0
2012-08-02 07:14:00	AAPL	Stock	21.7589	21.7589	21.75	21.75	8400.0
2012-08-02 07:17:00	AAPL	Stock	21.7504	21.7504	21.75	21.75	5600.0
2012-08-02 07:18:00	AAPL	Stock	21.7411	21.7411	21.7321	21.7321	44800.0
2012-08-02 07:26:00	AAPL	Stock	21.7143	21.7143	21.7143	21.7143	4760.0
2012-08-02 07:27:00	AAPL	Stock	21.7075	21.7075	21.7075	21.7075	4200.0
2012-08-02 07:30:00	AAPL	Stock	21.7143	21.7143	21.7143	21.7143	8400.0
2012-08-02 07:34:00	AAPL	Stock	21.7171	21.7171	21.7171	21.7171	2800.0
2012-08-02 07:36:00	AAPL	Stock	21.7407	21.7407	21.74	21.74	5600.0
2012-08-02 07:40:00	AAPL	Stock	21.7321	21.7386	21.7321	21.7386	25200.0
2012-08-02 07:41:00	AAPL	Stock	21.7386	21.7386	21.7382	21.7386	8400.0
2012-08-02 07:42:00	AAPL	Stock	21.7382	21.7411	21.7382	21.7411	36400.0
2012-08-02 07:43:00	AAPL	Stock	21.7411	21.7429	21.7393	21.7429	56000.0
2012-08-02 07:44:00	AAPL	Stock	21.7389	21.7429	21.7389	21.7396	47600.0
2012-08-02 07:45:00	AAPL	Stock	21.7396	21.7396	21.7143	21.7354	59920.0
2012-08-02 07:47:00	AAPL	Stock	21.7321	21.7321	21.7321	21.7321	8400.0
2012-08-02 07:48:00	AAPL	Stock	21.7321	21.7321	21.7321	21.7321	19600.0
2012-08-02 07:50:00	AAPL	Stock	21.7407	21.7768	21.7325	21.7768	55496.0
2012-08-02 07:51:00	AAPL	Stock	21.7361	21.7361	21.7361	21.7361	2800.0
2012-08-02 07:53:00	AAPL	Stock	21.7643	21.7643	21.7643	21.7643	8400.0
2012-08-02 07:55:00	AAPL	Stock	21.7707	21.7725	21.7686	21.7686	11200.0
2012-08-02 07:56:00	AAPL	Stock	21.7775	21.7846	21.7746	21.7839	14280.0
2012-08-02 07:57:00	AAPL	Stock	21.7786	21.7786	21.7786	21.7786	2800.0
2012-08-02 07:59:00	AAPL	Stock	21.775	21.775	21.7732	21.7732	11200.0
2012-08-02 08:00:00	AAPL	Stock	21.7679	21.7811	21.7657	21.7714	79324.0
2012-08-02 08:01:00	AAPL	Stock	21.7679	21.7679	21.7679	21.7679	19600.0
2012-08-02 08:02:00	AAPL	Stock	21.7714	21.7768	21.7679	21.7768	111412.0
2012-08-02 08:03:00	AAPL	Stock	21.7771	21.7821	21.7768	21.7814	33600.0
2012-08-02 08:04:00	AAPL	Stock	21.7771	21.7946	21.7771	21.7939	98336.0
2012-08-02 08:05:00	AAPL	Stock	21.7911	21.7925	21.7857	21.7864	33600.0
2012-08-02 08:06:00	AAPL	Stock	21.7857	21.7864	21.7768	21.7768	61572.0
2012-08-02 08:07:00	AAPL	Stock	21.7768	21.7768	21.7768	21.7768	5600.0
2012-08-02 08:08:00	AAPL	Stock	21.7768	21.7821	21.7768	21.78	99400.0
2012-08-02 08:10:00	AAPL	Stock	21.7761	21.7761	21.7575	21.7575	14000.0
2012-08-02 08:11:00	AAPL	Stock	21.7689	21.7689	21.7689	21.7689	2800.0

> showing 50 of 955,792 rows — these rows as CSV

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