PREVIEW / stock_1min / 2018-03-05

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-03-05.parquet
  size:    15.8 MB
  rows:    1,119,230
  symbols: 2,393

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-03-05 04:00:00	AAPL	Stock	44.025	44.025	44.025	44.025	2000.0
2018-03-05 04:02:00	AAPL	Stock	44.0225	44.0225	44.0225	44.0225	400.0
2018-03-05 04:08:00	AAPL	Stock	43.9275	43.9275	43.9275	43.9275	1200.0
2018-03-05 04:18:00	AAPL	Stock	43.9425	43.9425	43.9425	43.9425	400.0
2018-03-05 04:28:00	AAPL	Stock	43.8825	43.8825	43.8825	43.8825	800.0
2018-03-05 04:30:00	AAPL	Stock	43.8825	43.8825	43.8825	43.8825	400.0
2018-03-05 04:32:00	AAPL	Stock	43.8575	43.8575	43.8575	43.8575	800.0
2018-03-05 04:39:00	AAPL	Stock	43.8575	43.8825	43.85	43.8825	14760.0
2018-03-05 04:40:00	AAPL	Stock	43.8825	43.8825	43.8825	43.8825	9460.0
2018-03-05 04:47:00	AAPL	Stock	43.9725	43.985	43.9725	43.985	5780.0
2018-03-05 04:50:00	AAPL	Stock	43.9875	43.9875	43.9875	43.9875	2800.0
2018-03-05 04:51:00	AAPL	Stock	43.9875	43.9875	43.9875	43.9875	5600.0
2018-03-05 04:54:00	AAPL	Stock	44.0125	44.0125	43.9875	43.9875	1200.0
2018-03-05 04:55:00	AAPL	Stock	43.9925	43.9925	43.9925	43.9925	4604.0
2018-03-05 04:56:00	AAPL	Stock	44.0	44.0	44.0	44.0	2800.0
2018-03-05 04:57:00	AAPL	Stock	44.0	44.0025	43.9975	43.9975	8824.0
2018-03-05 05:13:00	AAPL	Stock	43.9975	43.9975	43.9975	43.9975	400.0
2018-03-05 05:15:00	AAPL	Stock	43.975	43.975	43.975	43.975	2000.0
2018-03-05 05:19:00	AAPL	Stock	43.95	43.95	43.95	43.95	1600.0
2018-03-05 05:20:00	AAPL	Stock	43.9975	43.9975	43.9975	43.9975	3580.0
2018-03-05 05:21:00	AAPL	Stock	43.9975	44.0	43.9975	44.0	12800.0
2018-03-05 05:23:00	AAPL	Stock	43.9975	43.9975	43.9975	43.9975	4400.0
2018-03-05 05:25:00	AAPL	Stock	43.9975	44.0	43.9975	44.0	11956.0
2018-03-05 05:26:00	AAPL	Stock	44.0	44.0	44.0	44.0	8684.0
2018-03-05 05:30:00	AAPL	Stock	43.96	43.96	43.96	43.96	660.0
2018-03-05 05:38:00	AAPL	Stock	44.0	44.0	44.0	44.0	1596.0
2018-03-05 05:39:00	AAPL	Stock	44.0	44.0	44.0	44.0	6000.0
2018-03-05 05:42:00	AAPL	Stock	44.0	44.0	44.0	44.0	400.0
2018-03-05 05:43:00	AAPL	Stock	44.0	44.0	44.0	44.0	1600.0
2018-03-05 05:46:00	AAPL	Stock	44.0375	44.0425	44.0375	44.0425	2000.0
2018-03-05 05:47:00	AAPL	Stock	44.045	44.0475	44.045	44.0475	6400.0
2018-03-05 05:54:00	AAPL	Stock	44.0525	44.0525	44.0525	44.0525	1600.0
2018-03-05 06:00:00	AAPL	Stock	44.07	44.07	44.07	44.07	1200.0
2018-03-05 06:04:00	AAPL	Stock	44.055	44.055	44.055	44.055	772.0
2018-03-05 06:05:00	AAPL	Stock	44.0625	44.075	44.0625	44.0725	5784.0
2018-03-05 06:12:00	AAPL	Stock	44.03	44.03	43.975	43.975	13332.0
2018-03-05 06:20:00	AAPL	Stock	44.0	44.0	44.0	44.0	760.0
2018-03-05 06:21:00	AAPL	Stock	43.9975	43.9975	43.9975	43.9975	400.0
2018-03-05 06:24:00	AAPL	Stock	44.01	44.01	44.01	44.01	400.0
2018-03-05 06:25:00	AAPL	Stock	44.0025	44.01	44.0025	44.01	800.0
2018-03-05 06:26:00	AAPL	Stock	44.01	44.01	44.01	44.01	14288.0
2018-03-05 06:38:00	AAPL	Stock	43.9775	43.9775	43.9775	43.9775	400.0
2018-03-05 06:53:00	AAPL	Stock	44.01	44.01	44.01	44.01	400.0
2018-03-05 06:58:00	AAPL	Stock	44.0075	44.0125	43.995	44.005	4000.0
2018-03-05 07:00:00	AAPL	Stock	43.975	43.98	43.9475	43.9475	14948.0
2018-03-05 07:01:00	AAPL	Stock	43.94	43.9425	43.94	43.9425	4124.0
2018-03-05 07:02:00	AAPL	Stock	43.9425	43.9425	43.9425	43.9425	1968.0
2018-03-05 07:03:00	AAPL	Stock	43.945	43.9725	43.945	43.9725	4788.0
2018-03-05 07:04:00	AAPL	Stock	43.95	43.975	43.95	43.95	4140.0
2018-03-05 07:10:00	AAPL	Stock	43.975	43.9875	43.975	43.9875	23364.0

> showing 50 of 1,119,230 rows — these rows as CSV

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