PREVIEW / stock_1min / 2017-06-16

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-06-16.parquet
  size:    14.3 MB
  rows:    1,055,462
  symbols: 2,499

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-06-16 04:00:00	AAPL	Stock	36.175	36.175	36.175	36.175	9484.0
2017-06-16 04:02:00	AAPL	Stock	36.1225	36.1225	36.1225	36.1225	3608.0
2017-06-16 04:04:00	AAPL	Stock	36.11	36.11	36.11	36.11	400.0
2017-06-16 04:05:00	AAPL	Stock	36.125	36.125	36.125	36.125	4000.0
2017-06-16 04:13:00	AAPL	Stock	36.15	36.15	36.15	36.15	7600.0
2017-06-16 04:14:00	AAPL	Stock	36.15	36.15	36.15	36.15	3960.0
2017-06-16 04:24:00	AAPL	Stock	36.19	36.19	36.19	36.19	3820.0
2017-06-16 06:06:00	AAPL	Stock	36.125	36.125	36.125	36.125	400.0
2017-06-16 06:14:00	AAPL	Stock	36.1125	36.1125	36.1125	36.1125	400.0
2017-06-16 06:17:00	AAPL	Stock	36.1125	36.1125	36.1125	36.1125	1276.0
2017-06-16 06:21:00	AAPL	Stock	36.115	36.115	36.115	36.115	800.0
2017-06-16 06:24:00	AAPL	Stock	36.1425	36.1475	36.1425	36.1475	3200.0
2017-06-16 06:33:00	AAPL	Stock	36.15	36.15	36.15	36.15	1200.0
2017-06-16 06:48:00	AAPL	Stock	36.1625	36.1625	36.1625	36.1625	400.0
2017-06-16 06:49:00	AAPL	Stock	36.125	36.125	36.125	36.125	400.0
2017-06-16 07:01:00	AAPL	Stock	36.1375	36.1375	36.1375	36.1375	3428.0
2017-06-16 07:02:00	AAPL	Stock	36.155	36.155	36.155	36.155	1672.0
2017-06-16 07:03:00	AAPL	Stock	36.1625	36.1625	36.1625	36.1625	2000.0
2017-06-16 07:10:00	AAPL	Stock	36.155	36.155	36.155	36.155	800.0
2017-06-16 07:11:00	AAPL	Stock	36.155	36.155	36.155	36.155	400.0
2017-06-16 07:34:00	AAPL	Stock	36.1375	36.1375	36.1375	36.1375	400.0
2017-06-16 07:39:00	AAPL	Stock	36.145	36.145	36.145	36.145	400.0
2017-06-16 07:41:00	AAPL	Stock	36.1425	36.1425	36.1425	36.1425	4800.0
2017-06-16 07:52:00	AAPL	Stock	36.1375	36.1375	36.1375	36.1375	2000.0
2017-06-16 07:56:00	AAPL	Stock	36.14	36.14	36.14	36.14	800.0
2017-06-16 07:58:00	AAPL	Stock	36.14	36.14	36.14	36.14	2000.0
2017-06-16 08:00:00	AAPL	Stock	36.1275	36.145	36.125	36.125	26116.0
2017-06-16 08:01:00	AAPL	Stock	36.1225	36.1375	36.1225	36.1375	1328.0
2017-06-16 08:02:00	AAPL	Stock	36.1075	36.1075	36.1	36.1	3008.0
2017-06-16 08:03:00	AAPL	Stock	36.09	36.09	36.09	36.09	5768.0
2017-06-16 08:05:00	AAPL	Stock	36.075	36.0975	36.075	36.0975	1224.0
2017-06-16 08:06:00	AAPL	Stock	36.1	36.1	36.0975	36.0975	26396.0
2017-06-16 08:07:00	AAPL	Stock	36.0975	36.0975	36.0975	36.0975	21124.0
2017-06-16 08:09:00	AAPL	Stock	36.1	36.1	36.1	36.1	400.0
2017-06-16 08:10:00	AAPL	Stock	36.1	36.1175	36.1	36.1175	12800.0
2017-06-16 08:13:00	AAPL	Stock	36.11	36.11	36.1025	36.1025	3200.0
2017-06-16 08:14:00	AAPL	Stock	36.1	36.1	36.1	36.1	400.0
2017-06-16 08:15:00	AAPL	Stock	36.1025	36.1075	36.1025	36.1075	8000.0
2017-06-16 08:16:00	AAPL	Stock	36.1075	36.1075	36.1075	36.1075	1008.0
2017-06-16 08:17:00	AAPL	Stock	36.11	36.11	36.11	36.11	400.0
2017-06-16 08:18:00	AAPL	Stock	36.1125	36.1125	36.1025	36.1025	3000.0
2017-06-16 08:19:00	AAPL	Stock	36.1075	36.1075	36.1075	36.1075	400.0
2017-06-16 08:22:00	AAPL	Stock	36.1075	36.1075	36.1075	36.1075	400.0
2017-06-16 08:24:00	AAPL	Stock	36.1075	36.1075	36.1075	36.1075	1200.0
2017-06-16 08:28:00	AAPL	Stock	36.0925	36.0925	36.0925	36.0925	560.0
2017-06-16 08:29:00	AAPL	Stock	36.12	36.12	36.1	36.1	1300.0
2017-06-16 08:31:00	AAPL	Stock	36.12	36.12	36.12	36.12	1200.0
2017-06-16 08:32:00	AAPL	Stock	36.1	36.1	36.1	36.1	424.0
2017-06-16 08:33:00	AAPL	Stock	36.0875	36.0875	36.085	36.085	2000.0
2017-06-16 08:34:00	AAPL	Stock	36.085	36.085	36.085	36.085	2400.0

> showing 50 of 1,055,462 rows — these rows as CSV

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