PREVIEW / etf_5min / 2024-07-03

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-07-03.parquet
  size:    1.5 MB
  rows:    71,203

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-03 04:00:00	SPY	ETF	548.71	548.79	548.68	548.68	2711.0
2024-07-03 04:05:00	SPY	ETF	548.66	548.79	548.66	548.79	1042.0
2024-07-03 04:10:00	SPY	ETF	548.79	548.83	548.79	548.83	800.0
2024-07-03 04:15:00	SPY	ETF	548.8	548.8	548.8	548.8	798.0
2024-07-03 04:20:00	SPY	ETF	548.97	548.97	548.97	548.97	500.0
2024-07-03 04:25:00	SPY	ETF	548.86	548.86	548.86	548.86	300.0
2024-07-03 04:30:00	SPY	ETF	548.9	548.93	548.9	548.93	431.0
2024-07-03 04:35:00	SPY	ETF	549.0	549.0	549.0	549.0	499.0
2024-07-03 04:40:00	SPY	ETF	549.11	549.29	549.1	549.29	1931.0
2024-07-03 04:45:00	SPY	ETF	549.37	549.39	549.35	549.39	3016.0
2024-07-03 04:50:00	SPY	ETF	549.41	549.41	549.26	549.26	1190.0
2024-07-03 04:55:00	SPY	ETF	549.29	549.29	549.29	549.29	700.0
2024-07-03 05:00:00	SPY	ETF	549.19	549.2	549.19	549.2	724.0
2024-07-03 05:05:00	SPY	ETF	549.18	549.18	549.18	549.18	218.0
2024-07-03 05:10:00	SPY	ETF	549.16	549.16	549.14	549.14	690.0
2024-07-03 05:15:00	SPY	ETF	549.18	549.18	549.18	549.18	280.0
2024-07-03 05:20:00	SPY	ETF	549.23	549.24	549.23	549.24	383.0
2024-07-03 05:25:00	SPY	ETF	549.19	549.19	549.19	549.19	900.0
2024-07-03 05:40:00	SPY	ETF	549.25	549.26	549.2	549.2	964.0
2024-07-03 05:45:00	SPY	ETF	549.32	549.32	549.3	549.3	200.0
2024-07-03 05:50:00	SPY	ETF	549.25	549.25	549.25	549.25	100.0
2024-07-03 05:55:00	SPY	ETF	549.16	549.26	549.15	549.26	6000.0
2024-07-03 06:00:00	SPY	ETF	549.23	549.23	549.22	549.22	1142.0
2024-07-03 06:05:00	SPY	ETF	549.17	549.17	549.09	549.15	1100.0
2024-07-03 06:10:00	SPY	ETF	549.11	549.11	549.11	549.11	100.0
2024-07-03 06:15:00	SPY	ETF	549.26	549.26	549.26	549.26	19909.0
2024-07-03 06:20:00	SPY	ETF	549.19	549.24	549.18	549.24	500.0
2024-07-03 06:25:00	SPY	ETF	549.29	549.32	549.22	549.32	1289.0
2024-07-03 06:30:00	SPY	ETF	549.3	549.31	549.27	549.27	551.0
2024-07-03 06:35:00	SPY	ETF	549.26	549.26	549.22	549.22	398.0
2024-07-03 06:40:00	SPY	ETF	549.29	549.29	549.29	549.29	200.0
2024-07-03 06:45:00	SPY	ETF	549.28	549.31	549.27	549.31	2989.0
2024-07-03 06:50:00	SPY	ETF	549.35	549.36	549.25	549.25	1996.0
2024-07-03 06:55:00	SPY	ETF	549.24	549.24	549.24	549.24	982.0
2024-07-03 07:00:00	SPY	ETF	549.17	549.3	549.15	549.25	7306.0
2024-07-03 07:05:00	SPY	ETF	549.3	549.3	549.3	549.3	945.0
2024-07-03 07:10:00	SPY	ETF	549.22	549.22	549.12	549.14	2062.0
2024-07-03 07:15:00	SPY	ETF	549.1	549.1	549.02	549.02	1500.0
2024-07-03 07:20:00	SPY	ETF	549.14	549.15	549.1	549.14	12460.0
2024-07-03 07:25:00	SPY	ETF	549.13	549.13	549.0	549.0	4903.0
2024-07-03 07:30:00	SPY	ETF	549.07	549.08	548.99	549.01	9091.0
2024-07-03 07:35:00	SPY	ETF	549.09	549.1	548.99	548.99	6825.0
2024-07-03 07:40:00	SPY	ETF	549.0	549.0	548.98	548.99	6175.0
2024-07-03 07:45:00	SPY	ETF	549.03	549.08	548.97	549.01	4747.0
2024-07-03 07:50:00	SPY	ETF	548.99	549.0	548.91	548.93	30092.0
2024-07-03 07:55:00	SPY	ETF	548.94	549.11	548.93	549.1	4975.0
2024-07-03 08:00:00	SPY	ETF	549.24	549.3	548.52	549.0	36017.0
2024-07-03 08:05:00	SPY	ETF	549.12	549.12	548.87	548.87	21778.0
2024-07-03 08:10:00	SPY	ETF	548.86	548.87	548.69	548.84	35832.0
2024-07-03 08:15:00	SPY	ETF	548.91	548.91	548.6	548.69	15809.0

> showing 50 of 71,203 rows — these rows as CSV

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