PREVIEW / stock_5min / 2017-08-07

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-07.parquet
  size:    5.3 MB
  rows:    345,410
  symbols: 2,988

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-08-07 04:00:00	AAPL	Stock	39.275	39.275	39.275	39.275	6744.0
2017-08-07 04:10:00	AAPL	Stock	39.275	39.275	39.275	39.275	4000.0
2017-08-07 04:15:00	AAPL	Stock	39.2375	39.2375	39.2375	39.2375	1956.0
2017-08-07 04:35:00	AAPL	Stock	39.2625	39.2625	39.2625	39.2625	1860.0
2017-08-07 05:00:00	AAPL	Stock	39.2625	39.2625	39.2625	39.2625	1696.0
2017-08-07 05:15:00	AAPL	Stock	39.2675	39.2675	39.25	39.25	800.0
2017-08-07 05:20:00	AAPL	Stock	39.245	39.245	39.245	39.245	800.0
2017-08-07 05:25:00	AAPL	Stock	39.245	39.245	39.245	39.245	400.0
2017-08-07 05:35:00	AAPL	Stock	39.245	39.245	39.245	39.245	1652.0
2017-08-07 05:40:00	AAPL	Stock	39.2125	39.2425	39.2125	39.2425	2012.0
2017-08-07 06:10:00	AAPL	Stock	39.205	39.205	39.2025	39.2025	2600.0
2017-08-07 06:25:00	AAPL	Stock	39.2375	39.24	39.2375	39.24	5600.0
2017-08-07 06:30:00	AAPL	Stock	39.2375	39.2375	39.2375	39.2375	400.0
2017-08-07 06:40:00	AAPL	Stock	39.2325	39.2325	39.225	39.225	1600.0
2017-08-07 06:50:00	AAPL	Stock	39.205	39.225	39.205	39.225	3580.0
2017-08-07 07:05:00	AAPL	Stock	39.215	39.225	39.205	39.2225	10348.0
2017-08-07 07:10:00	AAPL	Stock	39.2225	39.2225	39.205	39.205	940.0
2017-08-07 07:15:00	AAPL	Stock	39.2225	39.225	39.2125	39.2125	8000.0
2017-08-07 07:20:00	AAPL	Stock	39.205	39.205	39.205	39.205	8324.0
2017-08-07 07:25:00	AAPL	Stock	39.2125	39.2125	39.2	39.2	5792.0
2017-08-07 07:30:00	AAPL	Stock	39.1875	39.1875	39.1875	39.1875	6000.0
2017-08-07 07:35:00	AAPL	Stock	39.2075	39.2075	39.2	39.2	2336.0
2017-08-07 07:40:00	AAPL	Stock	39.2	39.2125	39.1975	39.1975	24400.0
2017-08-07 07:45:00	AAPL	Stock	39.1975	39.1975	39.1975	39.1975	1600.0
2017-08-07 07:50:00	AAPL	Stock	39.21	39.22	39.21	39.22	11880.0
2017-08-07 07:55:00	AAPL	Stock	39.21	39.21	39.21	39.21	400.0
2017-08-07 08:00:00	AAPL	Stock	39.2125	39.2375	39.015	39.015	52648.0
2017-08-07 08:05:00	AAPL	Stock	39.1925	39.21	39.19	39.21	5992.0
2017-08-07 08:10:00	AAPL	Stock	39.2125	39.22	39.1875	39.205	35424.0
2017-08-07 08:15:00	AAPL	Stock	39.2125	39.215	39.2125	39.215	9392.0
2017-08-07 08:20:00	AAPL	Stock	39.225	39.225	39.2075	39.2225	8700.0
2017-08-07 08:25:00	AAPL	Stock	39.2125	39.2425	39.2075	39.2425	20976.0
2017-08-07 08:30:00	AAPL	Stock	39.2425	39.2425	39.2375	39.2375	13364.0
2017-08-07 08:35:00	AAPL	Stock	39.2375	39.25	39.2375	39.245	15072.0
2017-08-07 08:40:00	AAPL	Stock	39.25	39.2625	39.25	39.25	22352.0
2017-08-07 08:45:00	AAPL	Stock	39.25	39.25	39.2175	39.2175	19312.0
2017-08-07 08:50:00	AAPL	Stock	39.24	39.24	39.22	39.22	3980.0
2017-08-07 08:55:00	AAPL	Stock	39.2475	39.2475	39.235	39.235	3600.0
2017-08-07 09:00:00	AAPL	Stock	39.2325	39.24	39.2225	39.2375	7200.0
2017-08-07 09:05:00	AAPL	Stock	39.2425	39.2725	39.2425	39.27	84760.0
2017-08-07 09:10:00	AAPL	Stock	39.265	39.2825	39.2625	39.275	34464.0
2017-08-07 09:15:00	AAPL	Stock	39.285	39.3	39.275	39.3	29752.0
2017-08-07 09:20:00	AAPL	Stock	39.3	39.3	39.29	39.2975	14976.0
2017-08-07 09:25:00	AAPL	Stock	39.3	39.3025	39.21	39.25	77856.0
2017-08-07 09:30:00	AAPL	Stock	39.2525	39.3225	39.1675	39.2295	3559888.0
2017-08-07 09:35:00	AAPL	Stock	39.2275	39.3	39.205	39.275	1841192.0
2017-08-07 09:40:00	AAPL	Stock	39.278	39.29	39.22	39.2882	1393752.0
2017-08-07 09:45:00	AAPL	Stock	39.288	39.2975	39.2575	39.26	1248632.0
2017-08-07 09:50:00	AAPL	Stock	39.265	39.3175	39.2475	39.3038	1479344.0
2017-08-07 09:55:00	AAPL	Stock	39.3038	39.375	39.3025	39.3575	1944636.0

> showing 50 of 345,410 rows — these rows as CSV

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