PREVIEW / stock_1min / 2017-07-17

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-07-17.parquet
  size:    14.0 MB
  rows:    1,019,110
  symbols: 2,481

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-17 04:04:00	AAPL	Stock	37.3	37.3	37.3	37.3	2400.0
2017-07-17 05:00:00	AAPL	Stock	37.275	37.275	37.275	37.275	972.0
2017-07-17 05:04:00	AAPL	Stock	37.275	37.275	37.275	37.275	3140.0
2017-07-17 05:23:00	AAPL	Stock	37.2625	37.275	37.2625	37.275	1600.0
2017-07-17 05:51:00	AAPL	Stock	37.305	37.31	37.305	37.31	1480.0
2017-07-17 06:05:00	AAPL	Stock	37.325	37.325	37.31	37.31	1080.0
2017-07-17 06:12:00	AAPL	Stock	37.3325	37.3375	37.3325	37.3375	20800.0
2017-07-17 06:26:00	AAPL	Stock	37.385	37.3875	37.385	37.3875	2000.0
2017-07-17 06:29:00	AAPL	Stock	37.375	37.375	37.375	37.375	400.0
2017-07-17 07:03:00	AAPL	Stock	37.375	37.375	37.35	37.35	9200.0
2017-07-17 07:09:00	AAPL	Stock	37.3725	37.3725	37.3725	37.3725	1000.0
2017-07-17 07:10:00	AAPL	Stock	37.3575	37.3625	37.3575	37.3575	2400.0
2017-07-17 07:12:00	AAPL	Stock	37.3625	37.3625	37.3625	37.3625	3800.0
2017-07-17 07:14:00	AAPL	Stock	37.3725	37.375	37.3725	37.375	3928.0
2017-07-17 07:15:00	AAPL	Stock	37.3775	37.3775	37.3775	37.3775	1000.0
2017-07-17 07:16:00	AAPL	Stock	37.3775	37.3775	37.3775	37.3775	1000.0
2017-07-17 07:17:00	AAPL	Stock	37.3775	37.3775	37.3775	37.3775	2800.0
2017-07-17 07:20:00	AAPL	Stock	37.365	37.3825	37.365	37.3825	800.0
2017-07-17 07:27:00	AAPL	Stock	37.365	37.365	37.365	37.365	800.0
2017-07-17 07:28:00	AAPL	Stock	37.3575	37.3575	37.355	37.355	2400.0
2017-07-17 07:29:00	AAPL	Stock	37.35	37.35	37.3375	37.3375	1744.0
2017-07-17 07:30:00	AAPL	Stock	37.35	37.35	37.35	37.35	800.0
2017-07-17 07:31:00	AAPL	Stock	37.3575	37.3575	37.35	37.35	9344.0
2017-07-17 07:35:00	AAPL	Stock	37.34	37.34	37.34	37.34	1196.0
2017-07-17 07:37:00	AAPL	Stock	37.345	37.345	37.345	37.345	5600.0
2017-07-17 07:39:00	AAPL	Stock	37.345	37.345	37.3	37.3	8320.0
2017-07-17 07:40:00	AAPL	Stock	37.3	37.3	37.275	37.3	14000.0
2017-07-17 07:41:00	AAPL	Stock	37.28	37.2875	37.2775	37.2875	4000.0
2017-07-17 07:42:00	AAPL	Stock	37.3	37.305	37.2975	37.305	3168.0
2017-07-17 07:43:00	AAPL	Stock	37.3	37.3	37.3	37.3	3200.0
2017-07-17 07:47:00	AAPL	Stock	37.3025	37.3025	37.3025	37.3025	600.0
2017-07-17 07:48:00	AAPL	Stock	37.3	37.305	37.3	37.3025	2188.0
2017-07-17 07:49:00	AAPL	Stock	37.305	37.305	37.305	37.305	2400.0
2017-07-17 07:50:00	AAPL	Stock	37.305	37.32	37.305	37.32	10696.0
2017-07-17 07:51:00	AAPL	Stock	37.3175	37.3175	37.3175	37.3175	2000.0
2017-07-17 07:55:00	AAPL	Stock	37.3175	37.3175	37.3175	37.3175	400.0
2017-07-17 07:56:00	AAPL	Stock	37.3175	37.3225	37.3175	37.3225	2128.0
2017-07-17 08:00:00	AAPL	Stock	37.3025	37.4	37.3	37.3225	56440.0
2017-07-17 08:01:00	AAPL	Stock	37.3175	37.3175	37.2925	37.2925	1600.0
2017-07-17 08:02:00	AAPL	Stock	37.2925	37.2925	37.2875	37.2875	1200.0
2017-07-17 08:03:00	AAPL	Stock	37.2875	37.2925	37.2875	37.2925	7200.0
2017-07-17 08:04:00	AAPL	Stock	37.2825	37.3	37.275	37.2925	18028.0
2017-07-17 08:05:00	AAPL	Stock	37.3	37.3	37.3	37.3	2000.0
2017-07-17 08:06:00	AAPL	Stock	37.2875	37.3175	37.2875	37.3175	34020.0
2017-07-17 08:07:00	AAPL	Stock	37.3025	37.3025	37.3025	37.3025	900.0
2017-07-17 08:09:00	AAPL	Stock	37.3025	37.305	37.3025	37.305	5880.0
2017-07-17 08:10:00	AAPL	Stock	37.305	37.305	37.3025	37.3025	2836.0
2017-07-17 08:12:00	AAPL	Stock	37.3175	37.3175	37.3175	37.3175	800.0
2017-07-17 08:14:00	AAPL	Stock	37.315	37.32	37.3025	37.3025	3240.0
2017-07-17 08:18:00	AAPL	Stock	37.3175	37.3175	37.3175	37.3175	1928.0

> showing 50 of 1,019,110 rows — these rows as CSV

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