PREVIEW / stock_5min / 2018-08-27

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-08-27.parquet
  size:    5.6 MB
  rows:    353,734
  symbols: 2,810

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
2018-08-27 04:00:00	AAPL	Stock	54.195	54.225	54.195	54.225	7324.0
2018-08-27 04:05:00	AAPL	Stock	54.2075	54.2075	54.2075	54.2075	1584.0
2018-08-27 04:15:00	AAPL	Stock	54.225	54.225	54.225	54.225	1600.0
2018-08-27 04:20:00	AAPL	Stock	54.25	54.2625	54.25	54.2625	3948.0
2018-08-27 04:30:00	AAPL	Stock	54.2175	54.2175	54.2175	54.2175	400.0
2018-08-27 05:25:00	AAPL	Stock	54.2625	54.2625	54.2625	54.2625	400.0
2018-08-27 06:05:00	AAPL	Stock	54.26	54.2875	54.26	54.26	3864.0
2018-08-27 06:20:00	AAPL	Stock	54.2725	54.2725	54.25	54.25	2580.0
2018-08-27 06:35:00	AAPL	Stock	54.25	54.25	54.25	54.25	400.0
2018-08-27 06:40:00	AAPL	Stock	54.25	54.2725	54.25	54.2725	2308.0
2018-08-27 06:45:00	AAPL	Stock	54.265	54.265	54.25	54.25	1600.0
2018-08-27 06:55:00	AAPL	Stock	54.2475	54.2475	54.2475	54.2475	2000.0
2018-08-27 07:00:00	AAPL	Stock	54.225	54.25	54.215	54.2275	33256.0
2018-08-27 07:05:00	AAPL	Stock	54.25	54.25	54.245	54.25	4240.0
2018-08-27 07:10:00	AAPL	Stock	54.25	54.25	54.25	54.25	6400.0
2018-08-27 07:15:00	AAPL	Stock	54.2475	54.255	54.2325	54.2475	20688.0
2018-08-27 07:20:00	AAPL	Stock	54.25	54.2625	54.2475	54.2625	10056.0
2018-08-27 07:25:00	AAPL	Stock	54.25	54.25	54.25	54.25	800.0
2018-08-27 07:30:00	AAPL	Stock	54.25	54.25	54.2425	54.2425	5956.0
2018-08-27 07:35:00	AAPL	Stock	54.235	54.235	54.2325	54.2325	3676.0
2018-08-27 07:55:00	AAPL	Stock	54.2375	54.2375	54.1975	54.205	56920.0
2018-08-27 08:00:00	AAPL	Stock	54.25	54.27	54.1975	54.25	65212.0
2018-08-27 08:05:00	AAPL	Stock	54.235	54.25	54.205	54.2375	15264.0
2018-08-27 08:10:00	AAPL	Stock	54.2375	54.2625	54.2375	54.2625	14460.0
2018-08-27 08:15:00	AAPL	Stock	54.25	54.2625	54.25	54.2625	59648.0
2018-08-27 08:20:00	AAPL	Stock	54.2625	54.2775	54.25	54.275	24760.0
2018-08-27 08:25:00	AAPL	Stock	54.275	54.2775	54.2675	54.275	31176.0
2018-08-27 08:30:00	AAPL	Stock	54.275	54.275	54.24	54.24	24712.0
2018-08-27 08:35:00	AAPL	Stock	54.2675	54.285	54.25	54.27	17520.0
2018-08-27 08:40:00	AAPL	Stock	54.2525	54.28	54.2525	54.28	7580.0
2018-08-27 08:45:00	AAPL	Stock	54.2775	54.2775	54.25	54.25	4164.0
2018-08-27 08:50:00	AAPL	Stock	54.255	54.255	54.2275	54.2375	23680.0
2018-08-27 08:55:00	AAPL	Stock	54.25	54.255	54.2325	54.2475	7600.0
2018-08-27 09:00:00	AAPL	Stock	54.24	54.2675	54.24	54.2675	2120.0
2018-08-27 09:05:00	AAPL	Stock	54.2625	54.2775	54.2525	54.275	12200.0
2018-08-27 09:10:00	AAPL	Stock	54.275	54.275	54.25	54.2525	17732.0
2018-08-27 09:15:00	AAPL	Stock	54.27	54.275	54.25	54.27	28064.0
2018-08-27 09:20:00	AAPL	Stock	54.2725	54.3225	54.2725	54.31	32216.0
2018-08-27 09:25:00	AAPL	Stock	54.31	54.31	54.25	54.295	44268.0
2018-08-27 09:30:00	AAPL	Stock	54.2875	54.43	54.1862	54.3442	4207288.0
2018-08-27 09:35:00	AAPL	Stock	54.3475	54.3875	54.14	54.2282	2319948.0
2018-08-27 09:40:00	AAPL	Stock	54.22	54.2625	54.13	54.13	1260360.0
2018-08-27 09:45:00	AAPL	Stock	54.1325	54.245	54.0875	54.2125	1549792.0
2018-08-27 09:50:00	AAPL	Stock	54.2175	54.2225	54.0825	54.199	1524012.0
2018-08-27 09:55:00	AAPL	Stock	54.2	54.2625	54.1925	54.245	1036268.0
2018-08-27 10:00:00	AAPL	Stock	54.2525	54.26	54.1775	54.195	904364.0
2018-08-27 10:05:00	AAPL	Stock	54.19	54.3025	54.185	54.2838	1237184.0
2018-08-27 10:10:00	AAPL	Stock	54.2875	54.35	54.285	54.3425	1394708.0
2018-08-27 10:15:00	AAPL	Stock	54.34	54.38	54.2825	54.3425	1216112.0
2018-08-27 10:20:00	AAPL	Stock	54.3475	54.425	54.3265	54.41	1767224.0

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

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