PREVIEW / etf_5min / 2024-07-31

all etf 5-min files

  file:    by_date/etf_5min/2024/2024-07-31.parquet
  size:    2.3 MB
  rows:    117,686

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-31 04:00:00	SPY	ETF	544.98	546.95	544.98	546.66	34025.0
2024-07-31 04:05:00	SPY	ETF	546.7	546.7	546.21	546.21	4725.0
2024-07-31 04:10:00	SPY	ETF	546.16	546.3	546.16	546.28	16197.0
2024-07-31 04:15:00	SPY	ETF	546.15	546.45	546.15	546.45	7740.0
2024-07-31 04:20:00	SPY	ETF	546.45	546.8	546.45	546.8	14827.0
2024-07-31 04:25:00	SPY	ETF	546.81	546.95	546.81	546.87	2974.0
2024-07-31 04:30:00	SPY	ETF	546.9	547.23	546.9	547.23	7081.0
2024-07-31 04:35:00	SPY	ETF	547.32	547.45	547.32	547.39	2379.0
2024-07-31 04:40:00	SPY	ETF	547.41	547.45	547.13	547.29	3539.0
2024-07-31 04:45:00	SPY	ETF	547.32	547.35	547.24	547.27	1152.0
2024-07-31 04:50:00	SPY	ETF	547.25	547.25	547.15	547.15	847.0
2024-07-31 04:55:00	SPY	ETF	547.02	547.08	546.95	546.95	3175.0
2024-07-31 05:00:00	SPY	ETF	546.98	547.03	546.75	546.75	2998.0
2024-07-31 05:05:00	SPY	ETF	546.76	546.85	546.76	546.82	300.0
2024-07-31 05:10:00	SPY	ETF	546.85	547.02	546.81	546.91	440.0
2024-07-31 05:15:00	SPY	ETF	546.8	546.93	546.8	546.84	1785.0
2024-07-31 05:20:00	SPY	ETF	546.83	546.83	546.83	546.83	250.0
2024-07-31 05:25:00	SPY	ETF	546.81	546.81	546.8	546.8	451.0
2024-07-31 05:30:00	SPY	ETF	546.98	547.06	546.98	547.06	1105.0
2024-07-31 05:35:00	SPY	ETF	547.24	547.24	547.19	547.23	800.0
2024-07-31 05:40:00	SPY	ETF	547.2	547.2	547.18	547.19	32919.0
2024-07-31 05:45:00	SPY	ETF	547.01	547.01	546.77	546.77	327.0
2024-07-31 05:50:00	SPY	ETF	546.81	546.81	546.81	546.81	100.0
2024-07-31 05:55:00	SPY	ETF	547.01	547.02	546.85	546.92	8471.0
2024-07-31 06:00:00	SPY	ETF	546.91	547.12	546.83	547.12	8494.0
2024-07-31 06:05:00	SPY	ETF	547.25	547.28	547.17	547.21	23799.0
2024-07-31 06:10:00	SPY	ETF	547.2	547.32	547.17	547.23	11489.0
2024-07-31 06:15:00	SPY	ETF	547.25	547.26	547.12	547.19	10050.0
2024-07-31 06:20:00	SPY	ETF	547.2	547.29	547.2	547.29	735.0
2024-07-31 06:25:00	SPY	ETF	547.11	547.24	547.08	547.24	3050.0
2024-07-31 06:30:00	SPY	ETF	547.16	547.2	547.1	547.17	4100.0
2024-07-31 06:35:00	SPY	ETF	547.2	547.2	547.2	547.2	100.0
2024-07-31 06:40:00	SPY	ETF	547.23	547.28	547.2	547.26	928.0
2024-07-31 06:45:00	SPY	ETF	547.17	547.28	547.16	547.25	7305.0
2024-07-31 06:50:00	SPY	ETF	547.19	547.25	547.16	547.24	7782.0
2024-07-31 06:55:00	SPY	ETF	547.29	547.47	547.29	547.47	8110.0
2024-07-31 07:00:00	SPY	ETF	547.4	547.4	546.82	547.0	128453.0
2024-07-31 07:05:00	SPY	ETF	547.01	547.19	547.0	547.0	20147.0
2024-07-31 07:10:00	SPY	ETF	547.05	547.12	546.97	547.03	20765.0
2024-07-31 07:15:00	SPY	ETF	547.021	547.17	546.98	547.09	19884.0
2024-07-31 07:20:00	SPY	ETF	547.08	547.24	547.0	547.21	113908.0
2024-07-31 07:25:00	SPY	ETF	547.18	547.2	547.1	547.1	40177.0
2024-07-31 07:30:00	SPY	ETF	547.09	547.09	546.96	546.98	10562.0
2024-07-31 07:35:00	SPY	ETF	547.0	547.08	546.96	546.96	2611.0
2024-07-31 07:40:00	SPY	ETF	546.96	547.14	546.96	547.14	9389.0
2024-07-31 07:45:00	SPY	ETF	547.18	547.41	547.07	547.4	30863.0
2024-07-31 07:50:00	SPY	ETF	547.47	547.51	547.331	547.38	30289.0
2024-07-31 07:55:00	SPY	ETF	547.42	547.49	547.27	547.29	24974.0
2024-07-31 08:00:00	SPY	ETF	547.07	547.5	543.9	547.33	171955.0
2024-07-31 08:05:00	SPY	ETF	547.3098	547.4	547.27	547.35	15397.0

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

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