PREVIEW / stock_1min / 2017-09-25

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-09-25.parquet
  size:    14.5 MB
  rows:    1,046,612
  symbols: 2,460

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-09-25 04:00:00	AAPL	Stock	37.7475	37.7475	37.7475	37.7475	800.0
2017-09-25 04:07:00	AAPL	Stock	37.7025	37.7025	37.7025	37.7025	400.0
2017-09-25 04:21:00	AAPL	Stock	37.76	37.76	37.76	37.76	1600.0
2017-09-25 04:27:00	AAPL	Stock	37.785	37.785	37.785	37.785	600.0
2017-09-25 04:35:00	AAPL	Stock	37.75	37.75	37.75	37.75	400.0
2017-09-25 05:16:00	AAPL	Stock	37.8	37.8	37.8	37.8	400.0
2017-09-25 05:49:00	AAPL	Stock	37.7625	37.7625	37.75	37.75	3620.0
2017-09-25 05:50:00	AAPL	Stock	37.725	37.75	37.725	37.7325	2000.0
2017-09-25 05:59:00	AAPL	Stock	37.75	37.75	37.75	37.75	516.0
2017-09-25 06:02:00	AAPL	Stock	37.725	37.725	37.65	37.65	4752.0
2017-09-25 06:03:00	AAPL	Stock	37.6425	37.6425	37.4125	37.5	19920.0
2017-09-25 06:04:00	AAPL	Stock	37.5175	37.5175	37.5125	37.5125	1680.0
2017-09-25 06:05:00	AAPL	Stock	37.6225	37.6675	37.6225	37.6675	19556.0
2017-09-25 06:06:00	AAPL	Stock	37.5925	37.5925	37.5875	37.5875	3600.0
2017-09-25 06:14:00	AAPL	Stock	37.625	37.625	37.6225	37.6225	1600.0
2017-09-25 06:18:00	AAPL	Stock	37.625	37.625	37.625	37.625	400.0
2017-09-25 06:19:00	AAPL	Stock	37.6375	37.6375	37.625	37.625	8000.0
2017-09-25 06:20:00	AAPL	Stock	37.6275	37.64	37.6275	37.64	1708.0
2017-09-25 06:21:00	AAPL	Stock	37.625	37.625	37.625	37.625	1600.0
2017-09-25 06:22:00	AAPL	Stock	37.625	37.625	37.625	37.625	4592.0
2017-09-25 06:24:00	AAPL	Stock	37.675	37.675	37.575	37.575	9528.0
2017-09-25 06:30:00	AAPL	Stock	37.6	37.6	37.6	37.6	400.0
2017-09-25 06:31:00	AAPL	Stock	37.575	37.575	37.575	37.575	800.0
2017-09-25 06:33:00	AAPL	Stock	37.5875	37.5875	37.5875	37.5875	1940.0
2017-09-25 06:39:00	AAPL	Stock	37.65	37.65	37.65	37.65	3200.0
2017-09-25 06:40:00	AAPL	Stock	37.65	37.65	37.65	37.65	1200.0
2017-09-25 06:41:00	AAPL	Stock	37.65	37.65	37.65	37.65	800.0
2017-09-25 06:42:00	AAPL	Stock	37.65	37.65	37.65	37.65	1200.0
2017-09-25 06:44:00	AAPL	Stock	37.65	37.65	37.65	37.65	3200.0
2017-09-25 06:56:00	AAPL	Stock	37.6425	37.6425	37.6425	37.6425	400.0
2017-09-25 06:57:00	AAPL	Stock	37.6625	37.6625	37.6525	37.6525	1204.0
2017-09-25 07:00:00	AAPL	Stock	37.6725	37.7575	37.67	37.715	25192.0
2017-09-25 07:01:00	AAPL	Stock	37.725	37.725	37.725	37.725	400.0
2017-09-25 07:02:00	AAPL	Stock	37.735	37.7375	37.7125	37.7125	1200.0
2017-09-25 07:04:00	AAPL	Stock	37.7	37.7	37.7	37.7	1600.0
2017-09-25 07:05:00	AAPL	Stock	37.695	37.695	37.695	37.695	468.0
2017-09-25 07:06:00	AAPL	Stock	37.725	37.725	37.725	37.725	1540.0
2017-09-25 07:07:00	AAPL	Stock	37.735	37.7575	37.735	37.75	13656.0
2017-09-25 07:08:00	AAPL	Stock	37.755	37.7775	37.755	37.7775	3956.0
2017-09-25 07:09:00	AAPL	Stock	37.78	37.78	37.7775	37.7775	1180.0
2017-09-25 07:12:00	AAPL	Stock	37.775	37.775	37.75	37.75	3600.0
2017-09-25 07:13:00	AAPL	Stock	37.7375	37.75	37.7375	37.75	1600.0
2017-09-25 07:14:00	AAPL	Stock	37.75	37.75	37.7375	37.7375	14400.0
2017-09-25 07:15:00	AAPL	Stock	37.7475	37.75	37.7475	37.75	5400.0
2017-09-25 07:16:00	AAPL	Stock	37.705	37.7475	37.705	37.7475	1200.0
2017-09-25 07:17:00	AAPL	Stock	37.725	37.725	37.725	37.725	3800.0
2017-09-25 07:18:00	AAPL	Stock	37.725	37.725	37.725	37.725	400.0
2017-09-25 07:21:00	AAPL	Stock	37.745	37.745	37.745	37.745	2000.0
2017-09-25 07:24:00	AAPL	Stock	37.725	37.725	37.7175	37.725	6240.0
2017-09-25 07:26:00	AAPL	Stock	37.6925	37.6925	37.6875	37.6925	9448.0

> showing 50 of 1,046,612 rows — these rows as CSV

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