PREVIEW / stock_1min / 2017-03-02

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-03-02.parquet
  size:    15.0 MB
  rows:    1,075,247
  symbols: 2,554

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
2017-03-02 04:00:00	AAPL	Stock	35.0	35.0	35.0	35.0	800.0
2017-03-02 04:08:00	AAPL	Stock	34.9875	34.9875	34.9875	34.9875	1200.0
2017-03-02 04:12:00	AAPL	Stock	34.9525	34.9525	34.9475	34.9475	1472.0
2017-03-02 04:15:00	AAPL	Stock	34.9625	34.9625	34.9625	34.9625	400.0
2017-03-02 04:45:00	AAPL	Stock	34.9375	34.9375	34.9375	34.9375	400.0
2017-03-02 04:59:00	AAPL	Stock	34.89	34.89	34.89	34.89	656.0
2017-03-02 05:00:00	AAPL	Stock	34.8875	34.8875	34.8875	34.8875	512.0
2017-03-02 05:26:00	AAPL	Stock	34.95	34.95	34.95	34.95	576.0
2017-03-02 05:27:00	AAPL	Stock	34.95	34.95	34.95	34.95	800.0
2017-03-02 05:38:00	AAPL	Stock	34.9675	34.9675	34.9675	34.9675	400.0
2017-03-02 05:42:00	AAPL	Stock	34.9675	34.975	34.9675	34.975	1776.0
2017-03-02 05:57:00	AAPL	Stock	34.95	34.95	34.95	34.95	400.0
2017-03-02 05:58:00	AAPL	Stock	34.95	34.95	34.95	34.95	788.0
2017-03-02 06:08:00	AAPL	Stock	34.92	34.92	34.92	34.92	2800.0
2017-03-02 06:09:00	AAPL	Stock	34.9475	34.9575	34.9475	34.9575	11612.0
2017-03-02 06:11:00	AAPL	Stock	34.9275	34.9275	34.9275	34.9275	1200.0
2017-03-02 06:15:00	AAPL	Stock	34.95	34.95	34.95	34.95	400.0
2017-03-02 06:44:00	AAPL	Stock	34.9075	34.9075	34.9075	34.9075	492.0
2017-03-02 06:50:00	AAPL	Stock	34.9475	34.95	34.9475	34.95	2800.0
2017-03-02 07:04:00	AAPL	Stock	34.9575	34.9575	34.9575	34.9575	472.0
2017-03-02 07:07:00	AAPL	Stock	34.975	34.975	34.975	34.975	400.0
2017-03-02 07:09:00	AAPL	Stock	34.955	34.9575	34.955	34.9575	2000.0
2017-03-02 07:11:00	AAPL	Stock	34.97	34.9975	34.97	34.9975	7408.0
2017-03-02 07:24:00	AAPL	Stock	34.9775	34.9775	34.9775	34.9775	400.0
2017-03-02 07:25:00	AAPL	Stock	34.995	34.995	34.995	34.995	800.0
2017-03-02 07:26:00	AAPL	Stock	34.995	34.995	34.995	34.995	400.0
2017-03-02 07:27:00	AAPL	Stock	34.995	34.995	34.995	34.995	5180.0
2017-03-02 07:28:00	AAPL	Stock	34.995	34.995	34.9825	34.9825	4040.0
2017-03-02 07:29:00	AAPL	Stock	34.995	34.995	34.995	34.995	1200.0
2017-03-02 07:31:00	AAPL	Stock	34.9875	34.9875	34.9875	34.9875	800.0
2017-03-02 07:32:00	AAPL	Stock	34.9825	34.9825	34.9825	34.9825	400.0
2017-03-02 07:35:00	AAPL	Stock	34.9825	34.985	34.9825	34.985	888.0
2017-03-02 07:40:00	AAPL	Stock	34.9925	34.995	34.985	34.995	2828.0
2017-03-02 07:44:00	AAPL	Stock	34.9875	34.9875	34.9825	34.9875	3812.0
2017-03-02 07:47:00	AAPL	Stock	34.9825	34.9825	34.9825	34.9825	400.0
2017-03-02 07:50:00	AAPL	Stock	34.9825	34.9875	34.9825	34.9875	3132.0
2017-03-02 07:51:00	AAPL	Stock	34.9875	34.9875	34.9875	34.9875	548.0
2017-03-02 07:55:00	AAPL	Stock	34.9875	34.9875	34.9875	34.9875	400.0
2017-03-02 07:56:00	AAPL	Stock	34.9775	34.9875	34.9775	34.9875	884.0
2017-03-02 08:00:00	AAPL	Stock	34.9875	34.99	34.95	34.9875	18416.0
2017-03-02 08:01:00	AAPL	Stock	34.9925	35.0	34.9925	35.0	19552.0
2017-03-02 08:02:00	AAPL	Stock	35.0	35.0	35.0	35.0	400.0
2017-03-02 08:03:00	AAPL	Stock	34.9925	35.0	34.9875	35.0	3200.0
2017-03-02 08:04:00	AAPL	Stock	35.0	35.0025	35.0	35.0025	10280.0
2017-03-02 08:05:00	AAPL	Stock	35.0025	35.0025	35.0025	35.0025	1400.0
2017-03-02 08:06:00	AAPL	Stock	35.02	35.02	35.0125	35.0125	2000.0
2017-03-02 08:07:00	AAPL	Stock	35.02	35.02	35.02	35.02	800.0
2017-03-02 08:08:00	AAPL	Stock	35.0075	35.0125	35.0075	35.0125	800.0
2017-03-02 08:09:00	AAPL	Stock	35.0125	35.0125	35.01	35.01	4748.0
2017-03-02 08:10:00	AAPL	Stock	35.005	35.0175	35.005	35.0175	7760.0

> showing 50 of 1,075,247 rows — these rows as CSV

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