PREVIEW / stock_5min / 2017-01-05

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-05.parquet
  size:    5.5 MB
  rows:    359,051
  symbols: 3,123

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-01-05 07:00:00	AAPL	Stock	28.9625	28.9625	28.9625	28.9625	1000.0
2017-01-05 07:05:00	AAPL	Stock	28.985	28.985	28.985	28.985	2000.0
2017-01-05 07:15:00	AAPL	Stock	28.985	28.985	28.985	28.985	800.0
2017-01-05 07:25:00	AAPL	Stock	28.9725	28.9725	28.9425	28.9425	8528.0
2017-01-05 07:40:00	AAPL	Stock	28.95	28.95	28.95	28.95	400.0
2017-01-05 07:45:00	AAPL	Stock	28.95	28.95	28.95	28.95	400.0
2017-01-05 07:50:00	AAPL	Stock	28.945	28.945	28.945	28.945	400.0
2017-01-05 07:55:00	AAPL	Stock	28.945	28.945	28.945	28.945	400.0
2017-01-05 08:00:00	AAPL	Stock	28.9975	28.9975	28.945	28.9575	8440.0
2017-01-05 08:05:00	AAPL	Stock	28.95	28.95	28.95	28.95	640.0
2017-01-05 08:10:00	AAPL	Stock	28.9525	28.9525	28.9525	28.9525	400.0
2017-01-05 08:15:00	AAPL	Stock	28.97	28.98	28.97	28.98	800.0
2017-01-05 08:20:00	AAPL	Stock	28.965	28.965	28.965	28.965	2400.0
2017-01-05 08:30:00	AAPL	Stock	28.975	28.985	28.9575	28.985	29480.0
2017-01-05 08:35:00	AAPL	Stock	28.995	29.0	28.985	28.9975	23768.0
2017-01-05 08:40:00	AAPL	Stock	28.9975	29.0125	28.9875	29.0125	2400.0
2017-01-05 08:45:00	AAPL	Stock	29.0125	29.015	29.0	29.015	15364.0
2017-01-05 08:50:00	AAPL	Stock	29.0025	29.0175	29.0025	29.0175	800.0
2017-01-05 08:55:00	AAPL	Stock	29.0175	29.0175	29.0175	29.0175	1600.0
2017-01-05 09:00:00	AAPL	Stock	29.015	29.0175	29.015	29.015	8832.0
2017-01-05 09:05:00	AAPL	Stock	29.015	29.015	29.015	29.015	2800.0
2017-01-05 09:10:00	AAPL	Stock	29.01	29.01	29.01	29.01	13400.0
2017-01-05 09:15:00	AAPL	Stock	29.0	29.0125	28.9875	29.0125	23904.0
2017-01-05 09:20:00	AAPL	Stock	29.01	29.0175	29.005	29.005	70180.0
2017-01-05 09:25:00	AAPL	Stock	29.0175	29.02	28.975	28.9825	44516.0
2017-01-05 09:30:00	AAPL	Stock	28.98	29.1275	28.9525	29.115	5087292.0
2017-01-05 09:35:00	AAPL	Stock	29.1225	29.125	29.0825	29.101	2228276.0
2017-01-05 09:40:00	AAPL	Stock	29.1025	29.185	29.0975	29.1675	3222172.0
2017-01-05 09:45:00	AAPL	Stock	29.1662	29.216	29.1625	29.2075	1703344.0
2017-01-05 09:50:00	AAPL	Stock	29.2075	29.2125	29.1662	29.2	1775396.0
2017-01-05 09:55:00	AAPL	Stock	29.2012	29.2112	29.145	29.1675	1416928.0
2017-01-05 10:00:00	AAPL	Stock	29.17	29.2	29.1375	29.1525	1238604.0
2017-01-05 10:05:00	AAPL	Stock	29.155	29.1825	29.1525	29.1575	813652.0
2017-01-05 10:10:00	AAPL	Stock	29.1575	29.19	29.155	29.1862	973404.0
2017-01-05 10:15:00	AAPL	Stock	29.1875	29.1975	29.1275	29.1282	1186504.0
2017-01-05 10:20:00	AAPL	Stock	29.131	29.1375	29.0825	29.1025	1447944.0
2017-01-05 10:25:00	AAPL	Stock	29.106	29.155	29.105	29.1375	1259032.0
2017-01-05 10:30:00	AAPL	Stock	29.14	29.145	29.0675	29.085	2280488.0
2017-01-05 10:35:00	AAPL	Stock	29.0838	29.085	29.045	29.0675	1507428.0
2017-01-05 10:40:00	AAPL	Stock	29.065	29.09	29.025	29.0325	1093936.0
2017-01-05 10:45:00	AAPL	Stock	29.0325	29.0525	29.02	29.051	1113292.0
2017-01-05 10:50:00	AAPL	Stock	29.0525	29.0625	29.0425	29.051	709620.0
2017-01-05 10:55:00	AAPL	Stock	29.0525	29.0925	29.0375	29.0825	796260.0
2017-01-05 11:00:00	AAPL	Stock	29.08	29.1	29.0575	29.0675	686564.0
2017-01-05 11:05:00	AAPL	Stock	29.0685	29.07	29.0125	29.0235	1237072.0
2017-01-05 11:10:00	AAPL	Stock	29.02	29.0388	29.005	29.0215	1015704.0
2017-01-05 11:15:00	AAPL	Stock	29.0225	29.0475	29.0125	29.0425	838224.0
2017-01-05 11:20:00	AAPL	Stock	29.045	29.0535	29.0175	29.032	626148.0
2017-01-05 11:25:00	AAPL	Stock	29.0322	29.0475	29.0125	29.0125	681276.0
2017-01-05 11:30:00	AAPL	Stock	29.0125	29.035	29.01	29.02	453756.0

> showing 50 of 359,051 rows — these rows as CSV

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