PREVIEW / stock_1min / 2012-07-19

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-07-19.parquet
  size:    12.3 MB
  rows:    906,866
  symbols: 2,818

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-19 04:00:00	AAPL	Stock	21.7839	21.7839	21.7839	21.7839	2800.0
2012-07-19 04:05:00	AAPL	Stock	21.8032	21.8032	21.8032	21.8032	3220.0
2012-07-19 05:39:00	AAPL	Stock	21.7843	21.7843	21.7843	21.7843	2800.0
2012-07-19 05:42:00	AAPL	Stock	21.7843	21.7843	21.7843	21.7843	2800.0
2012-07-19 05:55:00	AAPL	Stock	21.7843	21.7846	21.7843	21.7846	14000.0
2012-07-19 06:04:00	AAPL	Stock	21.8	21.8	21.8	21.8	3360.0
2012-07-19 06:05:00	AAPL	Stock	21.8	21.8	21.8	21.8	10640.0
2012-07-19 06:07:00	AAPL	Stock	21.8143	21.8143	21.8143	21.8143	2800.0
2012-07-19 06:08:00	AAPL	Stock	21.8143	21.8143	21.8143	21.8143	2800.0
2012-07-19 06:11:00	AAPL	Stock	21.8143	21.8143	21.8143	21.8143	2800.0
2012-07-19 06:12:00	AAPL	Stock	21.8143	21.8143	21.8143	21.8143	2800.0
2012-07-19 06:35:00	AAPL	Stock	21.7893	21.7893	21.7893	21.7893	9800.0
2012-07-19 06:36:00	AAPL	Stock	21.7857	21.7857	21.7821	21.7821	22540.0
2012-07-19 06:37:00	AAPL	Stock	21.7786	21.7786	21.7786	21.7786	11200.0
2012-07-19 06:41:00	AAPL	Stock	21.7554	21.7554	21.7554	21.7554	2800.0
2012-07-19 06:53:00	AAPL	Stock	21.7821	21.7821	21.7821	21.7821	2800.0
2012-07-19 06:56:00	AAPL	Stock	21.7821	21.7821	21.7821	21.7821	5600.0
2012-07-19 07:01:00	AAPL	Stock	21.7786	21.7804	21.7786	21.7804	5600.0
2012-07-19 07:02:00	AAPL	Stock	21.7682	21.78	21.7682	21.7714	12180.0
2012-07-19 07:05:00	AAPL	Stock	21.7779	21.7804	21.7779	21.7804	28000.0
2012-07-19 07:10:00	AAPL	Stock	21.7679	21.7679	21.7679	21.7679	5600.0
2012-07-19 07:11:00	AAPL	Stock	21.7607	21.7607	21.7607	21.7607	2800.0
2012-07-19 07:20:00	AAPL	Stock	21.75	21.75	21.7418	21.7418	8400.0
2012-07-19 07:21:00	AAPL	Stock	21.75	21.75	21.75	21.75	2800.0
2012-07-19 07:22:00	AAPL	Stock	21.75	21.75	21.75	21.75	2800.0
2012-07-19 07:23:00	AAPL	Stock	21.7496	21.7496	21.7496	21.7496	2800.0
2012-07-19 07:24:00	AAPL	Stock	21.75	21.75	21.75	21.75	3332.0
2012-07-19 07:25:00	AAPL	Stock	21.7464	21.75	21.7464	21.75	20748.0
2012-07-19 07:26:00	AAPL	Stock	21.75	21.75	21.7446	21.7446	11200.0
2012-07-19 07:28:00	AAPL	Stock	21.7496	21.75	21.7496	21.75	6720.0
2012-07-19 07:31:00	AAPL	Stock	21.7464	21.75	21.7464	21.75	21000.0
2012-07-19 07:32:00	AAPL	Stock	21.75	21.75	21.75	21.75	11200.0
2012-07-19 07:37:00	AAPL	Stock	21.7404	21.7404	21.7404	21.7404	2800.0
2012-07-19 07:40:00	AAPL	Stock	21.7411	21.7411	21.7321	21.7321	9184.0
2012-07-19 07:41:00	AAPL	Stock	21.7429	21.7429	21.7286	21.7321	12600.0
2012-07-19 07:43:00	AAPL	Stock	21.7411	21.7411	21.7411	21.7411	5600.0
2012-07-19 07:44:00	AAPL	Stock	21.75	21.75	21.75	21.75	9128.0
2012-07-19 07:45:00	AAPL	Stock	21.75	21.7675	21.75	21.7675	36120.0
2012-07-19 07:46:00	AAPL	Stock	21.7671	21.7671	21.7671	21.7671	2800.0
2012-07-19 07:47:00	AAPL	Stock	21.7679	21.7679	21.7679	21.7679	2800.0
2012-07-19 07:48:00	AAPL	Stock	21.7729	21.7818	21.7729	21.7818	19600.0
2012-07-19 07:50:00	AAPL	Stock	21.7818	21.7818	21.7793	21.7793	11200.0
2012-07-19 07:52:00	AAPL	Stock	21.7761	21.7761	21.7761	21.7761	2800.0
2012-07-19 07:53:00	AAPL	Stock	21.775	21.7754	21.7611	21.7714	169400.0
2012-07-19 07:54:00	AAPL	Stock	21.7704	21.7857	21.7704	21.7857	83356.0
2012-07-19 07:56:00	AAPL	Stock	21.7857	21.7857	21.7857	21.7857	50904.0
2012-07-19 07:59:00	AAPL	Stock	21.7786	21.7786	21.7786	21.7786	2800.0
2012-07-19 08:00:00	AAPL	Stock	21.7721	21.7857	21.75	21.7679	114912.0
2012-07-19 08:01:00	AAPL	Stock	21.7782	21.7839	21.7782	21.7786	57456.0
2012-07-19 08:02:00	AAPL	Stock	21.7768	21.7821	21.7679	21.7679	57512.0

> showing 50 of 906,866 rows — these rows as CSV

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