PREVIEW / stock_1min / 2018-07-20

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-20.parquet
  size:    14.0 MB
  rows:    1,012,721
  symbols: 2,320

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-20 04:45:00	AAPL	Stock	48.1225	48.125	48.1225	48.125	1200.0
2018-07-20 04:50:00	AAPL	Stock	48.0725	48.0725	48.0725	48.0725	3908.0
2018-07-20 04:52:00	AAPL	Stock	48.0725	48.0725	48.0725	48.0725	3908.0
2018-07-20 05:32:00	AAPL	Stock	48.075	48.075	48.075	48.075	2488.0
2018-07-20 05:45:00	AAPL	Stock	48.075	48.075	48.075	48.075	1348.0
2018-07-20 05:46:00	AAPL	Stock	48.1225	48.1225	48.1225	48.1225	1748.0
2018-07-20 06:13:00	AAPL	Stock	48.015	48.09	48.015	48.09	2400.0
2018-07-20 06:16:00	AAPL	Stock	47.9875	47.9875	47.95	47.95	8968.0
2018-07-20 06:21:00	AAPL	Stock	47.8875	47.8875	47.875	47.875	800.0
2018-07-20 06:22:00	AAPL	Stock	47.8775	47.8775	47.8775	47.8775	400.0
2018-07-20 06:25:00	AAPL	Stock	47.875	47.875	47.85	47.875	5784.0
2018-07-20 06:26:00	AAPL	Stock	47.875	47.875	47.875	47.875	11836.0
2018-07-20 06:27:00	AAPL	Stock	47.825	47.875	47.78	47.845	5280.0
2018-07-20 06:28:00	AAPL	Stock	47.8425	47.8475	47.8425	47.8475	2712.0
2018-07-20 06:32:00	AAPL	Stock	47.8475	47.8475	47.8475	47.8475	700.0
2018-07-20 06:43:00	AAPL	Stock	47.95	47.95	47.95	47.95	800.0
2018-07-20 06:50:00	AAPL	Stock	47.975	47.975	47.975	47.975	400.0
2018-07-20 06:54:00	AAPL	Stock	47.975	47.975	47.975	47.975	3616.0
2018-07-20 07:00:00	AAPL	Stock	47.99	47.99	47.99	47.99	1624.0
2018-07-20 07:03:00	AAPL	Stock	47.975	47.975	47.975	47.975	1200.0
2018-07-20 07:05:00	AAPL	Stock	47.955	47.955	47.955	47.955	1940.0
2018-07-20 07:14:00	AAPL	Stock	47.9625	47.9625	47.9625	47.9625	400.0
2018-07-20 07:15:00	AAPL	Stock	47.9525	47.9525	47.95	47.95	2000.0
2018-07-20 07:16:00	AAPL	Stock	47.94	47.94	47.925	47.925	6000.0
2018-07-20 07:20:00	AAPL	Stock	47.9375	47.9375	47.8925	47.8925	6620.0
2018-07-20 07:21:00	AAPL	Stock	47.925	47.9425	47.925	47.9425	5200.0
2018-07-20 07:22:00	AAPL	Stock	47.975	48.0	47.9675	48.0	4220.0
2018-07-20 07:23:00	AAPL	Stock	48.0	48.025	48.0	48.025	2808.0
2018-07-20 07:27:00	AAPL	Stock	47.9725	47.9725	47.97	47.97	1288.0
2018-07-20 07:29:00	AAPL	Stock	47.95	47.96	47.915	47.96	7292.0
2018-07-20 07:31:00	AAPL	Stock	47.96	47.9625	47.9575	47.9625	4136.0
2018-07-20 07:33:00	AAPL	Stock	47.9875	48.0	47.97	47.97	5100.0
2018-07-20 07:34:00	AAPL	Stock	47.97	47.9975	47.965	47.9975	2880.0
2018-07-20 07:36:00	AAPL	Stock	47.9775	47.9775	47.9725	47.9725	3420.0
2018-07-20 07:37:00	AAPL	Stock	47.9725	47.9725	47.9725	47.9725	8380.0
2018-07-20 07:38:00	AAPL	Stock	47.9525	47.9525	47.93	47.9375	2196.0
2018-07-20 07:39:00	AAPL	Stock	47.94	47.94	47.935	47.935	2196.0
2018-07-20 07:40:00	AAPL	Stock	47.945	47.9625	47.945	47.945	2212.0
2018-07-20 07:41:00	AAPL	Stock	47.945	47.945	47.945	47.945	404.0
2018-07-20 07:42:00	AAPL	Stock	47.96	47.96	47.96	47.96	800.0
2018-07-20 07:43:00	AAPL	Stock	47.95	47.95	47.95	47.95	408.0
2018-07-20 07:44:00	AAPL	Stock	47.95	47.95	47.95	47.95	3648.0
2018-07-20 07:53:00	AAPL	Stock	47.9325	47.9325	47.9325	47.9325	1884.0
2018-07-20 07:57:00	AAPL	Stock	47.95	47.95	47.95	47.95	400.0
2018-07-20 08:00:00	AAPL	Stock	47.995	48.025	47.915	47.9625	29144.0
2018-07-20 08:01:00	AAPL	Stock	47.9625	47.995	47.9625	47.995	5324.0
2018-07-20 08:03:00	AAPL	Stock	47.98	47.98	47.98	47.98	3712.0
2018-07-20 08:04:00	AAPL	Stock	47.98	47.9975	47.98	47.9975	5600.0
2018-07-20 08:05:00	AAPL	Stock	47.9875	47.9875	47.975	47.975	12576.0
2018-07-20 08:07:00	AAPL	Stock	47.9775	47.9775	47.9775	47.9775	1600.0

> showing 50 of 1,012,721 rows — these rows as CSV

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