PREVIEW / stock_1min / 2017-09-19

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-09-19.parquet
  size:    14.2 MB
  rows:    1,031,951
  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-19 04:04:00	AAPL	Stock	39.7125	39.7125	39.7125	39.7125	400.0
2017-09-19 04:07:00	AAPL	Stock	39.735	39.735	39.735	39.735	1200.0
2017-09-19 04:08:00	AAPL	Stock	39.7475	39.8	39.7475	39.8	4524.0
2017-09-19 04:13:00	AAPL	Stock	39.75	39.75	39.75	39.75	800.0
2017-09-19 04:18:00	AAPL	Stock	39.75	39.75	39.75	39.75	400.0
2017-09-19 04:26:00	AAPL	Stock	39.7625	39.7625	39.7625	39.7625	400.0
2017-09-19 04:39:00	AAPL	Stock	39.745	39.7625	39.745	39.7625	1888.0
2017-09-19 04:40:00	AAPL	Stock	39.7625	39.7625	39.7625	39.7625	1116.0
2017-09-19 04:41:00	AAPL	Stock	39.7575	39.7625	39.7575	39.7625	2000.0
2017-09-19 04:44:00	AAPL	Stock	39.745	39.745	39.745	39.745	1200.0
2017-09-19 04:47:00	AAPL	Stock	39.7775	39.7775	39.7775	39.7775	400.0
2017-09-19 04:49:00	AAPL	Stock	39.775	39.8	39.775	39.8	10800.0
2017-09-19 04:52:00	AAPL	Stock	39.755	39.755	39.755	39.755	400.0
2017-09-19 05:07:00	AAPL	Stock	39.7525	39.7525	39.725	39.725	2732.0
2017-09-19 05:15:00	AAPL	Stock	39.775	39.775	39.775	39.775	400.0
2017-09-19 05:37:00	AAPL	Stock	39.7875	39.7875	39.7875	39.7875	400.0
2017-09-19 05:43:00	AAPL	Stock	39.785	39.7875	39.785	39.7875	800.0
2017-09-19 05:44:00	AAPL	Stock	39.8	39.8	39.795	39.795	2400.0
2017-09-19 05:46:00	AAPL	Stock	39.8	39.805	39.8	39.805	1200.0
2017-09-19 05:47:00	AAPL	Stock	39.79	39.8175	39.79	39.8175	3108.0
2017-09-19 05:48:00	AAPL	Stock	39.825	39.83	39.825	39.8275	7204.0
2017-09-19 05:49:00	AAPL	Stock	39.83	39.83	39.83	39.83	400.0
2017-09-19 05:51:00	AAPL	Stock	39.85	39.85	39.85	39.85	2400.0
2017-09-19 05:58:00	AAPL	Stock	39.8	39.8	39.8	39.8	2000.0
2017-09-19 06:03:00	AAPL	Stock	39.825	39.825	39.825	39.825	400.0
2017-09-19 06:04:00	AAPL	Stock	39.825	39.825	39.825	39.825	400.0
2017-09-19 06:06:00	AAPL	Stock	39.8425	39.8425	39.825	39.825	800.0
2017-09-19 06:11:00	AAPL	Stock	39.825	39.825	39.825	39.825	400.0
2017-09-19 06:12:00	AAPL	Stock	39.8175	39.8175	39.8175	39.8175	400.0
2017-09-19 06:14:00	AAPL	Stock	39.8175	39.8275	39.8175	39.8275	2800.0
2017-09-19 06:15:00	AAPL	Stock	39.825	39.825	39.825	39.825	400.0
2017-09-19 06:16:00	AAPL	Stock	39.825	39.825	39.825	39.825	1200.0
2017-09-19 06:22:00	AAPL	Stock	39.81	39.81	39.805	39.805	944.0
2017-09-19 06:23:00	AAPL	Stock	39.8	39.8	39.8	39.8	1768.0
2017-09-19 06:34:00	AAPL	Stock	39.7925	39.7925	39.79	39.79	800.0
2017-09-19 06:35:00	AAPL	Stock	39.79	39.8	39.79	39.8	800.0
2017-09-19 06:39:00	AAPL	Stock	39.81	39.82	39.79	39.82	5400.0
2017-09-19 06:41:00	AAPL	Stock	39.8	39.8	39.8	39.8	480.0
2017-09-19 06:42:00	AAPL	Stock	39.815	39.82	39.815	39.82	2800.0
2017-09-19 06:47:00	AAPL	Stock	39.8125	39.8125	39.8125	39.8125	400.0
2017-09-19 06:48:00	AAPL	Stock	39.825	39.825	39.825	39.825	400.0
2017-09-19 06:51:00	AAPL	Stock	39.8325	39.8325	39.8325	39.8325	400.0
2017-09-19 07:00:00	AAPL	Stock	39.8075	39.8075	39.7875	39.7875	48608.0
2017-09-19 07:01:00	AAPL	Stock	39.7875	39.7925	39.7875	39.7925	3412.0
2017-09-19 07:05:00	AAPL	Stock	39.7975	39.7975	39.7975	39.7975	1748.0
2017-09-19 07:10:00	AAPL	Stock	39.7825	39.7825	39.7775	39.7775	4000.0
2017-09-19 07:12:00	AAPL	Stock	39.78	39.78	39.78	39.78	7888.0
2017-09-19 07:13:00	AAPL	Stock	39.78	39.78	39.78	39.78	800.0
2017-09-19 07:15:00	AAPL	Stock	39.7775	39.7775	39.765	39.765	4400.0
2017-09-19 07:17:00	AAPL	Stock	39.78	39.78	39.78	39.78	9788.0

> showing 50 of 1,031,951 rows — these rows as CSV

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