PREVIEW / etf_5min / 2023-09-05

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-09-05.parquet
  size:    2.0 MB
  rows:    96,249

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
2023-09-05 04:00:00	SPY	ETF	449.8	449.8	449.49	449.54	6116.0
2023-09-05 04:05:00	SPY	ETF	449.62	449.71	449.47	449.57	2224.0
2023-09-05 04:10:00	SPY	ETF	449.43	449.47	449.14	449.15	3044.0
2023-09-05 04:15:00	SPY	ETF	449.15	449.2	449.11	449.11	835.0
2023-09-05 04:20:00	SPY	ETF	449.11	449.27	449.11	449.15	3368.0
2023-09-05 04:25:00	SPY	ETF	449.23	449.26	449.16	449.21	3166.0
2023-09-05 04:30:00	SPY	ETF	449.15	449.36	449.15	449.36	828.0
2023-09-05 04:35:00	SPY	ETF	449.55	449.56	449.55	449.56	500.0
2023-09-05 04:40:00	SPY	ETF	449.56	449.77	449.56	449.77	4072.0
2023-09-05 04:45:00	SPY	ETF	449.77	449.77	449.75	449.77	671.0
2023-09-05 04:50:00	SPY	ETF	449.8	450.02	449.8	449.99	6857.0
2023-09-05 04:55:00	SPY	ETF	450.0	450.07	449.93	449.93	1939.0
2023-09-05 05:00:00	SPY	ETF	449.94	450.07	449.91	450.07	2550.0
2023-09-05 05:05:00	SPY	ETF	450.01	450.01	450.01	450.01	500.0
2023-09-05 05:10:00	SPY	ETF	450.03	450.18	450.03	450.18	5400.0
2023-09-05 05:15:00	SPY	ETF	450.19	450.24	450.18	450.24	6300.0
2023-09-05 05:20:00	SPY	ETF	450.27	450.27	450.2	450.2	995.0
2023-09-05 05:25:00	SPY	ETF	450.21	450.35	450.18	450.34	20554.0
2023-09-05 05:30:00	SPY	ETF	450.42	450.49	450.36	450.49	8589.0
2023-09-05 05:35:00	SPY	ETF	450.47	450.55	450.47	450.51	7148.0
2023-09-05 05:40:00	SPY	ETF	450.37	450.4	450.31	450.31	4234.0
2023-09-05 05:50:00	SPY	ETF	450.37	450.37	450.37	450.37	1138.0
2023-09-05 05:55:00	SPY	ETF	450.38	450.45	450.36	450.42	2700.0
2023-09-05 06:00:00	SPY	ETF	450.27	450.34	450.27	450.34	4399.0
2023-09-05 06:05:00	SPY	ETF	450.45	450.45	450.26	450.42	2000.0
2023-09-05 06:15:00	SPY	ETF	450.53	450.59	450.53	450.59	598.0
2023-09-05 06:20:00	SPY	ETF	450.58	450.62	450.54	450.58	2003.0
2023-09-05 06:25:00	SPY	ETF	450.61	450.63	450.51	450.6	13901.0
2023-09-05 06:30:00	SPY	ETF	450.61	450.64	450.61	450.64	300.0
2023-09-05 06:40:00	SPY	ETF	450.59	450.59	450.57	450.57	1700.0
2023-09-05 06:45:00	SPY	ETF	450.63	450.63	450.63	450.63	150.0
2023-09-05 06:50:00	SPY	ETF	450.65	450.65	450.6	450.65	5725.0
2023-09-05 06:55:00	SPY	ETF	450.73	450.73	450.42	450.45	2499.0
2023-09-05 07:00:00	SPY	ETF	450.45	450.5	450.23	450.23	10614.0
2023-09-05 07:05:00	SPY	ETF	450.23	450.27	450.09	450.1	13662.0
2023-09-05 07:10:00	SPY	ETF	450.11	450.17	450.07	450.16	8026.0
2023-09-05 07:15:00	SPY	ETF	450.16	450.25	450.15	450.25	4329.0
2023-09-05 07:20:00	SPY	ETF	450.06	450.09	450.01	450.06	7334.0
2023-09-05 07:25:00	SPY	ETF	450.1	450.25	450.1	450.25	2907.0
2023-09-05 07:30:00	SPY	ETF	450.24	450.42	450.24	450.26	5637.0
2023-09-05 07:35:00	SPY	ETF	450.3	450.48	450.3	450.47	2286.0
2023-09-05 07:40:00	SPY	ETF	450.511	450.53	450.5	450.501	10274.0
2023-09-05 07:45:00	SPY	ETF	450.53	450.62	450.53	450.62	6130.0
2023-09-05 07:50:00	SPY	ETF	450.65	450.68	450.64	450.66	6176.0
2023-09-05 07:55:00	SPY	ETF	450.61	450.61	450.47	450.56	23586.0
2023-09-05 08:00:00	SPY	ETF	450.1786	450.7	449.13	450.49	21640.0
2023-09-05 08:05:00	SPY	ETF	450.49	450.6	450.48	450.53	1447.0
2023-09-05 08:10:00	SPY	ETF	450.5	450.53	450.38	450.52	19652.0
2023-09-05 08:15:00	SPY	ETF	450.53	450.53	450.38	450.39	20943.0
2023-09-05 08:20:00	SPY	ETF	450.46	450.47	450.21	450.23	8658.0

> showing 50 of 96,249 rows — these rows as CSV

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