PREVIEW / stock_1min / 2018-05-07

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-05-07.parquet
  size:    15.0 MB
  rows:    1,079,349
  symbols: 2,388

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-05-07 04:00:00	AAPL	Stock	46.115	46.1375	46.1125	46.1125	2400.0
2018-05-07 04:01:00	AAPL	Stock	46.1	46.1	46.0575	46.0625	20828.0
2018-05-07 04:05:00	AAPL	Stock	46.125	46.125	46.125	46.125	1200.0
2018-05-07 04:12:00	AAPL	Stock	46.195	46.1975	46.185	46.185	2560.0
2018-05-07 04:16:00	AAPL	Stock	46.175	46.175	46.175	46.175	584.0
2018-05-07 04:17:00	AAPL	Stock	46.1725	46.1725	46.1725	46.1725	400.0
2018-05-07 04:36:00	AAPL	Stock	46.1725	46.1725	46.1725	46.1725	400.0
2018-05-07 04:37:00	AAPL	Stock	46.1725	46.1725	46.1725	46.1725	400.0
2018-05-07 04:46:00	AAPL	Stock	46.1775	46.1775	46.175	46.175	800.0
2018-05-07 04:47:00	AAPL	Stock	46.1775	46.1775	46.175	46.175	3976.0
2018-05-07 04:50:00	AAPL	Stock	46.21	46.215	46.21	46.2125	7052.0
2018-05-07 04:53:00	AAPL	Stock	46.2125	46.2125	46.2125	46.2125	1104.0
2018-05-07 04:59:00	AAPL	Stock	46.185	46.185	46.185	46.185	1200.0
2018-05-07 05:06:00	AAPL	Stock	46.2	46.2	46.2	46.2	564.0
2018-05-07 05:14:00	AAPL	Stock	46.175	46.175	46.175	46.175	1240.0
2018-05-07 05:24:00	AAPL	Stock	46.195	46.1975	46.195	46.1975	1712.0
2018-05-07 05:33:00	AAPL	Stock	46.1625	46.1625	46.1375	46.1375	2800.0
2018-05-07 05:34:00	AAPL	Stock	46.1375	46.1375	46.1375	46.1375	400.0
2018-05-07 05:35:00	AAPL	Stock	46.1375	46.1375	46.1375	46.1375	400.0
2018-05-07 05:37:00	AAPL	Stock	46.175	46.175	46.175	46.175	2000.0
2018-05-07 05:38:00	AAPL	Stock	46.1925	46.2	46.1925	46.2	10420.0
2018-05-07 05:40:00	AAPL	Stock	46.2	46.2	46.2	46.2	400.0
2018-05-07 05:42:00	AAPL	Stock	46.19	46.2225	46.19	46.22	11672.0
2018-05-07 05:45:00	AAPL	Stock	46.2	46.2	46.2	46.2	1200.0
2018-05-07 05:46:00	AAPL	Stock	46.1275	46.1275	46.125	46.125	3792.0
2018-05-07 05:56:00	AAPL	Stock	46.125	46.125	46.125	46.125	400.0
2018-05-07 05:57:00	AAPL	Stock	46.155	46.155	46.155	46.155	400.0
2018-05-07 05:59:00	AAPL	Stock	46.125	46.125	46.125	46.125	7836.0
2018-05-07 06:12:00	AAPL	Stock	46.125	46.2	46.125	46.2	9152.0
2018-05-07 06:31:00	AAPL	Stock	46.16	46.16	46.16	46.16	400.0
2018-05-07 06:34:00	AAPL	Stock	46.13	46.15	46.13	46.15	800.0
2018-05-07 06:35:00	AAPL	Stock	46.15	46.15	46.15	46.15	1576.0
2018-05-07 06:37:00	AAPL	Stock	46.15	46.15	46.15	46.15	3396.0
2018-05-07 06:38:00	AAPL	Stock	46.15	46.15	46.15	46.15	400.0
2018-05-07 06:49:00	AAPL	Stock	46.1525	46.1525	46.1525	46.1525	400.0
2018-05-07 06:53:00	AAPL	Stock	46.1275	46.1275	46.115	46.115	1600.0
2018-05-07 07:00:00	AAPL	Stock	46.1475	46.1625	46.1125	46.15	34680.0
2018-05-07 07:01:00	AAPL	Stock	46.15	46.1625	46.15	46.1625	5144.0
2018-05-07 07:02:00	AAPL	Stock	46.1625	46.17	46.1525	46.1625	6176.0
2018-05-07 07:03:00	AAPL	Stock	46.1625	46.1725	46.1625	46.1725	19036.0
2018-05-07 07:04:00	AAPL	Stock	46.1725	46.1875	46.1725	46.1875	16608.0
2018-05-07 07:05:00	AAPL	Stock	46.175	46.2	46.1725	46.1725	32052.0
2018-05-07 07:06:00	AAPL	Stock	46.1725	46.1925	46.1725	46.1925	16000.0
2018-05-07 07:07:00	AAPL	Stock	46.1925	46.2	46.175	46.1875	15480.0
2018-05-07 07:08:00	AAPL	Stock	46.1925	46.195	46.1875	46.195	7504.0
2018-05-07 07:09:00	AAPL	Stock	46.1875	46.195	46.1875	46.1875	13628.0
2018-05-07 07:10:00	AAPL	Stock	46.1775	46.185	46.165	46.185	20800.0
2018-05-07 07:11:00	AAPL	Stock	46.1875	46.1875	46.1775	46.1775	5420.0
2018-05-07 07:12:00	AAPL	Stock	46.1775	46.1875	46.1775	46.1875	4000.0
2018-05-07 07:13:00	AAPL	Stock	46.1875	46.2	46.1875	46.2	38808.0

> showing 50 of 1,079,349 rows — these rows as CSV

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