PREVIEW / stock_5min / 2017-10-12

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-12.parquet
  size:    5.4 MB
  rows:    348,147
  symbols: 2,954

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-10-12 05:50:00	AAPL	Stock	39.1	39.1	39.1	39.1	1040.0
2017-10-12 07:00:00	AAPL	Stock	39.0625	39.0625	39.0625	39.0625	400.0
2017-10-12 07:05:00	AAPL	Stock	39.0875	39.1	39.0875	39.1	1692.0
2017-10-12 07:15:00	AAPL	Stock	39.0975	39.0975	39.0975	39.0975	3680.0
2017-10-12 07:20:00	AAPL	Stock	39.0875	39.0875	39.0875	39.0875	800.0
2017-10-12 07:35:00	AAPL	Stock	39.1	39.1	39.1	39.1	1304.0
2017-10-12 07:40:00	AAPL	Stock	39.0675	39.075	39.05	39.05	14504.0
2017-10-12 07:45:00	AAPL	Stock	39.05	39.05	39.05	39.05	1600.0
2017-10-12 07:55:00	AAPL	Stock	39.075	39.075	39.075	39.075	400.0
2017-10-12 08:00:00	AAPL	Stock	39.1	39.225	39.05	39.075	50636.0
2017-10-12 08:05:00	AAPL	Stock	39.08	39.095	39.075	39.095	6048.0
2017-10-12 08:10:00	AAPL	Stock	39.095	39.1075	39.095	39.1075	9200.0
2017-10-12 08:15:00	AAPL	Stock	39.1075	39.1075	39.1075	39.1075	800.0
2017-10-12 08:20:00	AAPL	Stock	39.0775	39.0775	39.0775	39.0775	444.0
2017-10-12 08:25:00	AAPL	Stock	39.0925	39.0925	39.0925	39.0925	400.0
2017-10-12 08:30:00	AAPL	Stock	39.1	39.1125	39.1	39.1125	7852.0
2017-10-12 08:35:00	AAPL	Stock	39.0925	39.0925	39.0875	39.0875	4400.0
2017-10-12 08:40:00	AAPL	Stock	39.0875	39.0875	39.0625	39.0625	21196.0
2017-10-12 08:45:00	AAPL	Stock	39.0675	39.0675	39.065	39.065	2000.0
2017-10-12 08:50:00	AAPL	Stock	39.065	39.065	39.0525	39.0525	4844.0
2017-10-12 08:55:00	AAPL	Stock	39.0575	39.0575	39.0425	39.05	10000.0
2017-10-12 09:00:00	AAPL	Stock	39.0425	39.0875	39.0425	39.05	30124.0
2017-10-12 09:05:00	AAPL	Stock	39.075	39.0825	39.075	39.0825	8000.0
2017-10-12 09:10:00	AAPL	Stock	39.07	39.0725	39.07	39.0725	7292.0
2017-10-12 09:15:00	AAPL	Stock	39.055	39.055	39.055	39.055	2820.0
2017-10-12 09:20:00	AAPL	Stock	39.065	39.125	39.065	39.125	39440.0
2017-10-12 09:25:00	AAPL	Stock	39.1125	39.1125	39.075	39.0975	11528.0
2017-10-12 09:30:00	AAPL	Stock	39.105	39.2275	39.0675	39.18	2650120.0
2017-10-12 09:35:00	AAPL	Stock	39.1775	39.2125	39.1475	39.185	1397340.0
2017-10-12 09:40:00	AAPL	Stock	39.1865	39.2012	39.1375	39.1823	942160.0
2017-10-12 09:45:00	AAPL	Stock	39.1825	39.265	39.1475	39.245	1994264.0
2017-10-12 09:50:00	AAPL	Stock	39.2475	39.3175	39.225	39.3125	1985860.0
2017-10-12 09:55:00	AAPL	Stock	39.3125	39.3425	39.2	39.22	2308148.0
2017-10-12 10:00:00	AAPL	Stock	39.2212	39.275	39.1225	39.2225	2791516.0
2017-10-12 10:05:00	AAPL	Stock	39.2258	39.2325	39.177	39.21	879268.0
2017-10-12 10:10:00	AAPL	Stock	39.211	39.235	39.19	39.19	858340.0
2017-10-12 10:15:00	AAPL	Stock	39.1902	39.24	39.1825	39.2175	771580.0
2017-10-12 10:20:00	AAPL	Stock	39.22	39.2425	39.185	39.1962	666968.0
2017-10-12 10:25:00	AAPL	Stock	39.195	39.205	39.175	39.185	719716.0
2017-10-12 10:30:00	AAPL	Stock	39.185	39.205	39.1525	39.1575	933356.0
2017-10-12 10:35:00	AAPL	Stock	39.16	39.205	39.1575	39.1925	884976.0
2017-10-12 10:40:00	AAPL	Stock	39.1915	39.2	39.1625	39.1675	503708.0
2017-10-12 10:45:00	AAPL	Stock	39.1675	39.1725	39.1425	39.1675	494824.0
2017-10-12 10:50:00	AAPL	Stock	39.1708	39.195	39.1625	39.1625	342548.0
2017-10-12 10:55:00	AAPL	Stock	39.165	39.215	39.1625	39.205	882096.0
2017-10-12 11:00:00	AAPL	Stock	39.2025	39.23	39.2	39.2025	734212.0
2017-10-12 11:05:00	AAPL	Stock	39.2025	39.2125	39.1875	39.21	603788.0
2017-10-12 11:10:00	AAPL	Stock	39.2112	39.2338	39.2025	39.2275	481560.0
2017-10-12 11:15:00	AAPL	Stock	39.23	39.2375	39.2125	39.2125	506280.0
2017-10-12 11:20:00	AAPL	Stock	39.2138	39.2295	39.2025	39.229	391348.0

> showing 50 of 348,147 rows — these rows as CSV

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