PREVIEW / stock_1min / 2019-11-20

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-11-20.parquet
  size:    16.9 MB
  rows:    1,157,753
  symbols: 2,121

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
2019-11-20 04:00:00	AAPL	Stock	66.2475	66.2475	66.2475	66.2475	1300.0
2019-11-20 04:01:00	AAPL	Stock	66.245	66.245	66.1525	66.1525	2280.0
2019-11-20 04:03:00	AAPL	Stock	66.1525	66.1525	66.1525	66.1525	400.0
2019-11-20 04:04:00	AAPL	Stock	66.1525	66.1525	66.1525	66.1525	3740.0
2019-11-20 04:07:00	AAPL	Stock	66.0875	66.0875	66.075	66.075	2564.0
2019-11-20 04:10:00	AAPL	Stock	66.0875	66.0875	66.0875	66.0875	800.0
2019-11-20 04:22:00	AAPL	Stock	66.17	66.17	66.17	66.17	400.0
2019-11-20 04:30:00	AAPL	Stock	66.14	66.14	66.14	66.14	400.0
2019-11-20 04:31:00	AAPL	Stock	66.1825	66.1825	66.1825	66.1825	544.0
2019-11-20 04:35:00	AAPL	Stock	66.1875	66.2	66.1875	66.2	2000.0
2019-11-20 04:39:00	AAPL	Stock	66.2275	66.23	66.2275	66.23	1188.0
2019-11-20 04:42:00	AAPL	Stock	66.2225	66.2225	66.2225	66.2225	800.0
2019-11-20 04:51:00	AAPL	Stock	66.2025	66.2025	66.2025	66.2025	800.0
2019-11-20 04:52:00	AAPL	Stock	66.21	66.21	66.21	66.21	800.0
2019-11-20 04:53:00	AAPL	Stock	66.215	66.215	66.215	66.215	400.0
2019-11-20 04:54:00	AAPL	Stock	66.215	66.215	66.215	66.215	596.0
2019-11-20 04:55:00	AAPL	Stock	66.215	66.215	66.215	66.215	600.0
2019-11-20 04:59:00	AAPL	Stock	66.22	66.22	66.22	66.22	400.0
2019-11-20 05:00:00	AAPL	Stock	66.215	66.215	66.215	66.215	1132.0
2019-11-20 05:06:00	AAPL	Stock	66.2075	66.2075	66.2025	66.2025	1668.0
2019-11-20 05:11:00	AAPL	Stock	66.19	66.19	66.19	66.19	400.0
2019-11-20 05:12:00	AAPL	Stock	66.19	66.19	66.1875	66.1875	1392.0
2019-11-20 05:13:00	AAPL	Stock	66.165	66.165	66.165	66.165	1920.0
2019-11-20 05:15:00	AAPL	Stock	66.15	66.15	66.15	66.15	400.0
2019-11-20 05:20:00	AAPL	Stock	66.155	66.155	66.155	66.155	404.0
2019-11-20 05:37:00	AAPL	Stock	66.14	66.14	66.1	66.1	10744.0
2019-11-20 05:38:00	AAPL	Stock	66.1	66.1	66.1	66.1	800.0
2019-11-20 05:43:00	AAPL	Stock	66.09	66.09	66.09	66.09	400.0
2019-11-20 05:50:00	AAPL	Stock	66.1375	66.1375	66.1375	66.1375	1400.0
2019-11-20 05:53:00	AAPL	Stock	66.1	66.1	66.09	66.09	3640.0
2019-11-20 05:54:00	AAPL	Stock	66.09	66.09	66.09	66.09	400.0
2019-11-20 06:05:00	AAPL	Stock	66.15	66.15	66.15	66.15	400.0
2019-11-20 06:08:00	AAPL	Stock	66.15	66.15	66.09	66.09	7308.0
2019-11-20 06:09:00	AAPL	Stock	66.0875	66.0875	66.05	66.05	4640.0
2019-11-20 06:10:00	AAPL	Stock	66.07	66.07	66.07	66.07	4000.0
2019-11-20 06:18:00	AAPL	Stock	66.1475	66.1475	66.1475	66.1475	400.0
2019-11-20 06:22:00	AAPL	Stock	66.13	66.13	66.1	66.1	1732.0
2019-11-20 06:23:00	AAPL	Stock	66.13	66.13	66.075	66.075	5200.0
2019-11-20 06:24:00	AAPL	Stock	66.075	66.075	66.075	66.075	800.0
2019-11-20 06:25:00	AAPL	Stock	66.0775	66.0775	66.075	66.075	800.0
2019-11-20 06:26:00	AAPL	Stock	66.075	66.075	66.075	66.075	600.0
2019-11-20 06:36:00	AAPL	Stock	66.1225	66.1375	66.1225	66.1375	2900.0
2019-11-20 06:46:00	AAPL	Stock	66.1925	66.2125	66.1925	66.2125	18000.0
2019-11-20 06:48:00	AAPL	Stock	66.1925	66.1925	66.1925	66.1925	1680.0
2019-11-20 06:49:00	AAPL	Stock	66.195	66.2	66.195	66.195	4000.0
2019-11-20 06:53:00	AAPL	Stock	66.215	66.225	66.215	66.2175	1200.0
2019-11-20 06:54:00	AAPL	Stock	66.25	66.25	66.25	66.25	2400.0
2019-11-20 06:55:00	AAPL	Stock	66.25	66.25	66.25	66.25	832.0
2019-11-20 06:56:00	AAPL	Stock	66.25	66.25	66.25	66.25	400.0
2019-11-20 06:58:00	AAPL	Stock	66.2525	66.255	66.2525	66.255	1600.0

> showing 50 of 1,157,753 rows — these rows as CSV

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