PREVIEW / stock_1min / 2017-08-03

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-08-03.parquet
  size:    14.4 MB
  rows:    1,041,736
  symbols: 2,472

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-08-03 04:00:00	AAPL	Stock	39.2875	39.2875	39.2875	39.2875	736.0
2017-08-03 04:06:00	AAPL	Stock	39.265	39.265	39.265	39.265	800.0
2017-08-03 04:37:00	AAPL	Stock	39.285	39.285	39.285	39.285	2000.0
2017-08-03 05:00:00	AAPL	Stock	39.285	39.285	39.285	39.285	496.0
2017-08-03 05:05:00	AAPL	Stock	39.2875	39.2875	39.2875	39.2875	1200.0
2017-08-03 05:21:00	AAPL	Stock	39.37	39.37	39.37	39.37	800.0
2017-08-03 05:37:00	AAPL	Stock	39.35	39.35	39.35	39.35	3600.0
2017-08-03 05:47:00	AAPL	Stock	39.35	39.35	39.35	39.35	400.0
2017-08-03 05:55:00	AAPL	Stock	39.3375	39.3375	39.3375	39.3375	400.0
2017-08-03 05:58:00	AAPL	Stock	39.35	39.35	39.35	39.35	3652.0
2017-08-03 06:06:00	AAPL	Stock	39.35	39.35	39.3475	39.35	2800.0
2017-08-03 06:11:00	AAPL	Stock	39.35	39.35	39.35	39.35	400.0
2017-08-03 06:12:00	AAPL	Stock	39.35	39.35	39.35	39.35	800.0
2017-08-03 06:28:00	AAPL	Stock	39.325	39.325	39.325	39.325	8340.0
2017-08-03 06:31:00	AAPL	Stock	39.325	39.325	39.325	39.325	1148.0
2017-08-03 06:33:00	AAPL	Stock	39.3	39.3	39.3	39.3	4000.0
2017-08-03 06:39:00	AAPL	Stock	39.32	39.32	39.32	39.32	400.0
2017-08-03 06:42:00	AAPL	Stock	39.305	39.305	39.305	39.305	3864.0
2017-08-03 06:43:00	AAPL	Stock	39.3175	39.3175	39.3175	39.3175	400.0
2017-08-03 06:47:00	AAPL	Stock	39.32	39.32	39.32	39.32	800.0
2017-08-03 06:48:00	AAPL	Stock	39.29	39.29	39.29	39.29	2000.0
2017-08-03 06:51:00	AAPL	Stock	39.2925	39.2925	39.2925	39.2925	400.0
2017-08-03 06:53:00	AAPL	Stock	39.3125	39.325	39.3125	39.325	7620.0
2017-08-03 07:00:00	AAPL	Stock	39.3	39.3025	39.3	39.3	4588.0
2017-08-03 07:01:00	AAPL	Stock	39.3225	39.35	39.29	39.29	8800.0
2017-08-03 07:02:00	AAPL	Stock	39.325	39.325	39.325	39.325	400.0
2017-08-03 07:05:00	AAPL	Stock	39.3	39.3	39.3	39.3	4000.0
2017-08-03 07:08:00	AAPL	Stock	39.2825	39.2825	39.275	39.275	5204.0
2017-08-03 07:09:00	AAPL	Stock	39.265	39.265	39.2625	39.2625	3200.0
2017-08-03 07:10:00	AAPL	Stock	39.255	39.2625	39.25	39.25	4540.0
2017-08-03 07:11:00	AAPL	Stock	39.255	39.255	39.255	39.255	800.0
2017-08-03 07:12:00	AAPL	Stock	39.2725	39.2725	39.2725	39.2725	800.0
2017-08-03 07:13:00	AAPL	Stock	39.255	39.255	39.255	39.255	1600.0
2017-08-03 07:15:00	AAPL	Stock	39.255	39.255	39.255	39.255	1600.0
2017-08-03 07:21:00	AAPL	Stock	39.255	39.255	39.255	39.255	400.0
2017-08-03 07:25:00	AAPL	Stock	39.2725	39.295	39.2725	39.295	3700.0
2017-08-03 07:26:00	AAPL	Stock	39.29	39.2925	39.29	39.2925	1452.0
2017-08-03 07:27:00	AAPL	Stock	39.285	39.285	39.285	39.285	6104.0
2017-08-03 07:28:00	AAPL	Stock	39.275	39.275	39.275	39.275	1100.0
2017-08-03 07:30:00	AAPL	Stock	39.275	39.275	39.275	39.275	400.0
2017-08-03 07:33:00	AAPL	Stock	39.275	39.275	39.275	39.275	1048.0
2017-08-03 07:34:00	AAPL	Stock	39.26	39.26	39.26	39.26	800.0
2017-08-03 07:37:00	AAPL	Stock	39.275	39.275	39.275	39.275	400.0
2017-08-03 07:38:00	AAPL	Stock	39.265	39.265	39.26	39.26	1200.0
2017-08-03 07:39:00	AAPL	Stock	39.28	39.28	39.28	39.28	460.0
2017-08-03 07:48:00	AAPL	Stock	39.2675	39.2675	39.2675	39.2675	4528.0
2017-08-03 07:52:00	AAPL	Stock	39.265	39.265	39.265	39.265	400.0
2017-08-03 07:55:00	AAPL	Stock	39.2625	39.275	39.2625	39.275	6496.0
2017-08-03 07:56:00	AAPL	Stock	39.265	39.265	39.265	39.265	400.0
2017-08-03 07:57:00	AAPL	Stock	39.2575	39.2575	39.2575	39.2575	400.0

> showing 50 of 1,041,736 rows — these rows as CSV

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