PREVIEW / etf_5min / 2024-07-18

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-07-18.parquet
  size:    2.4 MB
  rows:    116,623

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-07-18 04:00:00	SPY	ETF	558.27	558.32	558.12	558.12	4073.0
2024-07-18 04:05:00	SPY	ETF	558.01	558.18	557.89	558.18	2818.0
2024-07-18 04:10:00	SPY	ETF	558.13	558.13	558.13	558.13	100.0
2024-07-18 04:15:00	SPY	ETF	558.07	558.07	557.96	558.04	336.0
2024-07-18 04:20:00	SPY	ETF	558.11	558.35	558.11	558.35	1950.0
2024-07-18 04:25:00	SPY	ETF	558.24	558.24	558.13	558.13	1510.0
2024-07-18 04:30:00	SPY	ETF	558.26	558.8	558.26	558.8	1661.0
2024-07-18 04:35:00	SPY	ETF	558.62	558.79	558.62	558.79	706.0
2024-07-18 04:40:00	SPY	ETF	558.71	558.84	558.7	558.74	1161.0
2024-07-18 04:45:00	SPY	ETF	558.85	558.85	558.66	558.74	954.0
2024-07-18 04:50:00	SPY	ETF	558.84	558.85	558.76	558.78	918.0
2024-07-18 04:55:00	SPY	ETF	558.82	558.84	558.82	558.84	422.0
2024-07-18 05:00:00	SPY	ETF	558.82	558.82	558.82	558.82	100.0
2024-07-18 05:05:00	SPY	ETF	558.8	558.85	558.8	558.85	513.0
2024-07-18 05:15:00	SPY	ETF	559.0	559.0	558.88	558.88	469.0
2024-07-18 05:20:00	SPY	ETF	558.92	558.94	558.92	558.94	300.0
2024-07-18 05:25:00	SPY	ETF	558.75	558.75	558.75	558.75	124.0
2024-07-18 05:30:00	SPY	ETF	558.5	558.5	558.24	558.24	200.0
2024-07-18 05:35:00	SPY	ETF	558.1	558.2	558.1	558.2	1943.0
2024-07-18 05:40:00	SPY	ETF	558.2	558.2	557.82	557.82	4196.0
2024-07-18 05:45:00	SPY	ETF	557.9	558.09	557.87	557.87	1698.0
2024-07-18 05:50:00	SPY	ETF	558.0	558.09	558.0	558.0	791.0
2024-07-18 05:55:00	SPY	ETF	558.05	558.05	557.93	557.93	1521.0
2024-07-18 06:00:00	SPY	ETF	558.02	558.02	557.5	557.5	1774.0
2024-07-18 06:05:00	SPY	ETF	557.51	557.51	557.51	557.51	300.0
2024-07-18 06:10:00	SPY	ETF	557.41	557.41	557.16	557.29	1676.0
2024-07-18 06:15:00	SPY	ETF	557.43	557.63	557.43	557.63	659.0
2024-07-18 06:20:00	SPY	ETF	557.66	557.68	557.66	557.68	1683.0
2024-07-18 06:25:00	SPY	ETF	557.68	557.68	557.4	557.41	1724.0
2024-07-18 06:30:00	SPY	ETF	557.5	557.5	557.42	557.5	846.0
2024-07-18 06:35:00	SPY	ETF	557.68	557.87	557.67	557.87	23201.0
2024-07-18 06:45:00	SPY	ETF	557.85	557.85	557.77	557.84	11875.0
2024-07-18 06:50:00	SPY	ETF	557.88	557.99	557.88	557.99	490.0
2024-07-18 06:55:00	SPY	ETF	558.05	558.05	557.99	557.99	300.0
2024-07-18 07:00:00	SPY	ETF	557.92	558.0	557.71	558.0	91720.0
2024-07-18 07:05:00	SPY	ETF	558.01	558.01	557.89	557.9	8892.0
2024-07-18 07:10:00	SPY	ETF	557.84	557.9	557.74	557.9	5634.0
2024-07-18 07:15:00	SPY	ETF	557.84	558.01	557.74	557.75	6352.0
2024-07-18 07:20:00	SPY	ETF	557.77	557.92	557.77	557.92	6482.0
2024-07-18 07:25:00	SPY	ETF	557.94	557.94	557.75	557.81	4010.0
2024-07-18 07:30:00	SPY	ETF	557.8	557.85	557.74	557.85	18679.0
2024-07-18 07:35:00	SPY	ETF	557.841	558.06	557.82	558.05	35782.0
2024-07-18 07:40:00	SPY	ETF	558.02	558.15	557.97	558.08	12778.0
2024-07-18 07:45:00	SPY	ETF	558.04	558.17	558.04	558.17	15203.0
2024-07-18 07:50:00	SPY	ETF	558.18	558.2	558.09	558.15	18788.0
2024-07-18 07:55:00	SPY	ETF	558.19	558.289	558.15	558.27	19092.0
2024-07-18 08:00:00	SPY	ETF	557.75	559.35	557.61	558.11	31545.0
2024-07-18 08:05:00	SPY	ETF	558.47	559.5	557.85	557.85	10326.0
2024-07-18 08:10:00	SPY	ETF	557.9596	558.1	557.93	558.1	6711.0
2024-07-18 08:15:00	SPY	ETF	558.08	558.31	557.93	558.31	9535.0

> showing 50 of 116,623 rows — these rows as CSV

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