PREVIEW / stock_1min / 2017-10-20

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-10-20.parquet
  size:    14.1 MB
  rows:    1,014,520
  symbols: 2,435

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-20 04:00:00	AAPL	Stock	39.05	39.1875	39.05	39.1875	2632.0
2017-10-20 04:13:00	AAPL	Stock	39.15	39.15	39.15	39.15	1200.0
2017-10-20 04:26:00	AAPL	Stock	39.175	39.175	39.175	39.175	800.0
2017-10-20 04:41:00	AAPL	Stock	39.125	39.125	39.125	39.125	400.0
2017-10-20 04:44:00	AAPL	Stock	39.1225	39.125	39.1225	39.125	1000.0
2017-10-20 04:49:00	AAPL	Stock	39.15	39.15	39.15	39.15	400.0
2017-10-20 04:57:00	AAPL	Stock	39.15	39.15	39.15	39.15	400.0
2017-10-20 05:11:00	AAPL	Stock	39.1625	39.1625	39.1625	39.1625	400.0
2017-10-20 05:23:00	AAPL	Stock	39.15	39.15	39.15	39.15	1200.0
2017-10-20 05:24:00	AAPL	Stock	39.1625	39.1625	39.1625	39.1625	400.0
2017-10-20 05:26:00	AAPL	Stock	39.1625	39.1625	39.1625	39.1625	400.0
2017-10-20 05:28:00	AAPL	Stock	39.1625	39.1625	39.1625	39.1625	1200.0
2017-10-20 05:29:00	AAPL	Stock	39.145	39.145	39.145	39.145	400.0
2017-10-20 05:30:00	AAPL	Stock	39.145	39.145	39.145	39.145	400.0
2017-10-20 05:33:00	AAPL	Stock	39.145	39.145	39.145	39.145	400.0
2017-10-20 05:35:00	AAPL	Stock	39.1625	39.1625	39.1625	39.1625	400.0
2017-10-20 05:40:00	AAPL	Stock	39.1375	39.1375	39.1375	39.1375	400.0
2017-10-20 05:44:00	AAPL	Stock	39.1375	39.1375	39.1375	39.1375	400.0
2017-10-20 05:45:00	AAPL	Stock	39.125	39.125	39.125	39.125	488.0
2017-10-20 06:05:00	AAPL	Stock	39.175	39.175	39.175	39.175	3232.0
2017-10-20 06:06:00	AAPL	Stock	39.185	39.185	39.185	39.185	5200.0
2017-10-20 06:11:00	AAPL	Stock	39.175	39.175	39.175	39.175	2000.0
2017-10-20 06:12:00	AAPL	Stock	39.175	39.175	39.175	39.175	800.0
2017-10-20 06:37:00	AAPL	Stock	39.175	39.175	39.175	39.175	2000.0
2017-10-20 06:38:00	AAPL	Stock	39.15	39.15	39.15	39.15	3200.0
2017-10-20 06:45:00	AAPL	Stock	39.1525	39.1525	39.1525	39.1525	1200.0
2017-10-20 06:47:00	AAPL	Stock	39.1525	39.1525	39.1525	39.1525	800.0
2017-10-20 06:58:00	AAPL	Stock	39.1525	39.1525	39.1525	39.1525	400.0
2017-10-20 07:01:00	AAPL	Stock	39.175	39.1875	39.15	39.1575	9600.0
2017-10-20 07:02:00	AAPL	Stock	39.15	39.1525	39.1375	39.1375	15960.0
2017-10-20 07:03:00	AAPL	Stock	39.115	39.125	39.115	39.1225	2100.0
2017-10-20 07:04:00	AAPL	Stock	39.1125	39.1125	39.1125	39.1125	800.0
2017-10-20 07:05:00	AAPL	Stock	39.115	39.115	39.1125	39.1125	1600.0
2017-10-20 07:06:00	AAPL	Stock	39.1125	39.1125	39.1125	39.1125	400.0
2017-10-20 07:08:00	AAPL	Stock	39.1	39.11	39.1	39.1	5688.0
2017-10-20 07:12:00	AAPL	Stock	39.1	39.1	39.09	39.09	5000.0
2017-10-20 07:13:00	AAPL	Stock	39.0875	39.0875	39.0875	39.0875	7476.0
2017-10-20 07:15:00	AAPL	Stock	39.0875	39.0875	39.0875	39.0875	1000.0
2017-10-20 07:18:00	AAPL	Stock	39.105	39.11	39.0775	39.0775	4372.0
2017-10-20 07:22:00	AAPL	Stock	39.0825	39.0825	39.0825	39.0825	400.0
2017-10-20 07:25:00	AAPL	Stock	39.08	39.08	39.08	39.08	1200.0
2017-10-20 07:27:00	AAPL	Stock	39.105	39.1175	39.105	39.1175	4000.0
2017-10-20 07:29:00	AAPL	Stock	39.0775	39.0775	39.0775	39.0775	2000.0
2017-10-20 07:30:00	AAPL	Stock	39.1	39.1	39.1	39.1	1464.0
2017-10-20 07:31:00	AAPL	Stock	39.0775	39.0775	39.0775	39.0775	2000.0
2017-10-20 07:32:00	AAPL	Stock	39.0925	39.095	39.0775	39.0775	3376.0
2017-10-20 07:33:00	AAPL	Stock	39.095	39.115	39.095	39.115	11528.0
2017-10-20 07:34:00	AAPL	Stock	39.11	39.11	39.11	39.11	400.0
2017-10-20 07:35:00	AAPL	Stock	39.125	39.1275	39.125	39.1275	3200.0
2017-10-20 07:36:00	AAPL	Stock	39.1425	39.1425	39.1425	39.1425	2400.0

> showing 50 of 1,014,520 rows — these rows as CSV

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