PREVIEW / etf_5min / 2024-11-04

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-11-04.parquet
  size:    2.5 MB
  rows:    120,476

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
2024-11-04 04:00:00	SPY	ETF	571.87	571.87	571.7	571.72	3083.0
2024-11-04 04:05:00	SPY	ETF	571.69	571.87	571.69	571.87	2667.0
2024-11-04 04:10:00	SPY	ETF	571.76	571.8	571.72	571.72	3654.0
2024-11-04 04:15:00	SPY	ETF	571.65	571.77	571.51	571.77	2758.0
2024-11-04 04:20:00	SPY	ETF	571.72	571.72	571.72	571.72	148.0
2024-11-04 04:25:00	SPY	ETF	571.59	571.65	571.59	571.64	580.0
2024-11-04 04:30:00	SPY	ETF	571.63	571.66	571.43	571.43	1187.0
2024-11-04 04:35:00	SPY	ETF	571.35	571.49	571.35	571.44	2379.0
2024-11-04 04:40:00	SPY	ETF	571.5	571.53	571.44	571.53	2023.0
2024-11-04 04:45:00	SPY	ETF	571.88	571.88	571.88	571.88	100.0
2024-11-04 04:55:00	SPY	ETF	572.0	572.0	572.0	572.0	4829.0
2024-11-04 05:00:00	SPY	ETF	571.94	572.42	571.94	572.3	2400.0
2024-11-04 05:05:00	SPY	ETF	572.3	572.3	572.26	572.26	637.0
2024-11-04 05:10:00	SPY	ETF	572.33	572.33	572.3	572.32	389.0
2024-11-04 05:20:00	SPY	ETF	572.21	572.26	572.21	572.26	345.0
2024-11-04 05:30:00	SPY	ETF	572.45	572.51	572.45	572.51	674.0
2024-11-04 05:35:00	SPY	ETF	572.63	572.8	572.63	572.8	419.0
2024-11-04 05:40:00	SPY	ETF	572.74	572.8	572.74	572.78	465.0
2024-11-04 05:45:00	SPY	ETF	572.7	572.7	572.7	572.7	159.0
2024-11-04 05:50:00	SPY	ETF	572.55	572.55	572.55	572.55	100.0
2024-11-04 05:55:00	SPY	ETF	572.63	572.63	572.63	572.63	371.0
2024-11-04 06:00:00	SPY	ETF	572.73	572.75	572.72	572.72	593.0
2024-11-04 06:05:00	SPY	ETF	572.55	572.55	572.49	572.52	2083.0
2024-11-04 06:10:00	SPY	ETF	572.47	572.47	572.34	572.34	526.0
2024-11-04 06:15:00	SPY	ETF	572.38	572.44	572.38	572.44	239.0
2024-11-04 06:20:00	SPY	ETF	572.35	572.35	572.28	572.28	700.0
2024-11-04 06:25:00	SPY	ETF	572.35	572.35	572.22	572.22	816.0
2024-11-04 06:30:00	SPY	ETF	572.32	572.32	572.27	572.27	1628.0
2024-11-04 06:40:00	SPY	ETF	572.21	572.37	572.21	572.37	1087.0
2024-11-04 06:45:00	SPY	ETF	572.38	572.41	572.37	572.41	3782.0
2024-11-04 06:50:00	SPY	ETF	572.42	572.42	572.42	572.42	100.0
2024-11-04 06:55:00	SPY	ETF	572.24	572.32	572.2	572.32	1500.0
2024-11-04 07:00:00	SPY	ETF	572.33	572.599	572.26	572.29	55635.0
2024-11-04 07:05:00	SPY	ETF	572.2	572.36	572.2	572.2	1053.0
2024-11-04 07:10:00	SPY	ETF	572.28	572.28	572.19	572.21	2372.0
2024-11-04 07:15:00	SPY	ETF	572.26	572.26	572.041	572.041	3431.0
2024-11-04 07:20:00	SPY	ETF	572.08	572.13	572.07	572.13	6829.0
2024-11-04 07:25:00	SPY	ETF	572.12	572.12	571.51	571.55	3053.0
2024-11-04 07:30:00	SPY	ETF	571.61	571.65	571.39	571.54	5283.0
2024-11-04 07:35:00	SPY	ETF	571.49	571.49	571.3	571.3	5970.0
2024-11-04 07:40:00	SPY	ETF	571.15	571.32	571.0	571.23	18177.0
2024-11-04 07:45:00	SPY	ETF	571.32	571.56	571.32	571.54	22166.0
2024-11-04 07:50:00	SPY	ETF	571.61	571.79	571.61	571.68	15147.0
2024-11-04 07:55:00	SPY	ETF	571.72	572.11	571.72	572.0	3455.0
2024-11-04 08:00:00	SPY	ETF	572.5	573.0	571.0599	572.12	50177.0
2024-11-04 08:05:00	SPY	ETF	572.19	572.28	572.1	572.1	3690.0
2024-11-04 08:10:00	SPY	ETF	572.08	572.08	571.65	571.72	4991.0
2024-11-04 08:15:00	SPY	ETF	571.69	571.9	571.55	571.9	6064.0
2024-11-04 08:20:00	SPY	ETF	571.841	571.841	571.69	571.73	1037.0
2024-11-04 08:25:00	SPY	ETF	571.68	571.82	571.65	571.82	4676.0

> showing 50 of 120,476 rows — these rows as CSV

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