PREVIEW / stock_5min / 2016-10-20

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-10-20.parquet
  size:    5.1 MB
  rows:    335,851
  symbols: 3,170

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-10-20 05:15:00	AAPL	Stock	29.305	29.305	29.305	29.305	800.0
2016-10-20 06:00:00	AAPL	Stock	29.25	29.25	29.25	29.25	3676.0
2016-10-20 06:20:00	AAPL	Stock	29.295	29.295	29.295	29.295	2000.0
2016-10-20 06:30:00	AAPL	Stock	29.295	29.295	29.295	29.295	800.0
2016-10-20 06:35:00	AAPL	Stock	29.3	29.3	29.3	29.3	400.0
2016-10-20 06:45:00	AAPL	Stock	29.305	29.305	29.305	29.305	1680.0
2016-10-20 06:55:00	AAPL	Stock	29.295	29.295	29.295	29.295	680.0
2016-10-20 07:05:00	AAPL	Stock	29.275	29.275	29.275	29.275	800.0
2016-10-20 07:25:00	AAPL	Stock	29.2975	29.2975	29.2975	29.2975	576.0
2016-10-20 07:30:00	AAPL	Stock	29.2975	29.305	29.2975	29.305	2056.0
2016-10-20 07:40:00	AAPL	Stock	29.31	29.3125	29.31	29.3125	3364.0
2016-10-20 07:45:00	AAPL	Stock	29.335	29.335	29.25	29.25	13600.0
2016-10-20 07:50:00	AAPL	Stock	29.2075	29.2075	29.15	29.1575	12200.0
2016-10-20 07:55:00	AAPL	Stock	29.175	29.1875	29.155	29.1875	7872.0
2016-10-20 08:00:00	AAPL	Stock	29.2975	29.31	29.14	29.1875	69268.0
2016-10-20 08:05:00	AAPL	Stock	29.1875	29.2125	29.1875	29.2125	12408.0
2016-10-20 08:10:00	AAPL	Stock	29.2075	29.2075	29.2075	29.2075	2400.0
2016-10-20 08:15:00	AAPL	Stock	29.195	29.2	29.195	29.195	2896.0
2016-10-20 08:20:00	AAPL	Stock	29.2125	29.2275	29.2	29.22	6724.0
2016-10-20 08:25:00	AAPL	Stock	29.205	29.2175	29.2	29.2	27616.0
2016-10-20 08:30:00	AAPL	Stock	29.225	29.225	29.205	29.205	900.0
2016-10-20 08:35:00	AAPL	Stock	29.2	29.2	29.1875	29.1875	8800.0
2016-10-20 08:40:00	AAPL	Stock	29.19	29.1925	29.19	29.1925	3768.0
2016-10-20 08:45:00	AAPL	Stock	29.1925	29.2075	29.1825	29.2	17164.0
2016-10-20 08:50:00	AAPL	Stock	29.21	29.23	29.205	29.205	13400.0
2016-10-20 08:55:00	AAPL	Stock	29.2275	29.2925	29.2225	29.275	24456.0
2016-10-20 09:00:00	AAPL	Stock	29.28	29.2925	29.235	29.25	11588.0
2016-10-20 09:05:00	AAPL	Stock	29.275	29.275	29.275	29.275	2204.0
2016-10-20 09:10:00	AAPL	Stock	29.2625	29.275	29.2625	29.275	32032.0
2016-10-20 09:15:00	AAPL	Stock	29.275	29.275	29.2425	29.2525	19480.0
2016-10-20 09:20:00	AAPL	Stock	29.24	29.24	29.225	29.225	12800.0
2016-10-20 09:25:00	AAPL	Stock	29.2175	29.2275	29.215	29.215	39032.0
2016-10-20 09:30:00	AAPL	Stock	29.215	29.2475	29.1512	29.245	3538956.0
2016-10-20 09:35:00	AAPL	Stock	29.245	29.27	29.16	29.17	1913924.0
2016-10-20 09:40:00	AAPL	Stock	29.1678	29.2275	29.1425	29.22	1787120.0
2016-10-20 09:45:00	AAPL	Stock	29.2175	29.2675	29.1962	29.2495	1735296.0
2016-10-20 09:50:00	AAPL	Stock	29.2475	29.2475	29.215	29.2275	1101316.0
2016-10-20 09:55:00	AAPL	Stock	29.225	29.255	29.2225	29.25	1163824.0
2016-10-20 10:00:00	AAPL	Stock	29.2475	29.3075	29.24	29.3072	1761288.0
2016-10-20 10:05:00	AAPL	Stock	29.305	29.3275	29.285	29.3	1579088.0
2016-10-20 10:10:00	AAPL	Stock	29.3025	29.305	29.2425	29.2425	1532500.0
2016-10-20 10:15:00	AAPL	Stock	29.2425	29.265	29.21	29.2125	1734200.0
2016-10-20 10:20:00	AAPL	Stock	29.2125	29.235	29.2	29.2012	793116.0
2016-10-20 10:25:00	AAPL	Stock	29.2025	29.225	29.1625	29.215	1462512.0
2016-10-20 10:30:00	AAPL	Stock	29.215	29.215	29.1475	29.15	1530552.0
2016-10-20 10:35:00	AAPL	Stock	29.15	29.15	29.0875	29.0898	2828816.0
2016-10-20 10:40:00	AAPL	Stock	29.09	29.145	29.0875	29.11	1937140.0
2016-10-20 10:45:00	AAPL	Stock	29.11	29.1425	29.0825	29.1262	1972916.0
2016-10-20 10:50:00	AAPL	Stock	29.125	29.175	29.1078	29.1675	1778368.0
2016-10-20 10:55:00	AAPL	Stock	29.1625	29.165	29.1125	29.1625	1337028.0

> showing 50 of 335,851 rows — these rows as CSV

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