PREVIEW / stock_1min / 2016-09-20

all stock 1-min files

  file:    by_date/stock_1min/2016/2016-09-20.parquet
  size:    13.7 MB
  rows:    1,012,357
  symbols: 2,651

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
2016-09-20 04:00:00	AAPL	Stock	28.395	28.395	28.395	28.395	1200.0
2016-09-20 04:02:00	AAPL	Stock	28.3575	28.3575	28.3575	28.3575	400.0
2016-09-20 04:10:00	AAPL	Stock	28.37	28.37	28.37	28.37	400.0
2016-09-20 05:03:00	AAPL	Stock	28.3325	28.3325	28.325	28.325	2000.0
2016-09-20 05:14:00	AAPL	Stock	28.3075	28.325	28.3075	28.325	1480.0
2016-09-20 05:18:00	AAPL	Stock	28.3	28.3	28.3	28.3	400.0
2016-09-20 05:27:00	AAPL	Stock	28.3	28.3	28.3	28.3	400.0
2016-09-20 05:28:00	AAPL	Stock	28.2925	28.2925	28.2925	28.2925	1200.0
2016-09-20 05:40:00	AAPL	Stock	28.32	28.3225	28.32	28.3225	4120.0
2016-09-20 05:41:00	AAPL	Stock	28.325	28.325	28.325	28.325	1856.0
2016-09-20 05:43:00	AAPL	Stock	28.3325	28.3325	28.3325	28.3325	400.0
2016-09-20 05:59:00	AAPL	Stock	28.3325	28.3325	28.3275	28.3275	1740.0
2016-09-20 06:28:00	AAPL	Stock	28.37	28.37	28.37	28.37	400.0
2016-09-20 06:32:00	AAPL	Stock	28.3475	28.3975	28.345	28.3725	7996.0
2016-09-20 06:35:00	AAPL	Stock	28.375	28.43	28.375	28.4275	9420.0
2016-09-20 06:36:00	AAPL	Stock	28.47	28.47	28.4275	28.4275	2800.0
2016-09-20 06:37:00	AAPL	Stock	28.395	28.395	28.395	28.395	400.0
2016-09-20 06:44:00	AAPL	Stock	28.4	28.4	28.4	28.4	4400.0
2016-09-20 06:45:00	AAPL	Stock	28.375	28.375	28.375	28.375	2000.0
2016-09-20 06:50:00	AAPL	Stock	28.38	28.38	28.38	28.38	652.0
2016-09-20 06:54:00	AAPL	Stock	28.405	28.405	28.405	28.405	1600.0
2016-09-20 06:55:00	AAPL	Stock	28.39	28.39	28.375	28.375	11172.0
2016-09-20 07:01:00	AAPL	Stock	28.35	28.35	28.35	28.35	400.0
2016-09-20 07:02:00	AAPL	Stock	28.4	28.4	28.4	28.4	2400.0
2016-09-20 07:03:00	AAPL	Stock	28.4	28.4225	28.4	28.4125	6620.0
2016-09-20 07:04:00	AAPL	Stock	28.4125	28.4225	28.4125	28.4225	3480.0
2016-09-20 07:05:00	AAPL	Stock	28.4275	28.4275	28.4275	28.4275	400.0
2016-09-20 07:06:00	AAPL	Stock	28.425	28.425	28.425	28.425	400.0
2016-09-20 07:07:00	AAPL	Stock	28.425	28.425	28.425	28.425	800.0
2016-09-20 07:08:00	AAPL	Stock	28.425	28.425	28.425	28.425	4180.0
2016-09-20 07:13:00	AAPL	Stock	28.4025	28.4025	28.4025	28.4025	1456.0
2016-09-20 07:16:00	AAPL	Stock	28.4025	28.4025	28.3775	28.3775	4088.0
2016-09-20 07:17:00	AAPL	Stock	28.3775	28.3775	28.375	28.375	7656.0
2016-09-20 07:23:00	AAPL	Stock	28.3625	28.3625	28.3625	28.3625	400.0
2016-09-20 07:29:00	AAPL	Stock	28.3675	28.3675	28.365	28.365	3800.0
2016-09-20 07:31:00	AAPL	Stock	28.365	28.365	28.365	28.365	1200.0
2016-09-20 07:40:00	AAPL	Stock	28.3625	28.3625	28.3625	28.3625	4000.0
2016-09-20 07:41:00	AAPL	Stock	28.3625	28.3625	28.33	28.33	16888.0
2016-09-20 07:42:00	AAPL	Stock	28.335	28.335	28.295	28.295	10024.0
2016-09-20 07:43:00	AAPL	Stock	28.285	28.285	28.2625	28.2625	14400.0
2016-09-20 07:44:00	AAPL	Stock	28.2775	28.3125	28.2775	28.2775	9800.0
2016-09-20 07:45:00	AAPL	Stock	28.2825	28.2825	28.265	28.265	7000.0
2016-09-20 07:46:00	AAPL	Stock	28.2775	28.32	28.275	28.275	20380.0
2016-09-20 07:48:00	AAPL	Stock	28.3	28.32	28.2875	28.32	7200.0
2016-09-20 07:49:00	AAPL	Stock	28.32	28.32	28.275	28.2775	8700.0
2016-09-20 07:50:00	AAPL	Stock	28.28	28.28	28.26	28.2625	51020.0
2016-09-20 07:51:00	AAPL	Stock	28.275	28.2875	28.275	28.275	13200.0
2016-09-20 07:59:00	AAPL	Stock	28.285	28.285	28.2575	28.2575	17656.0
2016-09-20 08:00:00	AAPL	Stock	28.275	28.4275	28.2575	28.3175	91184.0
2016-09-20 08:01:00	AAPL	Stock	28.31	28.32	28.3075	28.32	8400.0

> showing 50 of 1,012,357 rows — these rows as CSV

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