PREVIEW / stock_1min / 2017-01-23

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-01-23.parquet
  size:    14.1 MB
  rows:    1,020,903
  symbols: 2,573

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-01-23 04:05:00	AAPL	Stock	29.875	29.875	29.875	29.875	4400.0
2017-01-23 04:20:00	AAPL	Stock	29.925	29.925	29.925	29.925	2204.0
2017-01-23 04:26:00	AAPL	Stock	29.91	29.925	29.91	29.925	1816.0
2017-01-23 04:33:00	AAPL	Stock	29.95	29.95	29.95	29.95	400.0
2017-01-23 06:05:00	AAPL	Stock	29.955	29.955	29.955	29.955	400.0
2017-01-23 06:22:00	AAPL	Stock	29.95	29.95	29.95	29.95	4000.0
2017-01-23 06:29:00	AAPL	Stock	29.9425	29.9425	29.9425	29.9425	756.0
2017-01-23 06:36:00	AAPL	Stock	29.95	29.95	29.95	29.95	492.0
2017-01-23 06:42:00	AAPL	Stock	29.95	29.95	29.95	29.95	400.0
2017-01-23 06:47:00	AAPL	Stock	29.95	29.95	29.9425	29.9425	1768.0
2017-01-23 07:03:00	AAPL	Stock	29.9425	29.9425	29.9425	29.9425	2000.0
2017-01-23 07:07:00	AAPL	Stock	29.9475	29.9475	29.93	29.93	12400.0
2017-01-23 07:11:00	AAPL	Stock	29.9375	29.95	29.9375	29.95	3552.0
2017-01-23 07:12:00	AAPL	Stock	29.95	29.95	29.95	29.95	400.0
2017-01-23 07:13:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	3556.0
2017-01-23 07:14:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	1200.0
2017-01-23 07:15:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	800.0
2017-01-23 07:16:00	AAPL	Stock	29.95	29.95	29.95	29.95	3600.0
2017-01-23 07:24:00	AAPL	Stock	29.9625	29.9625	29.94	29.94	2400.0
2017-01-23 07:26:00	AAPL	Stock	29.9425	29.9425	29.9425	29.9425	1948.0
2017-01-23 07:28:00	AAPL	Stock	29.94	29.94	29.94	29.94	1948.0
2017-01-23 07:29:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	1652.0
2017-01-23 07:30:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	2000.0
2017-01-23 07:32:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	1748.0
2017-01-23 07:33:00	AAPL	Stock	29.94	29.94	29.9325	29.9325	3400.0
2017-01-23 07:34:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	400.0
2017-01-23 07:36:00	AAPL	Stock	29.9325	29.9325	29.9325	29.9325	1044.0
2017-01-23 07:39:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	400.0
2017-01-23 07:40:00	AAPL	Stock	29.9325	29.9325	29.9325	29.9325	2880.0
2017-01-23 07:41:00	AAPL	Stock	29.9325	29.9325	29.93	29.93	7204.0
2017-01-23 07:42:00	AAPL	Stock	29.93	29.93	29.93	29.93	476.0
2017-01-23 07:43:00	AAPL	Stock	29.925	29.925	29.925	29.925	7200.0
2017-01-23 07:45:00	AAPL	Stock	29.9175	29.9175	29.915	29.915	2800.0
2017-01-23 07:47:00	AAPL	Stock	29.9	29.9	29.9	29.9	2000.0
2017-01-23 07:49:00	AAPL	Stock	29.925	29.925	29.925	29.925	7920.0
2017-01-23 07:50:00	AAPL	Stock	29.925	29.925	29.925	29.925	1200.0
2017-01-23 07:53:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	2000.0
2017-01-23 08:00:00	AAPL	Stock	29.9475	29.9625	29.925	29.9375	40944.0
2017-01-23 08:02:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	5200.0
2017-01-23 08:03:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	832.0
2017-01-23 08:04:00	AAPL	Stock	29.9475	29.9475	29.9475	29.9475	800.0
2017-01-23 08:08:00	AAPL	Stock	29.95	29.95	29.95	29.95	1200.0
2017-01-23 08:09:00	AAPL	Stock	29.95	29.955	29.95	29.955	9256.0
2017-01-23 08:10:00	AAPL	Stock	29.9475	29.9475	29.9475	29.9475	1048.0
2017-01-23 08:13:00	AAPL	Stock	29.945	29.9475	29.945	29.945	22728.0
2017-01-23 08:14:00	AAPL	Stock	29.94	29.94	29.94	29.94	2800.0
2017-01-23 08:16:00	AAPL	Stock	29.94	29.94	29.9125	29.9125	27136.0
2017-01-23 08:17:00	AAPL	Stock	29.925	29.925	29.92	29.92	2400.0
2017-01-23 08:18:00	AAPL	Stock	29.925	29.925	29.92	29.925	34652.0
2017-01-23 08:21:00	AAPL	Stock	29.9375	29.9375	29.9375	29.9375	400.0

> showing 50 of 1,020,903 rows — these rows as CSV

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