PREVIEW / etf_5min / 2025-01-27

all etf 5-min files

  file:    by_date/etf_5min/2025/2025-01-27.parquet
  size:    2.9 MB
  rows:    145,261

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-01-27 04:00:00	SPY	ETF	598.78	598.83	595.68	595.9	35201.0
2025-01-27 04:05:00	SPY	ETF	595.89	596.17	595.84	596.01	29676.0
2025-01-27 04:10:00	SPY	ETF	596.16	596.53	595.97	596.0	4598.0
2025-01-27 04:15:00	SPY	ETF	596.29	596.41	595.88	595.89	3271.0
2025-01-27 04:20:00	SPY	ETF	595.98	596.49	595.98	596.4	5220.0
2025-01-27 04:25:00	SPY	ETF	596.45	596.6	596.13	596.13	9716.0
2025-01-27 04:30:00	SPY	ETF	596.05	596.54	595.89	596.2	13205.0
2025-01-27 04:35:00	SPY	ETF	596.2	596.7	596.12	596.67	15118.0
2025-01-27 04:40:00	SPY	ETF	596.73	596.93	596.4	596.42	17769.0
2025-01-27 04:45:00	SPY	ETF	596.42	596.49	595.75	595.75	14775.0
2025-01-27 04:50:00	SPY	ETF	595.92	596.2	595.89	596.13	11444.0
2025-01-27 04:55:00	SPY	ETF	596.03	596.15	595.89	595.9	28651.0
2025-01-27 05:00:00	SPY	ETF	595.95	595.98	594.67	594.67	23108.0
2025-01-27 05:05:00	SPY	ETF	594.79	595.17	594.74	595.15	11021.0
2025-01-27 05:10:00	SPY	ETF	595.12	595.12	594.51	594.51	32427.0
2025-01-27 05:15:00	SPY	ETF	594.41	594.56	593.95	594.11	23580.0
2025-01-27 05:20:00	SPY	ETF	593.95	594.47	593.95	594.24	18897.0
2025-01-27 05:25:00	SPY	ETF	594.3	594.32	593.93	593.93	34970.0
2025-01-27 05:30:00	SPY	ETF	594.1	594.1	593.39	593.39	9973.0
2025-01-27 05:35:00	SPY	ETF	593.38	593.81	593.32	593.62	17533.0
2025-01-27 05:40:00	SPY	ETF	593.61	593.64	593.08	593.1	25675.0
2025-01-27 05:45:00	SPY	ETF	593.12	593.26	592.5	592.5	29208.0
2025-01-27 05:50:00	SPY	ETF	592.63	592.63	589.75	591.96	69044.0
2025-01-27 05:55:00	SPY	ETF	592.04	592.75	592.01	592.25	104807.0
2025-01-27 06:00:00	SPY	ETF	592.25	593.0	592.1	592.5	172258.0
2025-01-27 06:05:00	SPY	ETF	592.68	593.72	592.57	593.49	168298.0
2025-01-27 06:10:00	SPY	ETF	593.39	593.69	592.92	593.69	50198.0
2025-01-27 06:15:00	SPY	ETF	593.69	594.2	593.18	593.18	82934.0
2025-01-27 06:20:00	SPY	ETF	593.29	594.2	593.29	593.46	46109.0
2025-01-27 06:25:00	SPY	ETF	593.42	593.58	592.49	592.97	44770.0
2025-01-27 06:30:00	SPY	ETF	592.89	593.73	592.78	593.73	29145.0
2025-01-27 06:35:00	SPY	ETF	593.76	594.12	593.41	594.0	69562.0
2025-01-27 06:40:00	SPY	ETF	593.98	594.09	593.77	593.81	37478.0
2025-01-27 06:45:00	SPY	ETF	593.79	594.0	593.5	593.91	76840.0
2025-01-27 06:50:00	SPY	ETF	593.92	593.92	593.25	593.65	144145.0
2025-01-27 06:55:00	SPY	ETF	593.65	593.77	593.0	593.23	62014.0
2025-01-27 07:00:00	SPY	ETF	593.24	594.0	593.16	593.5	72122.0
2025-01-27 07:05:00	SPY	ETF	593.51	594.23	593.41	594.21	84963.0
2025-01-27 07:10:00	SPY	ETF	594.26	594.5	594.1	594.47	74678.0
2025-01-27 07:15:00	SPY	ETF	594.46	594.55	594.0	594.06	102293.0
2025-01-27 07:20:00	SPY	ETF	594.0	595.2	593.9	594.58	151217.0
2025-01-27 07:25:00	SPY	ETF	594.51	594.85	594.37	594.6	35423.0
2025-01-27 07:30:00	SPY	ETF	594.48	594.55	594.31	594.41	66923.0
2025-01-27 07:35:00	SPY	ETF	594.44	594.78	594.4	594.62	108513.0
2025-01-27 07:40:00	SPY	ETF	594.55	595.33	594.5	595.33	170007.0
2025-01-27 07:45:00	SPY	ETF	595.24	595.67	595.16	595.36	77821.0
2025-01-27 07:50:00	SPY	ETF	595.4	595.4	594.79	595.12	62581.0
2025-01-27 07:55:00	SPY	ETF	595.17	595.5	594.99	595.05	105510.0
2025-01-27 08:00:00	SPY	ETF	593.69	602.3	592.2104	595.15	194052.0
2025-01-27 08:05:00	SPY	ETF	595.25	595.58	595.15	595.53	68994.0

> showing 50 of 145,261 rows — these rows as CSV

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