PREVIEW / stock_1min / 2017-10-25

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-10-25.parquet
  size:    14.9 MB
  rows:    1,063,717
  symbols: 2,424

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-25 04:31:00	AAPL	Stock	39.235	39.2475	39.235	39.2475	4000.0
2017-10-25 04:52:00	AAPL	Stock	39.245	39.245	39.245	39.245	760.0
2017-10-25 04:55:00	AAPL	Stock	39.23	39.23	39.23	39.23	1600.0
2017-10-25 04:57:00	AAPL	Stock	39.23	39.23	39.23	39.23	1600.0
2017-10-25 05:06:00	AAPL	Stock	39.2475	39.2575	39.2475	39.2575	6712.0
2017-10-25 05:14:00	AAPL	Stock	39.31	39.31	39.25	39.25	1200.0
2017-10-25 05:31:00	AAPL	Stock	39.25	39.25	39.2375	39.2375	968.0
2017-10-25 06:00:00	AAPL	Stock	39.3225	39.3225	39.3225	39.3225	1156.0
2017-10-25 06:11:00	AAPL	Stock	39.3225	39.3225	39.3225	39.3225	832.0
2017-10-25 06:33:00	AAPL	Stock	39.275	39.275	39.275	39.275	400.0
2017-10-25 06:52:00	AAPL	Stock	39.25	39.25	39.25	39.25	800.0
2017-10-25 06:55:00	AAPL	Stock	39.3	39.3	39.3	39.3	4000.0
2017-10-25 07:09:00	AAPL	Stock	39.2775	39.2775	39.2775	39.2775	400.0
2017-10-25 07:10:00	AAPL	Stock	39.3	39.3	39.3	39.3	800.0
2017-10-25 07:15:00	AAPL	Stock	39.2975	39.3	39.2975	39.3	2400.0
2017-10-25 07:17:00	AAPL	Stock	39.3	39.3	39.3	39.3	1660.0
2017-10-25 07:22:00	AAPL	Stock	39.2975	39.3125	39.2975	39.3125	4300.0
2017-10-25 07:23:00	AAPL	Stock	39.3125	39.35	39.3125	39.35	12656.0
2017-10-25 07:26:00	AAPL	Stock	39.3125	39.3125	39.3125	39.3125	400.0
2017-10-25 07:30:00	AAPL	Stock	39.3	39.3	39.3	39.3	444.0
2017-10-25 07:36:00	AAPL	Stock	39.3	39.3	39.3	39.3	1684.0
2017-10-25 07:40:00	AAPL	Stock	39.3	39.3	39.3	39.3	400.0
2017-10-25 07:53:00	AAPL	Stock	39.3	39.3	39.3	39.3	800.0
2017-10-25 07:55:00	AAPL	Stock	39.315	39.315	39.315	39.315	400.0
2017-10-25 07:56:00	AAPL	Stock	39.315	39.315	39.315	39.315	1600.0
2017-10-25 07:57:00	AAPL	Stock	39.315	39.315	39.3	39.3	3576.0
2017-10-25 08:00:00	AAPL	Stock	39.3	39.3175	39.275	39.2925	20372.0
2017-10-25 08:01:00	AAPL	Stock	39.2925	39.2925	39.2925	39.2925	3228.0
2017-10-25 08:02:00	AAPL	Stock	39.2925	39.3	39.2925	39.3	800.0
2017-10-25 08:04:00	AAPL	Stock	39.2825	39.2825	39.2825	39.2825	440.0
2017-10-25 08:07:00	AAPL	Stock	39.275	39.28	39.275	39.28	3520.0
2017-10-25 08:14:00	AAPL	Stock	39.3	39.3	39.2825	39.2825	8556.0
2017-10-25 08:15:00	AAPL	Stock	39.3	39.3	39.3	39.3	400.0
2017-10-25 08:17:00	AAPL	Stock	39.2875	39.2875	39.2875	39.2875	1800.0
2017-10-25 08:20:00	AAPL	Stock	39.2875	39.2875	39.2875	39.2875	400.0
2017-10-25 08:24:00	AAPL	Stock	39.2925	39.2925	39.2925	39.2925	4400.0
2017-10-25 08:25:00	AAPL	Stock	39.2925	39.2975	39.2925	39.2975	1432.0
2017-10-25 08:27:00	AAPL	Stock	39.3125	39.3125	39.31	39.31	1436.0
2017-10-25 08:29:00	AAPL	Stock	39.31	39.31	39.31	39.31	6448.0
2017-10-25 08:30:00	AAPL	Stock	39.31	39.31	39.31	39.31	6000.0
2017-10-25 08:31:00	AAPL	Stock	39.3125	39.3125	39.3125	39.3125	1200.0
2017-10-25 08:35:00	AAPL	Stock	39.3125	39.3125	39.3125	39.3125	1200.0
2017-10-25 08:36:00	AAPL	Stock	39.315	39.3175	39.3125	39.3175	5236.0
2017-10-25 08:37:00	AAPL	Stock	39.3125	39.315	39.3125	39.315	1600.0
2017-10-25 08:38:00	AAPL	Stock	39.3	39.3	39.3	39.3	2192.0
2017-10-25 08:39:00	AAPL	Stock	39.3	39.3	39.3	39.3	816.0
2017-10-25 08:42:00	AAPL	Stock	39.305	39.31	39.305	39.31	3200.0
2017-10-25 08:43:00	AAPL	Stock	39.31	39.3175	39.31	39.3175	3360.0
2017-10-25 08:44:00	AAPL	Stock	39.3175	39.3175	39.3175	39.3175	800.0
2017-10-25 08:45:00	AAPL	Stock	39.3175	39.3175	39.3175	39.3175	2400.0

> showing 50 of 1,063,717 rows — these rows as CSV

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