PREVIEW / etf_5min / 2023-07-26

all etf 5-min files

  file:    by_date/etf_5min/2023/2023-07-26.parquet
  size:    2.0 MB
  rows:    97,987

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
2023-07-26 04:00:00	SPY	ETF	455.78	455.78	455.64	455.64	4978.0
2023-07-26 04:05:00	SPY	ETF	455.61	455.7	455.51	455.7	2626.0
2023-07-26 04:10:00	SPY	ETF	455.71	455.71	455.52	455.52	2021.0
2023-07-26 04:15:00	SPY	ETF	455.53	455.76	455.53	455.76	1440.0
2023-07-26 04:20:00	SPY	ETF	455.74	455.74	455.69	455.7	5200.0
2023-07-26 04:25:00	SPY	ETF	455.67	455.75	455.67	455.75	425.0
2023-07-26 04:30:00	SPY	ETF	455.55	455.55	455.37	455.4	4125.0
2023-07-26 04:35:00	SPY	ETF	455.49	455.56	455.43	455.49	15259.0
2023-07-26 04:40:00	SPY	ETF	455.48	455.48	455.44	455.44	700.0
2023-07-26 04:45:00	SPY	ETF	455.43	455.43	455.38	455.38	299.0
2023-07-26 04:50:00	SPY	ETF	455.35	455.35	455.27	455.27	1639.0
2023-07-26 04:55:00	SPY	ETF	455.25	455.25	455.24	455.24	240.0
2023-07-26 05:00:00	SPY	ETF	455.35	455.47	455.35	455.4	1900.0
2023-07-26 05:15:00	SPY	ETF	455.15	455.2	455.15	455.2	1421.0
2023-07-26 05:20:00	SPY	ETF	455.28	455.36	455.28	455.36	700.0
2023-07-26 05:25:00	SPY	ETF	455.31	455.31	455.31	455.31	298.0
2023-07-26 05:30:00	SPY	ETF	455.3	455.3	455.26	455.29	500.0
2023-07-26 05:35:00	SPY	ETF	455.11	455.11	454.9	454.9	1200.0
2023-07-26 05:40:00	SPY	ETF	454.89	455.0	454.88	455.0	1678.0
2023-07-26 05:45:00	SPY	ETF	455.05	455.05	455.03	455.05	1649.0
2023-07-26 05:50:00	SPY	ETF	455.02	455.04	455.02	455.04	200.0
2023-07-26 05:55:00	SPY	ETF	455.1	455.1	455.1	455.1	360.0
2023-07-26 06:00:00	SPY	ETF	455.14	455.14	455.13	455.13	500.0
2023-07-26 06:05:00	SPY	ETF	455.06	455.06	455.01	455.01	4950.0
2023-07-26 06:10:00	SPY	ETF	455.0	455.0	454.77	454.8	3580.0
2023-07-26 06:15:00	SPY	ETF	454.83	454.88	454.83	454.83	775.0
2023-07-26 06:20:00	SPY	ETF	454.8	454.8	454.62	454.62	2200.0
2023-07-26 06:25:00	SPY	ETF	454.6	454.7	454.6	454.7	1000.0
2023-07-26 06:30:00	SPY	ETF	454.73	454.86	454.73	454.85	1670.0
2023-07-26 06:35:00	SPY	ETF	454.85	454.95	454.82	454.82	2374.0
2023-07-26 06:40:00	SPY	ETF	454.83	454.88	454.79	454.88	1884.0
2023-07-26 06:45:00	SPY	ETF	454.87	454.87	454.78	454.78	1990.0
2023-07-26 06:50:00	SPY	ETF	454.75	454.75	454.75	454.75	700.0
2023-07-26 06:55:00	SPY	ETF	454.8	454.8	454.77	454.77	300.0
2023-07-26 07:00:00	SPY	ETF	454.8	454.84	454.69	454.75	9582.0
2023-07-26 07:05:00	SPY	ETF	454.7	454.79	454.7	454.71	2499.0
2023-07-26 07:10:00	SPY	ETF	454.77	454.77	454.75	454.76	2426.0
2023-07-26 07:15:00	SPY	ETF	454.72	454.91	454.72	454.85	10114.0
2023-07-26 07:20:00	SPY	ETF	454.9	455.04	454.9	455.04	8243.0
2023-07-26 07:25:00	SPY	ETF	454.95	454.95	454.82	454.82	21758.0
2023-07-26 07:30:00	SPY	ETF	454.84	454.94	454.84	454.94	11962.0
2023-07-26 07:35:00	SPY	ETF	454.88	454.88	454.7	454.73	8718.0
2023-07-26 07:40:00	SPY	ETF	454.73	454.9	454.73	454.89	2450.0
2023-07-26 07:45:00	SPY	ETF	454.88	455.01	454.88	454.92	15800.0
2023-07-26 07:50:00	SPY	ETF	454.94	455.09	454.94	455.09	3339.0
2023-07-26 07:55:00	SPY	ETF	455.14	455.14	454.91	454.95	8805.0
2023-07-26 08:00:00	SPY	ETF	454.7587	456.1	454.69	454.82	37087.0
2023-07-26 08:05:00	SPY	ETF	454.85	454.85	454.64	454.6801	13517.0
2023-07-26 08:10:00	SPY	ETF	454.71	454.72	454.58	454.71	19069.0
2023-07-26 08:15:00	SPY	ETF	454.71	454.85	454.69	454.71	15911.0

> showing 50 of 97,987 rows — these rows as CSV

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