PREVIEW / stock_1min / 2017-02-23

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-02-23.parquet
  size:    14.8 MB
  rows:    1,066,888
  symbols: 2,544

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-23 05:05:00	AAPL	Stock	34.29	34.29	34.29	34.29	3600.0
2017-02-23 05:49:00	AAPL	Stock	34.3175	34.3175	34.3175	34.3175	604.0
2017-02-23 06:03:00	AAPL	Stock	34.29	34.29	34.29	34.29	976.0
2017-02-23 06:07:00	AAPL	Stock	34.3	34.3	34.2925	34.2925	868.0
2017-02-23 06:18:00	AAPL	Stock	34.2875	34.2875	34.2875	34.2875	400.0
2017-02-23 06:29:00	AAPL	Stock	34.2875	34.2875	34.2875	34.2875	400.0
2017-02-23 07:04:00	AAPL	Stock	34.3375	34.3375	34.3375	34.3375	1000.0
2017-02-23 07:27:00	AAPL	Stock	34.335	34.335	34.335	34.335	2020.0
2017-02-23 07:28:00	AAPL	Stock	34.335	34.3375	34.335	34.3375	5580.0
2017-02-23 07:30:00	AAPL	Stock	34.34	34.34	34.34	34.34	800.0
2017-02-23 07:31:00	AAPL	Stock	34.34	34.34	34.34	34.34	400.0
2017-02-23 07:34:00	AAPL	Stock	34.3375	34.3375	34.3375	34.3375	8000.0
2017-02-23 07:41:00	AAPL	Stock	34.3425	34.3425	34.3375	34.3375	5720.0
2017-02-23 07:42:00	AAPL	Stock	34.33	34.33	34.33	34.33	800.0
2017-02-23 07:43:00	AAPL	Stock	34.3375	34.3375	34.3375	34.3375	2800.0
2017-02-23 07:44:00	AAPL	Stock	34.3375	34.3375	34.3375	34.3375	400.0
2017-02-23 07:46:00	AAPL	Stock	34.34	34.34	34.3375	34.3375	1684.0
2017-02-23 07:47:00	AAPL	Stock	34.3325	34.3325	34.3325	34.3325	400.0
2017-02-23 07:48:00	AAPL	Stock	34.33	34.33	34.33	34.33	1180.0
2017-02-23 07:50:00	AAPL	Stock	34.3375	34.3375	34.3375	34.3375	3200.0
2017-02-23 07:53:00	AAPL	Stock	34.3325	34.3325	34.3325	34.3325	400.0
2017-02-23 07:54:00	AAPL	Stock	34.33	34.33	34.33	34.33	400.0
2017-02-23 07:58:00	AAPL	Stock	34.32	34.32	34.32	34.32	400.0
2017-02-23 08:00:00	AAPL	Stock	34.3175	34.33	34.31	34.3175	13096.0
2017-02-23 08:01:00	AAPL	Stock	34.315	34.315	34.3125	34.3125	8800.0
2017-02-23 08:02:00	AAPL	Stock	34.32	34.3225	34.32	34.3225	4400.0
2017-02-23 08:03:00	AAPL	Stock	34.3125	34.3125	34.3125	34.3125	400.0
2017-02-23 08:04:00	AAPL	Stock	34.3225	34.3225	34.3125	34.3125	7600.0
2017-02-23 08:05:00	AAPL	Stock	34.3175	34.3175	34.3175	34.3175	3600.0
2017-02-23 08:14:00	AAPL	Stock	34.3225	34.325	34.3225	34.3225	3996.0
2017-02-23 08:15:00	AAPL	Stock	34.325	34.335	34.3175	34.3275	37376.0
2017-02-23 08:16:00	AAPL	Stock	34.3275	34.3275	34.3275	34.3275	3700.0
2017-02-23 08:19:00	AAPL	Stock	34.325	34.3275	34.325	34.3275	2800.0
2017-02-23 08:21:00	AAPL	Stock	34.325	34.325	34.325	34.325	400.0
2017-02-23 08:24:00	AAPL	Stock	34.325	34.325	34.325	34.325	780.0
2017-02-23 08:27:00	AAPL	Stock	34.3325	34.335	34.3325	34.335	1180.0
2017-02-23 08:29:00	AAPL	Stock	34.3375	34.3375	34.325	34.325	3256.0
2017-02-23 08:30:00	AAPL	Stock	34.3375	34.3375	34.3375	34.3375	400.0
2017-02-23 08:31:00	AAPL	Stock	34.335	34.335	34.335	34.335	1200.0
2017-02-23 08:32:00	AAPL	Stock	34.3375	34.3375	34.335	34.335	2200.0
2017-02-23 08:34:00	AAPL	Stock	34.3375	34.3375	34.3375	34.3375	2000.0
2017-02-23 08:35:00	AAPL	Stock	34.3375	34.3425	34.3325	34.3325	2800.0
2017-02-23 08:37:00	AAPL	Stock	34.34	34.34	34.34	34.34	1776.0
2017-02-23 08:38:00	AAPL	Stock	34.33	34.3425	34.33	34.3425	952.0
2017-02-23 08:41:00	AAPL	Stock	34.3325	34.34	34.325	34.34	5560.0
2017-02-23 08:42:00	AAPL	Stock	34.3275	34.34	34.3	34.34	55376.0
2017-02-23 08:43:00	AAPL	Stock	34.305	34.305	34.305	34.305	460.0
2017-02-23 08:44:00	AAPL	Stock	34.3125	34.3125	34.3125	34.3125	4000.0
2017-02-23 08:46:00	AAPL	Stock	34.32	34.3225	34.32	34.3225	1740.0
2017-02-23 08:48:00	AAPL	Stock	34.3125	34.3125	34.31	34.31	4800.0

> showing 50 of 1,066,888 rows — these rows as CSV

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