PREVIEW / stock_1min / 2018-04-27

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-04-27.parquet
  size:    14.2 MB
  rows:    1,039,778
  symbols: 2,373

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-04-27 05:03:00	AAPL	Stock	41.2	41.2	41.2	41.2	400.0
2018-04-27 05:13:00	AAPL	Stock	41.2	41.2	41.175	41.175	1200.0
2018-04-27 05:18:00	AAPL	Stock	41.2025	41.2025	41.2	41.2	7972.0
2018-04-27 05:28:00	AAPL	Stock	41.2025	41.2025	41.2025	41.2025	4072.0
2018-04-27 05:54:00	AAPL	Stock	41.205	41.205	41.205	41.205	400.0
2018-04-27 06:09:00	AAPL	Stock	41.2	41.2	41.2	41.2	400.0
2018-04-27 06:25:00	AAPL	Stock	41.2275	41.2275	41.2275	41.2275	400.0
2018-04-27 06:33:00	AAPL	Stock	41.2425	41.2425	41.2425	41.2425	800.0
2018-04-27 06:44:00	AAPL	Stock	41.225	41.225	41.225	41.225	1596.0
2018-04-27 06:46:00	AAPL	Stock	41.225	41.225	41.225	41.225	800.0
2018-04-27 06:56:00	AAPL	Stock	41.2225	41.225	41.2225	41.225	1632.0
2018-04-27 07:00:00	AAPL	Stock	41.225	41.225	41.2225	41.225	2832.0
2018-04-27 07:01:00	AAPL	Stock	41.225	41.225	41.225	41.225	400.0
2018-04-27 07:04:00	AAPL	Stock	41.225	41.225	41.225	41.225	400.0
2018-04-27 07:05:00	AAPL	Stock	41.205	41.205	41.2	41.2	4736.0
2018-04-27 07:06:00	AAPL	Stock	41.2	41.2	41.2	41.2	2000.0
2018-04-27 07:07:00	AAPL	Stock	41.18	41.1825	41.18	41.1825	2992.0
2018-04-27 07:09:00	AAPL	Stock	41.195	41.195	41.195	41.195	1600.0
2018-04-27 07:12:00	AAPL	Stock	41.2175	41.225	41.2175	41.225	1000.0
2018-04-27 07:16:00	AAPL	Stock	41.2125	41.2225	41.2025	41.2225	6400.0
2018-04-27 07:18:00	AAPL	Stock	41.1875	41.1875	41.1825	41.1825	1260.0
2018-04-27 07:21:00	AAPL	Stock	41.1925	41.1925	41.19	41.1925	2800.0
2018-04-27 07:22:00	AAPL	Stock	41.19	41.19	41.19	41.19	400.0
2018-04-27 07:24:00	AAPL	Stock	41.1875	41.1875	41.1875	41.1875	896.0
2018-04-27 07:25:00	AAPL	Stock	41.19	41.2	41.19	41.2	4000.0
2018-04-27 07:26:00	AAPL	Stock	41.1875	41.1875	41.18	41.18	3032.0
2018-04-27 07:27:00	AAPL	Stock	41.1875	41.1875	41.18	41.18	2476.0
2018-04-27 07:28:00	AAPL	Stock	41.1975	41.1975	41.1975	41.1975	800.0
2018-04-27 07:30:00	AAPL	Stock	41.1975	41.1975	41.1975	41.1975	2000.0
2018-04-27 07:40:00	AAPL	Stock	41.2125	41.2125	41.2125	41.2125	3600.0
2018-04-27 07:42:00	AAPL	Stock	41.175	41.175	41.175	41.175	2000.0
2018-04-27 07:43:00	AAPL	Stock	41.1825	41.1825	41.1825	41.1825	1200.0
2018-04-27 07:47:00	AAPL	Stock	41.1825	41.1825	41.1825	41.1825	400.0
2018-04-27 07:48:00	AAPL	Stock	41.1775	41.1775	41.175	41.175	2176.0
2018-04-27 07:54:00	AAPL	Stock	41.195	41.195	41.195	41.195	400.0
2018-04-27 07:58:00	AAPL	Stock	41.205	41.205	41.205	41.205	400.0
2018-04-27 07:59:00	AAPL	Stock	41.2125	41.2175	41.2125	41.2175	6000.0
2018-04-27 08:00:00	AAPL	Stock	41.205	41.2375	41.1775	41.235	16808.0
2018-04-27 08:01:00	AAPL	Stock	41.2275	41.2275	41.2275	41.2275	4056.0
2018-04-27 08:02:00	AAPL	Stock	41.2375	41.245	41.2275	41.2275	4224.0
2018-04-27 08:03:00	AAPL	Stock	41.2275	41.245	41.2275	41.245	12000.0
2018-04-27 08:04:00	AAPL	Stock	41.2325	41.2325	41.23	41.23	888.0
2018-04-27 08:05:00	AAPL	Stock	41.24	41.27	41.24	41.27	8256.0
2018-04-27 08:06:00	AAPL	Stock	41.29	41.29	41.29	41.29	7600.0
2018-04-27 08:07:00	AAPL	Stock	41.2725	41.2725	41.27	41.27	1520.0
2018-04-27 08:08:00	AAPL	Stock	41.2525	41.2525	41.25	41.25	1188.0
2018-04-27 08:09:00	AAPL	Stock	41.275	41.2875	41.255	41.275	4040.0
2018-04-27 08:10:00	AAPL	Stock	41.275	41.275	41.275	41.275	400.0
2018-04-27 08:11:00	AAPL	Stock	41.265	41.265	41.2625	41.2625	1960.0
2018-04-27 08:12:00	AAPL	Stock	41.2738	41.2738	41.2425	41.2425	3040.0

> showing 50 of 1,039,778 rows — these rows as CSV

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