PREVIEW / stock_1min / 2017-07-03

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-07-03.parquet
  size:    8.4 MB
  rows:    594,369
  symbols: 2,423

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-03 04:05:00	AAPL	Stock	36.18	36.18	36.18	36.18	2000.0
2017-07-03 04:22:00	AAPL	Stock	36.1825	36.1825	36.1825	36.1825	644.0
2017-07-03 04:45:00	AAPL	Stock	36.1825	36.1825	36.1825	36.1825	1088.0
2017-07-03 04:46:00	AAPL	Stock	36.15	36.15	36.15	36.15	912.0
2017-07-03 05:01:00	AAPL	Stock	36.165	36.165	36.165	36.165	1200.0
2017-07-03 05:55:00	AAPL	Stock	36.16	36.16	36.16	36.16	1600.0
2017-07-03 06:05:00	AAPL	Stock	36.16	36.16	36.16	36.16	400.0
2017-07-03 06:29:00	AAPL	Stock	36.1125	36.1125	36.1125	36.1125	1200.0
2017-07-03 06:58:00	AAPL	Stock	36.125	36.125	36.125	36.125	680.0
2017-07-03 07:02:00	AAPL	Stock	36.14	36.14	36.14	36.14	488.0
2017-07-03 07:03:00	AAPL	Stock	36.1625	36.1625	36.15	36.15	2400.0
2017-07-03 07:06:00	AAPL	Stock	36.16	36.16	36.15	36.15	8800.0
2017-07-03 07:14:00	AAPL	Stock	36.1325	36.135	36.1325	36.135	800.0
2017-07-03 07:17:00	AAPL	Stock	36.145	36.145	36.145	36.145	400.0
2017-07-03 07:21:00	AAPL	Stock	36.15	36.15	36.15	36.15	3648.0
2017-07-03 07:30:00	AAPL	Stock	36.15	36.15	36.15	36.15	1200.0
2017-07-03 07:36:00	AAPL	Stock	36.1625	36.1625	36.1625	36.1625	800.0
2017-07-03 07:44:00	AAPL	Stock	36.1775	36.1775	36.1775	36.1775	1100.0
2017-07-03 07:45:00	AAPL	Stock	36.15	36.15	36.15	36.15	400.0
2017-07-03 08:00:00	AAPL	Stock	36.075	36.1775	36.075	36.1625	3404.0
2017-07-03 08:01:00	AAPL	Stock	36.1525	36.17	36.1525	36.17	2388.0
2017-07-03 08:02:00	AAPL	Stock	36.14	36.14	36.1375	36.1375	1200.0
2017-07-03 08:07:00	AAPL	Stock	36.14	36.14	36.14	36.14	532.0
2017-07-03 08:09:00	AAPL	Stock	36.15	36.15	36.15	36.15	1368.0
2017-07-03 08:10:00	AAPL	Stock	36.16	36.16	36.16	36.16	1200.0
2017-07-03 08:12:00	AAPL	Stock	36.1675	36.1675	36.1675	36.1675	1600.0
2017-07-03 08:14:00	AAPL	Stock	36.15	36.15	36.1425	36.1425	11788.0
2017-07-03 08:19:00	AAPL	Stock	36.17	36.17	36.17	36.17	1000.0
2017-07-03 08:25:00	AAPL	Stock	36.16	36.16	36.155	36.155	2400.0
2017-07-03 08:26:00	AAPL	Stock	36.1425	36.1425	36.1375	36.1375	2832.0
2017-07-03 08:28:00	AAPL	Stock	36.1375	36.1375	36.1375	36.1375	5612.0
2017-07-03 08:30:00	AAPL	Stock	36.1375	36.1375	36.1375	36.1375	400.0
2017-07-03 08:31:00	AAPL	Stock	36.16	36.16	36.16	36.16	400.0
2017-07-03 08:32:00	AAPL	Stock	36.13	36.13	36.13	36.13	400.0
2017-07-03 08:36:00	AAPL	Stock	36.125	36.125	36.125	36.125	920.0
2017-07-03 08:37:00	AAPL	Stock	36.15	36.15	36.15	36.15	4400.0
2017-07-03 08:43:00	AAPL	Stock	36.145	36.15	36.145	36.15	10800.0
2017-07-03 08:44:00	AAPL	Stock	36.16	36.1775	36.16	36.1775	8708.0
2017-07-03 08:46:00	AAPL	Stock	36.005	36.005	36.005	36.005	6520.0
2017-07-03 08:48:00	AAPL	Stock	36.175	36.175	36.175	36.175	4000.0
2017-07-03 08:51:00	AAPL	Stock	36.175	36.18	36.175	36.18	2000.0
2017-07-03 08:52:00	AAPL	Stock	36.1825	36.1825	36.175	36.1775	2436.0
2017-07-03 08:53:00	AAPL	Stock	36.175	36.1825	36.175	36.1825	2400.0
2017-07-03 08:54:00	AAPL	Stock	36.1825	36.1875	36.1825	36.1875	10700.0
2017-07-03 08:55:00	AAPL	Stock	36.1825	36.1825	36.1825	36.1825	1600.0
2017-07-03 08:58:00	AAPL	Stock	36.1825	36.1875	36.1825	36.1875	4780.0
2017-07-03 08:59:00	AAPL	Stock	36.19	36.1925	36.19	36.1925	6516.0
2017-07-03 09:00:00	AAPL	Stock	36.2025	36.2025	36.2025	36.2025	2400.0
2017-07-03 09:03:00	AAPL	Stock	36.1975	36.1975	36.1975	36.1975	1340.0
2017-07-03 09:04:00	AAPL	Stock	36.19	36.1925	36.1875	36.1925	2800.0

> showing 50 of 594,369 rows — these rows as CSV

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