PREVIEW / stock_1min / 2018-07-11

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-11.parquet
  size:    14.4 MB
  rows:    1,047,164
  symbols: 2,349

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-07-11 04:03:00	AAPL	Stock	47.15	47.15	47.15	47.15	2000.0
2018-07-11 04:07:00	AAPL	Stock	47.15	47.15	47.15	47.15	4000.0
2018-07-11 04:08:00	AAPL	Stock	47.15	47.15	47.15	47.15	1600.0
2018-07-11 04:11:00	AAPL	Stock	47.15	47.15	47.15	47.15	1668.0
2018-07-11 04:29:00	AAPL	Stock	47.125	47.125	47.125	47.125	400.0
2018-07-11 04:47:00	AAPL	Stock	47.125	47.125	47.125	47.125	800.0
2018-07-11 04:50:00	AAPL	Stock	47.1025	47.1025	47.1025	47.1025	3600.0
2018-07-11 04:51:00	AAPL	Stock	47.08	47.08	47.08	47.08	2080.0
2018-07-11 04:55:00	AAPL	Stock	47.015	47.015	47.0025	47.0025	5812.0
2018-07-11 05:15:00	AAPL	Stock	47.0075	47.0075	47.0075	47.0075	400.0
2018-07-11 05:36:00	AAPL	Stock	47.0625	47.0625	47.0625	47.0625	1440.0
2018-07-11 05:39:00	AAPL	Stock	47.0625	47.0625	47.0625	47.0625	2400.0
2018-07-11 05:46:00	AAPL	Stock	47.0625	47.0625	47.0625	47.0625	400.0
2018-07-11 05:49:00	AAPL	Stock	47.0575	47.0575	47.0575	47.0575	1900.0
2018-07-11 05:55:00	AAPL	Stock	47.0575	47.0625	47.0575	47.0625	7900.0
2018-07-11 05:59:00	AAPL	Stock	47.0625	47.0625	47.0625	47.0625	1600.0
2018-07-11 06:16:00	AAPL	Stock	47.1175	47.1175	47.1175	47.1175	800.0
2018-07-11 06:23:00	AAPL	Stock	47.145	47.15	47.145	47.15	4000.0
2018-07-11 06:24:00	AAPL	Stock	47.1525	47.1725	47.15	47.1725	10400.0
2018-07-11 06:35:00	AAPL	Stock	47.1625	47.1625	47.1625	47.1625	400.0
2018-07-11 06:47:00	AAPL	Stock	47.1375	47.1375	47.1375	47.1375	416.0
2018-07-11 07:00:00	AAPL	Stock	47.1475	47.17	47.1475	47.17	8332.0
2018-07-11 07:01:00	AAPL	Stock	47.17	47.1725	47.17	47.1725	3620.0
2018-07-11 07:02:00	AAPL	Stock	47.175	47.175	47.175	47.175	1200.0
2018-07-11 07:03:00	AAPL	Stock	47.2	47.2	47.2	47.2	4000.0
2018-07-11 07:04:00	AAPL	Stock	47.225	47.225	47.2125	47.2125	8064.0
2018-07-11 07:05:00	AAPL	Stock	47.21	47.21	47.21	47.21	400.0
2018-07-11 07:07:00	AAPL	Stock	47.2175	47.2175	47.2175	47.2175	400.0
2018-07-11 07:11:00	AAPL	Stock	47.225	47.225	47.225	47.225	400.0
2018-07-11 07:12:00	AAPL	Stock	47.2325	47.2325	47.2325	47.2325	400.0
2018-07-11 07:14:00	AAPL	Stock	47.2125	47.2125	47.2125	47.2125	3800.0
2018-07-11 07:15:00	AAPL	Stock	47.235	47.235	47.2	47.225	5800.0
2018-07-11 07:16:00	AAPL	Stock	47.225	47.225	47.225	47.225	400.0
2018-07-11 07:17:00	AAPL	Stock	47.2	47.2	47.1875	47.2	5720.0
2018-07-11 07:18:00	AAPL	Stock	47.195	47.195	47.19	47.19	800.0
2018-07-11 07:23:00	AAPL	Stock	47.1875	47.1875	47.1875	47.1875	2000.0
2018-07-11 07:25:00	AAPL	Stock	47.185	47.185	47.185	47.185	2000.0
2018-07-11 07:26:00	AAPL	Stock	47.175	47.175	47.175	47.175	6000.0
2018-07-11 07:27:00	AAPL	Stock	47.17	47.17	47.1625	47.1625	1200.0
2018-07-11 07:28:00	AAPL	Stock	47.1625	47.1625	47.15	47.15	2740.0
2018-07-11 07:32:00	AAPL	Stock	47.155	47.155	47.155	47.155	1200.0
2018-07-11 07:33:00	AAPL	Stock	47.155	47.155	47.155	47.155	1200.0
2018-07-11 07:34:00	AAPL	Stock	47.1675	47.1675	47.15	47.15	9960.0
2018-07-11 07:35:00	AAPL	Stock	47.17	47.175	47.1675	47.175	2024.0
2018-07-11 07:37:00	AAPL	Stock	47.17	47.1875	47.17	47.1875	9788.0
2018-07-11 07:38:00	AAPL	Stock	47.1875	47.1875	47.185	47.185	16044.0
2018-07-11 07:40:00	AAPL	Stock	47.1625	47.1625	47.15	47.15	5132.0
2018-07-11 07:42:00	AAPL	Stock	47.15	47.15	47.1375	47.14	4800.0
2018-07-11 07:43:00	AAPL	Stock	47.15	47.15	47.15	47.15	2400.0
2018-07-11 07:44:00	AAPL	Stock	47.1725	47.175	47.1725	47.175	1200.0

> showing 50 of 1,047,164 rows — these rows as CSV

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