PREVIEW / etf_1min / 2024-07-26

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-07-26.parquet
  size:    5.1 MB
  rows:    292,725

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-26 04:00:00	SPY	ETF	541.5	541.88	541.5	541.85	939.0
2024-07-26 04:01:00	SPY	ETF	541.81	541.81	541.81	541.81	100.0
2024-07-26 04:02:00	SPY	ETF	541.94	541.94	541.94	541.94	900.0
2024-07-26 04:05:00	SPY	ETF	541.73	541.89	541.73	541.82	2208.0
2024-07-26 04:06:00	SPY	ETF	541.81	541.81	541.8	541.8	677.0
2024-07-26 04:07:00	SPY	ETF	541.9	542.06	541.9	542.05	3400.0
2024-07-26 04:08:00	SPY	ETF	542.03	542.14	542.03	542.12	417.0
2024-07-26 04:10:00	SPY	ETF	542.06	542.06	542.06	542.06	1500.0
2024-07-26 04:11:00	SPY	ETF	542.18	542.18	542.18	542.18	100.0
2024-07-26 04:12:00	SPY	ETF	542.22	542.35	542.22	542.35	850.0
2024-07-26 04:18:00	SPY	ETF	542.49	542.49	542.49	542.49	702.0
2024-07-26 04:19:00	SPY	ETF	542.42	542.42	542.38	542.38	820.0
2024-07-26 04:21:00	SPY	ETF	542.23	542.23	542.2	542.2	464.0
2024-07-26 04:22:00	SPY	ETF	542.16	542.17	542.16	542.17	797.0
2024-07-26 04:23:00	SPY	ETF	542.12	542.12	542.12	542.12	500.0
2024-07-26 04:24:00	SPY	ETF	542.31	542.31	542.24	542.24	1460.0
2024-07-26 04:27:00	SPY	ETF	542.31	542.31	542.31	542.31	157.0
2024-07-26 04:29:00	SPY	ETF	542.41	542.41	542.32	542.32	1227.0
2024-07-26 04:30:00	SPY	ETF	542.41	542.41	542.4	542.4	292.0
2024-07-26 04:31:00	SPY	ETF	542.44	542.44	542.44	542.44	100.0
2024-07-26 04:32:00	SPY	ETF	542.5	542.5	542.5	542.5	100.0
2024-07-26 04:33:00	SPY	ETF	542.52	542.52	542.3	542.3	578.0
2024-07-26 04:34:00	SPY	ETF	542.3	542.3	542.25	542.25	243.0
2024-07-26 04:36:00	SPY	ETF	542.42	542.42	542.42	542.42	292.0
2024-07-26 04:39:00	SPY	ETF	542.29	542.29	542.29	542.29	248.0
2024-07-26 04:42:00	SPY	ETF	542.49	542.49	542.49	542.49	100.0
2024-07-26 04:43:00	SPY	ETF	542.48	542.54	542.48	542.54	215.0
2024-07-26 04:45:00	SPY	ETF	542.5	542.5	542.5	542.5	100.0
2024-07-26 04:48:00	SPY	ETF	542.54	542.54	542.5	542.5	1417.0
2024-07-26 04:52:00	SPY	ETF	542.52	542.53	542.52	542.53	451.0
2024-07-26 04:54:00	SPY	ETF	542.61	542.61	542.61	542.61	103.0
2024-07-26 04:58:00	SPY	ETF	543.0	543.09	543.0	543.09	10188.0
2024-07-26 04:59:00	SPY	ETF	543.11	543.15	543.1	543.15	21736.0
2024-07-26 05:00:00	SPY	ETF	543.09	543.09	543.09	543.09	1250.0
2024-07-26 05:01:00	SPY	ETF	542.96	542.96	542.95	542.95	900.0
2024-07-26 05:03:00	SPY	ETF	542.9	542.9	542.8	542.8	10092.0
2024-07-26 05:04:00	SPY	ETF	542.82	542.82	542.82	542.82	100.0
2024-07-26 05:06:00	SPY	ETF	542.66	542.66	542.66	542.66	209.0
2024-07-26 05:07:00	SPY	ETF	542.71	542.79	542.71	542.79	1296.0
2024-07-26 05:08:00	SPY	ETF	542.75	542.75	542.75	542.75	100.0
2024-07-26 05:09:00	SPY	ETF	542.71	542.73	542.71	542.73	400.0
2024-07-26 05:10:00	SPY	ETF	542.72	542.72	542.72	542.72	500.0
2024-07-26 05:11:00	SPY	ETF	542.73	542.75	542.73	542.75	300.0
2024-07-26 05:13:00	SPY	ETF	542.8	542.8	542.79	542.79	400.0
2024-07-26 05:14:00	SPY	ETF	543.0	543.1	543.0	543.1	1100.0
2024-07-26 05:15:00	SPY	ETF	542.99	543.1	542.99	543.07	964.0
2024-07-26 05:17:00	SPY	ETF	543.07	543.07	543.07	543.07	300.0
2024-07-26 05:18:00	SPY	ETF	543.07	543.07	543.07	543.07	600.0
2024-07-26 05:19:00	SPY	ETF	542.94	542.94	542.94	542.94	950.0
2024-07-26 05:20:00	SPY	ETF	542.86	542.86	542.86	542.86	120.0

> showing 50 of 292,725 rows — these rows as CSV

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