PREVIEW / stock_1min / 2017-04-20

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-04-20.parquet
  size:    14.4 MB
  rows:    1,049,912
  symbols: 2,530

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-04-20 04:00:00	AAPL	Stock	35.25	35.25	35.25	35.25	4000.0
2017-04-20 04:16:00	AAPL	Stock	35.3	35.3	35.3	35.3	4700.0
2017-04-20 04:34:00	AAPL	Stock	35.2975	35.2975	35.2975	35.2975	400.0
2017-04-20 04:46:00	AAPL	Stock	35.3	35.3225	35.3	35.3225	3932.0
2017-04-20 04:47:00	AAPL	Stock	35.325	35.325	35.325	35.325	2800.0
2017-04-20 04:54:00	AAPL	Stock	35.325	35.325	35.325	35.325	2468.0
2017-04-20 04:55:00	AAPL	Stock	35.325	35.325	35.325	35.325	836.0
2017-04-20 04:56:00	AAPL	Stock	35.325	35.325	35.325	35.325	400.0
2017-04-20 04:58:00	AAPL	Stock	35.3475	35.35	35.3475	35.35	1188.0
2017-04-20 05:14:00	AAPL	Stock	35.345	35.35	35.345	35.35	1600.0
2017-04-20 05:21:00	AAPL	Stock	35.3475	35.3475	35.3475	35.3475	2000.0
2017-04-20 05:28:00	AAPL	Stock	35.35	35.35	35.35	35.35	2800.0
2017-04-20 05:39:00	AAPL	Stock	35.325	35.325	35.325	35.325	960.0
2017-04-20 05:40:00	AAPL	Stock	35.325	35.325	35.325	35.325	2000.0
2017-04-20 05:50:00	AAPL	Stock	35.3425	35.3425	35.3425	35.3425	400.0
2017-04-20 05:51:00	AAPL	Stock	35.345	35.345	35.345	35.345	508.0
2017-04-20 05:52:00	AAPL	Stock	35.325	35.345	35.325	35.345	2800.0
2017-04-20 06:12:00	AAPL	Stock	35.3425	35.3425	35.3425	35.3425	408.0
2017-04-20 06:36:00	AAPL	Stock	35.3	35.3	35.3	35.3	3752.0
2017-04-20 06:37:00	AAPL	Stock	35.3	35.3	35.3	35.3	4000.0
2017-04-20 07:07:00	AAPL	Stock	35.3125	35.3125	35.3125	35.3125	1200.0
2017-04-20 07:10:00	AAPL	Stock	35.3	35.3	35.3	35.3	672.0
2017-04-20 07:11:00	AAPL	Stock	35.3	35.3	35.3	35.3	1728.0
2017-04-20 07:12:00	AAPL	Stock	35.3	35.3	35.3	35.3	1400.0
2017-04-20 07:13:00	AAPL	Stock	35.2825	35.2825	35.2825	35.2825	872.0
2017-04-20 07:25:00	AAPL	Stock	35.3	35.3025	35.3	35.3025	2804.0
2017-04-20 07:26:00	AAPL	Stock	35.31	35.325	35.31	35.325	8400.0
2017-04-20 07:27:00	AAPL	Stock	35.325	35.325	35.325	35.325	1540.0
2017-04-20 07:28:00	AAPL	Stock	35.305	35.305	35.305	35.305	2000.0
2017-04-20 07:33:00	AAPL	Stock	35.335	35.3375	35.335	35.3375	3000.0
2017-04-20 07:34:00	AAPL	Stock	35.3375	35.345	35.3375	35.345	4000.0
2017-04-20 07:35:00	AAPL	Stock	35.3375	35.3375	35.3375	35.3375	400.0
2017-04-20 07:36:00	AAPL	Stock	35.3225	35.3225	35.3225	35.3225	1600.0
2017-04-20 07:37:00	AAPL	Stock	35.325	35.325	35.325	35.325	3880.0
2017-04-20 07:42:00	AAPL	Stock	35.325	35.325	35.325	35.325	1000.0
2017-04-20 07:46:00	AAPL	Stock	35.325	35.325	35.325	35.325	400.0
2017-04-20 07:47:00	AAPL	Stock	35.325	35.325	35.325	35.325	400.0
2017-04-20 07:58:00	AAPL	Stock	35.325	35.325	35.325	35.325	400.0
2017-04-20 07:59:00	AAPL	Stock	35.325	35.325	35.325	35.325	1600.0
2017-04-20 08:00:00	AAPL	Stock	35.325	35.325	35.3025	35.3025	5888.0
2017-04-20 08:03:00	AAPL	Stock	35.3025	35.3025	35.3025	35.3025	2800.0
2017-04-20 08:04:00	AAPL	Stock	35.3125	35.3125	35.3125	35.3125	4800.0
2017-04-20 08:05:00	AAPL	Stock	35.325	35.325	35.325	35.325	400.0
2017-04-20 08:06:00	AAPL	Stock	35.325	35.325	35.325	35.325	8000.0
2017-04-20 08:09:00	AAPL	Stock	35.325	35.325	35.325	35.325	3244.0
2017-04-20 08:11:00	AAPL	Stock	35.325	35.33	35.325	35.33	2404.0
2017-04-20 08:13:00	AAPL	Stock	35.325	35.325	35.325	35.325	400.0
2017-04-20 08:16:00	AAPL	Stock	35.3125	35.3125	35.3125	35.3125	1600.0
2017-04-20 08:18:00	AAPL	Stock	35.325	35.3325	35.3125	35.3125	4376.0
2017-04-20 08:19:00	AAPL	Stock	35.325	35.325	35.325	35.325	2400.0

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

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