PREVIEW / stock_1min / 2017-08-31

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-08-31.parquet
  size:    14.4 MB
  rows:    1,042,414
  symbols: 2,485

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-08-31 04:00:00	AAPL	Stock	40.875	40.875	40.875	40.875	1152.0
2017-08-31 04:06:00	AAPL	Stock	40.815	40.815	40.815	40.815	400.0
2017-08-31 04:07:00	AAPL	Stock	40.8125	40.8125	40.8125	40.8125	400.0
2017-08-31 04:13:00	AAPL	Stock	40.875	40.875	40.875	40.875	4400.0
2017-08-31 04:14:00	AAPL	Stock	40.825	40.825	40.825	40.825	400.0
2017-08-31 04:16:00	AAPL	Stock	40.875	40.875	40.875	40.875	1200.0
2017-08-31 04:17:00	AAPL	Stock	40.875	40.875	40.875	40.875	512.0
2017-08-31 04:22:00	AAPL	Stock	40.875	40.875	40.875	40.875	512.0
2017-08-31 04:31:00	AAPL	Stock	40.875	40.875	40.875	40.875	992.0
2017-08-31 04:52:00	AAPL	Stock	40.9125	40.92	40.9125	40.92	3600.0
2017-08-31 05:01:00	AAPL	Stock	40.9275	40.9275	40.9275	40.9275	2600.0
2017-08-31 05:13:00	AAPL	Stock	40.925	40.925	40.925	40.925	800.0
2017-08-31 05:18:00	AAPL	Stock	40.9375	40.94	40.9375	40.94	1860.0
2017-08-31 05:19:00	AAPL	Stock	40.9375	40.9375	40.9375	40.9375	5860.0
2017-08-31 05:47:00	AAPL	Stock	40.9375	40.9375	40.925	40.925	980.0
2017-08-31 05:58:00	AAPL	Stock	40.975	40.975	40.975	40.975	800.0
2017-08-31 06:02:00	AAPL	Stock	40.95	40.95	40.95	40.95	5684.0
2017-08-31 06:05:00	AAPL	Stock	40.9375	40.9375	40.9375	40.9375	560.0
2017-08-31 06:06:00	AAPL	Stock	40.9375	40.9375	40.9375	40.9375	2800.0
2017-08-31 06:12:00	AAPL	Stock	40.9375	40.9375	40.9375	40.9375	800.0
2017-08-31 06:23:00	AAPL	Stock	40.9375	40.9375	40.9375	40.9375	4000.0
2017-08-31 06:36:00	AAPL	Stock	40.9125	40.9125	40.9125	40.9125	2804.0
2017-08-31 06:37:00	AAPL	Stock	40.9125	40.9125	40.9125	40.9125	400.0
2017-08-31 06:39:00	AAPL	Stock	40.9125	40.9125	40.9125	40.9125	1776.0
2017-08-31 06:42:00	AAPL	Stock	40.9	40.9	40.9	40.9	2000.0
2017-08-31 06:47:00	AAPL	Stock	40.9	40.9	40.9	40.9	2000.0
2017-08-31 06:50:00	AAPL	Stock	40.9	40.9	40.9	40.9	4000.0
2017-08-31 06:56:00	AAPL	Stock	40.9	40.9	40.9	40.9	5520.0
2017-08-31 06:57:00	AAPL	Stock	40.9	40.9	40.9	40.9	1280.0
2017-08-31 06:58:00	AAPL	Stock	40.9	40.9	40.9	40.9	800.0
2017-08-31 06:59:00	AAPL	Stock	40.9	40.9	40.9	40.9	800.0
2017-08-31 07:01:00	AAPL	Stock	40.9	40.9	40.9	40.9	3200.0
2017-08-31 07:02:00	AAPL	Stock	40.9025	40.9025	40.9	40.9	2492.0
2017-08-31 07:03:00	AAPL	Stock	40.9	40.9	40.9	40.9	9408.0
2017-08-31 07:10:00	AAPL	Stock	40.9175	40.9175	40.9175	40.9175	1748.0
2017-08-31 07:11:00	AAPL	Stock	40.9125	40.9175	40.9125	40.9175	2400.0
2017-08-31 07:12:00	AAPL	Stock	40.9175	40.9175	40.9175	40.9175	600.0
2017-08-31 07:15:00	AAPL	Stock	40.915	40.915	40.915	40.915	3124.0
2017-08-31 07:16:00	AAPL	Stock	40.915	40.9175	40.915	40.9175	2400.0
2017-08-31 07:17:00	AAPL	Stock	40.915	40.915	40.915	40.915	400.0
2017-08-31 07:18:00	AAPL	Stock	40.915	40.915	40.9125	40.9125	800.0
2017-08-31 07:19:00	AAPL	Stock	40.915	40.915	40.915	40.915	1600.0
2017-08-31 07:21:00	AAPL	Stock	40.91	40.91	40.9	40.9	6400.0
2017-08-31 07:22:00	AAPL	Stock	40.895	40.895	40.895	40.895	1244.0
2017-08-31 07:23:00	AAPL	Stock	40.895	40.895	40.895	40.895	400.0
2017-08-31 07:30:00	AAPL	Stock	40.905	40.91	40.9	40.91	10036.0
2017-08-31 07:32:00	AAPL	Stock	40.9	40.9	40.9	40.9	8800.0
2017-08-31 07:33:00	AAPL	Stock	40.895	40.895	40.895	40.895	3600.0
2017-08-31 07:36:00	AAPL	Stock	40.9	40.9	40.9	40.9	800.0
2017-08-31 07:37:00	AAPL	Stock	40.89	40.8975	40.8875	40.895	5348.0

> showing 50 of 1,042,414 rows — these rows as CSV

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