PREVIEW / stock_1min / 2017-07-19

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-07-19.parquet
  size:    14.1 MB
  rows:    1,018,918
  symbols: 2,479

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-07-19 04:24:00	AAPL	Stock	37.5875	37.5875	37.575	37.575	4400.0
2017-07-19 04:42:00	AAPL	Stock	37.6125	37.6125	37.6125	37.6125	400.0
2017-07-19 05:23:00	AAPL	Stock	37.565	37.565	37.525	37.525	1884.0
2017-07-19 05:27:00	AAPL	Stock	37.525	37.525	37.525	37.525	2668.0
2017-07-19 05:47:00	AAPL	Stock	37.5925	37.5925	37.5925	37.5925	400.0
2017-07-19 06:44:00	AAPL	Stock	37.585	37.5875	37.585	37.5875	3008.0
2017-07-19 06:54:00	AAPL	Stock	37.5875	37.5875	37.5875	37.5875	800.0
2017-07-19 07:07:00	AAPL	Stock	37.5875	37.5875	37.5875	37.5875	400.0
2017-07-19 07:08:00	AAPL	Stock	37.59	37.59	37.59	37.59	800.0
2017-07-19 07:09:00	AAPL	Stock	37.6075	37.6125	37.6075	37.6125	1200.0
2017-07-19 07:10:00	AAPL	Stock	37.6125	37.6125	37.6125	37.6125	5420.0
2017-07-19 07:16:00	AAPL	Stock	37.6075	37.6075	37.5925	37.5925	800.0
2017-07-19 07:25:00	AAPL	Stock	37.6175	37.6175	37.6125	37.6125	4400.0
2017-07-19 07:27:00	AAPL	Stock	37.6125	37.6125	37.6125	37.6125	400.0
2017-07-19 07:37:00	AAPL	Stock	37.6125	37.6125	37.6125	37.6125	2400.0
2017-07-19 07:38:00	AAPL	Stock	37.6125	37.6125	37.6125	37.6125	5524.0
2017-07-19 07:40:00	AAPL	Stock	37.6	37.6	37.6	37.6	936.0
2017-07-19 07:41:00	AAPL	Stock	37.6	37.6	37.6	37.6	2800.0
2017-07-19 07:46:00	AAPL	Stock	37.5875	37.5875	37.5675	37.5675	6248.0
2017-07-19 07:52:00	AAPL	Stock	37.5625	37.5625	37.5625	37.5625	400.0
2017-07-19 07:54:00	AAPL	Stock	37.5625	37.5625	37.5625	37.5625	400.0
2017-07-19 07:57:00	AAPL	Stock	37.575	37.575	37.575	37.575	800.0
2017-07-19 07:58:00	AAPL	Stock	37.5675	37.5675	37.565	37.565	29008.0
2017-07-19 08:00:00	AAPL	Stock	37.6125	37.6125	37.5625	37.565	10848.0
2017-07-19 08:02:00	AAPL	Stock	37.5775	37.5775	37.5775	37.5775	600.0
2017-07-19 08:04:00	AAPL	Stock	37.5775	37.5775	37.4375	37.565	9304.0
2017-07-19 08:05:00	AAPL	Stock	37.5775	37.5775	37.5775	37.5775	400.0
2017-07-19 08:06:00	AAPL	Stock	37.5875	37.5875	37.5875	37.5875	800.0
2017-07-19 08:07:00	AAPL	Stock	37.585	37.585	37.585	37.585	800.0
2017-07-19 08:08:00	AAPL	Stock	37.5875	37.5875	37.5875	37.5875	8560.0
2017-07-19 08:09:00	AAPL	Stock	37.5875	37.5875	37.5875	37.5875	18632.0
2017-07-19 08:15:00	AAPL	Stock	37.585	37.585	37.575	37.575	10000.0
2017-07-19 08:17:00	AAPL	Stock	37.585	37.5925	37.585	37.5925	4344.0
2017-07-19 08:19:00	AAPL	Stock	37.575	37.575	37.575	37.575	640.0
2017-07-19 08:21:00	AAPL	Stock	37.605	37.605	37.605	37.605	480.0
2017-07-19 08:22:00	AAPL	Stock	37.6075	37.6075	37.6075	37.6075	400.0
2017-07-19 08:23:00	AAPL	Stock	37.6075	37.6075	37.6075	37.6075	400.0
2017-07-19 08:24:00	AAPL	Stock	37.6125	37.6125	37.6125	37.6125	1200.0
2017-07-19 08:25:00	AAPL	Stock	37.6125	37.6125	37.6075	37.6075	1900.0
2017-07-19 08:26:00	AAPL	Stock	37.6025	37.6025	37.6025	37.6025	1200.0
2017-07-19 08:27:00	AAPL	Stock	37.6025	37.6025	37.6025	37.6025	2000.0
2017-07-19 08:29:00	AAPL	Stock	37.615	37.615	37.5875	37.615	5200.0
2017-07-19 08:31:00	AAPL	Stock	37.61	37.61	37.61	37.61	600.0
2017-07-19 08:32:00	AAPL	Stock	37.61	37.61	37.61	37.61	3000.0
2017-07-19 08:37:00	AAPL	Stock	37.59	37.59	37.59	37.59	400.0
2017-07-19 08:38:00	AAPL	Stock	37.6	37.6	37.6	37.6	2000.0
2017-07-19 08:39:00	AAPL	Stock	37.6	37.6	37.6	37.6	816.0
2017-07-19 08:41:00	AAPL	Stock	37.6025	37.6025	37.6025	37.6025	1016.0
2017-07-19 08:44:00	AAPL	Stock	37.5875	37.5875	37.5875	37.5875	400.0
2017-07-19 08:45:00	AAPL	Stock	37.5825	37.5825	37.5825	37.5825	764.0

> showing 50 of 1,018,918 rows — these rows as CSV

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