PREVIEW / stock_5min / 2016-09-20

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-09-20.parquet
  size:    5.2 MB
  rows:    342,980
  symbols: 3,216

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.3575	28.3575	1600.0
2016-09-20 04:10:00	AAPL	Stock	28.37	28.37	28.37	28.37	400.0
2016-09-20 05:00:00	AAPL	Stock	28.3325	28.3325	28.325	28.325	2000.0
2016-09-20 05:10:00	AAPL	Stock	28.3075	28.325	28.3075	28.325	1480.0
2016-09-20 05:15:00	AAPL	Stock	28.3	28.3	28.3	28.3	400.0
2016-09-20 05:25:00	AAPL	Stock	28.3	28.3	28.2925	28.2925	1600.0
2016-09-20 05:40:00	AAPL	Stock	28.32	28.3325	28.32	28.3325	6376.0
2016-09-20 05:55:00	AAPL	Stock	28.3325	28.3325	28.3275	28.3275	1740.0
2016-09-20 06:25:00	AAPL	Stock	28.37	28.37	28.37	28.37	400.0
2016-09-20 06:30:00	AAPL	Stock	28.3475	28.3975	28.345	28.3725	7996.0
2016-09-20 06:35:00	AAPL	Stock	28.375	28.47	28.375	28.395	12620.0
2016-09-20 06:40: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.405	28.38	28.405	2252.0
2016-09-20 06:55:00	AAPL	Stock	28.39	28.39	28.375	28.375	11172.0
2016-09-20 07:00:00	AAPL	Stock	28.35	28.4225	28.35	28.4225	12900.0
2016-09-20 07:05:00	AAPL	Stock	28.4275	28.4275	28.425	28.425	5780.0
2016-09-20 07:10:00	AAPL	Stock	28.4025	28.4025	28.4025	28.4025	1456.0
2016-09-20 07:15:00	AAPL	Stock	28.4025	28.4025	28.375	28.375	11744.0
2016-09-20 07:20:00	AAPL	Stock	28.3625	28.3625	28.3625	28.3625	400.0
2016-09-20 07:25:00	AAPL	Stock	28.3675	28.3675	28.365	28.365	3800.0
2016-09-20 07:30: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.2625	28.2775	55112.0
2016-09-20 07:45:00	AAPL	Stock	28.2825	28.32	28.265	28.2775	43280.0
2016-09-20 07:50:00	AAPL	Stock	28.28	28.2875	28.26	28.275	64220.0
2016-09-20 07:55: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.3425	140976.0
2016-09-20 08:05:00	AAPL	Stock	28.3175	28.325	28.3175	28.325	6400.0
2016-09-20 08:10:00	AAPL	Stock	28.33	28.33	28.33	28.33	2480.0
2016-09-20 08:15:00	AAPL	Stock	28.335	28.335	28.2925	28.2925	57360.0
2016-09-20 08:20:00	AAPL	Stock	28.3075	28.3175	28.3	28.31	26364.0
2016-09-20 08:25:00	AAPL	Stock	28.3225	28.3225	28.3	28.3	13520.0
2016-09-20 08:30:00	AAPL	Stock	28.31	28.325	28.3	28.3125	36836.0
2016-09-20 08:35:00	AAPL	Stock	28.3025	28.3125	28.3025	28.3125	8360.0
2016-09-20 08:40:00	AAPL	Stock	28.3025	28.305	28.27	28.2975	89380.0
2016-09-20 08:45:00	AAPL	Stock	28.295	28.2975	28.2825	28.295	35128.0
2016-09-20 08:50:00	AAPL	Stock	28.2975	28.3	28.2825	28.2825	50740.0
2016-09-20 08:55:00	AAPL	Stock	28.3	28.3	28.265	28.275	54432.0
2016-09-20 09:00:00	AAPL	Stock	28.2725	28.2875	28.2625	28.2875	43768.0
2016-09-20 09:05:00	AAPL	Stock	28.2925	28.3	28.2925	28.3	11980.0
2016-09-20 09:10:00	AAPL	Stock	28.2975	28.2975	28.285	28.2875	17740.0
2016-09-20 09:15:00	AAPL	Stock	28.285	28.2925	28.2725	28.2825	38544.0
2016-09-20 09:20:00	AAPL	Stock	28.2825	28.2825	28.2575	28.28	158344.0
2016-09-20 09:25:00	AAPL	Stock	28.275	28.28	28.2375	28.2475	229128.0
2016-09-20 09:30:00	AAPL	Stock	28.24	28.36	28.1275	28.2825	10589920.0
2016-09-20 09:35:00	AAPL	Stock	28.285	28.3475	28.2125	28.28	4805472.0
2016-09-20 09:40:00	AAPL	Stock	28.2775	28.3925	28.2652	28.3075	6685700.0
2016-09-20 09:45:00	AAPL	Stock	28.3075	28.3475	28.2525	28.3228	3700776.0
2016-09-20 09:50:00	AAPL	Stock	28.325	28.4625	28.32	28.445	4648504.0
2016-09-20 09:55:00	AAPL	Stock	28.4462	28.4875	28.395	28.4725	3143100.0

> showing 50 of 342,980 rows — these rows as CSV

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