PREVIEW / stock_1min / 2017-08-24

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-08-24.parquet
  size:    13.5 MB
  rows:    985,720
  symbols: 2,462

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-08-24 04:07:00	AAPL	Stock	39.95	39.95	39.95	39.95	1600.0
2017-08-24 04:42:00	AAPL	Stock	40.005	40.005	40.005	40.005	400.0
2017-08-24 06:10:00	AAPL	Stock	40.0475	40.0475	40.0475	40.0475	400.0
2017-08-24 07:02:00	AAPL	Stock	40.05	40.05	40.05	40.05	2004.0
2017-08-24 07:04:00	AAPL	Stock	40.0575	40.0575	40.05	40.055	7012.0
2017-08-24 07:06:00	AAPL	Stock	40.0375	40.0375	40.0375	40.0375	1912.0
2017-08-24 07:11:00	AAPL	Stock	40.0475	40.05	40.0475	40.05	4968.0
2017-08-24 07:14:00	AAPL	Stock	40.07	40.07	40.07	40.07	600.0
2017-08-24 07:15:00	AAPL	Stock	40.0725	40.0725	40.0725	40.0725	436.0
2017-08-24 07:19:00	AAPL	Stock	40.1125	40.1125	40.1125	40.1125	920.0
2017-08-24 07:20:00	AAPL	Stock	40.12	40.12	40.12	40.12	800.0
2017-08-24 07:23:00	AAPL	Stock	40.1175	40.125	40.1175	40.125	18252.0
2017-08-24 07:25:00	AAPL	Stock	40.1625	40.1625	40.1625	40.1625	400.0
2017-08-24 07:30:00	AAPL	Stock	40.125	40.125	40.125	40.125	400.0
2017-08-24 07:32:00	AAPL	Stock	40.1275	40.1275	40.1275	40.1275	400.0
2017-08-24 07:34:00	AAPL	Stock	40.1275	40.15	40.1275	40.15	4788.0
2017-08-24 07:36:00	AAPL	Stock	40.15	40.15	40.15	40.15	400.0
2017-08-24 07:40:00	AAPL	Stock	40.16	40.16	40.16	40.16	2400.0
2017-08-24 07:41:00	AAPL	Stock	40.16	40.16	40.16	40.16	800.0
2017-08-24 07:43:00	AAPL	Stock	40.15	40.15	40.15	40.15	400.0
2017-08-24 07:44:00	AAPL	Stock	40.15	40.1625	40.15	40.1625	1024.0
2017-08-24 07:45:00	AAPL	Stock	40.1625	40.1625	40.1625	40.1625	11280.0
2017-08-24 07:47:00	AAPL	Stock	40.145	40.145	40.145	40.145	400.0
2017-08-24 07:48:00	AAPL	Stock	40.145	40.145	40.145	40.145	800.0
2017-08-24 07:52:00	AAPL	Stock	40.155	40.155	40.155	40.155	400.0
2017-08-24 07:54:00	AAPL	Stock	40.145	40.145	40.145	40.145	400.0
2017-08-24 08:00:00	AAPL	Stock	40.145	40.155	40.0375	40.15	27656.0
2017-08-24 08:01:00	AAPL	Stock	40.15	40.155	40.1425	40.1425	11428.0
2017-08-24 08:02:00	AAPL	Stock	40.15	40.15	40.15	40.15	2000.0
2017-08-24 08:03:00	AAPL	Stock	40.15	40.15	40.15	40.15	800.0
2017-08-24 08:04:00	AAPL	Stock	40.155	40.155	40.155	40.155	1000.0
2017-08-24 08:05:00	AAPL	Stock	40.155	40.155	40.155	40.155	1200.0
2017-08-24 08:06:00	AAPL	Stock	40.155	40.155	40.155	40.155	500.0
2017-08-24 08:07:00	AAPL	Stock	40.1625	40.1675	40.155	40.155	14336.0
2017-08-24 08:08:00	AAPL	Stock	40.1525	40.155	40.1525	40.155	3200.0
2017-08-24 08:10:00	AAPL	Stock	40.1575	40.1575	40.155	40.155	7996.0
2017-08-24 08:11:00	AAPL	Stock	40.15	40.15	40.15	40.15	1200.0
2017-08-24 08:12:00	AAPL	Stock	40.155	40.155	40.15	40.15	2200.0
2017-08-24 08:13:00	AAPL	Stock	40.15	40.1575	40.15	40.1575	6252.0
2017-08-24 08:14:00	AAPL	Stock	40.15	40.15	40.15	40.15	2004.0
2017-08-24 08:16:00	AAPL	Stock	40.15	40.15	40.15	40.15	400.0
2017-08-24 08:19:00	AAPL	Stock	40.1425	40.1575	40.1425	40.1575	10240.0
2017-08-24 08:20:00	AAPL	Stock	40.1625	40.1625	40.1625	40.1625	8620.0
2017-08-24 08:21:00	AAPL	Stock	40.1625	40.165	40.1625	40.165	14120.0
2017-08-24 08:23:00	AAPL	Stock	40.1625	40.1625	40.1625	40.1625	696.0
2017-08-24 08:25:00	AAPL	Stock	40.1675	40.1725	40.1625	40.1725	10120.0
2017-08-24 08:27:00	AAPL	Stock	40.16	40.16	40.16	40.16	4400.0
2017-08-24 08:28:00	AAPL	Stock	40.1575	40.1575	40.1575	40.1575	400.0
2017-08-24 08:29:00	AAPL	Stock	40.155	40.155	40.1475	40.1475	3572.0
2017-08-24 08:30:00	AAPL	Stock	40.17	40.17	40.17	40.17	600.0

> showing 50 of 985,720 rows — these rows as CSV

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