PREVIEW / stock_5min / 2017-09-08

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-08.parquet
  size:    5.3 MB
  rows:    349,507
  symbols: 2,963

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-08 04:05:00	AAPL	Stock	40.285	40.285	40.285	40.285	644.0
2017-09-08 04:15:00	AAPL	Stock	40.3225	40.3225	40.3225	40.3225	1060.0
2017-09-08 04:20:00	AAPL	Stock	40.25	40.25	40.25	40.25	2308.0
2017-09-08 04:45:00	AAPL	Stock	40.275	40.275	40.275	40.275	400.0
2017-09-08 04:55:00	AAPL	Stock	40.25	40.25	40.25	40.25	1384.0
2017-09-08 05:35:00	AAPL	Stock	40.305	40.305	40.305	40.305	400.0
2017-09-08 05:40:00	AAPL	Stock	40.325	40.325	40.325	40.325	400.0
2017-09-08 05:55:00	AAPL	Stock	40.3225	40.3225	40.3225	40.3225	1200.0
2017-09-08 06:15:00	AAPL	Stock	40.3275	40.3275	40.3275	40.3275	800.0
2017-09-08 06:20:00	AAPL	Stock	40.365	40.365	40.365	40.365	2820.0
2017-09-08 06:25:00	AAPL	Stock	40.3625	40.3625	40.3625	40.3625	400.0
2017-09-08 06:40:00	AAPL	Stock	40.33	40.33	40.3225	40.3225	4440.0
2017-09-08 06:50:00	AAPL	Stock	40.2825	40.2825	40.2825	40.2825	800.0
2017-09-08 06:55:00	AAPL	Stock	40.2825	40.2825	40.2825	40.2825	400.0
2017-09-08 07:00:00	AAPL	Stock	40.2825	40.2825	40.2825	40.2825	3396.0
2017-09-08 07:05:00	AAPL	Stock	40.2825	40.2825	40.2825	40.2825	4000.0
2017-09-08 07:10:00	AAPL	Stock	40.265	40.2675	40.265	40.2675	800.0
2017-09-08 07:15:00	AAPL	Stock	40.275	40.275	40.2725	40.2725	2800.0
2017-09-08 07:20:00	AAPL	Stock	40.2725	40.2725	40.2725	40.2725	1600.0
2017-09-08 07:25:00	AAPL	Stock	40.2975	40.2975	40.2975	40.2975	3600.0
2017-09-08 07:35:00	AAPL	Stock	40.3	40.305	40.3	40.3	1600.0
2017-09-08 07:40:00	AAPL	Stock	40.3	40.3	40.3	40.3	440.0
2017-09-08 07:45:00	AAPL	Stock	40.2975	40.305	40.2975	40.305	800.0
2017-09-08 07:50:00	AAPL	Stock	40.2975	40.3	40.2975	40.3	1600.0
2017-09-08 08:00:00	AAPL	Stock	40.2975	40.315	40.275	40.285	903680.0
2017-09-08 08:05:00	AAPL	Stock	40.275	40.275	40.275	40.275	3640.0
2017-09-08 08:10:00	AAPL	Stock	40.265	40.265	40.225	40.225	25408.0
2017-09-08 08:15:00	AAPL	Stock	40.2125	40.2375	40.2125	40.2375	16864.0
2017-09-08 08:20:00	AAPL	Stock	40.25	40.25	40.23	40.23	8068.0
2017-09-08 08:25:00	AAPL	Stock	40.25	40.2875	40.25	40.2875	6104.0
2017-09-08 08:30:00	AAPL	Stock	40.2875	40.2875	40.2775	40.2775	4400.0
2017-09-08 08:35:00	AAPL	Stock	40.2525	40.285	40.2525	40.285	2400.0
2017-09-08 08:45:00	AAPL	Stock	40.275	40.275	40.2725	40.275	3404.0
2017-09-08 08:50:00	AAPL	Stock	40.275	40.29	40.2625	40.275	16140.0
2017-09-08 08:55:00	AAPL	Stock	40.285	40.285	40.2625	40.2625	2708.0
2017-09-08 09:00:00	AAPL	Stock	40.2625	40.285	40.2625	40.275	5424.0
2017-09-08 09:05:00	AAPL	Stock	40.2625	40.2625	40.225	40.2325	21484.0
2017-09-08 09:10:00	AAPL	Stock	40.225	40.25	40.225	40.25	15836.0
2017-09-08 09:15:00	AAPL	Stock	40.2325	40.25	40.2325	40.2375	11144.0
2017-09-08 09:20:00	AAPL	Stock	40.25	40.25	40.2375	40.2375	9400.0
2017-09-08 09:25:00	AAPL	Stock	40.2425	40.2425	40.21	40.225	49224.0
2017-09-08 09:30:00	AAPL	Stock	40.225	40.2472	40.165	40.2425	2971944.0
2017-09-08 09:35:00	AAPL	Stock	40.24	40.2875	40.1775	40.2075	1580872.0
2017-09-08 09:40:00	AAPL	Stock	40.21	40.2375	40.12	40.1825	1656812.0
2017-09-08 09:45:00	AAPL	Stock	40.1825	40.225	40.17	40.1888	812088.0
2017-09-08 09:50:00	AAPL	Stock	40.1888	40.2225	40.1275	40.1508	1261792.0
2017-09-08 09:55:00	AAPL	Stock	40.15	40.2	40.1325	40.1775	1056996.0
2017-09-08 10:00:00	AAPL	Stock	40.1765	40.1875	40.1325	40.135	1553020.0
2017-09-08 10:05:00	AAPL	Stock	40.1372	40.145	40.09	40.1075	2492672.0
2017-09-08 10:10:00	AAPL	Stock	40.11	40.1175	39.9	40.0088	4193712.0

> showing 50 of 349,507 rows — these rows as CSV

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