PREVIEW / stock_1min / 2017-07-18

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-07-18.parquet
  size:    13.8 MB
  rows:    1,001,196
  symbols: 2,485

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-07-18 04:18:00	AAPL	Stock	37.3775	37.3775	37.3775	37.3775	400.0
2017-07-18 04:28:00	AAPL	Stock	37.375	37.375	37.375	37.375	800.0
2017-07-18 04:29:00	AAPL	Stock	37.375	37.375	37.375	37.375	824.0
2017-07-18 04:30:00	AAPL	Stock	37.375	37.375	37.375	37.375	636.0
2017-07-18 04:37:00	AAPL	Stock	37.375	37.375	37.375	37.375	5864.0
2017-07-18 05:48:00	AAPL	Stock	37.405	37.405	37.405	37.405	800.0
2017-07-18 06:02:00	AAPL	Stock	37.405	37.405	37.405	37.405	1080.0
2017-07-18 06:03:00	AAPL	Stock	37.38	37.38	37.38	37.38	400.0
2017-07-18 06:18:00	AAPL	Stock	37.385	37.385	37.38	37.38	2000.0
2017-07-18 06:29:00	AAPL	Stock	37.38	37.38	37.38	37.38	400.0
2017-07-18 06:32:00	AAPL	Stock	37.375	37.375	37.375	37.375	1600.0
2017-07-18 06:40:00	AAPL	Stock	37.3625	37.3625	37.35	37.35	4400.0
2017-07-18 06:51:00	AAPL	Stock	37.3725	37.3725	37.3525	37.3525	1200.0
2017-07-18 06:54:00	AAPL	Stock	37.3725	37.3725	37.3725	37.3725	400.0
2017-07-18 06:58:00	AAPL	Stock	37.3625	37.3625	37.35	37.35	2000.0
2017-07-18 07:01:00	AAPL	Stock	37.35	37.3625	37.35	37.3625	2800.0
2017-07-18 07:02:00	AAPL	Stock	37.35	37.35	37.35	37.35	400.0
2017-07-18 07:05:00	AAPL	Stock	37.3625	37.365	37.3625	37.365	800.0
2017-07-18 07:08:00	AAPL	Stock	37.3725	37.38	37.355	37.3625	6600.0
2017-07-18 07:10:00	AAPL	Stock	37.3525	37.3525	37.3125	37.3125	10556.0
2017-07-18 07:11:00	AAPL	Stock	37.3125	37.3125	37.2875	37.2925	12852.0
2017-07-18 07:12:00	AAPL	Stock	37.295	37.295	37.2875	37.2875	8000.0
2017-07-18 07:13:00	AAPL	Stock	37.3225	37.3225	37.3225	37.3225	400.0
2017-07-18 07:17:00	AAPL	Stock	37.3	37.3	37.3	37.3	600.0
2017-07-18 07:18:00	AAPL	Stock	37.3175	37.3175	37.3	37.3	8576.0
2017-07-18 07:24:00	AAPL	Stock	37.295	37.295	37.295	37.295	800.0
2017-07-18 07:26:00	AAPL	Stock	37.29	37.29	37.2875	37.2875	21896.0
2017-07-18 07:28:00	AAPL	Stock	37.3	37.3	37.3	37.3	1000.0
2017-07-18 07:31:00	AAPL	Stock	37.2925	37.2925	37.29	37.29	2800.0
2017-07-18 07:32:00	AAPL	Stock	37.2875	37.2875	37.2875	37.2875	4800.0
2017-07-18 07:35:00	AAPL	Stock	37.2925	37.2925	37.2925	37.2925	800.0
2017-07-18 07:38:00	AAPL	Stock	37.2875	37.295	37.2875	37.295	2300.0
2017-07-18 07:40:00	AAPL	Stock	37.295	37.295	37.295	37.295	400.0
2017-07-18 07:45:00	AAPL	Stock	37.295	37.295	37.295	37.295	2800.0
2017-07-18 07:52:00	AAPL	Stock	37.275	37.275	37.275	37.275	1568.0
2017-07-18 07:54:00	AAPL	Stock	37.275	37.275	37.275	37.275	8000.0
2017-07-18 08:00:00	AAPL	Stock	37.29	37.3725	37.2775	37.3125	19668.0
2017-07-18 08:02:00	AAPL	Stock	37.3125	37.3125	37.3125	37.3125	904.0
2017-07-18 08:03:00	AAPL	Stock	37.335	37.335	37.335	37.335	2000.0
2017-07-18 08:05:00	AAPL	Stock	37.3075	37.3075	37.3075	37.3075	400.0
2017-07-18 08:06:00	AAPL	Stock	37.325	37.325	37.325	37.325	1860.0
2017-07-18 08:07:00	AAPL	Stock	37.3375	37.3375	37.3375	37.3375	13800.0
2017-07-18 08:08:00	AAPL	Stock	37.3375	37.3375	37.3375	37.3375	400.0
2017-07-18 08:10:00	AAPL	Stock	37.325	37.325	37.325	37.325	800.0
2017-07-18 08:12:00	AAPL	Stock	37.3225	37.3225	37.3225	37.3225	400.0
2017-07-18 08:13:00	AAPL	Stock	37.32	37.32	37.32	37.32	400.0
2017-07-18 08:16:00	AAPL	Stock	37.3225	37.3225	37.3225	37.3225	800.0
2017-07-18 08:18:00	AAPL	Stock	37.3425	37.3425	37.3425	37.3425	800.0
2017-07-18 08:20:00	AAPL	Stock	37.32	37.32	37.32	37.32	9496.0
2017-07-18 08:21:00	AAPL	Stock	37.3375	37.3425	37.315	37.315	15968.0

> showing 50 of 1,001,196 rows — these rows as CSV

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