PREVIEW / etf_5min / 2024-06-26

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-06-26.parquet
  size:    2.2 MB
  rows:    107,368

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-06-26 04:00:00	SPY	ETF	546.19	546.45	546.19	546.45	17944.0
2024-06-26 04:05:00	SPY	ETF	546.4	546.41	546.33	546.33	1053.0
2024-06-26 04:10:00	SPY	ETF	546.4	546.4	546.3	546.3	490.0
2024-06-26 04:15:00	SPY	ETF	546.24	546.24	546.24	546.24	250.0
2024-06-26 04:20:00	SPY	ETF	546.26	546.26	546.26	546.26	125.0
2024-06-26 04:25:00	SPY	ETF	546.1	546.19	546.1	546.19	325.0
2024-06-26 04:30:00	SPY	ETF	546.22	546.26	546.18	546.26	1598.0
2024-06-26 04:40:00	SPY	ETF	546.28	546.46	546.28	546.46	402.0
2024-06-26 04:45:00	SPY	ETF	546.47	546.55	546.47	546.55	1416.0
2024-06-26 04:50:00	SPY	ETF	546.38	546.38	546.25	546.25	268.0
2024-06-26 05:00:00	SPY	ETF	546.06	546.07	546.06	546.06	1000.0
2024-06-26 05:05:00	SPY	ETF	546.14	546.17	546.14	546.16	700.0
2024-06-26 05:10:00	SPY	ETF	546.11	546.11	546.01	546.03	783.0
2024-06-26 05:15:00	SPY	ETF	546.07	546.1	546.05	546.1	1086.0
2024-06-26 05:20:00	SPY	ETF	546.04	546.16	546.03	546.16	700.0
2024-06-26 05:25:00	SPY	ETF	546.11	546.11	546.11	546.11	100.0
2024-06-26 05:30:00	SPY	ETF	546.08	546.08	546.06	546.06	400.0
2024-06-26 05:35:00	SPY	ETF	545.98	545.98	545.98	545.98	170.0
2024-06-26 05:45:00	SPY	ETF	545.68	545.83	545.68	545.83	1750.0
2024-06-26 05:50:00	SPY	ETF	545.82	545.82	545.82	545.82	100.0
2024-06-26 05:55:00	SPY	ETF	545.68	545.68	545.68	545.68	500.0
2024-06-26 06:00:00	SPY	ETF	545.55	545.55	545.55	545.55	500.0
2024-06-26 06:05:00	SPY	ETF	545.55	545.61	545.55	545.61	5892.0
2024-06-26 06:10:00	SPY	ETF	545.51	545.54	545.51	545.54	600.0
2024-06-26 06:15:00	SPY	ETF	545.37	545.4	545.27	545.4	1325.0
2024-06-26 06:20:00	SPY	ETF	545.3	545.3	545.25	545.29	627.0
2024-06-26 06:25:00	SPY	ETF	545.29	545.3	545.19	545.2	1742.0
2024-06-26 06:30:00	SPY	ETF	545.2	545.34	545.2	545.34	600.0
2024-06-26 06:35:00	SPY	ETF	545.18	545.18	545.18	545.18	300.0
2024-06-26 06:40:00	SPY	ETF	545.18	545.36	545.18	545.36	1001.0
2024-06-26 06:45:00	SPY	ETF	545.33	545.4	545.33	545.36	585.0
2024-06-26 06:50:00	SPY	ETF	545.35	545.35	545.13	545.13	1999.0
2024-06-26 06:55:00	SPY	ETF	545.25	545.25	545.2	545.2	1017.0
2024-06-26 07:00:00	SPY	ETF	545.08	545.17	545.031	545.031	2697.0
2024-06-26 07:05:00	SPY	ETF	545.0	545.0	544.83	544.89	6805.0
2024-06-26 07:10:00	SPY	ETF	544.97	545.1	544.97	545.1	1760.0
2024-06-26 07:15:00	SPY	ETF	545.1	545.12	544.93	545.0	725.0
2024-06-26 07:20:00	SPY	ETF	545.04	545.07	544.87	544.87	6810.0
2024-06-26 07:25:00	SPY	ETF	544.93	544.93	544.71	544.82	2799.0
2024-06-26 07:30:00	SPY	ETF	544.83	544.83	544.64	544.65	9099.0
2024-06-26 07:35:00	SPY	ETF	544.8	544.83	544.7	544.7	2513.0
2024-06-26 07:40:00	SPY	ETF	544.74	544.74	544.67	544.71	2793.0
2024-06-26 07:45:00	SPY	ETF	544.7	544.86	544.7	544.75	2105.0
2024-06-26 07:50:00	SPY	ETF	544.8	544.8	544.73	544.8	2326.0
2024-06-26 07:55:00	SPY	ETF	544.85	544.99	544.83	544.98	4811.0
2024-06-26 08:00:00	SPY	ETF	545.05	546.01	544.68	544.96	29000.0
2024-06-26 08:05:00	SPY	ETF	544.97	544.97	544.82	544.85	4999.0
2024-06-26 08:10:00	SPY	ETF	544.88	544.88	544.6	544.6	2958.0
2024-06-26 08:15:00	SPY	ETF	544.6194	544.71	544.5	544.71	7308.0
2024-06-26 08:20:00	SPY	ETF	544.65	544.7	544.59	544.67	6895.0

> showing 50 of 107,368 rows — these rows as CSV

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