PREVIEW / stock_1min / 2017-06-21

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-06-21.parquet
  size:    14.4 MB
  rows:    1,048,267
  symbols: 2,497

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-06-21 04:00:00	AAPL	Stock	36.17	36.17	36.17	36.17	400.0
2017-06-21 04:23:00	AAPL	Stock	36.0875	36.0875	36.0875	36.0875	800.0
2017-06-21 04:41:00	AAPL	Stock	36.1475	36.1475	36.1475	36.1475	1620.0
2017-06-21 04:44:00	AAPL	Stock	36.175	36.175	36.175	36.175	4000.0
2017-06-21 05:25:00	AAPL	Stock	36.1475	36.1475	36.1475	36.1475	2428.0
2017-06-21 05:26:00	AAPL	Stock	36.1475	36.1475	36.1475	36.1475	8792.0
2017-06-21 05:27:00	AAPL	Stock	36.135	36.135	36.135	36.135	1040.0
2017-06-21 05:30:00	AAPL	Stock	36.1475	36.1475	36.1475	36.1475	3948.0
2017-06-21 05:36:00	AAPL	Stock	36.1475	36.1475	36.1475	36.1475	400.0
2017-06-21 05:37:00	AAPL	Stock	36.1475	36.1475	36.1475	36.1475	2800.0
2017-06-21 05:38:00	AAPL	Stock	36.135	36.135	36.135	36.135	2800.0
2017-06-21 05:42:00	AAPL	Stock	36.135	36.135	36.135	36.135	416.0
2017-06-21 05:47:00	AAPL	Stock	36.135	36.135	36.135	36.135	400.0
2017-06-21 06:02:00	AAPL	Stock	36.1275	36.1275	36.125	36.125	2224.0
2017-06-21 06:04:00	AAPL	Stock	36.105	36.105	36.1	36.1	932.0
2017-06-21 06:48:00	AAPL	Stock	36.1275	36.1275	36.1275	36.1275	1200.0
2017-06-21 06:50:00	AAPL	Stock	36.14	36.14	36.14	36.14	1200.0
2017-06-21 06:51:00	AAPL	Stock	36.125	36.125	36.125	36.125	1200.0
2017-06-21 06:52:00	AAPL	Stock	36.15	36.15	36.15	36.15	400.0
2017-06-21 06:54:00	AAPL	Stock	36.1625	36.1625	36.1625	36.1625	1360.0
2017-06-21 06:59:00	AAPL	Stock	36.1825	36.1825	36.1825	36.1825	720.0
2017-06-21 07:01:00	AAPL	Stock	36.1875	36.1875	36.1875	36.1875	1988.0
2017-06-21 07:05:00	AAPL	Stock	36.185	36.185	36.185	36.185	1200.0
2017-06-21 07:09:00	AAPL	Stock	36.1875	36.1875	36.1875	36.1875	400.0
2017-06-21 07:13:00	AAPL	Stock	36.1875	36.1875	36.1875	36.1875	400.0
2017-06-21 07:16:00	AAPL	Stock	36.175	36.175	36.175	36.175	2700.0
2017-06-21 07:23:00	AAPL	Stock	36.165	36.165	36.165	36.165	400.0
2017-06-21 07:32:00	AAPL	Stock	36.1525	36.1525	36.1525	36.1525	400.0
2017-06-21 07:33:00	AAPL	Stock	36.1525	36.1525	36.1525	36.1525	400.0
2017-06-21 07:36:00	AAPL	Stock	36.15	36.15	36.15	36.15	1564.0
2017-06-21 07:52:00	AAPL	Stock	36.185	36.185	36.185	36.185	400.0
2017-06-21 07:53:00	AAPL	Stock	36.185	36.185	36.185	36.185	536.0
2017-06-21 07:55:00	AAPL	Stock	36.185	36.185	36.185	36.185	400.0
2017-06-21 07:57:00	AAPL	Stock	36.1875	36.1875	36.1825	36.1825	4132.0
2017-06-21 07:58:00	AAPL	Stock	36.185	36.1875	36.185	36.1875	3200.0
2017-06-21 08:00:00	AAPL	Stock	36.2075	36.21	36.125	36.1875	26216.0
2017-06-21 08:01:00	AAPL	Stock	36.205	36.205	36.205	36.205	1200.0
2017-06-21 08:03:00	AAPL	Stock	36.205	36.205	36.205	36.205	800.0
2017-06-21 08:04:00	AAPL	Stock	36.2025	36.2025	36.2025	36.2025	3600.0
2017-06-21 08:07:00	AAPL	Stock	36.23	36.23	36.23	36.23	440.0
2017-06-21 08:10:00	AAPL	Stock	36.21	36.21	36.21	36.21	1200.0
2017-06-21 08:11:00	AAPL	Stock	36.21	36.21	36.21	36.21	900.0
2017-06-21 08:16:00	AAPL	Stock	36.225	36.2375	36.225	36.2375	8000.0
2017-06-21 08:17:00	AAPL	Stock	36.245	36.245	36.245	36.245	400.0
2017-06-21 08:19:00	AAPL	Stock	36.2675	36.275	36.2675	36.275	2812.0
2017-06-21 08:20:00	AAPL	Stock	36.29	36.3	36.29	36.3	10636.0
2017-06-21 08:24:00	AAPL	Stock	36.295	36.3125	36.295	36.3125	3864.0
2017-06-21 08:25:00	AAPL	Stock	36.33	36.3325	36.3275	36.3325	5088.0
2017-06-21 08:27:00	AAPL	Stock	36.3325	36.3325	36.33	36.33	4000.0
2017-06-21 08:28:00	AAPL	Stock	36.3275	36.3275	36.3275	36.3275	400.0

> showing 50 of 1,048,267 rows — these rows as CSV

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