PREVIEW / stock_5min / 2017-07-03

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-03.parquet
  size:    3.2 MB
  rows:    199,913
  symbols: 2,927

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-07-03 04:05:00	AAPL	Stock	36.18	36.18	36.18	36.18	2000.0
2017-07-03 04:20:00	AAPL	Stock	36.1825	36.1825	36.1825	36.1825	644.0
2017-07-03 04:45:00	AAPL	Stock	36.1825	36.1825	36.15	36.15	2000.0
2017-07-03 05:00:00	AAPL	Stock	36.165	36.165	36.165	36.165	1200.0
2017-07-03 05:55:00	AAPL	Stock	36.16	36.16	36.16	36.16	1600.0
2017-07-03 06:05:00	AAPL	Stock	36.16	36.16	36.16	36.16	400.0
2017-07-03 06:25:00	AAPL	Stock	36.1125	36.1125	36.1125	36.1125	1200.0
2017-07-03 06:55:00	AAPL	Stock	36.125	36.125	36.125	36.125	680.0
2017-07-03 07:00:00	AAPL	Stock	36.14	36.1625	36.14	36.15	2888.0
2017-07-03 07:05:00	AAPL	Stock	36.16	36.16	36.15	36.15	8800.0
2017-07-03 07:10:00	AAPL	Stock	36.1325	36.135	36.1325	36.135	800.0
2017-07-03 07:15:00	AAPL	Stock	36.145	36.145	36.145	36.145	400.0
2017-07-03 07:20:00	AAPL	Stock	36.15	36.15	36.15	36.15	3648.0
2017-07-03 07:30:00	AAPL	Stock	36.15	36.15	36.15	36.15	1200.0
2017-07-03 07:35:00	AAPL	Stock	36.1625	36.1625	36.1625	36.1625	800.0
2017-07-03 07:40:00	AAPL	Stock	36.1775	36.1775	36.1775	36.1775	1100.0
2017-07-03 07:45:00	AAPL	Stock	36.15	36.15	36.15	36.15	400.0
2017-07-03 08:00:00	AAPL	Stock	36.075	36.1775	36.075	36.1375	6992.0
2017-07-03 08:05:00	AAPL	Stock	36.14	36.15	36.14	36.15	1900.0
2017-07-03 08:10:00	AAPL	Stock	36.16	36.1675	36.1425	36.1425	14588.0
2017-07-03 08:15:00	AAPL	Stock	36.17	36.17	36.17	36.17	1000.0
2017-07-03 08:25:00	AAPL	Stock	36.16	36.16	36.1375	36.1375	10844.0
2017-07-03 08:30:00	AAPL	Stock	36.1375	36.16	36.13	36.13	1200.0
2017-07-03 08:35:00	AAPL	Stock	36.125	36.15	36.125	36.15	5320.0
2017-07-03 08:40:00	AAPL	Stock	36.145	36.1775	36.145	36.1775	19508.0
2017-07-03 08:45:00	AAPL	Stock	36.005	36.175	36.005	36.175	10520.0
2017-07-03 08:50:00	AAPL	Stock	36.175	36.1875	36.175	36.1875	17536.0
2017-07-03 08:55:00	AAPL	Stock	36.1825	36.1925	36.1825	36.1925	12896.0
2017-07-03 09:00:00	AAPL	Stock	36.2025	36.2025	36.1875	36.1925	6540.0
2017-07-03 09:05:00	AAPL	Stock	36.1875	36.1875	36.1775	36.1775	19656.0
2017-07-03 09:10:00	AAPL	Stock	36.18	36.2	36.1775	36.2	11432.0
2017-07-03 09:15:00	AAPL	Stock	36.195	36.21	36.1925	36.2	15660.0
2017-07-03 09:20:00	AAPL	Stock	36.175	36.2	36.1625	36.1925	19168.0
2017-07-03 09:25:00	AAPL	Stock	36.1925	36.26	36.1925	36.2425	94460.0
2017-07-03 09:30:00	AAPL	Stock	36.2375	36.325	36.22	36.295	3128404.0
2017-07-03 09:35:00	AAPL	Stock	36.29	36.32	36.2425	36.27	1726652.0
2017-07-03 09:40:00	AAPL	Stock	36.27	36.28	36.1975	36.2475	1386160.0
2017-07-03 09:45:00	AAPL	Stock	36.2475	36.31	36.2475	36.2775	1379720.0
2017-07-03 09:50:00	AAPL	Stock	36.275	36.3025	36.2475	36.265	744212.0
2017-07-03 09:55:00	AAPL	Stock	36.265	36.2775	36.1925	36.193	944440.0
2017-07-03 10:00:00	AAPL	Stock	36.2	36.225	36.1475	36.1515	963288.0
2017-07-03 10:05:00	AAPL	Stock	36.15	36.1875	36.1175	36.1725	1050652.0
2017-07-03 10:10:00	AAPL	Stock	36.1775	36.18	36.1535	36.1575	573920.0
2017-07-03 10:15:00	AAPL	Stock	36.1575	36.1812	36.0725	36.0775	1102320.0
2017-07-03 10:20:00	AAPL	Stock	36.075	36.0812	36.0075	36.0322	1058308.0
2017-07-03 10:25:00	AAPL	Stock	36.025	36.0675	35.975	36.035	1317528.0
2017-07-03 10:30:00	AAPL	Stock	36.03	36.0525	35.9825	35.99	835120.0
2017-07-03 10:35:00	AAPL	Stock	35.99	35.9948	35.945	35.975	910144.0
2017-07-03 10:40:00	AAPL	Stock	35.9762	35.9925	35.9625	35.9825	557536.0
2017-07-03 10:45:00	AAPL	Stock	35.9825	36.0065	35.97	35.9925	652884.0

> showing 50 of 199,913 rows — these rows as CSV

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