PREVIEW / stock_1min / 2017-09-11

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-09-11.parquet
  size:    14.5 MB
  rows:    1,058,026
  symbols: 2,454

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-09-11 04:00:00	AAPL	Stock	40.1025	40.1025	40.1025	40.1025	880.0
2017-09-11 04:01:00	AAPL	Stock	40.1	40.1	40.0875	40.0875	3600.0
2017-09-11 04:04:00	AAPL	Stock	40.1025	40.1025	40.1025	40.1025	404.0
2017-09-11 04:05:00	AAPL	Stock	40.1025	40.1025	40.1	40.1	4400.0
2017-09-11 04:09:00	AAPL	Stock	40.0875	40.0875	40.0875	40.0875	960.0
2017-09-11 04:12:00	AAPL	Stock	40.1025	40.1025	40.1025	40.1025	400.0
2017-09-11 04:14:00	AAPL	Stock	40.1	40.125	40.1	40.125	8140.0
2017-09-11 04:16:00	AAPL	Stock	40.1625	40.1625	40.1625	40.1625	716.0
2017-09-11 04:18:00	AAPL	Stock	40.105	40.105	40.1025	40.1025	2800.0
2017-09-11 04:19:00	AAPL	Stock	40.115	40.115	40.115	40.115	3200.0
2017-09-11 04:20:00	AAPL	Stock	40.125	40.125	40.125	40.125	2000.0
2017-09-11 04:24:00	AAPL	Stock	40.1575	40.1575	40.1575	40.1575	400.0
2017-09-11 04:25:00	AAPL	Stock	40.155	40.2	40.155	40.2	7440.0
2017-09-11 04:27:00	AAPL	Stock	40.175	40.175	40.175	40.175	4000.0
2017-09-11 04:28:00	AAPL	Stock	40.175	40.175	40.175	40.175	3556.0
2017-09-11 04:31:00	AAPL	Stock	40.175	40.175	40.175	40.175	1312.0
2017-09-11 04:38:00	AAPL	Stock	40.2175	40.2225	40.2175	40.2225	1208.0
2017-09-11 04:39:00	AAPL	Stock	40.2225	40.2225	40.2225	40.2225	400.0
2017-09-11 04:40:00	AAPL	Stock	40.2225	40.2225	40.2225	40.2225	400.0
2017-09-11 04:41:00	AAPL	Stock	40.2225	40.2225	40.2225	40.2225	1064.0
2017-09-11 04:42:00	AAPL	Stock	40.2225	40.2225	40.2225	40.2225	1200.0
2017-09-11 04:43:00	AAPL	Stock	40.2225	40.2225	40.2225	40.2225	2400.0
2017-09-11 04:45:00	AAPL	Stock	40.2225	40.2225	40.2225	40.2225	1760.0
2017-09-11 04:47:00	AAPL	Stock	40.2175	40.2175	40.2175	40.2175	8000.0
2017-09-11 04:49:00	AAPL	Stock	40.2175	40.2175	40.2175	40.2175	2400.0
2017-09-11 04:51:00	AAPL	Stock	40.2125	40.2125	40.2125	40.2125	1608.0
2017-09-11 04:53:00	AAPL	Stock	40.2175	40.2175	40.2175	40.2175	2800.0
2017-09-11 04:55:00	AAPL	Stock	40.2175	40.2175	40.2175	40.2175	400.0
2017-09-11 04:59:00	AAPL	Stock	40.2175	40.2175	40.2175	40.2175	400.0
2017-09-11 05:02:00	AAPL	Stock	40.2175	40.2175	40.2175	40.2175	3620.0
2017-09-11 05:03:00	AAPL	Stock	40.2175	40.2175	40.2175	40.2175	2000.0
2017-09-11 05:05:00	AAPL	Stock	40.2175	40.2175	40.2175	40.2175	800.0
2017-09-11 05:10:00	AAPL	Stock	40.2225	40.2225	40.2125	40.2125	1644.0
2017-09-11 05:13:00	AAPL	Stock	40.2125	40.2125	40.2125	40.2125	400.0
2017-09-11 05:15:00	AAPL	Stock	40.2125	40.2125	40.2125	40.2125	2000.0
2017-09-11 05:29:00	AAPL	Stock	40.215	40.215	40.2125	40.2125	4000.0
2017-09-11 05:30:00	AAPL	Stock	40.225	40.225	40.2125	40.2125	3000.0
2017-09-11 05:31:00	AAPL	Stock	40.2125	40.2125	40.2125	40.2125	2000.0
2017-09-11 05:36:00	AAPL	Stock	40.2125	40.2125	40.2125	40.2125	4872.0
2017-09-11 05:38:00	AAPL	Stock	40.2125	40.2125	40.2125	40.2125	400.0
2017-09-11 05:40:00	AAPL	Stock	40.2125	40.2125	40.2125	40.2125	400.0
2017-09-11 05:42:00	AAPL	Stock	40.2325	40.2325	40.2325	40.2325	1072.0
2017-09-11 05:43:00	AAPL	Stock	40.235	40.235	40.235	40.235	1712.0
2017-09-11 05:46:00	AAPL	Stock	40.235	40.235	40.235	40.235	2096.0
2017-09-11 05:47:00	AAPL	Stock	40.235	40.24	40.235	40.235	6840.0
2017-09-11 05:59:00	AAPL	Stock	40.2475	40.2575	40.2475	40.2575	3124.0
2017-09-11 06:00:00	AAPL	Stock	40.26	40.26	40.26	40.26	1664.0
2017-09-11 06:01:00	AAPL	Stock	40.2375	40.2375	40.2375	40.2375	3476.0
2017-09-11 06:02:00	AAPL	Stock	40.2375	40.2375	40.2375	40.2375	4496.0
2017-09-11 06:03:00	AAPL	Stock	40.2375	40.2375	40.225	40.225	1852.0

> showing 50 of 1,058,026 rows — these rows as CSV

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