PREVIEW / stock_1min / 2018-06-18

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-06-18.parquet
  size:    15.5 MB
  rows:    1,102,026
  symbols: 2,367

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-06-18 04:00:00	AAPL	Stock	47.08	47.08	47.04	47.0625	4128.0
2018-06-18 04:07:00	AAPL	Stock	46.9525	46.9525	46.9525	46.9525	400.0
2018-06-18 05:04:00	AAPL	Stock	47.0	47.0	47.0	47.0	400.0
2018-06-18 05:05:00	AAPL	Stock	47.0	47.0	47.0	47.0	724.0
2018-06-18 05:16:00	AAPL	Stock	47.0475	47.0475	47.045	47.045	6800.0
2018-06-18 05:18:00	AAPL	Stock	47.0425	47.0425	47.0425	47.0425	400.0
2018-06-18 05:31:00	AAPL	Stock	47.045	47.045	47.045	47.045	700.0
2018-06-18 05:32:00	AAPL	Stock	47.0	47.0	47.0	47.0	1844.0
2018-06-18 05:38:00	AAPL	Stock	46.9625	46.9625	46.9625	46.9625	784.0
2018-06-18 05:58:00	AAPL	Stock	47.0025	47.0025	47.0025	47.0025	400.0
2018-06-18 06:02:00	AAPL	Stock	47.0	47.0	47.0	47.0	400.0
2018-06-18 06:06:00	AAPL	Stock	46.9775	46.9775	46.9775	46.9775	456.0
2018-06-18 06:16:00	AAPL	Stock	46.9425	46.965	46.9425	46.9425	2000.0
2018-06-18 06:22:00	AAPL	Stock	46.9425	46.9425	46.9425	46.9425	400.0
2018-06-18 06:26:00	AAPL	Stock	46.985	46.985	46.985	46.985	400.0
2018-06-18 06:30:00	AAPL	Stock	46.9175	46.9175	46.9125	46.9125	1564.0
2018-06-18 06:31:00	AAPL	Stock	46.9125	46.9125	46.9125	46.9125	1780.0
2018-06-18 06:32:00	AAPL	Stock	46.92	46.92	46.92	46.92	3200.0
2018-06-18 06:33:00	AAPL	Stock	46.9125	46.9125	46.9	46.9	800.0
2018-06-18 06:45:00	AAPL	Stock	46.9175	46.9175	46.9175	46.9175	400.0
2018-06-18 06:46:00	AAPL	Stock	46.9025	46.9025	46.9025	46.9025	880.0
2018-06-18 07:00:00	AAPL	Stock	46.935	46.9525	46.9	46.93	30148.0
2018-06-18 07:01:00	AAPL	Stock	46.9125	46.9125	46.9125	46.9125	2000.0
2018-06-18 07:05:00	AAPL	Stock	46.9125	46.9125	46.9125	46.9125	400.0
2018-06-18 07:07:00	AAPL	Stock	46.9125	46.9125	46.9025	46.9025	1960.0
2018-06-18 07:10:00	AAPL	Stock	46.92	46.9225	46.9	46.9	2800.0
2018-06-18 07:11:00	AAPL	Stock	46.9	46.9	46.9	46.9	1916.0
2018-06-18 07:12:00	AAPL	Stock	46.915	46.915	46.915	46.915	9968.0
2018-06-18 07:13:00	AAPL	Stock	46.9175	46.9175	46.905	46.905	4440.0
2018-06-18 07:15:00	AAPL	Stock	46.9025	46.905	46.9025	46.9025	6000.0
2018-06-18 07:16:00	AAPL	Stock	46.9	46.9	46.9	46.9	400.0
2018-06-18 07:17:00	AAPL	Stock	46.9	46.9	46.9	46.9	5600.0
2018-06-18 07:18:00	AAPL	Stock	46.895	46.895	46.895	46.895	3584.0
2018-06-18 07:29:00	AAPL	Stock	46.9	46.91	46.9	46.91	2680.0
2018-06-18 07:31:00	AAPL	Stock	46.925	46.925	46.92	46.925	4872.0
2018-06-18 07:34:00	AAPL	Stock	46.95	46.95	46.95	46.95	8360.0
2018-06-18 07:35:00	AAPL	Stock	46.945	46.945	46.94	46.94	2800.0
2018-06-18 07:37:00	AAPL	Stock	46.94	46.94	46.94	46.94	400.0
2018-06-18 07:38:00	AAPL	Stock	46.935	46.935	46.935	46.935	800.0
2018-06-18 07:39:00	AAPL	Stock	46.935	46.935	46.935	46.935	400.0
2018-06-18 07:40:00	AAPL	Stock	46.935	46.935	46.93	46.93	13956.0
2018-06-18 07:41:00	AAPL	Stock	46.9275	46.93	46.9125	46.93	16424.0
2018-06-18 07:45:00	AAPL	Stock	46.925	46.925	46.925	46.925	7960.0
2018-06-18 07:53:00	AAPL	Stock	46.9	46.9	46.875	46.875	15520.0
2018-06-18 07:57:00	AAPL	Stock	46.875	46.875	46.875	46.875	400.0
2018-06-18 08:00:00	AAPL	Stock	46.9125	46.9475	46.875	46.8775	76416.0
2018-06-18 08:01:00	AAPL	Stock	46.8775	46.9	46.8775	46.8825	5000.0
2018-06-18 08:02:00	AAPL	Stock	46.8925	46.8925	46.8925	46.8925	576.0
2018-06-18 08:03:00	AAPL	Stock	46.885	46.885	46.885	46.885	1508.0
2018-06-18 08:04:00	AAPL	Stock	46.9	46.9	46.9	46.9	416.0

> showing 50 of 1,102,026 rows — these rows as CSV

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