PREVIEW / stock_5min / 2017-09-29

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-29.parquet
  size:    5.4 MB
  rows:    353,790
  symbols: 2,964

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	5152.0
2017-09-29 04:15: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:50:00	AAPL	Stock	38.35	38.35	38.3025	38.3025	1796.0
2017-09-29 05:05:00	AAPL	Stock	38.3025	38.3025	38.3025	38.3025	400.0
2017-09-29 05:25:00	AAPL	Stock	38.3625	38.3625	38.3625	38.3625	400.0
2017-09-29 05:55:00	AAPL	Stock	38.3625	38.3625	38.3625	38.3625	400.0
2017-09-29 06:00:00	AAPL	Stock	38.3175	38.3175	38.3175	38.3175	400.0
2017-09-29 06:05:00	AAPL	Stock	38.325	38.325	38.325	38.325	400.0
2017-09-29 06:35:00	AAPL	Stock	38.3275	38.3275	38.3275	38.3275	3876.0
2017-09-29 06:45:00	AAPL	Stock	38.35	38.35	38.35	38.35	800.0
2017-09-29 06:55: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.3125	38.3125	15512.0
2017-09-29 07:10:00	AAPL	Stock	38.3175	38.4	38.3	38.4	55468.0
2017-09-29 07:20:00	AAPL	Stock	38.37	38.37	38.3125	38.3125	7256.0
2017-09-29 07:25:00	AAPL	Stock	38.2775	38.3	38.2775	38.28	5440.0
2017-09-29 07:30:00	AAPL	Stock	38.28	38.3	38.28	38.3	17996.0
2017-09-29 07:35:00	AAPL	Stock	38.3	38.3025	38.3	38.3025	2364.0
2017-09-29 07:40:00	AAPL	Stock	38.32	38.32	38.32	38.32	400.0
2017-09-29 07:45:00	AAPL	Stock	38.3	38.3	38.2975	38.2975	8180.0
2017-09-29 07:50: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.255	38.2625	63220.0
2017-09-29 08:05:00	AAPL	Stock	38.275	38.275	38.2575	38.275	9336.0
2017-09-29 08:10:00	AAPL	Stock	38.3	38.3	38.275	38.275	24720.0
2017-09-29 08:15:00	AAPL	Stock	38.275	38.275	38.2575	38.2575	15116.0
2017-09-29 08:20:00	AAPL	Stock	38.2575	38.265	38.245	38.265	68428.0
2017-09-29 08:25:00	AAPL	Stock	38.25	38.2725	38.225	38.25	17160.0
2017-09-29 08:30:00	AAPL	Stock	38.225	38.225	38.225	38.225	1000.0
2017-09-29 08:35:00	AAPL	Stock	38.2425	38.2425	38.225	38.225	5880.0
2017-09-29 08:40:00	AAPL	Stock	38.235	38.25	38.235	38.25	14068.0
2017-09-29 08:45:00	AAPL	Stock	38.24	38.25	38.225	38.25	7580.0
2017-09-29 08:50:00	AAPL	Stock	38.255	38.255	38.255	38.255	4000.0
2017-09-29 08:55:00	AAPL	Stock	38.2525	38.27	38.2525	38.27	4880.0
2017-09-29 09:00:00	AAPL	Stock	38.27	38.27	38.2525	38.255	16884.0
2017-09-29 09:05:00	AAPL	Stock	38.275	38.275	38.25	38.255	17240.0
2017-09-29 09:10:00	AAPL	Stock	38.275	38.2875	38.255	38.2575	26048.0
2017-09-29 09:15:00	AAPL	Stock	38.2625	38.27	38.2575	38.27	4748.0
2017-09-29 09:20:00	AAPL	Stock	38.275	38.2875	38.2675	38.275	5768.0
2017-09-29 09:25:00	AAPL	Stock	38.28	38.3075	38.2575	38.3025	68128.0
2017-09-29 09:30:00	AAPL	Stock	38.3075	38.5	38.27	38.4122	3929232.0
2017-09-29 09:35:00	AAPL	Stock	38.415	38.465	38.3475	38.3578	1539900.0
2017-09-29 09:40:00	AAPL	Stock	38.36	38.3728	38.225	38.26	2426028.0
2017-09-29 09:45:00	AAPL	Stock	38.26	38.2925	38.1075	38.1275	2353196.0
2017-09-29 09:50:00	AAPL	Stock	38.13	38.1888	38.09	38.09	1793824.0
2017-09-29 09:55:00	AAPL	Stock	38.091	38.1075	38.0025	38.045	2543400.0
2017-09-29 10:00:00	AAPL	Stock	38.0475	38.09	38.0	38.0275	2638092.0
2017-09-29 10:05:00	AAPL	Stock	38.025	38.145	38.01	38.1325	2130452.0

> showing 50 of 353,790 rows — these rows as CSV

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