PREVIEW / stock_1min / 2017-08-17

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-08-17.parquet
  size:    14.1 MB
  rows:    1,028,556
  symbols: 2,449

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-08-17 04:07:00	AAPL	Stock	40.21	40.21	40.21	40.21	400.0
2017-08-17 06:05:00	AAPL	Stock	40.175	40.175	40.175	40.175	400.0
2017-08-17 06:54:00	AAPL	Stock	40.195	40.1975	40.195	40.1975	800.0
2017-08-17 06:55:00	AAPL	Stock	40.195	40.195	40.195	40.195	800.0
2017-08-17 06:56:00	AAPL	Stock	40.195	40.195	40.195	40.195	800.0
2017-08-17 06:58:00	AAPL	Stock	40.195	40.2	40.195	40.2	2000.0
2017-08-17 07:00:00	AAPL	Stock	40.2125	40.22	40.2125	40.22	1600.0
2017-08-17 07:01:00	AAPL	Stock	40.1875	40.1875	40.1875	40.1875	800.0
2017-08-17 07:03:00	AAPL	Stock	40.19	40.19	40.1825	40.1825	800.0
2017-08-17 07:04:00	AAPL	Stock	40.1625	40.1625	40.1625	40.1625	400.0
2017-08-17 07:06:00	AAPL	Stock	40.1575	40.1575	40.1575	40.1575	1800.0
2017-08-17 07:07:00	AAPL	Stock	40.1625	40.1625	40.1625	40.1625	800.0
2017-08-17 07:08:00	AAPL	Stock	40.1625	40.1625	40.1625	40.1625	400.0
2017-08-17 07:25:00	AAPL	Stock	40.1375	40.1375	40.1375	40.1375	800.0
2017-08-17 07:30:00	AAPL	Stock	40.13	40.13	40.13	40.13	1400.0
2017-08-17 07:31:00	AAPL	Stock	40.17	40.175	40.17	40.175	3200.0
2017-08-17 07:36:00	AAPL	Stock	40.1275	40.1275	40.1275	40.1275	800.0
2017-08-17 07:37:00	AAPL	Stock	40.1275	40.1275	40.1275	40.1275	3600.0
2017-08-17 07:38:00	AAPL	Stock	40.1075	40.1075	40.1075	40.1075	800.0
2017-08-17 07:39:00	AAPL	Stock	40.1225	40.1225	40.0975	40.0975	2276.0
2017-08-17 07:41:00	AAPL	Stock	40.0975	40.0975	40.0975	40.0975	1200.0
2017-08-17 07:43:00	AAPL	Stock	40.1025	40.1025	40.08	40.08	2144.0
2017-08-17 07:45:00	AAPL	Stock	40.095	40.095	40.095	40.095	1024.0
2017-08-17 07:47:00	AAPL	Stock	40.1025	40.1025	40.1025	40.1025	800.0
2017-08-17 07:50:00	AAPL	Stock	40.1225	40.1225	40.1225	40.1225	400.0
2017-08-17 07:52:00	AAPL	Stock	40.1225	40.125	40.1225	40.125	1200.0
2017-08-17 07:53:00	AAPL	Stock	40.125	40.125	40.125	40.125	7200.0
2017-08-17 07:55:00	AAPL	Stock	40.105	40.105	40.105	40.105	1200.0
2017-08-17 07:58:00	AAPL	Stock	40.105	40.105	40.105	40.105	400.0
2017-08-17 07:59:00	AAPL	Stock	40.105	40.105	40.1	40.1	5200.0
2017-08-17 08:00:00	AAPL	Stock	40.1	40.1625	40.0825	40.0825	13340.0
2017-08-17 08:01:00	AAPL	Stock	40.075	40.075	40.075	40.075	3200.0
2017-08-17 08:02:00	AAPL	Stock	40.15	40.15	40.15	40.15	8000.0
2017-08-17 08:03:00	AAPL	Stock	40.1	40.1	40.1	40.1	4200.0
2017-08-17 08:04:00	AAPL	Stock	40.1	40.1	40.1	40.1	1900.0
2017-08-17 08:05:00	AAPL	Stock	40.0875	40.0875	40.0775	40.0775	3000.0
2017-08-17 08:06:00	AAPL	Stock	40.0975	40.0975	40.0975	40.0975	400.0
2017-08-17 08:07:00	AAPL	Stock	40.075	40.075	40.07	40.07	3840.0
2017-08-17 08:09:00	AAPL	Stock	40.065	40.0925	40.065	40.0925	1580.0
2017-08-17 08:10:00	AAPL	Stock	40.1	40.1	40.0975	40.1	8200.0
2017-08-17 08:12:00	AAPL	Stock	40.09	40.1	40.09	40.1	2400.0
2017-08-17 08:13:00	AAPL	Stock	40.095	40.1	40.095	40.1	3600.0
2017-08-17 08:14:00	AAPL	Stock	40.1	40.1	40.1	40.1	1600.0
2017-08-17 08:16:00	AAPL	Stock	40.09	40.1	40.09	40.1	1000.0
2017-08-17 08:18:00	AAPL	Stock	40.12	40.125	40.1125	40.1125	12800.0
2017-08-17 08:19:00	AAPL	Stock	40.105	40.105	40.1	40.1	1600.0
2017-08-17 08:20:00	AAPL	Stock	40.095	40.095	40.0875	40.095	5600.0
2017-08-17 08:21:00	AAPL	Stock	40.085	40.085	40.085	40.085	400.0
2017-08-17 08:22:00	AAPL	Stock	40.0925	40.0925	40.0825	40.0825	1744.0
2017-08-17 08:23:00	AAPL	Stock	40.0825	40.085	40.075	40.085	2000.0

> showing 50 of 1,028,556 rows — these rows as CSV

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