PREVIEW / stock_1min / 2017-10-19

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-10-19.parquet
  size:    14.0 MB
  rows:    1,013,305
  symbols: 2,421

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-19 04:00:00	AAPL	Stock	39.625	39.625	39.425	39.425	11152.0
2017-10-19 04:01:00	AAPL	Stock	39.39	39.39	39.39	39.39	1600.0
2017-10-19 04:03:00	AAPL	Stock	39.415	39.415	39.325	39.325	3448.0
2017-10-19 04:04:00	AAPL	Stock	39.35	39.35	39.35	39.35	448.0
2017-10-19 04:06:00	AAPL	Stock	39.325	39.325	39.325	39.325	1252.0
2017-10-19 04:09:00	AAPL	Stock	39.3	39.3	39.3	39.3	600.0
2017-10-19 04:15:00	AAPL	Stock	39.25	39.25	39.225	39.225	2540.0
2017-10-19 04:16:00	AAPL	Stock	39.2125	39.2125	39.2125	39.2125	400.0
2017-10-19 04:17:00	AAPL	Stock	39.3125	39.3125	39.3125	39.3125	800.0
2017-10-19 04:23:00	AAPL	Stock	39.4	39.4	39.4	39.4	400.0
2017-10-19 04:29:00	AAPL	Stock	39.375	39.375	39.375	39.375	4000.0
2017-10-19 04:32:00	AAPL	Stock	39.425	39.425	39.425	39.425	800.0
2017-10-19 04:34:00	AAPL	Stock	39.42	39.42	39.42	39.42	400.0
2017-10-19 04:35:00	AAPL	Stock	39.4175	39.4175	39.4175	39.4175	10400.0
2017-10-19 04:36:00	AAPL	Stock	39.365	39.365	39.365	39.365	400.0
2017-10-19 04:37:00	AAPL	Stock	39.385	39.415	39.385	39.415	800.0
2017-10-19 04:39:00	AAPL	Stock	39.375	39.375	39.275	39.275	11492.0
2017-10-19 04:40:00	AAPL	Stock	39.36	39.36	39.36	39.36	800.0
2017-10-19 04:42:00	AAPL	Stock	39.3625	39.3625	39.3625	39.3625	692.0
2017-10-19 04:57:00	AAPL	Stock	39.3625	39.42	39.3625	39.42	800.0
2017-10-19 05:00:00	AAPL	Stock	39.3625	39.3625	39.3625	39.3625	3500.0
2017-10-19 05:08:00	AAPL	Stock	39.3625	39.3625	39.3625	39.3625	600.0
2017-10-19 05:11:00	AAPL	Stock	39.3625	39.3625	39.3625	39.3625	400.0
2017-10-19 05:14:00	AAPL	Stock	39.3725	39.3725	39.3725	39.3725	400.0
2017-10-19 05:15:00	AAPL	Stock	39.3625	39.3625	39.3625	39.3625	800.0
2017-10-19 05:19:00	AAPL	Stock	39.36	39.36	39.36	39.36	400.0
2017-10-19 05:21:00	AAPL	Stock	39.36	39.36	39.36	39.36	800.0
2017-10-19 05:25:00	AAPL	Stock	39.3575	39.3575	39.3575	39.3575	400.0
2017-10-19 05:26:00	AAPL	Stock	39.3575	39.3575	39.3575	39.3575	400.0
2017-10-19 05:30:00	AAPL	Stock	39.3575	39.3575	39.3575	39.3575	1600.0
2017-10-19 05:40:00	AAPL	Stock	39.3125	39.3125	39.3125	39.3125	1576.0
2017-10-19 05:42:00	AAPL	Stock	39.35	39.36	39.35	39.36	2000.0
2017-10-19 05:45:00	AAPL	Stock	39.36	39.36	39.36	39.36	400.0
2017-10-19 05:51:00	AAPL	Stock	39.36	39.36	39.36	39.36	400.0
2017-10-19 05:52:00	AAPL	Stock	39.36	39.36	39.35	39.35	8400.0
2017-10-19 05:57:00	AAPL	Stock	39.3425	39.3425	39.3375	39.3375	4344.0
2017-10-19 05:58:00	AAPL	Stock	39.3375	39.3375	39.3375	39.3375	7600.0
2017-10-19 06:00:00	AAPL	Stock	39.335	39.335	39.335	39.335	1200.0
2017-10-19 06:01:00	AAPL	Stock	39.3325	39.335	39.325	39.325	9600.0
2017-10-19 06:02:00	AAPL	Stock	39.3	39.315	39.3	39.315	5200.0
2017-10-19 06:03:00	AAPL	Stock	39.325	39.325	39.325	39.325	800.0
2017-10-19 06:04:00	AAPL	Stock	39.315	39.315	39.315	39.315	800.0
2017-10-19 06:05:00	AAPL	Stock	39.315	39.325	39.315	39.325	7600.0
2017-10-19 06:06:00	AAPL	Stock	39.325	39.325	39.325	39.325	400.0
2017-10-19 06:07:00	AAPL	Stock	39.3325	39.3375	39.3325	39.3375	2000.0
2017-10-19 06:14:00	AAPL	Stock	39.325	39.325	39.325	39.325	400.0
2017-10-19 06:15:00	AAPL	Stock	39.3025	39.3025	39.3025	39.3025	440.0
2017-10-19 06:17:00	AAPL	Stock	39.3025	39.3025	39.3025	39.3025	800.0
2017-10-19 06:21:00	AAPL	Stock	39.32	39.32	39.32	39.32	800.0
2017-10-19 06:22:00	AAPL	Stock	39.3025	39.3025	39.29	39.3	12700.0

> showing 50 of 1,013,305 rows — these rows as CSV

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