PREVIEW / stock_1min / 2019-07-17

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-07-17.parquet
  size:    15.1 MB
  rows:    1,079,710
  symbols: 2,164

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-07-17 04:06:00	AAPL	Stock	51.1375	51.1375	51.1375	51.1375	400.0
2019-07-17 05:52:00	AAPL	Stock	51.175	51.175	51.175	51.175	960.0
2019-07-17 05:53:00	AAPL	Stock	51.22	51.22	51.22	51.22	400.0
2019-07-17 06:16:00	AAPL	Stock	51.1975	51.1975	51.1975	51.1975	800.0
2019-07-17 06:17:00	AAPL	Stock	51.1875	51.1875	51.1875	51.1875	800.0
2019-07-17 06:21:00	AAPL	Stock	51.175	51.175	51.175	51.175	1120.0
2019-07-17 06:30:00	AAPL	Stock	51.175	51.175	51.175	51.175	400.0
2019-07-17 06:46:00	AAPL	Stock	51.175	51.175	51.175	51.175	732.0
2019-07-17 06:55:00	AAPL	Stock	51.1325	51.1725	51.1325	51.17	8236.0
2019-07-17 06:59:00	AAPL	Stock	51.175	51.175	51.175	51.175	508.0
2019-07-17 07:01:00	AAPL	Stock	51.225	51.2325	51.22	51.22	1600.0
2019-07-17 07:02:00	AAPL	Stock	51.2	51.205	51.19	51.205	2292.0
2019-07-17 07:03:00	AAPL	Stock	51.19	51.19	51.19	51.19	800.0
2019-07-17 07:04:00	AAPL	Stock	51.1875	51.1875	51.175	51.175	6900.0
2019-07-17 07:05:00	AAPL	Stock	51.175	51.21	51.1525	51.155	3200.0
2019-07-17 07:07:00	AAPL	Stock	51.1525	51.1525	51.1525	51.1525	400.0
2019-07-17 07:09:00	AAPL	Stock	51.15	51.15	51.15	51.15	1600.0
2019-07-17 07:10:00	AAPL	Stock	51.15	51.175	51.15	51.175	2584.0
2019-07-17 07:19:00	AAPL	Stock	51.175	51.175	51.175	51.175	400.0
2019-07-17 07:22:00	AAPL	Stock	51.175	51.175	51.175	51.175	800.0
2019-07-17 07:28:00	AAPL	Stock	51.1625	51.1625	51.1625	51.1625	2000.0
2019-07-17 07:31:00	AAPL	Stock	51.15	51.15	51.14	51.14	9448.0
2019-07-17 07:32:00	AAPL	Stock	51.1325	51.1325	51.1325	51.1325	500.0
2019-07-17 07:33:00	AAPL	Stock	51.15	51.15	51.15	51.15	400.0
2019-07-17 07:37:00	AAPL	Stock	51.1375	51.1375	51.1375	51.1375	624.0
2019-07-17 07:38:00	AAPL	Stock	51.14	51.14	51.14	51.14	400.0
2019-07-17 07:39:00	AAPL	Stock	51.1325	51.1325	51.125	51.125	15360.0
2019-07-17 07:42:00	AAPL	Stock	51.105	51.105	51.1025	51.1025	2000.0
2019-07-17 07:44:00	AAPL	Stock	51.125	51.125	51.125	51.125	400.0
2019-07-17 07:48:00	AAPL	Stock	51.1375	51.1375	51.1375	51.1375	800.0
2019-07-17 07:54:00	AAPL	Stock	51.145	51.1475	51.145	51.1475	4400.0
2019-07-17 07:59:00	AAPL	Stock	51.16	51.1625	51.16	51.1625	2400.0
2019-07-17 08:00:00	AAPL	Stock	51.1875	51.225	51.0775	51.1325	40620.0
2019-07-17 08:04:00	AAPL	Stock	51.16	51.16	51.15	51.155	1200.0
2019-07-17 08:05:00	AAPL	Stock	51.155	51.155	51.155	51.155	400.0
2019-07-17 08:06:00	AAPL	Stock	51.165	51.165	51.165	51.165	800.0
2019-07-17 08:07:00	AAPL	Stock	51.1575	51.1575	51.155	51.155	2240.0
2019-07-17 08:10:00	AAPL	Stock	51.1625	51.1625	51.1625	51.1625	1228.0
2019-07-17 08:11:00	AAPL	Stock	51.165	51.165	51.165	51.165	1600.0
2019-07-17 08:13:00	AAPL	Stock	51.1625	51.1625	51.1625	51.1625	3892.0
2019-07-17 08:14:00	AAPL	Stock	51.1625	51.1625	51.1625	51.1625	10000.0
2019-07-17 08:15:00	AAPL	Stock	51.155	51.1575	51.125	51.125	2960.0
2019-07-17 08:19:00	AAPL	Stock	51.145	51.145	51.145	51.145	580.0
2019-07-17 08:20:00	AAPL	Stock	51.1625	51.1625	51.15	51.15	4840.0
2019-07-17 08:21:00	AAPL	Stock	51.15	51.15	51.15	51.15	800.0
2019-07-17 08:24:00	AAPL	Stock	51.1375	51.14	51.125	51.1325	4532.0
2019-07-17 08:25:00	AAPL	Stock	51.135	51.135	51.13	51.13	3600.0
2019-07-17 08:27:00	AAPL	Stock	51.1575	51.165	51.135	51.135	1804.0
2019-07-17 08:29:00	AAPL	Stock	51.1275	51.1275	51.125	51.125	3680.0
2019-07-17 08:30:00	AAPL	Stock	51.1325	51.1325	51.125	51.125	4820.0

> showing 50 of 1,079,710 rows — these rows as CSV

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