PREVIEW / stock_5min / 2017-10-13

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-13.parquet
  size:    5.3 MB
  rows:    343,339
  symbols: 2,947

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-10-13 04:05:00	AAPL	Stock	39.05	39.05	39.05	39.05	400.0
2017-10-13 05:05:00	AAPL	Stock	39.035	39.035	39.0225	39.0225	1200.0
2017-10-13 05:10:00	AAPL	Stock	39.0	39.0	39.0	39.0	700.0
2017-10-13 05:15:00	AAPL	Stock	39.0	39.0	39.0	39.0	1200.0
2017-10-13 05:35:00	AAPL	Stock	39.035	39.035	39.035	39.035	1012.0
2017-10-13 06:10:00	AAPL	Stock	39.05	39.05	39.05	39.05	1600.0
2017-10-13 06:35:00	AAPL	Stock	39.05	39.05	39.05	39.05	1700.0
2017-10-13 06:55:00	AAPL	Stock	39.05	39.05	39.05	39.05	1800.0
2017-10-13 07:00:00	AAPL	Stock	39.0625	39.075	39.05	39.075	3312.0
2017-10-13 07:05:00	AAPL	Stock	39.0325	39.075	39.0325	39.075	2800.0
2017-10-13 07:15:00	AAPL	Stock	39.09	39.09	39.09	39.09	400.0
2017-10-13 07:20:00	AAPL	Stock	39.09	39.09	39.09	39.09	2000.0
2017-10-13 07:25:00	AAPL	Stock	39.0925	39.0925	39.0925	39.0925	868.0
2017-10-13 07:30:00	AAPL	Stock	39.11	39.125	39.11	39.125	896.0
2017-10-13 07:35:00	AAPL	Stock	39.105	39.105	39.105	39.105	2400.0
2017-10-13 07:40:00	AAPL	Stock	39.105	39.125	39.0875	39.0925	31860.0
2017-10-13 07:45:00	AAPL	Stock	39.1	39.1	39.0875	39.0875	6620.0
2017-10-13 07:50:00	AAPL	Stock	39.085	39.0875	39.085	39.0875	46800.0
2017-10-13 07:55:00	AAPL	Stock	39.0875	39.1	39.075	39.075	12868.0
2017-10-13 08:00:00	AAPL	Stock	39.1	39.125	39.085	39.0975	20832.0
2017-10-13 08:05:00	AAPL	Stock	39.0875	39.0875	39.08	39.08	9200.0
2017-10-13 08:10:00	AAPL	Stock	39.08	39.0875	39.0675	39.075	13920.0
2017-10-13 08:15:00	AAPL	Stock	39.0875	39.0875	39.085	39.085	3036.0
2017-10-13 08:20:00	AAPL	Stock	39.0825	39.0875	39.075	39.075	16680.0
2017-10-13 08:25:00	AAPL	Stock	39.08	39.1025	39.08	39.1	12400.0
2017-10-13 08:30:00	AAPL	Stock	39.11	39.1525	39.11	39.1525	50280.0
2017-10-13 08:35:00	AAPL	Stock	39.175	39.1875	39.125	39.125	39568.0
2017-10-13 08:40:00	AAPL	Stock	39.125	39.1575	39.125	39.1575	11324.0
2017-10-13 08:45:00	AAPL	Stock	39.1375	39.15	39.1375	39.15	5360.0
2017-10-13 08:50:00	AAPL	Stock	39.1375	39.14	39.125	39.14	24160.0
2017-10-13 08:55:00	AAPL	Stock	39.1475	39.1575	39.14	39.1575	38296.0
2017-10-13 09:00:00	AAPL	Stock	39.16	39.16	39.14	39.1475	10000.0
2017-10-13 09:05:00	AAPL	Stock	39.1475	39.155	39.125	39.14	52648.0
2017-10-13 09:10:00	AAPL	Stock	39.14	39.15	39.125	39.14	32384.0
2017-10-13 09:15:00	AAPL	Stock	39.14	39.1625	39.14	39.1625	12720.0
2017-10-13 09:20:00	AAPL	Stock	39.1425	39.15	39.14	39.15	15272.0
2017-10-13 09:25:00	AAPL	Stock	39.14	39.1875	39.14	39.1875	21968.0
2017-10-13 09:30:00	AAPL	Stock	39.185	39.2225	39.15	39.1725	2478924.0
2017-10-13 09:35:00	AAPL	Stock	39.1625	39.2125	39.14	39.1468	1611652.0
2017-10-13 09:40:00	AAPL	Stock	39.1475	39.1675	39.1025	39.16	1392160.0
2017-10-13 09:45:00	AAPL	Stock	39.1625	39.205	39.145	39.1865	1148756.0
2017-10-13 09:50:00	AAPL	Stock	39.1875	39.2392	39.1825	39.2175	1732620.0
2017-10-13 09:55:00	AAPL	Stock	39.2175	39.22	39.1675	39.175	1013520.0
2017-10-13 10:00:00	AAPL	Stock	39.1775	39.2125	39.1775	39.2062	730664.0
2017-10-13 10:05:00	AAPL	Stock	39.2075	39.2738	39.205	39.2725	1588128.0
2017-10-13 10:10:00	AAPL	Stock	39.2725	39.28	39.2025	39.2175	1239968.0
2017-10-13 10:15:00	AAPL	Stock	39.22	39.25	39.2125	39.2148	552080.0
2017-10-13 10:20:00	AAPL	Stock	39.22	39.2525	39.1825	39.185	1125252.0
2017-10-13 10:25:00	AAPL	Stock	39.1875	39.245	39.1775	39.2425	980028.0
2017-10-13 10:30:00	AAPL	Stock	39.2425	39.2575	39.23	39.2525	921596.0

> showing 50 of 343,339 rows — these rows as CSV

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