PREVIEW / stock_1min / 2014-06-23

all stock 1-min files

  file:    by_date/stock_1min/2014/2014-06-23.parquet
  size:    14.7 MB
  rows:    1,078,886
  symbols: 2,919

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
2014-06-23 04:00:00	AAPL	Stock	22.625	22.9	22.625	22.695	7220.0
2014-06-23 04:01:00	AAPL	Stock	22.6925	22.6925	22.6925	22.6925	3600.0
2014-06-23 04:02:00	AAPL	Stock	22.6875	22.6875	22.6875	22.6875	1200.0
2014-06-23 04:04:00	AAPL	Stock	22.7	22.7	22.6875	22.6875	4400.0
2014-06-23 04:05:00	AAPL	Stock	22.6875	22.6875	22.6875	22.6875	15200.0
2014-06-23 04:06:00	AAPL	Stock	22.6875	22.6875	22.6875	22.6875	1200.0
2014-06-23 04:07:00	AAPL	Stock	22.6875	22.6875	22.6875	22.6875	400.0
2014-06-23 04:08:00	AAPL	Stock	22.6875	22.6875	22.6875	22.6875	800.0
2014-06-23 04:11:00	AAPL	Stock	22.6875	22.6875	22.6875	22.6875	400.0
2014-06-23 04:14:00	AAPL	Stock	22.695	22.695	22.695	22.695	800.0
2014-06-23 04:17:00	AAPL	Stock	22.6925	22.6925	22.6925	22.6925	4000.0
2014-06-23 04:18:00	AAPL	Stock	22.6875	22.6875	22.6875	22.6875	41200.0
2014-06-23 04:19:00	AAPL	Stock	22.6875	22.6925	22.6875	22.6925	4800.0
2014-06-23 04:20:00	AAPL	Stock	22.6875	22.6875	22.6875	22.6875	2000.0
2014-06-23 04:21:00	AAPL	Stock	22.6875	22.6875	22.6875	22.6875	18800.0
2014-06-23 04:22:00	AAPL	Stock	22.6875	22.6875	22.6875	22.6875	1200.0
2014-06-23 04:23:00	AAPL	Stock	22.6875	22.6875	22.6775	22.6875	10400.0
2014-06-23 04:25:00	AAPL	Stock	22.6775	22.6775	22.6775	22.6775	2180.0
2014-06-23 04:27:00	AAPL	Stock	22.6775	22.6775	22.6775	22.6775	800.0
2014-06-23 04:28:00	AAPL	Stock	22.6725	22.675	22.6725	22.675	2280.0
2014-06-23 04:37:00	AAPL	Stock	22.6725	22.6725	22.6725	22.6725	400.0
2014-06-23 05:00:00	AAPL	Stock	22.6625	22.675	22.6625	22.675	6700.0
2014-06-23 05:01:00	AAPL	Stock	22.675	22.675	22.675	22.675	1200.0
2014-06-23 05:06:00	AAPL	Stock	22.6875	22.6875	22.6875	22.6875	400.0
2014-06-23 05:10:00	AAPL	Stock	22.675	22.675	22.675	22.675	800.0
2014-06-23 05:13:00	AAPL	Stock	22.685	22.6875	22.685	22.6875	31300.0
2014-06-23 05:14:00	AAPL	Stock	22.6875	22.6875	22.6875	22.6875	27608.0
2014-06-23 05:27:00	AAPL	Stock	22.725	22.725	22.725	22.725	10768.0
2014-06-23 05:30:00	AAPL	Stock	22.725	22.725	22.725	22.725	3368.0
2014-06-23 05:38:00	AAPL	Stock	22.7475	22.7475	22.7475	22.7475	7916.0
2014-06-23 05:42:00	AAPL	Stock	22.7375	22.7375	22.7375	22.7375	400.0
2014-06-23 05:44:00	AAPL	Stock	22.75	22.75	22.75	22.75	400.0
2014-06-23 05:45:00	AAPL	Stock	22.7475	22.75	22.7475	22.75	4124.0
2014-06-23 05:46:00	AAPL	Stock	22.755	22.755	22.75	22.75	1200.0
2014-06-23 05:48:00	AAPL	Stock	22.75	22.75	22.75	22.75	800.0
2014-06-23 05:49:00	AAPL	Stock	22.75	22.75	22.75	22.75	2400.0
2014-06-23 05:50:00	AAPL	Stock	22.75	22.75	22.75	22.75	400.0
2014-06-23 05:51:00	AAPL	Stock	22.75	22.75	22.75	22.75	3200.0
2014-06-23 05:52:00	AAPL	Stock	22.75	22.75	22.75	22.75	800.0
2014-06-23 05:53:00	AAPL	Stock	22.75	22.75	22.75	22.75	6000.0
2014-06-23 05:57:00	AAPL	Stock	22.755	22.755	22.755	22.755	720.0
2014-06-23 05:58:00	AAPL	Stock	22.755	22.755	22.755	22.755	1200.0
2014-06-23 06:04:00	AAPL	Stock	22.7725	22.785	22.77	22.785	6500.0
2014-06-23 06:05:00	AAPL	Stock	22.7825	22.7825	22.7825	22.7825	2000.0
2014-06-23 06:06:00	AAPL	Stock	22.7825	22.7825	22.7825	22.7825	800.0
2014-06-23 06:07:00	AAPL	Stock	22.7825	22.7825	22.775	22.775	34156.0
2014-06-23 06:08:00	AAPL	Stock	22.775	22.775	22.775	22.775	7200.0
2014-06-23 06:09:00	AAPL	Stock	22.775	22.7775	22.775	22.775	15284.0
2014-06-23 06:11:00	AAPL	Stock	22.775	22.775	22.775	22.775	9600.0
2014-06-23 06:16:00	AAPL	Stock	22.765	22.765	22.765	22.765	1356.0

> showing 50 of 1,078,886 rows — these rows as CSV

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