PREVIEW / stock_5min / 2017-02-02

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-02-02.parquet
  size:    5.4 MB
  rows:    352,419
  symbols: 3,110

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-02-02 04:00:00	AAPL	Stock	32.125	32.125	32.125	32.125	6940.0
2017-02-02 04:10:00	AAPL	Stock	32.1125	32.1325	32.1125	32.1325	2000.0
2017-02-02 04:25:00	AAPL	Stock	32.0525	32.0525	32.0525	32.0525	2360.0
2017-02-02 04:30:00	AAPL	Stock	32.0525	32.0525	32.03	32.03	1836.0
2017-02-02 04:50:00	AAPL	Stock	32.0375	32.0375	32.0375	32.0375	800.0
2017-02-02 04:55:00	AAPL	Stock	32.075	32.075	32.075	32.075	752.0
2017-02-02 05:00:00	AAPL	Stock	32.03	32.03	32.0175	32.025	5456.0
2017-02-02 05:05:00	AAPL	Stock	32.025	32.025	32.025	32.025	2000.0
2017-02-02 05:25:00	AAPL	Stock	32.05	32.05	32.05	32.05	888.0
2017-02-02 05:30:00	AAPL	Stock	32.05	32.06	32.05	32.06	13200.0
2017-02-02 05:35:00	AAPL	Stock	32.075	32.0775	32.075	32.0775	4012.0
2017-02-02 05:40:00	AAPL	Stock	32.065	32.065	32.065	32.065	656.0
2017-02-02 05:45:00	AAPL	Stock	32.0775	32.095	32.0775	32.095	1856.0
2017-02-02 05:50:00	AAPL	Stock	32.095	32.095	32.095	32.095	2000.0
2017-02-02 06:00:00	AAPL	Stock	32.1225	32.1225	32.1225	32.1225	1348.0
2017-02-02 06:05:00	AAPL	Stock	32.1	32.1225	32.1	32.1225	4580.0
2017-02-02 06:10:00	AAPL	Stock	32.1	32.1	32.1	32.1	1036.0
2017-02-02 06:15:00	AAPL	Stock	32.1	32.125	32.1	32.125	7600.0
2017-02-02 06:20:00	AAPL	Stock	32.125	32.125	32.125	32.125	5200.0
2017-02-02 06:25:00	AAPL	Stock	32.125	32.125	32.11	32.11	11256.0
2017-02-02 06:30:00	AAPL	Stock	32.085	32.1	32.0525	32.0525	8664.0
2017-02-02 06:40:00	AAPL	Stock	32.0975	32.0975	32.0975	32.0975	2400.0
2017-02-02 06:45:00	AAPL	Stock	32.075	32.075	32.075	32.075	916.0
2017-02-02 06:50:00	AAPL	Stock	32.075	32.095	32.075	32.095	1680.0
2017-02-02 07:00:00	AAPL	Stock	32.095	32.12	32.075	32.075	7888.0
2017-02-02 07:05:00	AAPL	Stock	32.075	32.075	32.075	32.075	2776.0
2017-02-02 07:10:00	AAPL	Stock	32.0925	32.0925	32.075	32.0875	6220.0
2017-02-02 07:15:00	AAPL	Stock	32.1175	32.12	32.07	32.075	14212.0
2017-02-02 07:20:00	AAPL	Stock	32.075	32.095	32.075	32.0875	1200.0
2017-02-02 07:25:00	AAPL	Stock	32.11	32.115	32.1	32.1	18440.0
2017-02-02 07:30:00	AAPL	Stock	32.1	32.1	32.0875	32.1	7456.0
2017-02-02 07:35:00	AAPL	Stock	32.11	32.12	32.1	32.1	8276.0
2017-02-02 07:40:00	AAPL	Stock	32.1125	32.1275	32.1125	32.125	6368.0
2017-02-02 07:45:00	AAPL	Stock	32.1275	32.1275	32.125	32.125	16800.0
2017-02-02 07:50:00	AAPL	Stock	32.125	32.125	32.0925	32.1125	10280.0
2017-02-02 07:55:00	AAPL	Stock	32.1125	32.1125	32.0875	32.1	6320.0
2017-02-02 08:00:00	AAPL	Stock	32.0875	32.1275	32.07	32.1125	151304.0
2017-02-02 08:05:00	AAPL	Stock	32.0875	32.125	32.0875	32.125	25044.0
2017-02-02 08:10:00	AAPL	Stock	32.125	32.14	32.125	32.14	55800.0
2017-02-02 08:15:00	AAPL	Stock	32.1275	32.13	32.105	32.105	59904.0
2017-02-02 08:20:00	AAPL	Stock	32.12	32.12	32.1	32.1125	30172.0
2017-02-02 08:25:00	AAPL	Stock	32.1125	32.1125	32.105	32.105	3432.0
2017-02-02 08:30:00	AAPL	Stock	32.095	32.1125	32.095	32.105	22188.0
2017-02-02 08:35:00	AAPL	Stock	32.11	32.1125	32.0875	32.1075	22800.0
2017-02-02 08:40:00	AAPL	Stock	32.1075	32.1075	32.0925	32.0925	9888.0
2017-02-02 08:45:00	AAPL	Stock	32.0925	32.0975	32.0675	32.075	47528.0
2017-02-02 08:50:00	AAPL	Stock	32.07	32.085	32.06	32.085	70936.0
2017-02-02 08:55:00	AAPL	Stock	32.085	32.1125	32.08	32.08	35996.0
2017-02-02 09:00:00	AAPL	Stock	32.085	32.1	32.085	32.0875	19304.0
2017-02-02 09:05:00	AAPL	Stock	32.0875	32.11	32.0875	32.1075	40484.0

> showing 50 of 352,419 rows — these rows as CSV

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