PREVIEW / stock_1min / 2017-08-07

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-08-07.parquet
  size:    14.1 MB
  rows:    1,022,641
  symbols: 2,474

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
2017-08-07 04:03:00	AAPL	Stock	39.275	39.275	39.275	39.275	6744.0
2017-08-07 04:12:00	AAPL	Stock	39.275	39.275	39.275	39.275	4000.0
2017-08-07 04:15:00	AAPL	Stock	39.2375	39.2375	39.2375	39.2375	1956.0
2017-08-07 04:39:00	AAPL	Stock	39.2625	39.2625	39.2625	39.2625	1860.0
2017-08-07 05:00:00	AAPL	Stock	39.2625	39.2625	39.2625	39.2625	896.0
2017-08-07 05:01:00	AAPL	Stock	39.2625	39.2625	39.2625	39.2625	800.0
2017-08-07 05:17:00	AAPL	Stock	39.2675	39.2675	39.25	39.25	800.0
2017-08-07 05:23:00	AAPL	Stock	39.245	39.245	39.245	39.245	400.0
2017-08-07 05:24:00	AAPL	Stock	39.245	39.245	39.245	39.245	400.0
2017-08-07 05:25:00	AAPL	Stock	39.245	39.245	39.245	39.245	400.0
2017-08-07 05:39:00	AAPL	Stock	39.245	39.245	39.245	39.245	1652.0
2017-08-07 05:42:00	AAPL	Stock	39.2125	39.2125	39.2125	39.2125	412.0
2017-08-07 05:43:00	AAPL	Stock	39.2125	39.2125	39.2125	39.2125	1200.0
2017-08-07 05:44:00	AAPL	Stock	39.2425	39.2425	39.2425	39.2425	400.0
2017-08-07 06:13:00	AAPL	Stock	39.205	39.205	39.2025	39.2025	2600.0
2017-08-07 06:29:00	AAPL	Stock	39.2375	39.24	39.2375	39.24	5600.0
2017-08-07 06:33:00	AAPL	Stock	39.2375	39.2375	39.2375	39.2375	400.0
2017-08-07 06:40:00	AAPL	Stock	39.2325	39.2325	39.2325	39.2325	400.0
2017-08-07 06:42:00	AAPL	Stock	39.225	39.225	39.225	39.225	1200.0
2017-08-07 06:51:00	AAPL	Stock	39.205	39.205	39.205	39.205	1080.0
2017-08-07 06:52:00	AAPL	Stock	39.205	39.225	39.205	39.225	2500.0
2017-08-07 07:05:00	AAPL	Stock	39.215	39.215	39.2125	39.2125	2520.0
2017-08-07 07:06:00	AAPL	Stock	39.2125	39.2125	39.205	39.205	5428.0
2017-08-07 07:07:00	AAPL	Stock	39.22	39.225	39.22	39.2225	2400.0
2017-08-07 07:10:00	AAPL	Stock	39.2225	39.2225	39.2225	39.2225	540.0
2017-08-07 07:12:00	AAPL	Stock	39.205	39.205	39.205	39.205	400.0
2017-08-07 07:15:00	AAPL	Stock	39.2225	39.225	39.2225	39.225	1200.0
2017-08-07 07:16:00	AAPL	Stock	39.225	39.225	39.225	39.225	6400.0
2017-08-07 07:18:00	AAPL	Stock	39.2125	39.2125	39.2125	39.2125	400.0
2017-08-07 07:22:00	AAPL	Stock	39.205	39.205	39.205	39.205	5688.0
2017-08-07 07:23:00	AAPL	Stock	39.205	39.205	39.205	39.205	2636.0
2017-08-07 07:27:00	AAPL	Stock	39.2125	39.2125	39.2	39.2	1800.0
2017-08-07 07:29:00	AAPL	Stock	39.2075	39.2075	39.2	39.2	3992.0
2017-08-07 07:30:00	AAPL	Stock	39.1875	39.1875	39.1875	39.1875	1200.0
2017-08-07 07:31:00	AAPL	Stock	39.1875	39.1875	39.1875	39.1875	4800.0
2017-08-07 07:38:00	AAPL	Stock	39.2075	39.2075	39.2	39.2	1936.0
2017-08-07 07:39:00	AAPL	Stock	39.2	39.2	39.2	39.2	400.0
2017-08-07 07:41:00	AAPL	Stock	39.2	39.2125	39.2	39.2125	1304.0
2017-08-07 07:42:00	AAPL	Stock	39.2125	39.2125	39.2125	39.2125	15096.0
2017-08-07 07:43:00	AAPL	Stock	39.2	39.2	39.1975	39.1975	8000.0
2017-08-07 07:45:00	AAPL	Stock	39.1975	39.1975	39.1975	39.1975	1600.0
2017-08-07 07:51:00	AAPL	Stock	39.21	39.22	39.21	39.22	11880.0
2017-08-07 07:56:00	AAPL	Stock	39.21	39.21	39.21	39.21	400.0
2017-08-07 08:00:00	AAPL	Stock	39.2125	39.2375	39.1875	39.22	45288.0
2017-08-07 08:01:00	AAPL	Stock	39.2125	39.2125	39.2125	39.2125	800.0
2017-08-07 08:02:00	AAPL	Stock	39.2125	39.2125	39.2125	39.2125	560.0
2017-08-07 08:04:00	AAPL	Stock	39.015	39.015	39.015	39.015	6000.0
2017-08-07 08:06:00	AAPL	Stock	39.1925	39.1925	39.19	39.19	4792.0
2017-08-07 08:07:00	AAPL	Stock	39.2075	39.2075	39.2075	39.2075	800.0
2017-08-07 08:08:00	AAPL	Stock	39.21	39.21	39.21	39.21	400.0

> showing 50 of 1,022,641 rows — these rows as CSV

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