PREVIEW / stock_1min / 2019-11-07

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-11-07.parquet
  size:    16.7 MB
  rows:    1,139,906
  symbols: 2,133

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-07 04:00:00	AAPL	Stock	64.54	64.54	64.4375	64.525	3064.0
2019-11-07 04:01:00	AAPL	Stock	64.55	64.55	64.55	64.55	1076.0
2019-11-07 04:03:00	AAPL	Stock	64.525	64.525	64.525	64.525	2400.0
2019-11-07 04:04:00	AAPL	Stock	64.5475	64.5475	64.5475	64.5475	464.0
2019-11-07 04:05:00	AAPL	Stock	64.53	64.57	64.53	64.57	2284.0
2019-11-07 04:07:00	AAPL	Stock	64.575	64.575	64.575	64.575	8660.0
2019-11-07 04:13:00	AAPL	Stock	64.6	64.6	64.6	64.6	800.0
2019-11-07 04:14:00	AAPL	Stock	64.6	64.6	64.6	64.6	2792.0
2019-11-07 04:15:00	AAPL	Stock	64.6	64.6	64.6	64.6	3992.0
2019-11-07 04:16:00	AAPL	Stock	64.6	64.6	64.6	64.6	800.0
2019-11-07 04:19:00	AAPL	Stock	64.6	64.625	64.6	64.625	5456.0
2019-11-07 04:20:00	AAPL	Stock	64.66	64.66	64.6375	64.6375	800.0
2019-11-07 04:22:00	AAPL	Stock	64.625	64.65	64.625	64.65	800.0
2019-11-07 04:23:00	AAPL	Stock	64.6475	64.6475	64.6475	64.6475	800.0
2019-11-07 04:24:00	AAPL	Stock	64.6475	64.65	64.6475	64.65	5600.0
2019-11-07 04:25:00	AAPL	Stock	64.7	64.7	64.7	64.7	2516.0
2019-11-07 04:27:00	AAPL	Stock	64.65	64.65	64.65	64.65	400.0
2019-11-07 04:28:00	AAPL	Stock	64.6275	64.6275	64.625	64.625	4804.0
2019-11-07 04:32:00	AAPL	Stock	64.6075	64.6225	64.6075	64.6225	1200.0
2019-11-07 04:34:00	AAPL	Stock	64.625	64.625	64.625	64.625	400.0
2019-11-07 04:36:00	AAPL	Stock	64.635	64.64	64.635	64.64	868.0
2019-11-07 04:40:00	AAPL	Stock	64.625	64.65	64.625	64.65	3600.0
2019-11-07 04:42:00	AAPL	Stock	64.625	64.625	64.625	64.625	2800.0
2019-11-07 04:46:00	AAPL	Stock	64.5875	64.6	64.5875	64.5875	7652.0
2019-11-07 04:47:00	AAPL	Stock	64.6	64.6	64.5625	64.5625	2016.0
2019-11-07 04:50:00	AAPL	Stock	64.6	64.6	64.6	64.6	2628.0
2019-11-07 04:51:00	AAPL	Stock	64.6	64.6	64.575	64.575	1168.0
2019-11-07 04:56:00	AAPL	Stock	64.565	64.565	64.5625	64.5625	1200.0
2019-11-07 04:57:00	AAPL	Stock	64.57	64.575	64.57	64.575	3596.0
2019-11-07 04:59:00	AAPL	Stock	64.5525	64.5525	64.5525	64.5525	436.0
2019-11-07 05:01:00	AAPL	Stock	64.5625	64.5625	64.5625	64.5625	1516.0
2019-11-07 05:03:00	AAPL	Stock	64.575	64.575	64.575	64.575	1536.0
2019-11-07 05:08:00	AAPL	Stock	64.575	64.575	64.575	64.575	5664.0
2019-11-07 05:12:00	AAPL	Stock	64.575	64.595	64.575	64.595	1200.0
2019-11-07 05:17:00	AAPL	Stock	64.5775	64.5775	64.575	64.575	2120.0
2019-11-07 05:19:00	AAPL	Stock	64.575	64.575	64.575	64.575	4000.0
2019-11-07 05:20:00	AAPL	Stock	64.575	64.575	64.575	64.575	3200.0
2019-11-07 05:21:00	AAPL	Stock	64.5875	64.5875	64.5875	64.5875	1836.0
2019-11-07 05:22:00	AAPL	Stock	64.575	64.575	64.575	64.575	1416.0
2019-11-07 05:28:00	AAPL	Stock	64.575	64.575	64.575	64.575	2000.0
2019-11-07 05:36:00	AAPL	Stock	64.55	64.55	64.55	64.55	2000.0
2019-11-07 05:39:00	AAPL	Stock	64.55	64.55	64.55	64.55	460.0
2019-11-07 05:41:00	AAPL	Stock	64.5125	64.5125	64.5	64.5	3236.0
2019-11-07 05:42:00	AAPL	Stock	64.505	64.505	64.505	64.505	584.0
2019-11-07 05:43:00	AAPL	Stock	64.505	64.505	64.505	64.505	584.0
2019-11-07 05:52:00	AAPL	Stock	64.505	64.5125	64.505	64.5125	2400.0
2019-11-07 05:53:00	AAPL	Stock	64.52	64.52	64.52	64.52	1316.0
2019-11-07 05:54:00	AAPL	Stock	64.52	64.52	64.52	64.52	800.0
2019-11-07 05:57:00	AAPL	Stock	64.5	64.5	64.5	64.5	1200.0
2019-11-07 05:58:00	AAPL	Stock	64.51	64.51	64.51	64.51	2452.0

> showing 50 of 1,139,906 rows — these rows as CSV

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