PREVIEW / stock_1min / 2017-01-06

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-01-06.parquet
  size:    14.3 MB
  rows:    1,036,816
  symbols: 2,586

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-01-06 06:02:00	AAPL	Stock	29.1425	29.1425	29.1425	29.1425	568.0
2017-01-06 06:34:00	AAPL	Stock	29.1425	29.1425	29.1425	29.1425	424.0
2017-01-06 07:00:00	AAPL	Stock	29.1525	29.1525	29.1525	29.1525	844.0
2017-01-06 07:13:00	AAPL	Stock	29.175	29.175	29.175	29.175	1824.0
2017-01-06 07:18:00	AAPL	Stock	29.1675	29.1675	29.1675	29.1675	400.0
2017-01-06 07:19:00	AAPL	Stock	29.1675	29.1675	29.1675	29.1675	400.0
2017-01-06 07:23:00	AAPL	Stock	29.1975	29.2025	29.1975	29.2025	3200.0
2017-01-06 07:36:00	AAPL	Stock	29.2	29.2	29.2	29.2	400.0
2017-01-06 07:44:00	AAPL	Stock	29.1875	29.1875	29.1875	29.1875	400.0
2017-01-06 07:57:00	AAPL	Stock	29.175	29.175	29.175	29.175	1000.0
2017-01-06 08:00:00	AAPL	Stock	29.1525	29.2025	29.1525	29.1875	5800.0
2017-01-06 08:02:00	AAPL	Stock	29.1875	29.1875	29.1825	29.1825	6400.0
2017-01-06 08:04:00	AAPL	Stock	29.175	29.175	29.175	29.175	400.0
2017-01-06 08:05:00	AAPL	Stock	29.175	29.175	29.175	29.175	800.0
2017-01-06 08:07:00	AAPL	Stock	29.175	29.175	29.175	29.175	400.0
2017-01-06 08:09:00	AAPL	Stock	29.175	29.175	29.1275	29.1275	8276.0
2017-01-06 08:10:00	AAPL	Stock	29.1275	29.1275	29.0	29.0825	126764.0
2017-01-06 08:11:00	AAPL	Stock	29.0575	29.125	29.0575	29.125	20896.0
2017-01-06 08:12:00	AAPL	Stock	29.0925	29.17	29.0925	29.17	9252.0
2017-01-06 08:17:00	AAPL	Stock	29.1375	29.1375	29.1375	29.1375	1144.0
2017-01-06 08:23:00	AAPL	Stock	29.135	29.135	29.135	29.135	1340.0
2017-01-06 08:24:00	AAPL	Stock	29.1475	29.1475	29.1475	29.1475	3200.0
2017-01-06 08:25:00	AAPL	Stock	29.1475	29.15	29.1475	29.1475	3200.0
2017-01-06 08:27:00	AAPL	Stock	29.1625	29.165	29.1525	29.1525	4400.0
2017-01-06 08:30:00	AAPL	Stock	29.125	29.2	29.125	29.1975	14844.0
2017-01-06 08:31:00	AAPL	Stock	29.1775	29.2	29.175	29.195	14156.0
2017-01-06 08:32:00	AAPL	Stock	29.2	29.2125	29.2	29.2125	14672.0
2017-01-06 08:33:00	AAPL	Stock	29.21	29.21	29.21	29.21	4468.0
2017-01-06 08:34:00	AAPL	Stock	29.1875	29.2175	29.1875	29.2175	12140.0
2017-01-06 08:35:00	AAPL	Stock	29.2	29.2	29.2	29.2	400.0
2017-01-06 08:36:00	AAPL	Stock	29.1775	29.1775	29.1775	29.1775	800.0
2017-01-06 08:37:00	AAPL	Stock	29.19	29.19	29.1875	29.1875	4400.0
2017-01-06 08:39:00	AAPL	Stock	29.1775	29.1775	29.175	29.175	9000.0
2017-01-06 08:41:00	AAPL	Stock	29.13	29.1325	29.13	29.1325	6000.0
2017-01-06 08:42:00	AAPL	Stock	29.135	29.135	29.135	29.135	4000.0
2017-01-06 08:44:00	AAPL	Stock	29.1525	29.1525	29.15	29.15	5200.0
2017-01-06 08:45:00	AAPL	Stock	29.15	29.175	29.1475	29.175	4400.0
2017-01-06 08:47:00	AAPL	Stock	29.1625	29.175	29.1475	29.1475	4808.0
2017-01-06 08:50:00	AAPL	Stock	29.15	29.15	29.145	29.145	6000.0
2017-01-06 08:51:00	AAPL	Stock	29.1375	29.1375	29.1375	29.1375	1928.0
2017-01-06 08:52:00	AAPL	Stock	29.1475	29.1475	29.1475	29.1475	2000.0
2017-01-06 08:53:00	AAPL	Stock	29.1475	29.1475	29.1475	29.1475	800.0
2017-01-06 08:54:00	AAPL	Stock	29.15	29.15	29.15	29.15	400.0
2017-01-06 08:58:00	AAPL	Stock	29.15	29.15	29.1375	29.145	7616.0
2017-01-06 08:59:00	AAPL	Stock	29.14	29.14	29.1375	29.1375	4072.0
2017-01-06 09:02:00	AAPL	Stock	29.1525	29.1525	29.1525	29.1525	400.0
2017-01-06 09:03:00	AAPL	Stock	29.1675	29.1675	29.1675	29.1675	400.0
2017-01-06 09:05:00	AAPL	Stock	29.1625	29.1625	29.1625	29.1625	400.0
2017-01-06 09:08:00	AAPL	Stock	29.16	29.1625	29.16	29.1625	2800.0
2017-01-06 09:09:00	AAPL	Stock	29.1625	29.1688	29.1625	29.1688	78104.0

> showing 50 of 1,036,816 rows — these rows as CSV

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