PREVIEW / stock_1min / 2018-06-13

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-06-13.parquet
  size:    15.5 MB
  rows:    1,095,725
  symbols: 2,364

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-06-13 04:00:00	AAPL	Stock	48.125	48.125	48.125	48.125	600.0
2018-06-13 05:28:00	AAPL	Stock	48.075	48.075	48.075	48.075	2000.0
2018-06-13 05:52:00	AAPL	Stock	48.075	48.075	48.075	48.075	800.0
2018-06-13 06:11:00	AAPL	Stock	48.0775	48.0775	48.0775	48.0775	800.0
2018-06-13 06:47:00	AAPL	Stock	48.0875	48.0875	48.0875	48.0875	400.0
2018-06-13 06:53:00	AAPL	Stock	48.1	48.1	48.1	48.1	7812.0
2018-06-13 06:55:00	AAPL	Stock	48.075	48.1	48.055	48.1	12000.0
2018-06-13 07:02:00	AAPL	Stock	48.1	48.1	48.1	48.1	400.0
2018-06-13 07:06:00	AAPL	Stock	48.135	48.135	48.135	48.135	5700.0
2018-06-13 07:07:00	AAPL	Stock	48.14	48.1425	48.14	48.1425	3060.0
2018-06-13 07:08:00	AAPL	Stock	48.15	48.15	48.15	48.15	400.0
2018-06-13 07:09:00	AAPL	Stock	48.1475	48.1475	48.1475	48.1475	1680.0
2018-06-13 07:17:00	AAPL	Stock	48.135	48.1425	48.135	48.1425	2948.0
2018-06-13 07:19:00	AAPL	Stock	48.1625	48.1675	48.125	48.125	46704.0
2018-06-13 07:26:00	AAPL	Stock	48.1475	48.1475	48.1475	48.1475	4000.0
2018-06-13 07:27:00	AAPL	Stock	48.1375	48.1475	48.1375	48.1475	800.0
2018-06-13 07:29:00	AAPL	Stock	48.13	48.13	48.13	48.13	400.0
2018-06-13 07:31:00	AAPL	Stock	48.13	48.13	48.13	48.13	860.0
2018-06-13 07:32:00	AAPL	Stock	48.1425	48.1425	48.1425	48.1425	2000.0
2018-06-13 07:33:00	AAPL	Stock	48.1375	48.1375	48.1375	48.1375	1600.0
2018-06-13 07:34:00	AAPL	Stock	48.125	48.125	48.1225	48.1225	2760.0
2018-06-13 07:40:00	AAPL	Stock	48.155	48.155	48.155	48.155	400.0
2018-06-13 07:44:00	AAPL	Stock	48.15	48.15	48.1425	48.15	2280.0
2018-06-13 07:45:00	AAPL	Stock	48.1575	48.1575	48.125	48.125	2916.0
2018-06-13 07:47:00	AAPL	Stock	48.1475	48.15	48.1475	48.15	1600.0
2018-06-13 07:48:00	AAPL	Stock	48.16	48.1625	48.16	48.1625	1512.0
2018-06-13 07:49:00	AAPL	Stock	48.1625	48.1625	48.155	48.16	3092.0
2018-06-13 07:50:00	AAPL	Stock	48.15	48.15	48.15	48.15	5600.0
2018-06-13 07:51:00	AAPL	Stock	48.1575	48.1625	48.155	48.1625	5560.0
2018-06-13 07:57:00	AAPL	Stock	48.1375	48.1375	48.1375	48.1375	400.0
2018-06-13 08:00:00	AAPL	Stock	48.155	48.155	48.1	48.145	17696.0
2018-06-13 08:01:00	AAPL	Stock	48.135	48.135	48.135	48.135	1300.0
2018-06-13 08:03:00	AAPL	Stock	48.13	48.13	48.13	48.13	400.0
2018-06-13 08:04:00	AAPL	Stock	48.125	48.13	48.125	48.13	3920.0
2018-06-13 08:05:00	AAPL	Stock	48.1225	48.1225	48.1225	48.1225	400.0
2018-06-13 08:06:00	AAPL	Stock	48.1225	48.1225	48.1125	48.1125	3808.0
2018-06-13 08:08:00	AAPL	Stock	48.1075	48.1075	48.1075	48.1075	1200.0
2018-06-13 08:09:00	AAPL	Stock	48.1075	48.1075	48.105	48.105	3300.0
2018-06-13 08:10:00	AAPL	Stock	48.105	48.105	48.105	48.105	1176.0
2018-06-13 08:11:00	AAPL	Stock	48.095	48.095	48.0925	48.0925	1600.0
2018-06-13 08:13:00	AAPL	Stock	48.08	48.08	48.08	48.08	1000.0
2018-06-13 08:15:00	AAPL	Stock	48.1	48.1	48.1	48.1	15600.0
2018-06-13 08:16:00	AAPL	Stock	48.1	48.1	48.1	48.1	3344.0
2018-06-13 08:18:00	AAPL	Stock	48.0975	48.12	48.0875	48.0925	4644.0
2018-06-13 08:19:00	AAPL	Stock	48.1	48.1	48.1	48.1	640.0
2018-06-13 08:21:00	AAPL	Stock	48.115	48.1175	48.115	48.1175	1440.0
2018-06-13 08:22:00	AAPL	Stock	48.115	48.115	48.1075	48.1075	3600.0
2018-06-13 08:24:00	AAPL	Stock	48.1	48.1	48.1	48.1	3200.0
2018-06-13 08:25:00	AAPL	Stock	48.1075	48.1075	48.1075	48.1075	2400.0
2018-06-13 08:26:00	AAPL	Stock	48.105	48.105	48.105	48.105	1200.0

> showing 50 of 1,095,725 rows — these rows as CSV

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