PREVIEW / stock_5min / 2016-12-27

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-12-27.parquet
  size:    5.3 MB
  rows:    351,714
  symbols: 3,165

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
2016-12-27 05:00:00	AAPL	Stock	29.1375	29.1375	29.1375	29.1375	400.0
2016-12-27 06:50:00	AAPL	Stock	29.1725	29.1725	29.1725	29.1725	864.0
2016-12-27 07:10:00	AAPL	Stock	29.225	29.23	29.225	29.225	6000.0
2016-12-27 07:15:00	AAPL	Stock	29.225	29.225	29.225	29.225	400.0
2016-12-27 07:25:00	AAPL	Stock	29.225	29.225	29.225	29.225	2560.0
2016-12-27 07:40:00	AAPL	Stock	29.205	29.205	29.1875	29.1875	800.0
2016-12-27 07:45:00	AAPL	Stock	29.21	29.2225	29.1875	29.1875	18600.0
2016-12-27 07:55:00	AAPL	Stock	29.19	29.19	29.185	29.185	1600.0
2016-12-27 08:00:00	AAPL	Stock	29.225	29.225	29.1775	29.19	7040.0
2016-12-27 08:05:00	AAPL	Stock	29.19	29.19	29.19	29.19	800.0
2016-12-27 08:10:00	AAPL	Stock	29.1775	29.1775	29.1775	29.1775	800.0
2016-12-27 08:15:00	AAPL	Stock	29.18	29.18	29.18	29.18	3600.0
2016-12-27 08:20:00	AAPL	Stock	29.18	29.18	29.18	29.18	1600.0
2016-12-27 08:25:00	AAPL	Stock	29.1825	29.1875	29.1825	29.1875	4624.0
2016-12-27 08:30:00	AAPL	Stock	29.1875	29.1875	29.1775	29.1775	3140.0
2016-12-27 08:35:00	AAPL	Stock	29.1775	29.1775	29.175	29.175	6400.0
2016-12-27 08:40:00	AAPL	Stock	29.185	29.185	29.17	29.17	8000.0
2016-12-27 08:45:00	AAPL	Stock	29.1625	29.1625	29.1625	29.1625	7996.0
2016-12-27 08:50:00	AAPL	Stock	29.17	29.18	29.17	29.18	5464.0
2016-12-27 08:55:00	AAPL	Stock	29.18	29.18	29.1775	29.1775	7200.0
2016-12-27 09:00:00	AAPL	Stock	29.17	29.1825	29.17	29.1825	5648.0
2016-12-27 09:05:00	AAPL	Stock	29.17	29.175	29.17	29.175	2108.0
2016-12-27 09:10:00	AAPL	Stock	29.175	29.175	29.175	29.175	2304.0
2016-12-27 09:15:00	AAPL	Stock	29.175	29.175	29.1625	29.1625	5088.0
2016-12-27 09:20:00	AAPL	Stock	29.1625	29.1625	29.1525	29.1525	10296.0
2016-12-27 09:25:00	AAPL	Stock	29.19	29.19	29.13	29.13	28248.0
2016-12-27 09:30:00	AAPL	Stock	29.1425	29.25	29.1225	29.246	3958212.0
2016-12-27 09:35:00	AAPL	Stock	29.245	29.3375	29.235	29.3038	3450232.0
2016-12-27 09:40:00	AAPL	Stock	29.305	29.3675	29.3025	29.3528	2428184.0
2016-12-27 09:45:00	AAPL	Stock	29.3538	29.4375	29.35	29.421	3995712.0
2016-12-27 09:50:00	AAPL	Stock	29.4225	29.4375	29.4	29.42	2100604.0
2016-12-27 09:55:00	AAPL	Stock	29.4188	29.445	29.4075	29.4438	1835868.0
2016-12-27 10:00:00	AAPL	Stock	29.4438	29.45	29.4075	29.4125	1192656.0
2016-12-27 10:05:00	AAPL	Stock	29.4125	29.4225	29.4038	29.4075	1133320.0
2016-12-27 10:10:00	AAPL	Stock	29.4075	29.42	29.365	29.3775	1237864.0
2016-12-27 10:15:00	AAPL	Stock	29.3775	29.395	29.3775	29.393	739992.0
2016-12-27 10:20:00	AAPL	Stock	29.395	29.41	29.385	29.4098	902072.0
2016-12-27 10:25:00	AAPL	Stock	29.41	29.4175	29.3975	29.4125	1141244.0
2016-12-27 10:30:00	AAPL	Stock	29.41	29.4225	29.4025	29.415	995392.0
2016-12-27 10:35:00	AAPL	Stock	29.415	29.4165	29.4075	29.4075	448272.0
2016-12-27 10:40:00	AAPL	Stock	29.4075	29.4138	29.38	29.38	815532.0
2016-12-27 10:45:00	AAPL	Stock	29.38	29.3975	29.38	29.3925	638028.0
2016-12-27 10:50:00	AAPL	Stock	29.3938	29.4025	29.3675	29.3888	788828.0
2016-12-27 10:55:00	AAPL	Stock	29.39	29.4075	29.3812	29.4075	667096.0
2016-12-27 11:00:00	AAPL	Stock	29.4062	29.4175	29.405	29.41	751836.0
2016-12-27 11:05:00	AAPL	Stock	29.41	29.4125	29.3975	29.399	512232.0
2016-12-27 11:10:00	AAPL	Stock	29.3975	29.3975	29.385	29.394	679604.0
2016-12-27 11:15:00	AAPL	Stock	29.395	29.405	29.39	29.405	534888.0
2016-12-27 11:20:00	AAPL	Stock	29.405	29.41	29.3962	29.41	496732.0
2016-12-27 11:25:00	AAPL	Stock	29.41	29.42	29.4075	29.419	610356.0

> showing 50 of 351,714 rows — these rows as CSV

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