PREVIEW / stock_5min / 2017-08-15

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-15.parquet
  size:    5.3 MB
  rows:    345,347
  symbols: 2,990

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-08-15 04:00:00	AAPL	Stock	40.0825	40.0875	40.0825	40.0875	1448.0
2017-08-15 04:05:00	AAPL	Stock	40.0875	40.0875	40.0875	40.0875	3168.0
2017-08-15 05:55:00	AAPL	Stock	40.0275	40.0275	40.0275	40.0275	800.0
2017-08-15 06:00:00	AAPL	Stock	40.0825	40.0825	40.0825	40.0825	3252.0
2017-08-15 06:10:00	AAPL	Stock	40.0775	40.0825	40.0775	40.0825	4440.0
2017-08-15 06:20:00	AAPL	Stock	40.0875	40.0875	40.0625	40.0625	1200.0
2017-08-15 06:25:00	AAPL	Stock	40.0625	40.0625	40.03	40.03	2800.0
2017-08-15 06:30:00	AAPL	Stock	40.04	40.04	40.0375	40.0375	2396.0
2017-08-15 06:35:00	AAPL	Stock	40.0375	40.0375	40.0375	40.0375	800.0
2017-08-15 06:40:00	AAPL	Stock	40.0625	40.0625	40.0625	40.0625	2400.0
2017-08-15 06:45:00	AAPL	Stock	40.0875	40.0875	40.0875	40.0875	3920.0
2017-08-15 06:50:00	AAPL	Stock	40.0875	40.0875	40.0875	40.0875	400.0
2017-08-15 06:55:00	AAPL	Stock	40.0875	40.0875	40.0875	40.0875	1600.0
2017-08-15 07:00:00	AAPL	Stock	40.0925	40.175	40.0925	40.175	11792.0
2017-08-15 07:05:00	AAPL	Stock	40.1275	40.1625	40.1275	40.1625	2400.0
2017-08-15 07:10:00	AAPL	Stock	40.1475	40.1575	40.1475	40.1575	18692.0
2017-08-15 07:15:00	AAPL	Stock	40.15	40.1625	40.15	40.1625	1600.0
2017-08-15 07:20:00	AAPL	Stock	40.175	40.175	40.175	40.175	4400.0
2017-08-15 07:25:00	AAPL	Stock	40.1375	40.1375	40.1375	40.1375	400.0
2017-08-15 07:30:00	AAPL	Stock	40.15	40.1575	40.15	40.1575	7600.0
2017-08-15 07:35:00	AAPL	Stock	40.1475	40.1575	40.1475	40.1575	1156.0
2017-08-15 07:40:00	AAPL	Stock	40.15	40.15	40.075	40.075	9732.0
2017-08-15 07:45:00	AAPL	Stock	40.075	40.1225	40.075	40.1225	18100.0
2017-08-15 07:50:00	AAPL	Stock	40.1225	40.125	40.1125	40.115	7756.0
2017-08-15 07:55:00	AAPL	Stock	40.1225	40.125	40.1125	40.1225	4080.0
2017-08-15 08:00:00	AAPL	Stock	40.125	40.175	40.1125	40.14	62360.0
2017-08-15 08:05:00	AAPL	Stock	40.145	40.145	40.1275	40.1275	27408.0
2017-08-15 08:10:00	AAPL	Stock	40.14	40.14	40.125	40.125	12648.0
2017-08-15 08:15:00	AAPL	Stock	40.125	40.1425	40.1225	40.1425	60868.0
2017-08-15 08:20:00	AAPL	Stock	40.1425	40.1575	40.125	40.1575	48992.0
2017-08-15 08:25:00	AAPL	Stock	40.145	40.15	40.125	40.1275	71192.0
2017-08-15 08:30:00	AAPL	Stock	40.1275	40.185	40.1125	40.185	35652.0
2017-08-15 08:35:00	AAPL	Stock	40.185	40.215	40.1775	40.2	48608.0
2017-08-15 08:40:00	AAPL	Stock	40.2	40.2	40.16	40.175	39636.0
2017-08-15 08:45:00	AAPL	Stock	40.175	40.175	40.1375	40.16	87092.0
2017-08-15 08:50:00	AAPL	Stock	40.165	40.18	40.165	40.18	8152.0
2017-08-15 08:55:00	AAPL	Stock	40.18	40.2	40.1675	40.2	15952.0
2017-08-15 09:00:00	AAPL	Stock	40.2	40.2275	40.2	40.2275	17752.0
2017-08-15 09:05:00	AAPL	Stock	40.235	40.2425	40.195	40.2	92776.0
2017-08-15 09:10:00	AAPL	Stock	40.2	40.205	40.1925	40.2	13612.0
2017-08-15 09:15:00	AAPL	Stock	40.2075	40.2075	40.15	40.1975	84516.0
2017-08-15 09:20:00	AAPL	Stock	40.1975	40.205	40.1825	40.205	31760.0
2017-08-15 09:25:00	AAPL	Stock	40.2025	40.2075	40.1425	40.1775	59288.0
2017-08-15 09:30:00	AAPL	Stock	40.165	40.2775	40.1082	40.2475	5088408.0
2017-08-15 09:35:00	AAPL	Stock	40.2425	40.2925	40.125	40.205	2508296.0
2017-08-15 09:40:00	AAPL	Stock	40.2075	40.23	40.1125	40.1512	1829348.0
2017-08-15 09:45:00	AAPL	Stock	40.1475	40.1575	40.035	40.0925	1994728.0
2017-08-15 09:50:00	AAPL	Stock	40.0975	40.1575	40.085	40.145	1546736.0
2017-08-15 09:55:00	AAPL	Stock	40.145	40.2125	40.145	40.186	1744428.0
2017-08-15 10:00:00	AAPL	Stock	40.185	40.24	40.1825	40.195	1634220.0

> showing 50 of 345,347 rows — these rows as CSV

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