PREVIEW / stock_1min / 2018-06-05

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-06-05.parquet
  size:    15.6 MB
  rows:    1,110,153
  symbols: 2,369

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
2018-06-05 04:00:00	AAPL	Stock	48.0525	48.0525	48.0525	48.0525	1800.0
2018-06-05 04:10:00	AAPL	Stock	48.11	48.11	48.11	48.11	3700.0
2018-06-05 04:18:00	AAPL	Stock	48.11	48.11	48.11	48.11	4000.0
2018-06-05 04:30:00	AAPL	Stock	48.1375	48.1375	48.1375	48.1375	2000.0
2018-06-05 04:34:00	AAPL	Stock	48.145	48.145	48.145	48.145	400.0
2018-06-05 04:35:00	AAPL	Stock	48.1675	48.1675	48.1675	48.1675	1600.0
2018-06-05 04:56:00	AAPL	Stock	48.185	48.185	48.185	48.185	2000.0
2018-06-05 04:57:00	AAPL	Stock	48.1875	48.1875	48.1875	48.1875	752.0
2018-06-05 05:02:00	AAPL	Stock	48.1875	48.1875	48.1875	48.1875	800.0
2018-06-05 05:22:00	AAPL	Stock	48.1875	48.1975	48.1875	48.1975	3056.0
2018-06-05 05:43:00	AAPL	Stock	48.2	48.2075	48.2	48.2075	916.0
2018-06-05 05:45:00	AAPL	Stock	48.2125	48.2125	48.2125	48.2125	824.0
2018-06-05 05:46:00	AAPL	Stock	48.2125	48.2125	48.2125	48.2125	5600.0
2018-06-05 05:47:00	AAPL	Stock	48.2125	48.2125	48.2125	48.2125	2000.0
2018-06-05 05:56:00	AAPL	Stock	48.1775	48.1775	48.17	48.17	1956.0
2018-06-05 05:57:00	AAPL	Stock	48.21	48.21	48.21	48.21	800.0
2018-06-05 06:06:00	AAPL	Stock	48.1675	48.1675	48.1675	48.1675	2000.0
2018-06-05 06:08:00	AAPL	Stock	48.175	48.175	48.175	48.175	400.0
2018-06-05 06:09:00	AAPL	Stock	48.1675	48.1675	48.1675	48.1675	600.0
2018-06-05 06:15:00	AAPL	Stock	48.1675	48.1675	48.1675	48.1675	400.0
2018-06-05 06:16:00	AAPL	Stock	48.1525	48.1525	48.1375	48.1375	6420.0
2018-06-05 06:18:00	AAPL	Stock	48.1375	48.1375	48.1325	48.1325	1200.0
2018-06-05 06:21:00	AAPL	Stock	48.1375	48.1375	48.1375	48.1375	900.0
2018-06-05 06:22:00	AAPL	Stock	48.1325	48.1325	48.1325	48.1325	2000.0
2018-06-05 06:23:00	AAPL	Stock	48.1375	48.1625	48.1375	48.1625	4544.0
2018-06-05 06:34:00	AAPL	Stock	48.13	48.13	48.13	48.13	400.0
2018-06-05 06:36:00	AAPL	Stock	48.125	48.125	48.125	48.125	800.0
2018-06-05 06:37:00	AAPL	Stock	48.13	48.13	48.13	48.13	1568.0
2018-06-05 06:41:00	AAPL	Stock	48.1475	48.15	48.1475	48.15	2800.0
2018-06-05 06:46:00	AAPL	Stock	48.1375	48.1375	48.1375	48.1375	400.0
2018-06-05 06:48:00	AAPL	Stock	48.14	48.14	48.14	48.14	400.0
2018-06-05 06:52:00	AAPL	Stock	48.1625	48.1625	48.1625	48.1625	400.0
2018-06-05 06:53:00	AAPL	Stock	48.1625	48.1675	48.1625	48.1675	800.0
2018-06-05 07:00:00	AAPL	Stock	48.165	48.1725	48.15	48.1725	20716.0
2018-06-05 07:01:00	AAPL	Stock	48.1625	48.1625	48.1625	48.1625	1600.0
2018-06-05 07:02:00	AAPL	Stock	48.165	48.175	48.165	48.175	6012.0
2018-06-05 07:03:00	AAPL	Stock	48.175	48.1875	48.1725	48.18	49476.0
2018-06-05 07:04:00	AAPL	Stock	48.1925	48.1925	48.1925	48.1925	1200.0
2018-06-05 07:07:00	AAPL	Stock	48.1875	48.195	48.1875	48.195	12000.0
2018-06-05 07:08:00	AAPL	Stock	48.1925	48.1925	48.1825	48.1825	1600.0
2018-06-05 07:09:00	AAPL	Stock	48.1975	48.1975	48.1875	48.1875	6296.0
2018-06-05 07:10:00	AAPL	Stock	48.1925	48.1975	48.1925	48.1975	5180.0
2018-06-05 07:11:00	AAPL	Stock	48.1975	48.1975	48.195	48.195	2000.0
2018-06-05 07:12:00	AAPL	Stock	48.2025	48.2025	48.2025	48.2025	400.0
2018-06-05 07:13:00	AAPL	Stock	48.205	48.205	48.2	48.2	15304.0
2018-06-05 07:15:00	AAPL	Stock	48.2	48.21	48.2	48.21	4696.0
2018-06-05 07:16:00	AAPL	Stock	48.21	48.2125	48.21	48.2125	10216.0
2018-06-05 07:17:00	AAPL	Stock	48.215	48.2225	48.215	48.2225	7988.0
2018-06-05 07:18:00	AAPL	Stock	48.2225	48.2375	48.2225	48.2375	8732.0
2018-06-05 07:19:00	AAPL	Stock	48.245	48.25	48.2375	48.2375	12520.0

> showing 50 of 1,110,153 rows — these rows as CSV

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