PREVIEW / stock_1min / 2018-01-04

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-01-04.parquet
  size:    16.6 MB
  rows:    1,108,676
  symbols: 2,430

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-01-04 04:02:00	AAPL	Stock	43.1	43.1	43.1	43.1	1392.0
2018-01-04 04:08:00	AAPL	Stock	43.1025	43.1025	43.1025	43.1025	400.0
2018-01-04 04:15:00	AAPL	Stock	43.1	43.1	43.1	43.1	2520.0
2018-01-04 05:16:00	AAPL	Stock	43.15	43.15	43.15	43.15	400.0
2018-01-04 05:21:00	AAPL	Stock	43.15	43.2	43.15	43.2	6108.0
2018-01-04 06:03:00	AAPL	Stock	43.1525	43.1525	43.1525	43.1525	400.0
2018-01-04 06:05:00	AAPL	Stock	43.1525	43.1525	43.1525	43.1525	400.0
2018-01-04 06:07:00	AAPL	Stock	43.1275	43.1275	43.1275	43.1275	1080.0
2018-01-04 06:08:00	AAPL	Stock	43.1275	43.1275	43.1275	43.1275	400.0
2018-01-04 06:12:00	AAPL	Stock	43.14	43.14	43.14	43.14	800.0
2018-01-04 06:13:00	AAPL	Stock	43.1275	43.1275	43.1275	43.1275	400.0
2018-01-04 06:14:00	AAPL	Stock	43.125	43.1275	43.125	43.1275	6580.0
2018-01-04 06:15:00	AAPL	Stock	43.1275	43.1275	43.1275	43.1275	1600.0
2018-01-04 06:21:00	AAPL	Stock	43.1525	43.1525	43.1525	43.1525	1800.0
2018-01-04 06:23:00	AAPL	Stock	43.1525	43.1525	43.1525	43.1525	6000.0
2018-01-04 06:35:00	AAPL	Stock	43.1525	43.1525	43.1525	43.1525	800.0
2018-01-04 06:44:00	AAPL	Stock	43.17	43.17	43.17	43.17	800.0
2018-01-04 06:48:00	AAPL	Stock	43.17	43.17	43.17	43.17	400.0
2018-01-04 07:00:00	AAPL	Stock	43.14	43.14	43.14	43.14	1600.0
2018-01-04 07:03:00	AAPL	Stock	43.155	43.155	43.155	43.155	400.0
2018-01-04 07:04:00	AAPL	Stock	43.14	43.14	43.14	43.14	1600.0
2018-01-04 07:11:00	AAPL	Stock	43.14	43.145	43.14	43.145	1400.0
2018-01-04 07:15:00	AAPL	Stock	43.15	43.15	43.15	43.15	400.0
2018-01-04 07:18:00	AAPL	Stock	43.15	43.15	43.15	43.15	1200.0
2018-01-04 07:19:00	AAPL	Stock	43.14	43.1725	43.1325	43.1725	10216.0
2018-01-04 07:22:00	AAPL	Stock	43.1425	43.1425	43.1425	43.1425	2400.0
2018-01-04 07:27:00	AAPL	Stock	43.1425	43.155	43.1425	43.155	800.0
2018-01-04 07:28:00	AAPL	Stock	43.1575	43.1575	43.1575	43.1575	6000.0
2018-01-04 07:29:00	AAPL	Stock	43.17	43.1725	43.17	43.1725	1952.0
2018-01-04 07:30:00	AAPL	Stock	43.1625	43.1625	43.1625	43.1625	400.0
2018-01-04 07:31:00	AAPL	Stock	43.1575	43.1725	43.1575	43.1725	10520.0
2018-01-04 07:33:00	AAPL	Stock	43.16	43.1625	43.16	43.1625	4000.0
2018-01-04 07:35:00	AAPL	Stock	43.1725	43.1725	43.1725	43.1725	1200.0
2018-01-04 07:39:00	AAPL	Stock	43.175	43.175	43.175	43.175	800.0
2018-01-04 07:44:00	AAPL	Stock	43.185	43.1925	43.185	43.1925	2808.0
2018-01-04 07:45:00	AAPL	Stock	43.1925	43.1925	43.1925	43.1925	1000.0
2018-01-04 07:48:00	AAPL	Stock	43.1875	43.1875	43.1875	43.1875	400.0
2018-01-04 07:50:00	AAPL	Stock	43.1825	43.1825	43.18	43.18	2800.0
2018-01-04 07:51:00	AAPL	Stock	43.1825	43.1825	43.1825	43.1825	2240.0
2018-01-04 07:53:00	AAPL	Stock	43.185	43.185	43.1825	43.1825	2960.0
2018-01-04 07:54:00	AAPL	Stock	43.18	43.18	43.18	43.18	2440.0
2018-01-04 07:55:00	AAPL	Stock	43.18	43.18	43.1525	43.1525	2800.0
2018-01-04 08:00:00	AAPL	Stock	43.17	43.1925	43.14	43.1525	27624.0
2018-01-04 08:01:00	AAPL	Stock	43.1525	43.1525	43.1525	43.1525	476.0
2018-01-04 08:03:00	AAPL	Stock	43.155	43.155	43.155	43.155	2000.0
2018-01-04 08:04:00	AAPL	Stock	43.16	43.16	43.1575	43.1575	1600.0
2018-01-04 08:05:00	AAPL	Stock	43.1575	43.1725	43.1575	43.1725	2760.0
2018-01-04 08:06:00	AAPL	Stock	43.1625	43.1625	43.16	43.16	2460.0
2018-01-04 08:07:00	AAPL	Stock	43.1625	43.1625	43.1525	43.1625	8956.0
2018-01-04 08:08:00	AAPL	Stock	43.1625	43.1625	43.1625	43.1625	2000.0

> showing 50 of 1,108,676 rows — these rows as CSV

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