PREVIEW / stock_5min / 2017-10-18

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-18.parquet
  size:    5.4 MB
  rows:    351,831
  symbols: 2,933

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-18 07:00:00	AAPL	Stock	40.1575	40.1575	40.1575	40.1575	400.0
2017-10-18 07:10:00	AAPL	Stock	40.175	40.1975	40.175	40.195	2800.0
2017-10-18 07:15:00	AAPL	Stock	40.195	40.2	40.195	40.2	4372.0
2017-10-18 07:20:00	AAPL	Stock	40.22	40.22	40.22	40.22	1148.0
2017-10-18 07:25:00	AAPL	Stock	40.205	40.2175	40.205	40.2175	7092.0
2017-10-18 07:30:00	AAPL	Stock	40.2125	40.2125	40.2	40.2	4340.0
2017-10-18 07:35:00	AAPL	Stock	40.1875	40.1875	40.1875	40.1875	3600.0
2017-10-18 07:40:00	AAPL	Stock	40.195	40.2	40.195	40.2	10956.0
2017-10-18 07:45:00	AAPL	Stock	40.2	40.205	40.2	40.205	3672.0
2017-10-18 07:50:00	AAPL	Stock	40.2	40.2	40.2	40.2	1988.0
2017-10-18 07:55:00	AAPL	Stock	40.2	40.2	40.1775	40.1775	10240.0
2017-10-18 08:00:00	AAPL	Stock	40.22	40.22	40.175	40.175	54244.0
2017-10-18 08:05:00	AAPL	Stock	40.1625	40.175	40.1625	40.17	17780.0
2017-10-18 08:10:00	AAPL	Stock	40.17	40.175	40.1675	40.1725	15176.0
2017-10-18 08:15:00	AAPL	Stock	40.185	40.185	40.175	40.185	5764.0
2017-10-18 08:20:00	AAPL	Stock	40.185	40.1875	40.18	40.1875	15608.0
2017-10-18 08:25:00	AAPL	Stock	40.1825	40.1875	40.1825	40.185	6200.0
2017-10-18 08:30:00	AAPL	Stock	40.185	40.1875	40.18	40.185	17804.0
2017-10-18 08:35:00	AAPL	Stock	40.195	40.2	40.1875	40.1925	11648.0
2017-10-18 08:40:00	AAPL	Stock	40.1825	40.2	40.175	40.2	24708.0
2017-10-18 08:45:00	AAPL	Stock	40.1925	40.1925	40.185	40.185	4800.0
2017-10-18 08:50:00	AAPL	Stock	40.185	40.185	40.175	40.185	12204.0
2017-10-18 08:55:00	AAPL	Stock	40.185	40.185	40.1825	40.1825	15560.0
2017-10-18 09:00:00	AAPL	Stock	40.185	40.2125	40.18	40.21	33016.0
2017-10-18 09:05:00	AAPL	Stock	40.215	40.225	40.2075	40.2075	69376.0
2017-10-18 09:10:00	AAPL	Stock	40.2125	40.225	40.2075	40.2075	30004.0
2017-10-18 09:15:00	AAPL	Stock	40.195	40.225	40.195	40.225	1232.0
2017-10-18 09:20:00	AAPL	Stock	40.2175	40.2175	40.19	40.2175	4896.0
2017-10-18 09:25:00	AAPL	Stock	40.2125	40.22	40.0825	40.1075	194264.0
2017-10-18 09:30:00	AAPL	Stock	40.1125	40.1625	40.07	40.0975	3959356.0
2017-10-18 09:35:00	AAPL	Stock	40.095	40.1775	40.09	40.1225	1344628.0
2017-10-18 09:40:00	AAPL	Stock	40.125	40.1265	39.98	40.0065	1955976.0
2017-10-18 09:45:00	AAPL	Stock	40.01	40.0475	39.9525	39.995	1595800.0
2017-10-18 09:50:00	AAPL	Stock	39.995	40.0375	39.995	40.0275	1490020.0
2017-10-18 09:55:00	AAPL	Stock	40.0275	40.0775	40.0075	40.0675	1038736.0
2017-10-18 10:00:00	AAPL	Stock	40.07	40.1112	40.0625	40.0938	1360172.0
2017-10-18 10:05:00	AAPL	Stock	40.095	40.1025	40.055	40.0875	1164176.0
2017-10-18 10:10:00	AAPL	Stock	40.086	40.11	40.0352	40.076	998972.0
2017-10-18 10:15:00	AAPL	Stock	40.0775	40.0875	40.0392	40.055	506344.0
2017-10-18 10:20:00	AAPL	Stock	40.055	40.0675	40.0312	40.0425	840316.0
2017-10-18 10:25:00	AAPL	Stock	40.0425	40.0875	40.0425	40.07	641932.0
2017-10-18 10:30:00	AAPL	Stock	40.07	40.1	40.0665	40.0775	588720.0
2017-10-18 10:35:00	AAPL	Stock	40.08	40.0812	40.0375	40.0525	410116.0
2017-10-18 10:40:00	AAPL	Stock	40.0513	40.0625	40.045	40.0543	496000.0
2017-10-18 10:45:00	AAPL	Stock	40.0565	40.0675	40.0475	40.0525	459544.0
2017-10-18 10:50:00	AAPL	Stock	40.0525	40.065	40.0425	40.0575	428312.0
2017-10-18 10:55:00	AAPL	Stock	40.055	40.06	40.03	40.03	643200.0
2017-10-18 11:00:00	AAPL	Stock	40.03	40.0425	40.0125	40.0175	525720.0
2017-10-18 11:05:00	AAPL	Stock	40.015	40.03	39.9825	39.9825	707900.0
2017-10-18 11:10:00	AAPL	Stock	39.9812	40.035	39.9812	40.0282	583548.0

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

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