PREVIEW / stock_5min / 2017-01-23

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-23.parquet
  size:    5.3 MB
  rows:    349,631
  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-23 04:05:00	AAPL	Stock	29.875	29.875	29.875	29.875	4400.0
2017-01-23 04:20:00	AAPL	Stock	29.925	29.925	29.925	29.925	2204.0
2017-01-23 04:25:00	AAPL	Stock	29.91	29.925	29.91	29.925	1816.0
2017-01-23 04:30:00	AAPL	Stock	29.95	29.95	29.95	29.95	400.0
2017-01-23 06:05:00	AAPL	Stock	29.955	29.955	29.955	29.955	400.0
2017-01-23 06:20:00	AAPL	Stock	29.95	29.95	29.95	29.95	4000.0
2017-01-23 06:25:00	AAPL	Stock	29.9425	29.9425	29.9425	29.9425	756.0
2017-01-23 06:35:00	AAPL	Stock	29.95	29.95	29.95	29.95	492.0
2017-01-23 06:40:00	AAPL	Stock	29.95	29.95	29.95	29.95	400.0
2017-01-23 06:45:00	AAPL	Stock	29.95	29.95	29.9425	29.9425	1768.0
2017-01-23 07:00:00	AAPL	Stock	29.9425	29.9425	29.9425	29.9425	2000.0
2017-01-23 07:05:00	AAPL	Stock	29.9475	29.9475	29.93	29.93	12400.0
2017-01-23 07:10:00	AAPL	Stock	29.9375	29.95	29.9375	29.9375	8708.0
2017-01-23 07:15:00	AAPL	Stock	29.9375	29.95	29.9375	29.95	4400.0
2017-01-23 07:20:00	AAPL	Stock	29.9625	29.9625	29.94	29.94	2400.0
2017-01-23 07:25:00	AAPL	Stock	29.9425	29.9425	29.9375	29.9375	5548.0
2017-01-23 07:30:00	AAPL	Stock	29.9375	29.94	29.9325	29.9375	7548.0
2017-01-23 07:35:00	AAPL	Stock	29.9325	29.9375	29.9325	29.9375	1444.0
2017-01-23 07:40:00	AAPL	Stock	29.9325	29.9325	29.925	29.925	17760.0
2017-01-23 07:45:00	AAPL	Stock	29.9175	29.925	29.9	29.925	12720.0
2017-01-23 07:50:00	AAPL	Stock	29.925	29.9375	29.925	29.9375	3200.0
2017-01-23 08:00:00	AAPL	Stock	29.9475	29.9625	29.925	29.9475	47776.0
2017-01-23 08:05:00	AAPL	Stock	29.95	29.955	29.95	29.955	10456.0
2017-01-23 08:10:00	AAPL	Stock	29.9475	29.9475	29.94	29.94	26576.0
2017-01-23 08:15:00	AAPL	Stock	29.94	29.94	29.9125	29.925	64188.0
2017-01-23 08:20:00	AAPL	Stock	29.9375	29.9375	29.9325	29.9325	1200.0
2017-01-23 08:25:00	AAPL	Stock	29.935	29.9375	29.925	29.9375	39808.0
2017-01-23 08:30:00	AAPL	Stock	29.94	29.9425	29.94	29.9425	14920.0
2017-01-23 08:35:00	AAPL	Stock	29.945	29.945	29.935	29.945	9364.0
2017-01-23 08:40:00	AAPL	Stock	29.9375	29.9425	29.9375	29.9425	2800.0
2017-01-23 08:45:00	AAPL	Stock	29.945	29.95	29.9425	29.945	5200.0
2017-01-23 08:50:00	AAPL	Stock	29.95	29.95	29.95	29.95	3392.0
2017-01-23 08:55:00	AAPL	Stock	29.9625	29.9675	29.9575	29.9625	23760.0
2017-01-23 09:00:00	AAPL	Stock	29.96	29.9625	29.955	29.9625	24904.0
2017-01-23 09:05:00	AAPL	Stock	29.9575	29.9575	29.945	29.95	14048.0
2017-01-23 09:10:00	AAPL	Stock	29.95	29.96	29.95	29.96	14960.0
2017-01-23 09:15:00	AAPL	Stock	29.955	29.96	29.955	29.9575	24000.0
2017-01-23 09:20:00	AAPL	Stock	29.955	29.955	29.9475	29.95	26692.0
2017-01-23 09:25:00	AAPL	Stock	29.945	30.0	29.945	29.98	108376.0
2017-01-23 09:30:00	AAPL	Stock	29.9825	30.1175	29.98	30.1075	6960964.0
2017-01-23 09:35:00	AAPL	Stock	30.1075	30.1975	30.1062	30.1888	3683160.0
2017-01-23 09:40:00	AAPL	Stock	30.19	30.2025	30.075	30.13	3681824.0
2017-01-23 09:45:00	AAPL	Stock	30.13	30.135	30.1025	30.13	1297504.0
2017-01-23 09:50:00	AAPL	Stock	30.13	30.135	30.0675	30.0788	1458872.0
2017-01-23 09:55:00	AAPL	Stock	30.0788	30.089	30.04	30.0625	1205404.0
2017-01-23 10:00:00	AAPL	Stock	30.0618	30.0975	30.0612	30.085	1604656.0
2017-01-23 10:05:00	AAPL	Stock	30.085	30.0962	30.0275	30.0738	1486956.0
2017-01-23 10:10:00	AAPL	Stock	30.0725	30.0975	30.05	30.0962	1364800.0
2017-01-23 10:15:00	AAPL	Stock	30.0975	30.1175	30.0825	30.0865	1202440.0
2017-01-23 10:20:00	AAPL	Stock	30.0875	30.1022	30.0775	30.0875	816664.0

> showing 50 of 349,631 rows — these rows as CSV

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