PREVIEW / etf_5min / 2024-10-23

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-10-23.parquet
  size:    2.4 MB
  rows:    117,637

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-10-23 04:00:00	SPY	ETF	582.9	583.01	582.9	582.98	6801.0
2024-10-23 04:05:00	SPY	ETF	583.08	583.16	583.08	583.13	1097.0
2024-10-23 04:10:00	SPY	ETF	583.1	583.11	583.06	583.06	887.0
2024-10-23 04:15:00	SPY	ETF	583.07	583.23	583.07	583.21	387.0
2024-10-23 04:20:00	SPY	ETF	583.0	583.06	583.0	583.06	417.0
2024-10-23 04:25:00	SPY	ETF	583.05	583.1	583.05	583.06	600.0
2024-10-23 04:30:00	SPY	ETF	583.05	583.06	582.97	582.97	503.0
2024-10-23 04:35:00	SPY	ETF	582.93	582.96	582.89	582.89	647.0
2024-10-23 04:40:00	SPY	ETF	582.82	582.82	582.66	582.66	1549.0
2024-10-23 04:45:00	SPY	ETF	582.66	582.74	582.56	582.56	1772.0
2024-10-23 04:50:00	SPY	ETF	582.51	582.51	582.43	582.43	15202.0
2024-10-23 04:55:00	SPY	ETF	582.5	582.51	582.46	582.46	622.0
2024-10-23 05:00:00	SPY	ETF	582.59	582.68	582.59	582.68	300.0
2024-10-23 05:05:00	SPY	ETF	582.62	582.62	582.62	582.62	100.0
2024-10-23 05:10:00	SPY	ETF	582.61	582.61	582.51	582.51	200.0
2024-10-23 05:15:00	SPY	ETF	582.42	582.78	582.38	582.61	3734.0
2024-10-23 05:20:00	SPY	ETF	582.63	582.72	582.5	582.54	2149.0
2024-10-23 05:25:00	SPY	ETF	582.67	582.71	582.67	582.71	2122.0
2024-10-23 05:30:00	SPY	ETF	582.7	582.7	582.56	582.61	900.0
2024-10-23 05:35:00	SPY	ETF	582.52	582.52	582.52	582.52	100.0
2024-10-23 05:40:00	SPY	ETF	582.4	582.45	582.4	582.45	320.0
2024-10-23 05:45:00	SPY	ETF	582.37	582.43	582.37	582.43	287.0
2024-10-23 05:50:00	SPY	ETF	582.48	582.48	582.48	582.48	167.0
2024-10-23 05:55:00	SPY	ETF	582.59	582.59	582.59	582.59	100.0
2024-10-23 06:00:00	SPY	ETF	582.3	582.3	582.07	582.27	1125.0
2024-10-23 06:05:00	SPY	ETF	582.17	582.17	582.12	582.15	450.0
2024-10-23 06:10:00	SPY	ETF	582.43	582.43	582.37	582.38	850.0
2024-10-23 06:15:00	SPY	ETF	582.18	582.18	582.18	582.18	100.0
2024-10-23 06:25:00	SPY	ETF	582.19	582.19	582.06	582.06	2576.0
2024-10-23 06:30:00	SPY	ETF	582.06	582.12	582.02	582.02	7062.0
2024-10-23 06:35:00	SPY	ETF	582.03	582.03	582.02	582.02	1238.0
2024-10-23 06:40:00	SPY	ETF	582.0	582.04	581.95	581.95	3120.0
2024-10-23 06:45:00	SPY	ETF	581.93	581.96	581.92	581.96	3200.0
2024-10-23 06:50:00	SPY	ETF	581.84	581.89	581.8	581.81	6151.0
2024-10-23 06:55:00	SPY	ETF	581.9	582.01	581.86	581.93	11046.0
2024-10-23 07:00:00	SPY	ETF	581.93	582.21	581.91	582.17	7068.0
2024-10-23 07:05:00	SPY	ETF	582.16	582.25	582.07	582.24	3696.0
2024-10-23 07:10:00	SPY	ETF	582.24	582.24	582.14	582.14	8363.0
2024-10-23 07:15:00	SPY	ETF	582.14	582.34	582.14	582.34	1227.0
2024-10-23 07:20:00	SPY	ETF	582.31	582.31	582.19	582.24	2745.0
2024-10-23 07:25:00	SPY	ETF	582.0	582.05	581.94	582.02	4951.0
2024-10-23 07:30:00	SPY	ETF	581.98	582.09	581.87	582.01	8843.0
2024-10-23 07:35:00	SPY	ETF	582.07	582.09	581.91	582.0	11176.0
2024-10-23 07:40:00	SPY	ETF	581.96	582.01	581.96	582.0	1922.0
2024-10-23 07:45:00	SPY	ETF	581.95	582.2	581.9	582.2	3942.0
2024-10-23 07:50:00	SPY	ETF	582.21	582.25	582.17	582.25	2361.0
2024-10-23 07:55:00	SPY	ETF	582.15	582.15	582.1	582.1	300.0
2024-10-23 08:00:00	SPY	ETF	581.99	583.43	581.85	581.85	46073.0
2024-10-23 08:05:00	SPY	ETF	581.95	582.12	581.87	582.04	6073.0
2024-10-23 08:10:00	SPY	ETF	581.98	582.0	581.89	581.99	1327.0

> showing 50 of 117,637 rows — these rows as CSV

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