PREVIEW / stock_5min / 2020-07-20

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-07-20.parquet
  size:    6.6 MB
  rows:    410,911
  symbols: 2,443

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
2020-07-20 04:00:00	AAPL	Stock	95.8	95.8	95.8	95.8	1556.0
2020-07-20 04:25:00	AAPL	Stock	95.75	95.75	95.75	95.75	1600.0
2020-07-20 04:35:00	AAPL	Stock	95.75	95.76	95.75	95.76	1200.0
2020-07-20 04:40:00	AAPL	Stock	95.7975	96.0	95.7975	96.0	9788.0
2020-07-20 04:45:00	AAPL	Stock	96.0975	96.12	96.0375	96.095	7180.0
2020-07-20 05:00:00	AAPL	Stock	96.1975	96.2475	96.1225	96.2475	15064.0
2020-07-20 05:05:00	AAPL	Stock	96.055	96.055	96.055	96.055	424.0
2020-07-20 05:15:00	AAPL	Stock	96.34	96.3775	96.2075	96.2075	2800.0
2020-07-20 05:20:00	AAPL	Stock	96.1925	96.1925	96.1625	96.1625	2476.0
2020-07-20 05:25:00	AAPL	Stock	96.105	96.2375	96.1	96.2375	1936.0
2020-07-20 05:40:00	AAPL	Stock	96.24	96.24	96.24	96.24	608.0
2020-07-20 05:45:00	AAPL	Stock	96.25	96.25	96.25	96.25	400.0
2020-07-20 06:20:00	AAPL	Stock	96.185	96.185	96.185	96.185	400.0
2020-07-20 06:25:00	AAPL	Stock	96.1925	96.1925	96.1925	96.1925	976.0
2020-07-20 06:35:00	AAPL	Stock	96.22	96.22	96.22	96.22	800.0
2020-07-20 07:00:00	AAPL	Stock	96.25	96.3125	96.2125	96.25	21896.0
2020-07-20 07:05:00	AAPL	Stock	96.25	96.3	96.25	96.25	8216.0
2020-07-20 07:10:00	AAPL	Stock	96.25	96.275	96.2125	96.2125	13888.0
2020-07-20 07:15:00	AAPL	Stock	96.2225	96.225	96.2225	96.225	3052.0
2020-07-20 07:20:00	AAPL	Stock	96.335	96.3725	96.33	96.3725	2000.0
2020-07-20 07:25:00	AAPL	Stock	96.33	96.4225	96.33	96.4175	13040.0
2020-07-20 07:30:00	AAPL	Stock	96.405	96.405	96.305	96.33	5780.0
2020-07-20 07:35:00	AAPL	Stock	96.3625	96.3625	96.335	96.335	1200.0
2020-07-20 07:40:00	AAPL	Stock	96.3375	96.3375	96.2525	96.2525	1612.0
2020-07-20 07:45:00	AAPL	Stock	96.2525	96.3	96.2525	96.3	6964.0
2020-07-20 07:50:00	AAPL	Stock	96.45	96.475	96.35	96.35	8348.0
2020-07-20 07:55:00	AAPL	Stock	96.3875	96.41	96.3625	96.38	22496.0
2020-07-20 08:00:00	AAPL	Stock	96.2505	96.4625	96.195	96.38	74204.0
2020-07-20 08:05:00	AAPL	Stock	96.419	96.419	96.25	96.25	29756.0
2020-07-20 08:10:00	AAPL	Stock	96.25	96.35	96.25	96.345	14964.0
2020-07-20 08:15:00	AAPL	Stock	96.34	96.375	96.3	96.375	18764.0
2020-07-20 08:20:00	AAPL	Stock	96.3625	96.425	96.3625	96.425	6732.0
2020-07-20 08:25:00	AAPL	Stock	96.41	96.41	96.34	96.34	14496.0
2020-07-20 08:30:00	AAPL	Stock	96.34	96.4875	96.3375	96.4875	21016.0
2020-07-20 08:35:00	AAPL	Stock	96.4625	96.5225	96.4625	96.5	10896.0
2020-07-20 08:40:00	AAPL	Stock	96.5	96.565	96.4475	96.475	36800.0
2020-07-20 08:45:00	AAPL	Stock	96.49	96.55	96.475	96.55	26080.0
2020-07-20 08:50:00	AAPL	Stock	96.55	96.64	96.55	96.615	23028.0
2020-07-20 08:55:00	AAPL	Stock	96.575	96.615	96.5	96.5	23836.0
2020-07-20 09:00:00	AAPL	Stock	96.48	96.5625	96.48	96.5625	13492.0
2020-07-20 09:05:00	AAPL	Stock	96.5275	96.5998	96.5275	96.5998	18808.0
2020-07-20 09:10:00	AAPL	Stock	96.585	96.6418	96.5575	96.575	38156.0
2020-07-20 09:15:00	AAPL	Stock	96.575	96.575	96.4825	96.5	15556.0
2020-07-20 09:20:00	AAPL	Stock	96.5375	96.5375	96.4825	96.5375	24836.0
2020-07-20 09:25:00	AAPL	Stock	96.5375	96.5375	96.355	96.3975	65768.0
2020-07-20 09:30:00	AAPL	Stock	96.4162	96.5575	96.3	96.405	2575220.0
2020-07-20 09:35:00	AAPL	Stock	96.4	96.48	96.0625	96.3795	1396444.0
2020-07-20 09:40:00	AAPL	Stock	96.3725	96.407	96.0842	96.345	1063660.0
2020-07-20 09:45:00	AAPL	Stock	96.32	96.51	96.2575	96.375	1347632.0
2020-07-20 09:50:00	AAPL	Stock	96.38	96.4175	96.21	96.26	1055372.0

> showing 50 of 410,911 rows — these rows as CSV

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