PREVIEW / stock_1min / 2017-02-02

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-02-02.parquet
  size:    14.5 MB
  rows:    1,049,090
  symbols: 2,564

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-02-02 04:03:00	AAPL	Stock	32.125	32.125	32.125	32.125	6940.0
2017-02-02 04:10:00	AAPL	Stock	32.1125	32.1125	32.1125	32.1125	1600.0
2017-02-02 04:11:00	AAPL	Stock	32.1325	32.1325	32.1325	32.1325	400.0
2017-02-02 04:29:00	AAPL	Stock	32.0525	32.0525	32.0525	32.0525	2360.0
2017-02-02 04:30:00	AAPL	Stock	32.0525	32.0525	32.0525	32.0525	800.0
2017-02-02 04:31:00	AAPL	Stock	32.035	32.035	32.03	32.03	1036.0
2017-02-02 04:50:00	AAPL	Stock	32.0375	32.0375	32.0375	32.0375	800.0
2017-02-02 04:59:00	AAPL	Stock	32.075	32.075	32.075	32.075	752.0
2017-02-02 05:02:00	AAPL	Stock	32.03	32.03	32.03	32.03	3456.0
2017-02-02 05:03:00	AAPL	Stock	32.0175	32.025	32.0175	32.025	2000.0
2017-02-02 05:05:00	AAPL	Stock	32.025	32.025	32.025	32.025	2000.0
2017-02-02 05:29:00	AAPL	Stock	32.05	32.05	32.05	32.05	888.0
2017-02-02 05:30:00	AAPL	Stock	32.05	32.05	32.05	32.05	12000.0
2017-02-02 05:32:00	AAPL	Stock	32.06	32.06	32.06	32.06	1200.0
2017-02-02 05:38:00	AAPL	Stock	32.075	32.0775	32.075	32.0775	4012.0
2017-02-02 05:42:00	AAPL	Stock	32.065	32.065	32.065	32.065	656.0
2017-02-02 05:45:00	AAPL	Stock	32.0775	32.0775	32.0775	32.0775	656.0
2017-02-02 05:48:00	AAPL	Stock	32.095	32.095	32.095	32.095	1200.0
2017-02-02 05:51:00	AAPL	Stock	32.095	32.095	32.095	32.095	2000.0
2017-02-02 06:02:00	AAPL	Stock	32.1225	32.1225	32.1225	32.1225	1348.0
2017-02-02 06:05:00	AAPL	Stock	32.1	32.1	32.1	32.1	780.0
2017-02-02 06:07:00	AAPL	Stock	32.12	32.1225	32.12	32.1225	3800.0
2017-02-02 06:11:00	AAPL	Stock	32.1	32.1	32.1	32.1	400.0
2017-02-02 06:13:00	AAPL	Stock	32.1	32.1	32.1	32.1	636.0
2017-02-02 06:15:00	AAPL	Stock	32.1	32.1	32.1	32.1	1200.0
2017-02-02 06:17:00	AAPL	Stock	32.1025	32.1025	32.1025	32.1025	2400.0
2017-02-02 06:19:00	AAPL	Stock	32.1	32.125	32.1	32.125	4000.0
2017-02-02 06:24:00	AAPL	Stock	32.125	32.125	32.125	32.125	5200.0
2017-02-02 06:25:00	AAPL	Stock	32.125	32.125	32.125	32.125	10612.0
2017-02-02 06:28:00	AAPL	Stock	32.11	32.11	32.11	32.11	644.0
2017-02-02 06:32:00	AAPL	Stock	32.085	32.1	32.085	32.1	3744.0
2017-02-02 06:33:00	AAPL	Stock	32.085	32.085	32.075	32.075	2408.0
2017-02-02 06:34:00	AAPL	Stock	32.075	32.075	32.0525	32.0525	2512.0
2017-02-02 06:42:00	AAPL	Stock	32.0975	32.0975	32.0975	32.0975	2400.0
2017-02-02 06:49:00	AAPL	Stock	32.075	32.075	32.075	32.075	916.0
2017-02-02 06:50:00	AAPL	Stock	32.075	32.075	32.075	32.075	480.0
2017-02-02 06:54:00	AAPL	Stock	32.095	32.095	32.095	32.095	1200.0
2017-02-02 07:00:00	AAPL	Stock	32.095	32.12	32.095	32.12	4400.0
2017-02-02 07:01:00	AAPL	Stock	32.1125	32.12	32.1125	32.1125	1776.0
2017-02-02 07:03:00	AAPL	Stock	32.0925	32.0925	32.0925	32.0925	1200.0
2017-02-02 07:04:00	AAPL	Stock	32.075	32.075	32.075	32.075	512.0
2017-02-02 07:09:00	AAPL	Stock	32.075	32.075	32.075	32.075	2776.0
2017-02-02 07:13:00	AAPL	Stock	32.0925	32.0925	32.0925	32.0925	800.0
2017-02-02 07:14:00	AAPL	Stock	32.075	32.0875	32.075	32.0875	5420.0
2017-02-02 07:15:00	AAPL	Stock	32.1175	32.12	32.1175	32.12	12764.0
2017-02-02 07:17:00	AAPL	Stock	32.1	32.1	32.1	32.1	400.0
2017-02-02 07:18:00	AAPL	Stock	32.07	32.07	32.07	32.07	648.0
2017-02-02 07:19:00	AAPL	Stock	32.075	32.075	32.075	32.075	400.0
2017-02-02 07:20:00	AAPL	Stock	32.075	32.075	32.075	32.075	400.0
2017-02-02 07:22:00	AAPL	Stock	32.095	32.095	32.095	32.095	400.0

> showing 50 of 1,049,090 rows — these rows as CSV

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