PREVIEW / stock_5min / 2018-09-05

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-09-05.parquet
  size:    5.6 MB
  rows:    354,887
  symbols: 2,782

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
2018-09-05 04:00:00	AAPL	Stock	57.0625	57.0625	56.9625	57.0	14528.0
2018-09-05 04:10:00	AAPL	Stock	57.125	57.125	57.02	57.02	1172.0
2018-09-05 04:15:00	AAPL	Stock	57.0725	57.0775	57.04	57.04	5868.0
2018-09-05 04:25:00	AAPL	Stock	57.025	57.025	57.025	57.025	1588.0
2018-09-05 04:30:00	AAPL	Stock	57.0225	57.025	57.0	57.005	4000.0
2018-09-05 04:45:00	AAPL	Stock	57.0	57.025	57.0	57.025	940.0
2018-09-05 04:55:00	AAPL	Stock	57.0375	57.05	57.0375	57.05	4880.0
2018-09-05 05:00:00	AAPL	Stock	57.0475	57.0475	57.0475	57.0475	800.0
2018-09-05 05:10:00	AAPL	Stock	57.0425	57.0425	57.0	57.0	5308.0
2018-09-05 05:15:00	AAPL	Stock	57.05	57.05	57.025	57.025	2396.0
2018-09-05 05:25:00	AAPL	Stock	57.0	57.0	57.0	57.0	2380.0
2018-09-05 05:30:00	AAPL	Stock	56.975	56.975	56.9625	56.9625	6892.0
2018-09-05 05:35:00	AAPL	Stock	56.9625	56.9625	56.9625	56.9625	1200.0
2018-09-05 05:45:00	AAPL	Stock	56.9475	56.9475	56.9475	56.9475	800.0
2018-09-05 05:55:00	AAPL	Stock	56.9475	56.9625	56.9475	56.9625	13168.0
2018-09-05 06:00:00	AAPL	Stock	56.9625	56.9625	56.9375	56.9375	8800.0
2018-09-05 06:05:00	AAPL	Stock	56.9275	56.9275	56.9	56.9	800.0
2018-09-05 06:10:00	AAPL	Stock	56.935	56.9375	56.935	56.9375	1076.0
2018-09-05 06:15:00	AAPL	Stock	56.9375	56.9375	56.9375	56.9375	400.0
2018-09-05 06:20:00	AAPL	Stock	56.935	56.935	56.935	56.935	1756.0
2018-09-05 06:25:00	AAPL	Stock	56.9475	56.9625	56.9475	56.9625	6940.0
2018-09-05 06:35:00	AAPL	Stock	56.9725	57.0175	56.9725	57.0175	4968.0
2018-09-05 06:45:00	AAPL	Stock	57.0125	57.0125	57.0125	57.0125	480.0
2018-09-05 07:00:00	AAPL	Stock	57.02	57.0375	57.02	57.0375	11520.0
2018-09-05 07:05:00	AAPL	Stock	57.0375	57.0825	57.0375	57.065	10664.0
2018-09-05 07:10:00	AAPL	Stock	57.0375	57.0525	57.03	57.0525	8396.0
2018-09-05 07:15:00	AAPL	Stock	57.0475	57.06	57.0475	57.06	1736.0
2018-09-05 07:20:00	AAPL	Stock	57.0325	57.07	57.0	57.0575	41244.0
2018-09-05 07:25:00	AAPL	Stock	57.055	57.08	57.0425	57.0425	12120.0
2018-09-05 07:30:00	AAPL	Stock	57.05	57.08	57.05	57.05	14868.0
2018-09-05 07:35:00	AAPL	Stock	57.0525	57.0625	57.0525	57.0625	2880.0
2018-09-05 07:45:00	AAPL	Stock	57.05	57.0625	57.05	57.0625	14136.0
2018-09-05 08:00:00	AAPL	Stock	57.025	57.225	57.0175	57.03	56380.0
2018-09-05 08:05:00	AAPL	Stock	57.035	57.0425	57.025	57.025	8420.0
2018-09-05 08:10:00	AAPL	Stock	57.0125	57.0375	57.0075	57.025	23240.0
2018-09-05 08:15:00	AAPL	Stock	57.0075	57.025	57.0	57.0	28816.0
2018-09-05 08:20:00	AAPL	Stock	57.0	57.0	56.9875	56.99	10792.0
2018-09-05 08:25:00	AAPL	Stock	56.99	57.0025	56.99	57.0025	5148.0
2018-09-05 08:30:00	AAPL	Stock	56.9975	57.0125	56.98	57.0	14972.0
2018-09-05 08:35:00	AAPL	Stock	57.0125	57.025	57.0	57.025	11800.0
2018-09-05 08:40:00	AAPL	Stock	57.025	57.025	57.0125	57.0125	9300.0
2018-09-05 08:45:00	AAPL	Stock	57.0125	57.0375	57.0125	57.0325	28968.0
2018-09-05 08:50:00	AAPL	Stock	57.025	57.0875	57.025	57.0775	27148.0
2018-09-05 08:55:00	AAPL	Stock	57.0925	57.135	57.0925	57.1125	49968.0
2018-09-05 09:00:00	AAPL	Stock	57.1125	57.12	57.0875	57.0875	35212.0
2018-09-05 09:05:00	AAPL	Stock	57.0875	57.16	57.0875	57.1575	44336.0
2018-09-05 09:10:00	AAPL	Stock	57.15	57.1625	57.1375	57.1625	46968.0
2018-09-05 09:15:00	AAPL	Stock	57.1525	57.1625	57.1375	57.16	55852.0
2018-09-05 09:20:00	AAPL	Stock	57.1575	57.1725	57.1525	57.165	9832.0
2018-09-05 09:25:00	AAPL	Stock	57.1625	57.25	57.1625	57.25	95548.0

> showing 50 of 354,887 rows — these rows as CSV

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