PREVIEW / stock_5min / 2018-08-29

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-08-29.parquet
  size:    5.5 MB
  rows:    349,870
  symbols: 2,797

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-08-29 04:00:00	AAPL	Stock	55.0625	55.0625	55.0625	55.0625	3700.0
2018-08-29 04:10:00	AAPL	Stock	55.075	55.125	55.075	55.125	1300.0
2018-08-29 04:15:00	AAPL	Stock	55.1175	55.125	55.1175	55.125	3704.0
2018-08-29 04:25:00	AAPL	Stock	55.015	55.015	55.015	55.015	800.0
2018-08-29 04:35:00	AAPL	Stock	55.0575	55.0575	55.0575	55.0575	400.0
2018-08-29 04:50:00	AAPL	Stock	55.075	55.075	55.05	55.05	2000.0
2018-08-29 04:55:00	AAPL	Stock	55.05	55.05	55.05	55.05	5232.0
2018-08-29 05:00:00	AAPL	Stock	55.05	55.05	55.0375	55.0375	1200.0
2018-08-29 05:15:00	AAPL	Stock	55.0475	55.0475	55.0475	55.0475	400.0
2018-08-29 05:20:00	AAPL	Stock	55.0475	55.05	55.0475	55.05	13348.0
2018-08-29 05:25:00	AAPL	Stock	55.05	55.05	55.05	55.05	1176.0
2018-08-29 05:35:00	AAPL	Stock	55.05	55.05	54.99	55.0	9828.0
2018-08-29 05:45:00	AAPL	Stock	55.0025	55.005	55.0025	55.005	896.0
2018-08-29 05:50:00	AAPL	Stock	55.05	55.05	55.05	55.05	4400.0
2018-08-29 06:30:00	AAPL	Stock	55.0	55.0	55.0	55.0	800.0
2018-08-29 06:45:00	AAPL	Stock	54.9825	54.9825	54.9825	54.9825	604.0
2018-08-29 07:00:00	AAPL	Stock	54.9925	54.9975	54.9875	54.9975	2800.0
2018-08-29 07:05:00	AAPL	Stock	54.9875	54.9925	54.9875	54.9925	2616.0
2018-08-29 07:10:00	AAPL	Stock	54.995	55.005	54.985	55.005	6700.0
2018-08-29 07:15:00	AAPL	Stock	55.0125	55.0125	55.01	55.0125	2196.0
2018-08-29 07:20:00	AAPL	Stock	55.0225	55.0225	55.005	55.0225	7516.0
2018-08-29 07:25:00	AAPL	Stock	55.0175	55.0175	55.0175	55.0175	832.0
2018-08-29 07:30:00	AAPL	Stock	55.0225	55.045	55.0225	55.025	8844.0
2018-08-29 07:35:00	AAPL	Stock	55.025	55.025	55.0025	55.025	11956.0
2018-08-29 07:40:00	AAPL	Stock	55.0425	55.0625	55.0425	55.0525	24548.0
2018-08-29 07:45:00	AAPL	Stock	55.06	55.0625	55.0525	55.0525	4012.0
2018-08-29 07:50:00	AAPL	Stock	55.06	55.075	55.06	55.075	14800.0
2018-08-29 07:55:00	AAPL	Stock	55.0825	55.105	55.0825	55.0875	24228.0
2018-08-29 08:00:00	AAPL	Stock	55.0	55.11	54.9875	55.075	155816.0
2018-08-29 08:05:00	AAPL	Stock	55.0675	55.0875	55.0675	55.0875	12912.0
2018-08-29 08:10:00	AAPL	Stock	55.08	55.0875	55.08	55.0875	16112.0
2018-08-29 08:15:00	AAPL	Stock	55.0875	55.0875	55.04	55.04	38040.0
2018-08-29 08:20:00	AAPL	Stock	55.0525	55.0525	55.0	55.0125	53568.0
2018-08-29 08:25:00	AAPL	Stock	55.03	55.045	54.9875	55.0	43876.0
2018-08-29 08:30:00	AAPL	Stock	54.9875	55.0375	54.9675	55.0125	57072.0
2018-08-29 08:35:00	AAPL	Stock	55.0125	55.0125	54.9525	54.9825	38476.0
2018-08-29 08:40:00	AAPL	Stock	54.9625	55.0125	54.9625	55.0125	12096.0
2018-08-29 08:45:00	AAPL	Stock	55.0225	55.0225	55.0225	55.0225	5020.0
2018-08-29 08:50:00	AAPL	Stock	55.005	55.025	55.005	55.005	13512.0
2018-08-29 08:55:00	AAPL	Stock	55.005	55.0225	55.0	55.0225	24900.0
2018-08-29 09:00:00	AAPL	Stock	55.0125	55.045	55.0125	55.045	12672.0
2018-08-29 09:05:00	AAPL	Stock	55.0425	55.0625	55.0425	55.05	52796.0
2018-08-29 09:10:00	AAPL	Stock	55.05	55.0625	55.0425	55.0625	9212.0
2018-08-29 09:15:00	AAPL	Stock	55.0525	55.0525	55.035	55.035	4552.0
2018-08-29 09:20:00	AAPL	Stock	55.0475	55.0475	55.0375	55.0475	11828.0
2018-08-29 09:25:00	AAPL	Stock	55.0475	55.055	55.0125	55.055	31236.0
2018-08-29 09:30:00	AAPL	Stock	55.0625	55.1	54.925	54.9888	3568028.0
2018-08-29 09:35:00	AAPL	Stock	54.99	55.0	54.8525	54.975	1939032.0
2018-08-29 09:40:00	AAPL	Stock	54.975	55.0625	54.9328	55.0288	1875524.0
2018-08-29 09:45:00	AAPL	Stock	55.0375	55.0588	54.9775	55.04	1613064.0

> showing 50 of 349,870 rows — these rows as CSV

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