PREVIEW / stock_1min / 2017-09-29

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-09-29.parquet
  size:    14.3 MB
  rows:    1,041,194
  symbols: 2,456

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-09-29 04:00:00	AAPL	Stock	38.3175	38.3175	38.3175	38.3175	2000.0
2017-09-29 04:05:00	AAPL	Stock	38.3	38.3	38.3	38.3	4752.0
2017-09-29 04:06:00	AAPL	Stock	38.3	38.3	38.3	38.3	400.0
2017-09-29 04:19:00	AAPL	Stock	38.3325	38.3325	38.3325	38.3325	1600.0
2017-09-29 04:20:00	AAPL	Stock	38.3	38.3	38.3	38.3	1600.0
2017-09-29 04:25:00	AAPL	Stock	38.35	38.35	38.35	38.35	1600.0
2017-09-29 04:53:00	AAPL	Stock	38.35	38.35	38.35	38.35	400.0
2017-09-29 04:54:00	AAPL	Stock	38.3025	38.3025	38.3025	38.3025	1396.0
2017-09-29 05:07:00	AAPL	Stock	38.3025	38.3025	38.3025	38.3025	400.0
2017-09-29 05:27:00	AAPL	Stock	38.3625	38.3625	38.3625	38.3625	400.0
2017-09-29 05:57:00	AAPL	Stock	38.3625	38.3625	38.3625	38.3625	400.0
2017-09-29 06:02:00	AAPL	Stock	38.3175	38.3175	38.3175	38.3175	400.0
2017-09-29 06:06:00	AAPL	Stock	38.325	38.325	38.325	38.325	400.0
2017-09-29 06:38:00	AAPL	Stock	38.3275	38.3275	38.3275	38.3275	3876.0
2017-09-29 06:47:00	AAPL	Stock	38.35	38.35	38.35	38.35	400.0
2017-09-29 06:49:00	AAPL	Stock	38.35	38.35	38.35	38.35	400.0
2017-09-29 06:59:00	AAPL	Stock	38.3125	38.35	38.3	38.35	2800.0
2017-09-29 07:00:00	AAPL	Stock	38.35	38.35	38.325	38.325	8360.0
2017-09-29 07:01:00	AAPL	Stock	38.325	38.325	38.3125	38.3125	7152.0
2017-09-29 07:10:00	AAPL	Stock	38.3175	38.3175	38.3125	38.3125	7196.0
2017-09-29 07:11:00	AAPL	Stock	38.3	38.3125	38.3	38.3	38528.0
2017-09-29 07:12:00	AAPL	Stock	38.3	38.4	38.3	38.4	9744.0
2017-09-29 07:21:00	AAPL	Stock	38.37	38.37	38.37	38.37	400.0
2017-09-29 07:23:00	AAPL	Stock	38.3125	38.3125	38.3125	38.3125	6856.0
2017-09-29 07:26:00	AAPL	Stock	38.2775	38.2775	38.2775	38.2775	400.0
2017-09-29 07:28:00	AAPL	Stock	38.3	38.3	38.2975	38.2975	2400.0
2017-09-29 07:29:00	AAPL	Stock	38.3	38.3	38.28	38.28	2640.0
2017-09-29 07:30:00	AAPL	Stock	38.28	38.28	38.28	38.28	400.0
2017-09-29 07:31:00	AAPL	Stock	38.2825	38.2825	38.2825	38.2825	1640.0
2017-09-29 07:32:00	AAPL	Stock	38.28	38.28	38.28	38.28	1640.0
2017-09-29 07:33:00	AAPL	Stock	38.3	38.3	38.3	38.3	400.0
2017-09-29 07:34:00	AAPL	Stock	38.3	38.3	38.2875	38.3	13916.0
2017-09-29 07:37:00	AAPL	Stock	38.3	38.3025	38.3	38.3025	2364.0
2017-09-29 07:41:00	AAPL	Stock	38.32	38.32	38.32	38.32	400.0
2017-09-29 07:48:00	AAPL	Stock	38.3	38.3	38.2975	38.2975	4744.0
2017-09-29 07:49:00	AAPL	Stock	38.2975	38.2975	38.2975	38.2975	3436.0
2017-09-29 07:54:00	AAPL	Stock	38.2875	38.2875	38.2875	38.2875	6000.0
2017-09-29 07:55:00	AAPL	Stock	38.2875	38.2875	38.2875	38.2875	4000.0
2017-09-29 08:00:00	AAPL	Stock	38.3475	38.375	38.28	38.28	29700.0
2017-09-29 08:01:00	AAPL	Stock	38.28	38.28	38.275	38.275	3236.0
2017-09-29 08:02:00	AAPL	Stock	38.2625	38.275	38.2625	38.275	11364.0
2017-09-29 08:03:00	AAPL	Stock	38.275	38.275	38.255	38.255	6000.0
2017-09-29 08:04:00	AAPL	Stock	38.255	38.275	38.255	38.2625	12920.0
2017-09-29 08:05:00	AAPL	Stock	38.275	38.275	38.2575	38.275	6468.0
2017-09-29 08:06:00	AAPL	Stock	38.275	38.275	38.2625	38.2625	1468.0
2017-09-29 08:09:00	AAPL	Stock	38.265	38.275	38.265	38.275	1400.0
2017-09-29 08:11:00	AAPL	Stock	38.3	38.3	38.3	38.3	6000.0
2017-09-29 08:13:00	AAPL	Stock	38.275	38.275	38.275	38.275	1920.0
2017-09-29 08:14:00	AAPL	Stock	38.2775	38.2775	38.275	38.275	16800.0
2017-09-29 08:15:00	AAPL	Stock	38.275	38.275	38.275	38.275	1000.0

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

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