PREVIEW / stock_1min / 2017-10-31

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-10-31.parquet
  size:    15.1 MB
  rows:    1,078,143
  symbols: 2,446

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-10-31 04:00:00	AAPL	Stock	41.75	41.75	41.75	41.75	1276.0
2017-10-31 04:11:00	AAPL	Stock	41.76	41.76	41.75	41.75	1480.0
2017-10-31 04:21:00	AAPL	Stock	41.77	41.77	41.77	41.77	516.0
2017-10-31 05:26:00	AAPL	Stock	41.8125	41.8125	41.8125	41.8125	1984.0
2017-10-31 05:52:00	AAPL	Stock	41.8625	41.8625	41.8625	41.8625	400.0
2017-10-31 05:59:00	AAPL	Stock	41.8625	41.8625	41.8625	41.8625	1200.0
2017-10-31 06:02:00	AAPL	Stock	41.87	41.87	41.8625	41.8625	800.0
2017-10-31 06:04:00	AAPL	Stock	41.87	41.87	41.87	41.87	960.0
2017-10-31 06:05:00	AAPL	Stock	41.85	41.85	41.85	41.85	400.0
2017-10-31 06:06:00	AAPL	Stock	41.845	41.845	41.845	41.845	400.0
2017-10-31 06:12:00	AAPL	Stock	41.875	41.875	41.875	41.875	1188.0
2017-10-31 06:15:00	AAPL	Stock	41.875	41.875	41.8525	41.8525	800.0
2017-10-31 06:26:00	AAPL	Stock	41.925	41.925	41.925	41.925	2400.0
2017-10-31 06:27:00	AAPL	Stock	41.9	41.9	41.9	41.9	1200.0
2017-10-31 06:33:00	AAPL	Stock	41.885	41.885	41.885	41.885	400.0
2017-10-31 06:35:00	AAPL	Stock	41.9	41.92	41.9	41.92	4000.0
2017-10-31 06:40:00	AAPL	Stock	41.875	41.875	41.85	41.85	3196.0
2017-10-31 06:52:00	AAPL	Stock	41.825	41.825	41.825	41.825	540.0
2017-10-31 06:54:00	AAPL	Stock	41.8275	41.8275	41.8	41.8	5200.0
2017-10-31 06:55:00	AAPL	Stock	41.775	41.775	41.775	41.775	3832.0
2017-10-31 06:58:00	AAPL	Stock	41.7775	41.7775	41.7775	41.7775	400.0
2017-10-31 07:00:00	AAPL	Stock	41.775	41.8675	41.775	41.8	25884.0
2017-10-31 07:01:00	AAPL	Stock	41.825	41.85	41.825	41.85	7208.0
2017-10-31 07:03:00	AAPL	Stock	41.8125	41.815	41.8125	41.815	3200.0
2017-10-31 07:04:00	AAPL	Stock	41.815	41.8425	41.815	41.8375	2492.0
2017-10-31 07:05:00	AAPL	Stock	41.8375	41.8375	41.8375	41.8375	400.0
2017-10-31 07:07:00	AAPL	Stock	41.8375	41.85	41.8375	41.85	7920.0
2017-10-31 07:08:00	AAPL	Stock	41.8675	41.8675	41.8675	41.8675	400.0
2017-10-31 07:11:00	AAPL	Stock	41.85	41.85	41.825	41.825	14120.0
2017-10-31 07:12:00	AAPL	Stock	41.8175	41.84	41.8175	41.825	6800.0
2017-10-31 07:13:00	AAPL	Stock	41.7875	41.7875	41.7875	41.7875	2800.0
2017-10-31 07:14:00	AAPL	Stock	41.825	41.825	41.825	41.825	3600.0
2017-10-31 07:16:00	AAPL	Stock	41.805	41.8325	41.805	41.8325	1480.0
2017-10-31 07:18:00	AAPL	Stock	41.8375	41.8475	41.8375	41.8475	1400.0
2017-10-31 07:19:00	AAPL	Stock	41.85	41.85	41.85	41.85	18120.0
2017-10-31 07:20:00	AAPL	Stock	41.85	41.85	41.85	41.85	3200.0
2017-10-31 07:23:00	AAPL	Stock	41.85	41.85	41.85	41.85	460.0
2017-10-31 07:24:00	AAPL	Stock	41.85	41.85	41.8325	41.835	20000.0
2017-10-31 07:27:00	AAPL	Stock	41.8375	41.8375	41.825	41.825	4400.0
2017-10-31 07:28:00	AAPL	Stock	41.835	41.8375	41.835	41.8375	24376.0
2017-10-31 07:31:00	AAPL	Stock	41.8625	41.8625	41.8625	41.8625	400.0
2017-10-31 07:32:00	AAPL	Stock	41.845	41.845	41.845	41.845	3760.0
2017-10-31 07:33:00	AAPL	Stock	41.8425	41.87	41.8425	41.87	2400.0
2017-10-31 07:35:00	AAPL	Stock	41.87	41.875	41.87	41.875	4400.0
2017-10-31 07:37:00	AAPL	Stock	41.885	41.885	41.885	41.885	800.0
2017-10-31 07:38:00	AAPL	Stock	41.875	41.875	41.865	41.875	21472.0
2017-10-31 07:39:00	AAPL	Stock	41.88	41.88	41.88	41.88	1200.0
2017-10-31 07:40:00	AAPL	Stock	41.885	41.9175	41.885	41.9175	12564.0
2017-10-31 07:41:00	AAPL	Stock	41.9175	41.92	41.9175	41.92	4000.0
2017-10-31 07:42:00	AAPL	Stock	41.92	41.92	41.9	41.9	20696.0

> showing 50 of 1,078,143 rows — these rows as CSV

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