PREVIEW / stock_1min / 2017-07-11

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-07-11.parquet
  size:    14.0 MB
  rows:    1,034,439
  symbols: 2,479

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-07-11 04:00:00	AAPL	Stock	36.2325	36.2325	36.225	36.225	7032.0
2017-07-11 04:04:00	AAPL	Stock	36.25	36.25	36.25	36.25	760.0
2017-07-11 04:05:00	AAPL	Stock	36.25	36.25	36.25	36.25	640.0
2017-07-11 04:18:00	AAPL	Stock	36.275	36.275	36.275	36.275	400.0
2017-07-11 04:23:00	AAPL	Stock	36.25	36.25	36.25	36.25	1300.0
2017-07-11 05:10:00	AAPL	Stock	36.25	36.25	36.25	36.25	1148.0
2017-07-11 05:50:00	AAPL	Stock	36.2125	36.2125	36.2125	36.2125	4000.0
2017-07-11 06:04:00	AAPL	Stock	36.2275	36.2275	36.2275	36.2275	2000.0
2017-07-11 06:11:00	AAPL	Stock	36.2025	36.2025	36.2025	36.2025	1100.0
2017-07-11 06:30:00	AAPL	Stock	36.2125	36.2125	36.2125	36.2125	800.0
2017-07-11 06:31:00	AAPL	Stock	36.2125	36.2125	36.2125	36.2125	400.0
2017-07-11 06:35:00	AAPL	Stock	36.215	36.215	36.215	36.215	400.0
2017-07-11 06:36:00	AAPL	Stock	36.2125	36.2125	36.2125	36.2125	8000.0
2017-07-11 06:37:00	AAPL	Stock	36.2125	36.2125	36.19	36.19	800.0
2017-07-11 06:39:00	AAPL	Stock	36.22	36.22	36.22	36.22	2092.0
2017-07-11 06:40:00	AAPL	Stock	36.2025	36.2025	36.2	36.2	800.0
2017-07-11 06:41:00	AAPL	Stock	36.2125	36.22	36.2125	36.22	5508.0
2017-07-11 06:43:00	AAPL	Stock	36.215	36.215	36.2125	36.2125	10400.0
2017-07-11 06:50:00	AAPL	Stock	36.2375	36.2375	36.2375	36.2375	400.0
2017-07-11 07:05:00	AAPL	Stock	36.2125	36.2125	36.2125	36.2125	1208.0
2017-07-11 07:20:00	AAPL	Stock	36.2125	36.225	36.1625	36.1625	8216.0
2017-07-11 07:21:00	AAPL	Stock	36.1775	36.1775	36.165	36.165	1640.0
2017-07-11 07:24:00	AAPL	Stock	36.165	36.165	36.1625	36.1625	13200.0
2017-07-11 07:25:00	AAPL	Stock	36.14	36.145	36.1375	36.145	2160.0
2017-07-11 07:26:00	AAPL	Stock	36.1275	36.13	36.1225	36.1225	9592.0
2017-07-11 07:28:00	AAPL	Stock	36.1225	36.125	36.1225	36.125	7244.0
2017-07-11 07:29:00	AAPL	Stock	36.15	36.15	36.15	36.15	400.0
2017-07-11 07:30:00	AAPL	Stock	36.15	36.15	36.15	36.15	2000.0
2017-07-11 07:32:00	AAPL	Stock	36.15	36.15	36.15	36.15	7200.0
2017-07-11 07:35:00	AAPL	Stock	36.1525	36.1525	36.15	36.15	14400.0
2017-07-11 07:36:00	AAPL	Stock	36.15	36.15	36.15	36.15	8400.0
2017-07-11 07:38:00	AAPL	Stock	36.1475	36.1475	36.1475	36.1475	1200.0
2017-07-11 07:41:00	AAPL	Stock	36.1275	36.1275	36.1125	36.1275	5164.0
2017-07-11 07:47:00	AAPL	Stock	36.13	36.13	36.125	36.125	2000.0
2017-07-11 07:48:00	AAPL	Stock	36.125	36.125	36.125	36.125	2000.0
2017-07-11 07:49:00	AAPL	Stock	36.1075	36.1075	36.1025	36.1025	920.0
2017-07-11 07:51:00	AAPL	Stock	36.125	36.125	36.125	36.125	400.0
2017-07-11 07:54:00	AAPL	Stock	36.125	36.125	36.125	36.125	400.0
2017-07-11 07:56:00	AAPL	Stock	36.125	36.125	36.125	36.125	800.0
2017-07-11 08:00:00	AAPL	Stock	36.125	36.125	36.1025	36.1025	11180.0
2017-07-11 08:01:00	AAPL	Stock	36.1025	36.125	36.1025	36.125	5828.0
2017-07-11 08:02:00	AAPL	Stock	36.125	36.125	36.125	36.125	7200.0
2017-07-11 08:03:00	AAPL	Stock	36.125	36.15	36.125	36.15	7184.0
2017-07-11 08:04:00	AAPL	Stock	36.2375	36.2375	36.15	36.15	9028.0
2017-07-11 08:05:00	AAPL	Stock	36.15	36.15	36.15	36.15	8968.0
2017-07-11 08:06:00	AAPL	Stock	36.1675	36.1675	36.15	36.15	5600.0
2017-07-11 08:07:00	AAPL	Stock	36.1675	36.1675	36.1625	36.1675	2416.0
2017-07-11 08:08:00	AAPL	Stock	36.1675	36.175	36.1675	36.175	8000.0
2017-07-11 08:11:00	AAPL	Stock	36.15	36.15	36.15	36.15	2000.0
2017-07-11 08:13:00	AAPL	Stock	36.1625	36.165	36.1625	36.165	2000.0

> showing 50 of 1,034,439 rows — these rows as CSV

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