PREVIEW / stock_1min / 2018-09-04

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-09-04.parquet
  size:    15.5 MB
  rows:    1,090,546
  symbols: 2,340

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-09-04 04:00:00	AAPL	Stock	57.0625	57.0625	57.0625	57.0625	400.0
2018-09-04 04:01:00	AAPL	Stock	57.075	57.075	57.075	57.075	400.0
2018-09-04 04:03:00	AAPL	Stock	57.1225	57.1225	57.1225	57.1225	2000.0
2018-09-04 04:04:00	AAPL	Stock	57.1225	57.125	57.1225	57.125	9040.0
2018-09-04 04:05:00	AAPL	Stock	57.1375	57.1375	57.1375	57.1375	400.0
2018-09-04 04:08:00	AAPL	Stock	57.1725	57.1725	57.1725	57.1725	480.0
2018-09-04 04:10:00	AAPL	Stock	57.1725	57.175	57.1725	57.175	800.0
2018-09-04 04:11:00	AAPL	Stock	57.1375	57.1375	57.125	57.125	4852.0
2018-09-04 04:15:00	AAPL	Stock	57.125	57.15	57.125	57.125	2576.0
2018-09-04 04:17:00	AAPL	Stock	57.12	57.12	57.12	57.12	400.0
2018-09-04 04:22:00	AAPL	Stock	57.11	57.11	57.1075	57.1075	1204.0
2018-09-04 04:23:00	AAPL	Stock	57.12	57.12	57.12	57.12	1200.0
2018-09-04 04:26:00	AAPL	Stock	57.1175	57.1175	57.1175	57.1175	1200.0
2018-09-04 04:28:00	AAPL	Stock	57.1175	57.1175	57.1175	57.1175	1200.0
2018-09-04 04:32:00	AAPL	Stock	57.095	57.095	57.0875	57.0875	5600.0
2018-09-04 04:35:00	AAPL	Stock	57.09	57.09	57.09	57.09	4316.0
2018-09-04 04:46:00	AAPL	Stock	57.09	57.12	57.09	57.12	9220.0
2018-09-04 04:57:00	AAPL	Stock	57.125	57.125	57.125	57.125	4000.0
2018-09-04 05:01:00	AAPL	Stock	57.125	57.125	57.125	57.125	3200.0
2018-09-04 05:06:00	AAPL	Stock	57.1	57.1	57.1	57.1	560.0
2018-09-04 05:08:00	AAPL	Stock	57.0875	57.0875	57.0875	57.0875	4676.0
2018-09-04 05:09:00	AAPL	Stock	57.1	57.1	57.1	57.1	2000.0
2018-09-04 05:10:00	AAPL	Stock	57.1	57.1	57.0875	57.0875	4088.0
2018-09-04 05:24:00	AAPL	Stock	57.0875	57.0875	57.0875	57.0875	600.0
2018-09-04 05:29:00	AAPL	Stock	57.0775	57.0775	57.075	57.075	1480.0
2018-09-04 05:30:00	AAPL	Stock	57.075	57.075	57.075	57.075	800.0
2018-09-04 05:35:00	AAPL	Stock	57.0325	57.0325	57.0325	57.0325	2000.0
2018-09-04 05:37:00	AAPL	Stock	57.02	57.02	57.02	57.02	6016.0
2018-09-04 05:59:00	AAPL	Stock	57.0775	57.0775	57.0775	57.0775	400.0
2018-09-04 06:00:00	AAPL	Stock	57.065	57.065	57.0625	57.0625	4752.0
2018-09-04 06:02:00	AAPL	Stock	57.025	57.025	57.025	57.025	2800.0
2018-09-04 06:08:00	AAPL	Stock	57.01	57.01	57.01	57.01	400.0
2018-09-04 06:11:00	AAPL	Stock	57.085	57.085	57.085	57.085	800.0
2018-09-04 06:13:00	AAPL	Stock	57.04	57.04	57.04	57.04	3044.0
2018-09-04 06:15:00	AAPL	Stock	57.07	57.07	57.07	57.07	400.0
2018-09-04 06:22:00	AAPL	Stock	57.0425	57.0425	57.0425	57.0425	540.0
2018-09-04 06:24:00	AAPL	Stock	57.07	57.07	57.07	57.07	3600.0
2018-09-04 06:31:00	AAPL	Stock	57.065	57.065	57.065	57.065	400.0
2018-09-04 06:36:00	AAPL	Stock	57.04	57.0625	57.04	57.0625	3424.0
2018-09-04 06:37:00	AAPL	Stock	57.05	57.05	57.05	57.05	2000.0
2018-09-04 06:39:00	AAPL	Stock	57.0625	57.0625	57.0625	57.0625	600.0
2018-09-04 06:45:00	AAPL	Stock	57.025	57.025	57.025	57.025	400.0
2018-09-04 06:51:00	AAPL	Stock	57.0	57.0	57.0	57.0	400.0
2018-09-04 06:52:00	AAPL	Stock	56.99	56.99	56.99	56.99	2000.0
2018-09-04 06:59:00	AAPL	Stock	57.0325	57.0375	57.0325	57.0375	2000.0
2018-09-04 07:00:00	AAPL	Stock	57.0125	57.0575	57.0125	57.0375	29028.0
2018-09-04 07:01:00	AAPL	Stock	57.045	57.0625	57.045	57.0625	13400.0
2018-09-04 07:02:00	AAPL	Stock	57.0825	57.0825	57.055	57.055	40868.0
2018-09-04 07:03:00	AAPL	Stock	57.0625	57.075	57.0625	57.065	3052.0
2018-09-04 07:04:00	AAPL	Stock	57.0575	57.075	57.0575	57.0575	10700.0

> showing 50 of 1,090,546 rows — these rows as CSV

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