PREVIEW / stock_1min / 2018-07-12

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-07-12.parquet
  size:    14.7 MB
  rows:    1,064,619
  symbols: 2,351

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-07-12 04:00:00	AAPL	Stock	47.1175	47.1175	47.1175	47.1175	400.0
2018-07-12 04:08:00	AAPL	Stock	47.1525	47.1525	47.1525	47.1525	1200.0
2018-07-12 04:17:00	AAPL	Stock	47.1525	47.1525	47.1525	47.1525	1756.0
2018-07-12 04:33:00	AAPL	Stock	47.1525	47.1525	47.1525	47.1525	1200.0
2018-07-12 04:55:00	AAPL	Stock	47.1525	47.1525	47.1525	47.1525	2432.0
2018-07-12 05:15:00	AAPL	Stock	47.15	47.15	47.15	47.15	2800.0
2018-07-12 06:07:00	AAPL	Stock	47.0875	47.0875	47.0875	47.0875	400.0
2018-07-12 06:32:00	AAPL	Stock	47.23	47.23	47.23	47.23	1200.0
2018-07-12 06:54:00	AAPL	Stock	47.235	47.25	47.235	47.25	1400.0
2018-07-12 06:55:00	AAPL	Stock	47.25	47.25	47.25	47.25	1300.0
2018-07-12 06:56:00	AAPL	Stock	47.2625	47.2625	47.2625	47.2625	800.0
2018-07-12 07:00:00	AAPL	Stock	47.2625	47.2625	47.25	47.2625	4236.0
2018-07-12 07:01:00	AAPL	Stock	47.2725	47.29	47.2725	47.285	8392.0
2018-07-12 07:03:00	AAPL	Stock	47.29	47.29	47.29	47.29	760.0
2018-07-12 07:05:00	AAPL	Stock	47.2575	47.2575	47.2575	47.2575	1600.0
2018-07-12 07:06:00	AAPL	Stock	47.2575	47.2575	47.255	47.255	1200.0
2018-07-12 07:07:00	AAPL	Stock	47.2625	47.2725	47.2625	47.2725	1308.0
2018-07-12 07:08:00	AAPL	Stock	47.2775	47.28	47.2775	47.28	1600.0
2018-07-12 07:09:00	AAPL	Stock	47.285	47.285	47.285	47.285	400.0
2018-07-12 07:11:00	AAPL	Stock	47.2775	47.2775	47.2775	47.2775	1860.0
2018-07-12 07:12:00	AAPL	Stock	47.285	47.285	47.285	47.285	400.0
2018-07-12 07:13:00	AAPL	Stock	47.285	47.285	47.27	47.27	3780.0
2018-07-12 07:15:00	AAPL	Stock	47.2825	47.2825	47.2825	47.2825	2900.0
2018-07-12 07:19:00	AAPL	Stock	47.28	47.28	47.28	47.28	4000.0
2018-07-12 07:22:00	AAPL	Stock	47.285	47.2875	47.285	47.2875	4400.0
2018-07-12 07:23:00	AAPL	Stock	47.2875	47.29	47.2875	47.29	8644.0
2018-07-12 07:24:00	AAPL	Stock	47.2875	47.2875	47.2875	47.2875	1400.0
2018-07-12 07:27:00	AAPL	Stock	47.2975	47.2975	47.2975	47.2975	400.0
2018-07-12 07:28:00	AAPL	Stock	47.29	47.29	47.2775	47.2775	3000.0
2018-07-12 07:29:00	AAPL	Stock	47.2625	47.2625	47.2625	47.2625	400.0
2018-07-12 07:30:00	AAPL	Stock	47.2675	47.2675	47.2675	47.2675	400.0
2018-07-12 07:31:00	AAPL	Stock	47.275	47.275	47.275	47.275	1680.0
2018-07-12 07:33:00	AAPL	Stock	47.2825	47.2825	47.2825	47.2825	400.0
2018-07-12 07:35:00	AAPL	Stock	47.2725	47.2725	47.2725	47.2725	400.0
2018-07-12 07:38:00	AAPL	Stock	47.2775	47.2775	47.2775	47.2775	488.0
2018-07-12 07:44:00	AAPL	Stock	47.2775	47.2875	47.2725	47.2725	10200.0
2018-07-12 07:50:00	AAPL	Stock	47.27	47.29	47.27	47.2825	6036.0
2018-07-12 07:51:00	AAPL	Stock	47.29	47.29	47.29	47.29	400.0
2018-07-12 07:54:00	AAPL	Stock	47.29	47.29	47.29	47.29	1080.0
2018-07-12 07:57:00	AAPL	Stock	47.3	47.3	47.3	47.3	400.0
2018-07-12 08:00:00	AAPL	Stock	47.2675	47.3125	47.2525	47.275	58568.0
2018-07-12 08:02:00	AAPL	Stock	47.2825	47.2825	47.2625	47.2625	1188.0
2018-07-12 08:03:00	AAPL	Stock	47.275	47.275	47.275	47.275	1900.0
2018-07-12 08:04:00	AAPL	Stock	47.275	47.28	47.275	47.28	2008.0
2018-07-12 08:05:00	AAPL	Stock	47.2925	47.3	47.2925	47.3	3600.0
2018-07-12 08:06:00	AAPL	Stock	47.3125	47.325	47.305	47.325	38844.0
2018-07-12 08:07:00	AAPL	Stock	47.3125	47.3175	47.29	47.29	3600.0
2018-07-12 08:08:00	AAPL	Stock	47.29	47.29	47.29	47.29	2216.0
2018-07-12 08:09:00	AAPL	Stock	47.29	47.29	47.2875	47.2875	15600.0
2018-07-12 08:11:00	AAPL	Stock	47.2775	47.2775	47.2625	47.2775	2060.0

> showing 50 of 1,064,619 rows — these rows as CSV

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