PREVIEW / stock_1min / 2017-01-19

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-01-19.parquet
  size:    14.2 MB
  rows:    1,038,367
  symbols: 2,575

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-01-19 05:47:00	AAPL	Stock	29.9775	29.9775	29.9775	29.9775	596.0
2017-01-19 05:53:00	AAPL	Stock	29.9625	29.9625	29.9625	29.9625	3672.0
2017-01-19 05:58:00	AAPL	Stock	29.965	29.965	29.965	29.965	3860.0
2017-01-19 05:59:00	AAPL	Stock	29.9625	29.9625	29.9625	29.9625	2020.0
2017-01-19 06:02:00	AAPL	Stock	30.0	30.02	30.0	30.02	4948.0
2017-01-19 06:07:00	AAPL	Stock	30.0175	30.0175	30.0175	30.0175	400.0
2017-01-19 06:08:00	AAPL	Stock	30.0175	30.0175	30.0175	30.0175	5800.0
2017-01-19 06:09:00	AAPL	Stock	30.03	30.05	30.03	30.05	14624.0
2017-01-19 06:14:00	AAPL	Stock	30.0625	30.0625	30.0625	30.0625	2720.0
2017-01-19 06:19:00	AAPL	Stock	30.0625	30.0625	30.0625	30.0625	400.0
2017-01-19 06:26:00	AAPL	Stock	30.06	30.0625	30.06	30.0625	1444.0
2017-01-19 06:31:00	AAPL	Stock	30.0425	30.0425	30.0425	30.0425	400.0
2017-01-19 06:33:00	AAPL	Stock	30.0625	30.0625	30.0425	30.0425	6352.0
2017-01-19 06:36:00	AAPL	Stock	30.0075	30.0075	29.9925	29.9925	824.0
2017-01-19 06:37:00	AAPL	Stock	29.9925	30.0	29.9925	30.0	8172.0
2017-01-19 06:39:00	AAPL	Stock	30.0	30.0125	30.0	30.0125	20244.0
2017-01-19 06:40:00	AAPL	Stock	29.9925	29.9925	29.9925	29.9925	9600.0
2017-01-19 06:41:00	AAPL	Stock	29.9925	30.0	29.9925	30.0	11600.0
2017-01-19 06:46:00	AAPL	Stock	30.0125	30.0125	30.0125	30.0125	400.0
2017-01-19 06:53:00	AAPL	Stock	30.0125	30.0125	30.0125	30.0125	400.0
2017-01-19 07:03:00	AAPL	Stock	30.0125	30.0125	30.0075	30.0075	1872.0
2017-01-19 07:05:00	AAPL	Stock	29.9975	29.9975	29.9825	29.985	8000.0
2017-01-19 07:08:00	AAPL	Stock	29.9825	29.9825	29.9575	29.98	18672.0
2017-01-19 07:09:00	AAPL	Stock	29.98	29.98	29.9275	29.9275	6524.0
2017-01-19 07:12:00	AAPL	Stock	29.945	29.945	29.9325	29.9325	6152.0
2017-01-19 07:13:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	400.0
2017-01-19 07:17:00	AAPL	Stock	29.965	29.965	29.965	29.965	400.0
2017-01-19 07:20:00	AAPL	Stock	29.95	29.9725	29.95	29.9725	1160.0
2017-01-19 07:21:00	AAPL	Stock	29.95	29.95	29.95	29.95	1000.0
2017-01-19 07:22:00	AAPL	Stock	29.95	29.95	29.95	29.95	1428.0
2017-01-19 07:24:00	AAPL	Stock	29.9525	29.9525	29.95	29.95	2400.0
2017-01-19 07:26:00	AAPL	Stock	29.95	29.95	29.94	29.94	2000.0
2017-01-19 07:27:00	AAPL	Stock	29.95	29.95	29.95	29.95	23072.0
2017-01-19 07:28:00	AAPL	Stock	29.95	29.95	29.95	29.95	3320.0
2017-01-19 07:31:00	AAPL	Stock	29.95	29.95	29.95	29.95	4000.0
2017-01-19 07:33:00	AAPL	Stock	29.9675	29.9675	29.9675	29.9675	2400.0
2017-01-19 07:42:00	AAPL	Stock	29.945	29.945	29.94	29.94	1888.0
2017-01-19 07:43:00	AAPL	Stock	29.9625	29.9625	29.9625	29.9625	2000.0
2017-01-19 07:45:00	AAPL	Stock	29.95	29.95	29.95	29.95	10200.0
2017-01-19 07:47:00	AAPL	Stock	29.9675	29.9675	29.9675	29.9675	1684.0
2017-01-19 07:48:00	AAPL	Stock	29.95	29.95	29.95	29.95	1684.0
2017-01-19 07:49:00	AAPL	Stock	29.9425	29.9425	29.94	29.94	1628.0
2017-01-19 07:50:00	AAPL	Stock	29.94	29.94	29.9375	29.9375	2136.0
2017-01-19 07:53:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	4196.0
2017-01-19 07:55:00	AAPL	Stock	29.9325	29.9325	29.9325	29.9325	2000.0
2017-01-19 07:56:00	AAPL	Stock	29.9325	29.9325	29.9325	29.9325	2000.0
2017-01-19 07:58:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	400.0
2017-01-19 08:00:00	AAPL	Stock	29.98	29.98	29.925	29.925	31200.0
2017-01-19 08:01:00	AAPL	Stock	29.925	29.925	29.925	29.925	400.0
2017-01-19 08:02:00	AAPL	Stock	29.9225	29.925	29.9225	29.925	5200.0

> showing 50 of 1,038,367 rows — these rows as CSV

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