PREVIEW / etf_5min / 2025-07-24

all etf 5-min files

  file:    by_date/etf_5min/2025/2025-07-24.parquet
  size:    2.8 MB
  rows:    139,684

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
2025-07-24 04:00:00	SPY	ETF	633.95	634.1	633.91	634.0	5525.0
2025-07-24 04:05:00	SPY	ETF	633.95	633.99	633.8	633.99	2000.0
2025-07-24 04:10:00	SPY	ETF	634.03	634.29	634.03	634.28	2260.0
2025-07-24 04:15:00	SPY	ETF	634.3	634.33	634.26	634.32	700.0
2025-07-24 04:20:00	SPY	ETF	634.28	634.37	634.23	634.36	1600.0
2025-07-24 04:25:00	SPY	ETF	634.4	634.48	634.4	634.48	930.0
2025-07-24 04:30:00	SPY	ETF	634.45	634.59	634.45	634.59	800.0
2025-07-24 04:35:00	SPY	ETF	634.51	634.54	634.49	634.49	3767.0
2025-07-24 04:40:00	SPY	ETF	634.48	634.48	634.33	634.35	2215.0
2025-07-24 04:45:00	SPY	ETF	634.41	634.43	634.41	634.43	316.0
2025-07-24 04:50:00	SPY	ETF	634.45	634.57	634.45	634.57	1090.0
2025-07-24 04:55:00	SPY	ETF	634.48	634.49	634.48	634.49	956.0
2025-07-24 05:00:00	SPY	ETF	634.45	634.46	634.38	634.46	3400.0
2025-07-24 05:05:00	SPY	ETF	634.47	634.54	634.47	634.54	500.0
2025-07-24 05:10:00	SPY	ETF	634.48	634.48	634.46	634.46	900.0
2025-07-24 05:15:00	SPY	ETF	634.49	634.49	634.44	634.48	800.0
2025-07-24 05:20:00	SPY	ETF	634.47	634.47	634.42	634.43	1400.0
2025-07-24 05:25:00	SPY	ETF	634.47	634.56	634.47	634.56	800.0
2025-07-24 05:30:00	SPY	ETF	634.71	634.73	634.71	634.73	579.0
2025-07-24 05:35:00	SPY	ETF	634.69	634.69	634.69	634.69	100.0
2025-07-24 05:40:00	SPY	ETF	634.6	634.6	634.6	634.6	100.0
2025-07-24 05:45:00	SPY	ETF	634.62	634.63	634.62	634.63	200.0
2025-07-24 05:50:00	SPY	ETF	634.73	634.77	634.73	634.76	1100.0
2025-07-24 05:55:00	SPY	ETF	634.8	634.81	634.8	634.81	300.0
2025-07-24 06:00:00	SPY	ETF	634.73	634.83	634.54	634.65	3955.0
2025-07-24 06:05:00	SPY	ETF	634.61	634.66	634.61	634.63	300.0
2025-07-24 06:10:00	SPY	ETF	634.51	634.51	634.48	634.48	800.0
2025-07-24 06:15:00	SPY	ETF	634.47	634.47	634.44	634.44	250.0
2025-07-24 06:20:00	SPY	ETF	634.27	634.27	634.18	634.18	1200.0
2025-07-24 06:25:00	SPY	ETF	634.21	634.21	634.15	634.19	1100.0
2025-07-24 06:30:00	SPY	ETF	634.23	634.23	634.0	634.08	3325.0
2025-07-24 06:35:00	SPY	ETF	634.07	634.07	634.07	634.07	100.0
2025-07-24 06:40:00	SPY	ETF	634.24	634.26	634.24	634.26	300.0
2025-07-24 06:45:00	SPY	ETF	634.15	634.16	634.13	634.14	1267.0
2025-07-24 06:50:00	SPY	ETF	634.18	634.28	634.18	634.28	310.0
2025-07-24 06:55:00	SPY	ETF	634.19	634.26	634.19	634.24	300.0
2025-07-24 07:00:00	SPY	ETF	634.28	634.35	634.2	634.3	11790.0
2025-07-24 07:05:00	SPY	ETF	634.29	634.379	634.29	634.35	14676.0
2025-07-24 07:10:00	SPY	ETF	634.34	634.42	634.34	634.4	5595.0
2025-07-24 07:15:00	SPY	ETF	634.5	634.5	634.43	634.45	1138.0
2025-07-24 07:20:00	SPY	ETF	634.49	634.52	634.49	634.52	2038.0
2025-07-24 07:25:00	SPY	ETF	634.56	634.75	634.56	634.68	2031.0
2025-07-24 07:30:00	SPY	ETF	634.66	634.78	634.64	634.75	11904.0
2025-07-24 07:35:00	SPY	ETF	634.8	634.829	634.74	634.79	4176.0
2025-07-24 07:40:00	SPY	ETF	634.76	635.02	634.76	634.84	17060.0
2025-07-24 07:45:00	SPY	ETF	634.84	634.86	634.8	634.8	1840.0
2025-07-24 07:50:00	SPY	ETF	634.72	634.78	634.69	634.69	2580.0
2025-07-24 07:55:00	SPY	ETF	634.67	634.79	634.66	634.79	4402.0
2025-07-24 08:00:00	SPY	ETF	634.31	635.01	633.85	634.64	100890.0
2025-07-24 08:05:00	SPY	ETF	634.66	634.8	634.66	634.75	38558.0

> showing 50 of 139,684 rows — these rows as CSV

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