PREVIEW / stock_1min / 2019-08-21

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-08-21.parquet
  size:    14.8 MB
  rows:    1,056,201
  symbols: 2,166

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-08-21 04:00:00	AAPL	Stock	52.775	52.775	52.775	52.775	552.0
2019-08-21 04:06:00	AAPL	Stock	52.91	52.91	52.91	52.91	748.0
2019-08-21 04:10:00	AAPL	Stock	52.995	52.995	52.965	52.965	800.0
2019-08-21 04:12:00	AAPL	Stock	52.9975	53.0	52.9975	53.0	2400.0
2019-08-21 04:13:00	AAPL	Stock	53.06	53.11	53.06	53.11	6708.0
2019-08-21 04:15:00	AAPL	Stock	53.0475	53.0475	53.045	53.045	800.0
2019-08-21 04:17:00	AAPL	Stock	53.065	53.065	53.065	53.065	400.0
2019-08-21 04:22:00	AAPL	Stock	53.015	53.015	53.015	53.015	400.0
2019-08-21 04:28:00	AAPL	Stock	53.05	53.05	53.05	53.05	1172.0
2019-08-21 04:33:00	AAPL	Stock	53.045	53.045	53.045	53.045	3600.0
2019-08-21 04:37:00	AAPL	Stock	53.08	53.08	53.08	53.08	1200.0
2019-08-21 04:40:00	AAPL	Stock	53.075	53.075	53.075	53.075	1200.0
2019-08-21 04:41:00	AAPL	Stock	53.135	53.135	53.135	53.135	460.0
2019-08-21 04:49:00	AAPL	Stock	53.135	53.135	53.135	53.135	800.0
2019-08-21 05:07:00	AAPL	Stock	53.1125	53.1125	53.1125	53.1125	1200.0
2019-08-21 05:08:00	AAPL	Stock	53.1125	53.1125	53.1125	53.1125	2400.0
2019-08-21 05:18:00	AAPL	Stock	53.125	53.125	53.125	53.125	400.0
2019-08-21 05:19:00	AAPL	Stock	53.1	53.1	53.1	53.1	1708.0
2019-08-21 05:21:00	AAPL	Stock	53.0875	53.0875	53.0875	53.0875	400.0
2019-08-21 05:22:00	AAPL	Stock	53.1125	53.125	53.1125	53.125	11936.0
2019-08-21 05:23:00	AAPL	Stock	53.125	53.125	53.125	53.125	2000.0
2019-08-21 05:27:00	AAPL	Stock	53.15	53.15	53.15	53.15	908.0
2019-08-21 05:28:00	AAPL	Stock	53.15	53.15	53.15	53.15	1200.0
2019-08-21 05:31:00	AAPL	Stock	53.1525	53.1525	53.1525	53.1525	400.0
2019-08-21 05:49:00	AAPL	Stock	53.2	53.2	53.2	53.2	440.0
2019-08-21 05:51:00	AAPL	Stock	53.1325	53.1325	53.125	53.125	1600.0
2019-08-21 05:52:00	AAPL	Stock	53.0975	53.0975	53.0975	53.0975	2000.0
2019-08-21 05:53:00	AAPL	Stock	53.1	53.1125	53.09	53.1125	4872.0
2019-08-21 05:54:00	AAPL	Stock	53.1125	53.1125	53.1125	53.1125	1200.0
2019-08-21 06:02:00	AAPL	Stock	53.09	53.09	53.09	53.09	472.0
2019-08-21 06:03:00	AAPL	Stock	53.09	53.09	53.08	53.08	11664.0
2019-08-21 06:05:00	AAPL	Stock	53.045	53.045	53.045	53.045	1676.0
2019-08-21 06:07:00	AAPL	Stock	53.045	53.045	53.045	53.045	2000.0
2019-08-21 06:09:00	AAPL	Stock	53.045	53.045	53.045	53.045	1600.0
2019-08-21 06:10:00	AAPL	Stock	53.08	53.08	53.08	53.08	400.0
2019-08-21 06:23:00	AAPL	Stock	53.08	53.08	53.08	53.08	1600.0
2019-08-21 06:37:00	AAPL	Stock	53.1125	53.1125	53.1125	53.1125	400.0
2019-08-21 06:44:00	AAPL	Stock	53.055	53.055	53.05	53.05	1580.0
2019-08-21 06:47:00	AAPL	Stock	53.0675	53.0675	53.0675	53.0675	4000.0
2019-08-21 06:58:00	AAPL	Stock	53.1125	53.1125	53.1125	53.1125	800.0
2019-08-21 06:59:00	AAPL	Stock	53.0775	53.0775	53.075	53.075	2400.0
2019-08-21 07:00:00	AAPL	Stock	53.1	53.1	53.0475	53.0475	9924.0
2019-08-21 07:01:00	AAPL	Stock	53.0375	53.0375	53.0	53.0	8736.0
2019-08-21 07:02:00	AAPL	Stock	53.0125	53.0475	53.0125	53.0475	1428.0
2019-08-21 07:03:00	AAPL	Stock	53.015	53.03	53.0125	53.03	4228.0
2019-08-21 07:04:00	AAPL	Stock	53.0075	53.0075	53.0075	53.0075	1428.0
2019-08-21 07:05:00	AAPL	Stock	53.03	53.0625	53.03	53.045	8360.0
2019-08-21 07:06:00	AAPL	Stock	53.045	53.05	53.045	53.05	1760.0
2019-08-21 07:07:00	AAPL	Stock	53.05	53.05	53.05	53.05	600.0
2019-08-21 07:08:00	AAPL	Stock	53.055	53.055	53.055	53.055	460.0

> showing 50 of 1,056,201 rows — these rows as CSV

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