PREVIEW / stock_1min / 2017-10-23

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-10-23.parquet
  size:    14.0 MB
  rows:    1,008,224
  symbols: 2,418

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-10-23 04:26:00	AAPL	Stock	39.0625	39.0625	39.0625	39.0625	2800.0
2017-10-23 04:34:00	AAPL	Stock	39.1	39.1	39.1	39.1	572.0
2017-10-23 04:42:00	AAPL	Stock	39.1625	39.1625	39.1625	39.1625	552.0
2017-10-23 05:01:00	AAPL	Stock	39.1	39.1	39.1	39.1	1924.0
2017-10-23 05:10:00	AAPL	Stock	39.1425	39.1425	39.1425	39.1425	400.0
2017-10-23 05:15:00	AAPL	Stock	39.1	39.1	39.1	39.1	400.0
2017-10-23 05:20:00	AAPL	Stock	39.1	39.1	39.1	39.1	800.0
2017-10-23 05:45:00	AAPL	Stock	39.15	39.15	39.15	39.15	2380.0
2017-10-23 05:58:00	AAPL	Stock	39.115	39.115	39.115	39.115	400.0
2017-10-23 06:03:00	AAPL	Stock	39.115	39.115	39.115	39.115	800.0
2017-10-23 06:06:00	AAPL	Stock	39.115	39.115	39.115	39.115	1600.0
2017-10-23 06:09:00	AAPL	Stock	39.15	39.15	39.15	39.15	800.0
2017-10-23 06:34:00	AAPL	Stock	39.15	39.15	39.15	39.15	768.0
2017-10-23 06:46:00	AAPL	Stock	39.15	39.2	39.15	39.2	11876.0
2017-10-23 06:56:00	AAPL	Stock	39.15	39.15	39.15	39.15	1200.0
2017-10-23 06:57:00	AAPL	Stock	39.15	39.15	39.15	39.15	4800.0
2017-10-23 07:00:00	AAPL	Stock	39.1375	39.1375	39.1375	39.1375	600.0
2017-10-23 07:09:00	AAPL	Stock	39.15	39.15	39.15	39.15	796.0
2017-10-23 07:15:00	AAPL	Stock	39.1625	39.1625	39.1625	39.1625	400.0
2017-10-23 07:18:00	AAPL	Stock	39.15	39.15	39.1375	39.1375	4320.0
2017-10-23 07:21:00	AAPL	Stock	39.105	39.105	39.105	39.105	1256.0
2017-10-23 07:25:00	AAPL	Stock	39.15	39.15	39.15	39.15	1280.0
2017-10-23 07:31:00	AAPL	Stock	39.1475	39.1475	39.1375	39.1375	3600.0
2017-10-23 07:48:00	AAPL	Stock	39.1375	39.1375	39.135	39.135	800.0
2017-10-23 07:51:00	AAPL	Stock	39.135	39.135	39.135	39.135	400.0
2017-10-23 07:52:00	AAPL	Stock	39.1325	39.1325	39.1275	39.1275	3480.0
2017-10-23 07:53:00	AAPL	Stock	39.135	39.135	39.135	39.135	400.0
2017-10-23 07:54:00	AAPL	Stock	39.1275	39.1275	39.125	39.125	3280.0
2017-10-23 07:57:00	AAPL	Stock	39.125	39.125	39.125	39.125	1200.0
2017-10-23 07:58:00	AAPL	Stock	39.1225	39.1225	39.1225	39.1225	1460.0
2017-10-23 08:00:00	AAPL	Stock	39.15	39.15	39.1025	39.125	24836.0
2017-10-23 08:01:00	AAPL	Stock	39.125	39.125	39.125	39.125	8000.0
2017-10-23 08:02:00	AAPL	Stock	39.115	39.115	39.115	39.115	400.0
2017-10-23 08:04:00	AAPL	Stock	39.125	39.125	39.115	39.115	1840.0
2017-10-23 08:05:00	AAPL	Stock	39.125	39.125	39.125	39.125	800.0
2017-10-23 08:06:00	AAPL	Stock	39.125	39.125	39.125	39.125	904.0
2017-10-23 08:08:00	AAPL	Stock	39.115	39.115	39.115	39.115	1892.0
2017-10-23 08:10:00	AAPL	Stock	39.12	39.12	39.12	39.12	400.0
2017-10-23 08:11:00	AAPL	Stock	39.12	39.12	39.12	39.12	1200.0
2017-10-23 08:15:00	AAPL	Stock	39.1325	39.1325	39.1325	39.1325	400.0
2017-10-23 08:16:00	AAPL	Stock	39.15	39.15	39.15	39.15	800.0
2017-10-23 08:19:00	AAPL	Stock	39.1325	39.1325	39.1325	39.1325	400.0
2017-10-23 08:22:00	AAPL	Stock	39.1325	39.1325	39.1325	39.1325	1428.0
2017-10-23 08:25:00	AAPL	Stock	39.14	39.14	39.14	39.14	904.0
2017-10-23 08:29:00	AAPL	Stock	39.15	39.1725	39.15	39.1725	12256.0
2017-10-23 08:30:00	AAPL	Stock	39.175	39.175	39.175	39.175	1200.0
2017-10-23 08:31:00	AAPL	Stock	39.1925	39.1925	39.1925	39.1925	400.0
2017-10-23 08:33:00	AAPL	Stock	39.2	39.2	39.2	39.2	400.0
2017-10-23 08:34:00	AAPL	Stock	39.1925	39.1925	39.1775	39.1775	3840.0
2017-10-23 08:35:00	AAPL	Stock	39.1875	39.1975	39.1875	39.1975	2904.0

> showing 50 of 1,008,224 rows — these rows as CSV

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