PREVIEW / stock_1min / 2018-11-08

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-11-08.parquet
  size:    15.8 MB
  rows:    1,106,257
  symbols: 2,300

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-11-08 04:00:00	AAPL	Stock	52.595	52.595	52.4	52.4	2000.0
2018-11-08 04:01:00	AAPL	Stock	52.405	52.4075	52.4	52.4	2880.0
2018-11-08 04:04:00	AAPL	Stock	52.4	52.4375	52.4	52.4375	7320.0
2018-11-08 04:06:00	AAPL	Stock	52.4375	52.4375	52.4375	52.4375	588.0
2018-11-08 04:08:00	AAPL	Stock	52.4375	52.4375	52.4375	52.4375	1068.0
2018-11-08 04:19:00	AAPL	Stock	52.3775	52.3775	52.3775	52.3775	800.0
2018-11-08 04:39:00	AAPL	Stock	52.3	52.3	52.3	52.3	3252.0
2018-11-08 04:41:00	AAPL	Stock	52.3	52.3	52.3	52.3	3688.0
2018-11-08 04:42:00	AAPL	Stock	52.3375	52.3375	52.3375	52.3375	1020.0
2018-11-08 04:50:00	AAPL	Stock	52.3375	52.35	52.3375	52.35	4000.0
2018-11-08 04:51:00	AAPL	Stock	52.35	52.35	52.35	52.35	15600.0
2018-11-08 04:52:00	AAPL	Stock	52.3	52.3	52.3	52.3	1136.0
2018-11-08 04:56:00	AAPL	Stock	52.275	52.275	52.26	52.26	1684.0
2018-11-08 04:57:00	AAPL	Stock	52.265	52.265	52.265	52.265	800.0
2018-11-08 04:59:00	AAPL	Stock	52.275	52.275	52.275	52.275	1200.0
2018-11-08 05:02:00	AAPL	Stock	52.2775	52.34	52.2375	52.25	11016.0
2018-11-08 05:06:00	AAPL	Stock	52.25	52.25	52.25	52.25	400.0
2018-11-08 05:09:00	AAPL	Stock	52.25	52.25	52.25	52.25	400.0
2018-11-08 05:10:00	AAPL	Stock	52.275	52.275	52.275	52.275	12400.0
2018-11-08 05:13:00	AAPL	Stock	52.26	52.26	52.25	52.25	4000.0
2018-11-08 05:14:00	AAPL	Stock	52.25	52.25	52.25	52.25	400.0
2018-11-08 05:16:00	AAPL	Stock	52.255	52.255	52.255	52.255	400.0
2018-11-08 05:17:00	AAPL	Stock	52.2525	52.2525	52.2525	52.2525	400.0
2018-11-08 05:18:00	AAPL	Stock	52.2525	52.2525	52.2525	52.2525	400.0
2018-11-08 05:20:00	AAPL	Stock	52.25	52.25	52.25	52.25	1200.0
2018-11-08 05:21:00	AAPL	Stock	52.25	52.25	52.25	52.25	400.0
2018-11-08 05:23:00	AAPL	Stock	52.22	52.22	52.22	52.22	400.0
2018-11-08 05:24:00	AAPL	Stock	52.1925	52.1925	52.175	52.175	2400.0
2018-11-08 05:25:00	AAPL	Stock	52.15	52.15	52.15	52.15	1160.0
2018-11-08 05:26:00	AAPL	Stock	52.205	52.205	52.205	52.205	1200.0
2018-11-08 05:27:00	AAPL	Stock	52.17	52.17	52.16	52.16	16000.0
2018-11-08 05:32:00	AAPL	Stock	52.125	52.125	52.125	52.125	1000.0
2018-11-08 05:33:00	AAPL	Stock	52.125	52.125	52.125	52.125	400.0
2018-11-08 05:35:00	AAPL	Stock	52.12	52.12	52.12	52.12	400.0
2018-11-08 05:36:00	AAPL	Stock	52.125	52.125	52.125	52.125	400.0
2018-11-08 05:37:00	AAPL	Stock	52.125	52.125	52.125	52.125	400.0
2018-11-08 05:42:00	AAPL	Stock	52.11	52.11	52.11	52.11	400.0
2018-11-08 05:43:00	AAPL	Stock	52.105	52.105	52.105	52.105	1700.0
2018-11-08 05:45:00	AAPL	Stock	52.1075	52.1075	52.105	52.105	1600.0
2018-11-08 05:46:00	AAPL	Stock	52.125	52.125	52.125	52.125	800.0
2018-11-08 05:47:00	AAPL	Stock	52.1275	52.1275	52.1275	52.1275	1200.0
2018-11-08 05:48:00	AAPL	Stock	52.1475	52.1475	52.1275	52.1275	1864.0
2018-11-08 05:51:00	AAPL	Stock	52.1375	52.1375	52.1375	52.1375	400.0
2018-11-08 05:52:00	AAPL	Stock	52.12	52.12	52.12	52.12	556.0
2018-11-08 05:55:00	AAPL	Stock	52.175	52.175	52.175	52.175	2616.0
2018-11-08 05:56:00	AAPL	Stock	52.13	52.13	52.13	52.13	476.0
2018-11-08 06:00:00	AAPL	Stock	52.17	52.17	52.17	52.17	400.0
2018-11-08 06:01:00	AAPL	Stock	52.105	52.105	52.105	52.105	3200.0
2018-11-08 06:05:00	AAPL	Stock	52.125	52.125	52.125	52.125	1596.0
2018-11-08 06:07:00	AAPL	Stock	52.15	52.15	52.15	52.15	648.0

> showing 50 of 1,106,257 rows — these rows as CSV

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