PREVIEW / stock_1min / 2017-09-27

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-09-27.parquet
  size:    15.4 MB
  rows:    1,104,060
  symbols: 2,452

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-09-27 04:09:00	AAPL	Stock	38.4275	38.4275	38.4275	38.4275	400.0
2017-09-27 04:47:00	AAPL	Stock	38.485	38.485	38.485	38.485	400.0
2017-09-27 04:49:00	AAPL	Stock	38.56	38.56	38.56	38.56	400.0
2017-09-27 05:00:00	AAPL	Stock	38.49	38.49	38.49	38.49	800.0
2017-09-27 05:16:00	AAPL	Stock	38.5	38.5	38.5	38.5	400.0
2017-09-27 05:17:00	AAPL	Stock	38.55	38.55	38.55	38.55	400.0
2017-09-27 05:21:00	AAPL	Stock	38.5	38.5	38.5	38.5	744.0
2017-09-27 05:22:00	AAPL	Stock	38.5	38.5	38.5	38.5	2944.0
2017-09-27 05:27:00	AAPL	Stock	38.5025	38.5025	38.5025	38.5025	400.0
2017-09-27 05:31:00	AAPL	Stock	38.5	38.5	38.5	38.5	400.0
2017-09-27 05:33:00	AAPL	Stock	38.545	38.545	38.545	38.545	436.0
2017-09-27 05:39:00	AAPL	Stock	38.545	38.545	38.545	38.545	400.0
2017-09-27 05:43:00	AAPL	Stock	38.5425	38.545	38.5425	38.545	2896.0
2017-09-27 05:47:00	AAPL	Stock	38.52	38.52	38.52	38.52	512.0
2017-09-27 06:09:00	AAPL	Stock	38.465	38.465	38.465	38.465	400.0
2017-09-27 06:10:00	AAPL	Stock	38.4625	38.4625	38.4625	38.4625	1600.0
2017-09-27 06:25:00	AAPL	Stock	38.5175	38.5175	38.5175	38.5175	400.0
2017-09-27 06:32:00	AAPL	Stock	38.5	38.5	38.5	38.5	4000.0
2017-09-27 06:34:00	AAPL	Stock	38.5	38.5	38.5	38.5	988.0
2017-09-27 06:35:00	AAPL	Stock	38.52	38.52	38.5	38.5	1560.0
2017-09-27 06:36:00	AAPL	Stock	38.5	38.5	38.5	38.5	1600.0
2017-09-27 06:50:00	AAPL	Stock	38.52	38.55	38.52	38.55	8704.0
2017-09-27 06:54:00	AAPL	Stock	38.5375	38.575	38.5375	38.575	45440.0
2017-09-27 07:00:00	AAPL	Stock	38.56	38.6	38.56	38.6	15668.0
2017-09-27 07:01:00	AAPL	Stock	38.6	38.6625	38.575	38.575	13468.0
2017-09-27 07:03:00	AAPL	Stock	38.575	38.575	38.575	38.575	8552.0
2017-09-27 07:04:00	AAPL	Stock	38.575	38.575	38.575	38.575	1600.0
2017-09-27 07:05:00	AAPL	Stock	38.575	38.575	38.2875	38.3625	94180.0
2017-09-27 07:06:00	AAPL	Stock	38.3625	38.3625	38.275	38.2975	10052.0
2017-09-27 07:07:00	AAPL	Stock	38.275	38.35	38.275	38.305	17168.0
2017-09-27 07:08:00	AAPL	Stock	38.3475	38.3475	38.275	38.3	23628.0
2017-09-27 07:09:00	AAPL	Stock	38.345	38.3875	38.33	38.33	16400.0
2017-09-27 07:10:00	AAPL	Stock	38.3775	38.4	38.35	38.35	6460.0
2017-09-27 07:12:00	AAPL	Stock	38.3725	38.3725	38.33	38.33	7536.0
2017-09-27 07:13:00	AAPL	Stock	38.375	38.375	38.375	38.375	5980.0
2017-09-27 07:14:00	AAPL	Stock	38.375	38.375	38.375	38.375	3640.0
2017-09-27 07:15:00	AAPL	Stock	38.375	38.415	38.375	38.4	15440.0
2017-09-27 07:16:00	AAPL	Stock	38.4375	38.45	38.4375	38.45	19604.0
2017-09-27 07:17:00	AAPL	Stock	38.45	38.45	38.45	38.45	49568.0
2017-09-27 07:18:00	AAPL	Stock	38.4525	38.4525	38.4425	38.4425	1200.0
2017-09-27 07:19:00	AAPL	Stock	38.435	38.435	38.435	38.435	19812.0
2017-09-27 07:20:00	AAPL	Stock	38.43	38.43	38.43	38.43	800.0
2017-09-27 07:22:00	AAPL	Stock	38.4	38.4	38.4	38.4	400.0
2017-09-27 07:24:00	AAPL	Stock	38.39	38.39	38.39	38.39	4000.0
2017-09-27 07:25:00	AAPL	Stock	38.3925	38.3925	38.39	38.3925	9200.0
2017-09-27 07:26:00	AAPL	Stock	38.39	38.42	38.375	38.42	9000.0
2017-09-27 07:29:00	AAPL	Stock	38.3875	38.4125	38.38	38.3875	3320.0
2017-09-27 07:30:00	AAPL	Stock	38.405	38.405	38.395	38.395	2000.0
2017-09-27 07:32:00	AAPL	Stock	38.4	38.4025	38.4	38.4	3600.0
2017-09-27 07:33:00	AAPL	Stock	38.4	38.4	38.4	38.4	2800.0

> showing 50 of 1,104,060 rows — these rows as CSV

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