PREVIEW / stock_5min / 2017-04-05

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-04-05.parquet
  size:    5.6 MB
  rows:    364,357
  symbols: 3,073

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-04-05 05:05:00	AAPL	Stock	36.175	36.175	36.175	36.175	1200.0
2017-04-05 05:10:00	AAPL	Stock	36.1625	36.1625	36.1625	36.1625	544.0
2017-04-05 06:10:00	AAPL	Stock	36.15	36.15	36.15	36.15	1200.0
2017-04-05 06:25:00	AAPL	Stock	36.15	36.15	36.15	36.15	400.0
2017-04-05 06:50:00	AAPL	Stock	36.15	36.15	36.15	36.15	400.0
2017-04-05 06:55:00	AAPL	Stock	36.15	36.15	36.15	36.15	4800.0
2017-04-05 07:05:00	AAPL	Stock	36.1375	36.1375	36.13	36.13	7584.0
2017-04-05 07:15:00	AAPL	Stock	36.1475	36.1475	36.125	36.125	4912.0
2017-04-05 07:20:00	AAPL	Stock	36.1425	36.1425	36.125	36.125	7000.0
2017-04-05 07:25:00	AAPL	Stock	36.1425	36.1425	36.1425	36.1425	400.0
2017-04-05 07:30:00	AAPL	Stock	36.1275	36.135	36.1275	36.135	5200.0
2017-04-05 07:35:00	AAPL	Stock	36.145	36.1625	36.145	36.1625	6800.0
2017-04-05 07:40:00	AAPL	Stock	36.15	36.15	36.15	36.15	21524.0
2017-04-05 07:45:00	AAPL	Stock	36.15	36.15	36.15	36.15	2800.0
2017-04-05 07:50:00	AAPL	Stock	36.165	36.165	36.165	36.165	400.0
2017-04-05 07:55:00	AAPL	Stock	36.1625	36.1625	36.1625	36.1625	400.0
2017-04-05 08:00:00	AAPL	Stock	36.1675	36.1675	36.15	36.16	35688.0
2017-04-05 08:05:00	AAPL	Stock	36.16	36.1625	36.16	36.1625	2800.0
2017-04-05 08:15:00	AAPL	Stock	36.1625	36.175	36.1625	36.1625	67620.0
2017-04-05 08:20:00	AAPL	Stock	36.1625	36.1825	36.1625	36.1825	27428.0
2017-04-05 08:25:00	AAPL	Stock	36.175	36.18	36.1625	36.18	8892.0
2017-04-05 08:30:00	AAPL	Stock	36.1725	36.1725	36.15	36.165	28312.0
2017-04-05 08:35:00	AAPL	Stock	36.15	36.1525	36.125	36.125	34400.0
2017-04-05 08:40:00	AAPL	Stock	36.1275	36.1275	35.8175	35.9375	412064.0
2017-04-05 08:45:00	AAPL	Stock	35.905	35.9175	35.85	35.8975	187724.0
2017-04-05 08:50:00	AAPL	Stock	35.8975	35.96	35.8975	35.945	205612.0
2017-04-05 08:55:00	AAPL	Stock	35.955	35.9725	35.9	35.9675	258964.0
2017-04-05 09:00:00	AAPL	Stock	35.965	36.0175	35.965	35.99	338460.0
2017-04-05 09:05:00	AAPL	Stock	35.9875	36.0	35.9375	35.9625	119916.0
2017-04-05 09:10:00	AAPL	Stock	35.9625	36.01	35.95	36.0075	72928.0
2017-04-05 09:15:00	AAPL	Stock	36.01	36.0325	36.0025	36.0125	101160.0
2017-04-05 09:20:00	AAPL	Stock	36.0175	36.0375	36.0125	36.035	62616.0
2017-04-05 09:25:00	AAPL	Stock	36.0325	36.16	36.0212	36.16	526784.0
2017-04-05 09:30:00	AAPL	Stock	36.055	36.2	36.055	36.0888	6991148.0
2017-04-05 09:35:00	AAPL	Stock	36.0898	36.175	36.0888	36.1375	2042592.0
2017-04-05 09:40:00	AAPL	Stock	36.1375	36.2412	36.13	36.225	2721188.0
2017-04-05 09:45:00	AAPL	Stock	36.225	36.2975	36.2125	36.28	3867148.0
2017-04-05 09:50:00	AAPL	Stock	36.2798	36.2875	36.1975	36.2125	2926448.0
2017-04-05 09:55:00	AAPL	Stock	36.2125	36.215	36.1625	36.193	1466576.0
2017-04-05 10:00:00	AAPL	Stock	36.1925	36.195	36.135	36.1735	2619240.0
2017-04-05 10:05:00	AAPL	Stock	36.175	36.21	36.175	36.2075	1239728.0
2017-04-05 10:10:00	AAPL	Stock	36.21	36.2225	36.18	36.1925	884160.0
2017-04-05 10:15:00	AAPL	Stock	36.195	36.245	36.1825	36.23	1005748.0
2017-04-05 10:20:00	AAPL	Stock	36.23	36.245	36.1975	36.2025	1010776.0
2017-04-05 10:25:00	AAPL	Stock	36.2025	36.2688	36.2025	36.2615	1211436.0
2017-04-05 10:30:00	AAPL	Stock	36.26	36.2875	36.24	36.244	1501896.0
2017-04-05 10:35:00	AAPL	Stock	36.2425	36.275	36.2375	36.26	858328.0
2017-04-05 10:40:00	AAPL	Stock	36.26	36.315	36.26	36.3075	1801944.0
2017-04-05 10:45:00	AAPL	Stock	36.3088	36.3465	36.3075	36.34	1769376.0
2017-04-05 10:50:00	AAPL	Stock	36.34	36.3475	36.305	36.3275	1379988.0

> showing 50 of 364,357 rows — these rows as CSV

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