PREVIEW / etf_5min / 2023-07-06

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-06.parquet
  size:    2.0 MB
  rows:    99,091

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-07-06 04:00:00	SPY	ETF	441.5	441.54	441.41	441.41	5326.0
2023-07-06 04:05:00	SPY	ETF	441.43	441.56	441.37	441.53	5901.0
2023-07-06 04:10:00	SPY	ETF	441.5	441.52	441.46	441.49	1155.0
2023-07-06 04:15:00	SPY	ETF	441.48	441.5	441.4	441.5	1570.0
2023-07-06 04:20:00	SPY	ETF	441.46	441.46	441.3	441.3	1343.0
2023-07-06 04:25:00	SPY	ETF	441.3	441.31	441.3	441.31	400.0
2023-07-06 04:30:00	SPY	ETF	441.34	441.37	441.31	441.31	954.0
2023-07-06 04:35:00	SPY	ETF	441.34	441.34	441.24	441.24	500.0
2023-07-06 04:40:00	SPY	ETF	441.33	441.42	441.33	441.41	1780.0
2023-07-06 04:45:00	SPY	ETF	441.61	441.61	441.57	441.57	740.0
2023-07-06 04:50:00	SPY	ETF	441.74	441.74	441.55	441.59	3800.0
2023-07-06 04:55:00	SPY	ETF	441.54	441.56	441.45	441.45	1455.0
2023-07-06 05:00:00	SPY	ETF	441.28	441.34	441.28	441.31	3364.0
2023-07-06 05:05:00	SPY	ETF	441.2	441.27	441.18	441.27	3304.0
2023-07-06 05:10:00	SPY	ETF	441.37	441.38	441.35	441.35	6961.0
2023-07-06 05:15:00	SPY	ETF	441.4	441.4	441.38	441.38	450.0
2023-07-06 05:20:00	SPY	ETF	441.58	441.58	441.47	441.47	707.0
2023-07-06 05:30:00	SPY	ETF	441.5	441.59	441.48	441.59	2004.0
2023-07-06 05:35:00	SPY	ETF	441.59	441.59	441.59	441.59	200.0
2023-07-06 05:40:00	SPY	ETF	441.47	441.47	441.42	441.42	1045.0
2023-07-06 05:45:00	SPY	ETF	441.38	441.53	441.38	441.52	2130.0
2023-07-06 05:50:00	SPY	ETF	441.54	441.55	441.44	441.55	11690.0
2023-07-06 05:55:00	SPY	ETF	441.58	441.58	441.53	441.53	700.0
2023-07-06 06:00:00	SPY	ETF	441.42	441.44	441.42	441.44	225.0
2023-07-06 06:05:00	SPY	ETF	441.48	441.48	441.38	441.41	2650.0
2023-07-06 06:10:00	SPY	ETF	441.35	441.47	441.32	441.41	911.0
2023-07-06 06:15:00	SPY	ETF	441.44	441.47	441.38	441.47	1700.0
2023-07-06 06:20:00	SPY	ETF	441.49	441.53	441.34	441.34	5834.0
2023-07-06 06:25:00	SPY	ETF	441.34	441.54	441.34	441.54	2638.0
2023-07-06 06:30:00	SPY	ETF	441.62	441.62	441.48	441.48	5556.0
2023-07-06 06:35:00	SPY	ETF	441.5	441.6	441.5	441.54	2973.0
2023-07-06 06:40:00	SPY	ETF	441.54	441.64	441.54	441.64	3090.0
2023-07-06 06:45:00	SPY	ETF	441.57	441.57	441.43	441.43	1484.0
2023-07-06 06:50:00	SPY	ETF	441.45	441.47	441.38	441.39	4099.0
2023-07-06 06:55:00	SPY	ETF	441.36	441.38	441.36	441.38	2200.0
2023-07-06 07:00:00	SPY	ETF	441.43	441.559	441.43	441.43	9805.0
2023-07-06 07:05:00	SPY	ETF	441.5	441.55	441.49	441.55	6077.0
2023-07-06 07:10:00	SPY	ETF	441.59	441.709	441.57	441.7	56805.0
2023-07-06 07:15:00	SPY	ETF	441.7	441.72	441.54	441.58	72565.0
2023-07-06 07:20:00	SPY	ETF	441.53	441.62	441.53	441.62	2480.0
2023-07-06 07:25:00	SPY	ETF	441.65	441.75	441.65	441.7	12615.0
2023-07-06 07:30:00	SPY	ETF	441.7	441.7	441.5	441.5	7368.0
2023-07-06 07:35:00	SPY	ETF	441.54	441.56	441.37	441.37	8820.0
2023-07-06 07:40:00	SPY	ETF	441.39	441.39	441.16	441.25	64359.0
2023-07-06 07:45:00	SPY	ETF	441.22	441.33	441.22	441.29	60621.0
2023-07-06 07:50:00	SPY	ETF	441.26	441.34	441.21	441.24	10657.0
2023-07-06 07:55:00	SPY	ETF	441.23	441.27	441.15	441.16	73409.0
2023-07-06 08:00:00	SPY	ETF	441.4695	442.0	440.99	440.99	36638.0
2023-07-06 08:05:00	SPY	ETF	441.0	441.0	440.63	440.68	61741.0
2023-07-06 08:10:00	SPY	ETF	440.69	440.7	440.54	440.7	58038.0

> showing 50 of 99,091 rows — these rows as CSV

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