PREVIEW / etf_5min / 2025-09-19

all etf 5-min files

  file:    by_date/etf_5min/2025/2025-09-19.parquet
  size:    2.9 MB
  rows:    146,276

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-09-19 04:00:00	SPY	ETF	660.5	661.1	660.38	660.51	5570.0
2025-09-19 04:05:00	SPY	ETF	660.59	660.79	660.59	660.79	4690.0
2025-09-19 04:10:00	SPY	ETF	660.84	660.91	660.83	660.91	1119.0
2025-09-19 04:15:00	SPY	ETF	660.82	660.98	660.82	660.97	1265.0
2025-09-19 04:20:00	SPY	ETF	660.98	661.05	660.97	660.98	2550.0
2025-09-19 04:25:00	SPY	ETF	660.98	660.98	660.89	660.95	3945.0
2025-09-19 04:30:00	SPY	ETF	661.02	661.09	661.02	661.07	1709.0
2025-09-19 04:35:00	SPY	ETF	661.11	661.11	661.11	661.11	200.0
2025-09-19 04:40:00	SPY	ETF	661.09	661.09	660.9	660.9	3424.0
2025-09-19 04:45:00	SPY	ETF	660.95	660.98	660.93	660.95	900.0
2025-09-19 04:50:00	SPY	ETF	660.87	661.02	660.87	660.91	2088.0
2025-09-19 04:55:00	SPY	ETF	660.84	660.97	660.84	660.97	980.0
2025-09-19 05:00:00	SPY	ETF	660.95	660.97	660.95	660.97	300.0
2025-09-19 05:05:00	SPY	ETF	661.01	661.09	661.01	661.09	1029.0
2025-09-19 05:10:00	SPY	ETF	661.01	661.01	660.89	660.89	600.0
2025-09-19 05:15:00	SPY	ETF	660.9	660.9	660.9	660.9	100.0
2025-09-19 05:25:00	SPY	ETF	661.22	661.24	661.16	661.16	1300.0
2025-09-19 05:30:00	SPY	ETF	661.16	661.39	661.16	661.34	2521.0
2025-09-19 05:35:00	SPY	ETF	661.34	661.39	661.34	661.39	200.0
2025-09-19 05:40:00	SPY	ETF	661.36	661.4	661.3	661.3	1190.0
2025-09-19 05:45:00	SPY	ETF	661.31	661.36	661.24	661.32	700.0
2025-09-19 05:50:00	SPY	ETF	661.22	661.22	660.92	661.0	2371.0
2025-09-19 05:55:00	SPY	ETF	661.0	661.07	660.97	661.06	1400.0
2025-09-19 06:00:00	SPY	ETF	660.88	660.97	660.81	660.97	3091.0
2025-09-19 06:05:00	SPY	ETF	660.96	660.99	660.96	660.99	300.0
2025-09-19 06:10:00	SPY	ETF	661.06	661.1	660.97	660.98	1100.0
2025-09-19 06:15:00	SPY	ETF	661.08	661.3	661.08	661.3	3100.0
2025-09-19 06:20:00	SPY	ETF	661.1	661.1	661.0	661.0	1824.0
2025-09-19 06:25:00	SPY	ETF	661.04	661.19	661.04	661.19	5193.0
2025-09-19 06:30:00	SPY	ETF	661.15	661.18	661.11	661.11	6922.0
2025-09-19 06:35:00	SPY	ETF	661.14	661.33	661.1	661.32	11147.0
2025-09-19 06:40:00	SPY	ETF	661.32	661.4	661.31	661.31	6574.0
2025-09-19 06:45:00	SPY	ETF	661.32	661.32	661.17	661.17	2302.0
2025-09-19 06:50:00	SPY	ETF	661.13	661.2	661.11	661.13	2081.0
2025-09-19 06:55:00	SPY	ETF	661.12	661.39	661.01	661.39	5520.0
2025-09-19 07:00:00	SPY	ETF	661.38	661.66	661.38	661.44	9175.0
2025-09-19 07:05:00	SPY	ETF	661.49	661.52	661.35	661.43	2515.0
2025-09-19 07:10:00	SPY	ETF	661.43	661.43	661.12	661.2	20830.0
2025-09-19 07:15:00	SPY	ETF	661.22	661.33	661.21	661.33	1531.0
2025-09-19 07:20:00	SPY	ETF	661.3	661.36	661.24	661.36	5547.0
2025-09-19 07:25:00	SPY	ETF	661.3	661.5	661.28	661.47	8647.0
2025-09-19 07:30:00	SPY	ETF	661.4	661.46	661.33	661.46	7547.0
2025-09-19 07:35:00	SPY	ETF	661.49	661.55	661.46	661.54	10217.0
2025-09-19 07:40:00	SPY	ETF	661.56	661.56	661.38	661.38	14749.0
2025-09-19 07:45:00	SPY	ETF	661.32	661.47	661.3	661.4	16542.0
2025-09-19 07:50:00	SPY	ETF	661.51	661.65	661.5	661.63	9174.0
2025-09-19 07:55:00	SPY	ETF	661.63	661.63	661.55	661.61	11630.0
2025-09-19 08:00:00	SPY	ETF	661.57	661.84	659.62	661.82	68479.0
2025-09-19 08:05:00	SPY	ETF	661.82	661.9	661.7083	661.7083	10259.0
2025-09-19 08:10:00	SPY	ETF	661.74	661.81	661.73	661.77	20632.0

> showing 50 of 146,276 rows — these rows as CSV

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