PREVIEW / stock_1min / 2017-10-18

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-10-18.parquet
  size:    14.3 MB
  rows:    1,034,580
  symbols: 2,427

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-18 07:00:00	AAPL	Stock	40.1575	40.1575	40.1575	40.1575	400.0
2017-10-18 07:11:00	AAPL	Stock	40.175	40.175	40.175	40.175	400.0
2017-10-18 07:12:00	AAPL	Stock	40.1975	40.1975	40.1975	40.1975	2000.0
2017-10-18 07:14:00	AAPL	Stock	40.195	40.195	40.195	40.195	400.0
2017-10-18 07:15:00	AAPL	Stock	40.195	40.195	40.195	40.195	772.0
2017-10-18 07:17:00	AAPL	Stock	40.195	40.195	40.195	40.195	400.0
2017-10-18 07:19:00	AAPL	Stock	40.1975	40.2	40.1975	40.2	3200.0
2017-10-18 07:21:00	AAPL	Stock	40.22	40.22	40.22	40.22	1148.0
2017-10-18 07:26:00	AAPL	Stock	40.205	40.2075	40.205	40.205	6292.0
2017-10-18 07:27:00	AAPL	Stock	40.2075	40.2075	40.2075	40.2075	400.0
2017-10-18 07:29:00	AAPL	Stock	40.2175	40.2175	40.2175	40.2175	400.0
2017-10-18 07:31:00	AAPL	Stock	40.2125	40.2125	40.2125	40.2125	400.0
2017-10-18 07:32:00	AAPL	Stock	40.2125	40.2125	40.2125	40.2125	3540.0
2017-10-18 07:34:00	AAPL	Stock	40.2	40.2	40.2	40.2	400.0
2017-10-18 07:36:00	AAPL	Stock	40.1875	40.1875	40.1875	40.1875	3600.0
2017-10-18 07:40:00	AAPL	Stock	40.195	40.2	40.195	40.2	9412.0
2017-10-18 07:43:00	AAPL	Stock	40.2	40.2	40.2	40.2	1544.0
2017-10-18 07:45:00	AAPL	Stock	40.2	40.2	40.2	40.2	2000.0
2017-10-18 07:46:00	AAPL	Stock	40.205	40.205	40.205	40.205	472.0
2017-10-18 07:47:00	AAPL	Stock	40.205	40.205	40.205	40.205	1200.0
2017-10-18 07:54:00	AAPL	Stock	40.2	40.2	40.2	40.2	1988.0
2017-10-18 07:59:00	AAPL	Stock	40.2	40.2	40.1775	40.1775	10240.0
2017-10-18 08:00:00	AAPL	Stock	40.22	40.22	40.175	40.2125	31584.0
2017-10-18 08:01:00	AAPL	Stock	40.1975	40.1975	40.1975	40.1975	5000.0
2017-10-18 08:02:00	AAPL	Stock	40.195	40.1975	40.195	40.1975	5200.0
2017-10-18 08:03:00	AAPL	Stock	40.1975	40.1975	40.1825	40.1825	2400.0
2017-10-18 08:04:00	AAPL	Stock	40.175	40.175	40.175	40.175	10060.0
2017-10-18 08:06:00	AAPL	Stock	40.1625	40.175	40.1625	40.175	1700.0
2017-10-18 08:08:00	AAPL	Stock	40.1725	40.1725	40.1725	40.1725	400.0
2017-10-18 08:09:00	AAPL	Stock	40.1625	40.17	40.1625	40.17	15680.0
2017-10-18 08:10:00	AAPL	Stock	40.17	40.17	40.17	40.17	3988.0
2017-10-18 08:11:00	AAPL	Stock	40.1675	40.175	40.1675	40.1675	2800.0
2017-10-18 08:12:00	AAPL	Stock	40.175	40.175	40.175	40.175	3988.0
2017-10-18 08:13:00	AAPL	Stock	40.17	40.17	40.17	40.17	400.0
2017-10-18 08:14:00	AAPL	Stock	40.1725	40.1725	40.1725	40.1725	4000.0
2017-10-18 08:15:00	AAPL	Stock	40.185	40.185	40.18	40.18	800.0
2017-10-18 08:16:00	AAPL	Stock	40.1825	40.185	40.1825	40.1825	2564.0
2017-10-18 08:17:00	AAPL	Stock	40.185	40.185	40.185	40.185	800.0
2017-10-18 08:18:00	AAPL	Stock	40.185	40.185	40.185	40.185	400.0
2017-10-18 08:19:00	AAPL	Stock	40.175	40.185	40.175	40.185	1200.0
2017-10-18 08:20:00	AAPL	Stock	40.185	40.185	40.18	40.1825	8800.0
2017-10-18 08:21:00	AAPL	Stock	40.1825	40.1825	40.1825	40.1825	2000.0
2017-10-18 08:22:00	AAPL	Stock	40.1825	40.1825	40.1825	40.1825	3608.0
2017-10-18 08:24:00	AAPL	Stock	40.185	40.1875	40.185	40.1875	1200.0
2017-10-18 08:26:00	AAPL	Stock	40.1825	40.1825	40.1825	40.1825	400.0
2017-10-18 08:28:00	AAPL	Stock	40.1875	40.1875	40.185	40.185	5800.0
2017-10-18 08:30:00	AAPL	Stock	40.185	40.1875	40.185	40.1875	3200.0
2017-10-18 08:31:00	AAPL	Stock	40.1875	40.1875	40.1875	40.1875	400.0
2017-10-18 08:32:00	AAPL	Stock	40.185	40.185	40.185	40.185	3200.0
2017-10-18 08:33:00	AAPL	Stock	40.1825	40.185	40.18	40.185	6400.0

> showing 50 of 1,034,580 rows — these rows as CSV

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