PREVIEW / etf_1min / 2024-06-05

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-06-05.parquet
  size:    5.1 MB
  rows:    289,200

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-05 04:00:00	SPY	ETF	528.91	528.91	528.91	528.91	501.0
2024-06-05 04:02:00	SPY	ETF	529.07	529.07	529.07	529.07	100.0
2024-06-05 04:03:00	SPY	ETF	529.18	529.18	529.16	529.16	520.0
2024-06-05 04:05:00	SPY	ETF	529.08	529.11	529.08	529.11	898.0
2024-06-05 04:06:00	SPY	ETF	528.99	528.99	528.95	528.95	200.0
2024-06-05 04:07:00	SPY	ETF	529.0	529.0	529.0	529.0	200.0
2024-06-05 04:10:00	SPY	ETF	529.05	529.05	529.05	529.05	248.0
2024-06-05 04:11:00	SPY	ETF	529.09	529.09	529.05	529.05	447.0
2024-06-05 04:16:00	SPY	ETF	529.07	529.07	529.07	529.07	100.0
2024-06-05 04:17:00	SPY	ETF	529.0	529.0	529.0	529.0	100.0
2024-06-05 04:18:00	SPY	ETF	528.82	528.85	528.81	528.85	1000.0
2024-06-05 04:19:00	SPY	ETF	528.84	528.84	528.84	528.84	200.0
2024-06-05 04:22:00	SPY	ETF	528.75	528.75	528.75	528.75	190.0
2024-06-05 04:28:00	SPY	ETF	528.84	528.84	528.84	528.84	100.0
2024-06-05 04:31:00	SPY	ETF	528.99	528.99	528.99	528.99	100.0
2024-06-05 04:32:00	SPY	ETF	528.99	528.99	528.99	528.99	400.0
2024-06-05 04:34:00	SPY	ETF	529.07	529.07	529.07	529.07	100.0
2024-06-05 04:37:00	SPY	ETF	529.04	529.05	529.04	529.04	1428.0
2024-06-05 04:41:00	SPY	ETF	529.13	529.13	529.13	529.13	100.0
2024-06-05 04:44:00	SPY	ETF	529.15	529.15	529.15	529.15	1034.0
2024-06-05 04:46:00	SPY	ETF	529.18	529.18	529.18	529.18	200.0
2024-06-05 04:49:00	SPY	ETF	529.14	529.18	529.14	529.18	300.0
2024-06-05 04:51:00	SPY	ETF	529.19	529.19	529.17	529.17	6187.0
2024-06-05 04:54:00	SPY	ETF	529.19	529.19	529.19	529.19	200.0
2024-06-05 04:59:00	SPY	ETF	529.15	529.15	529.15	529.15	220.0
2024-06-05 05:01:00	SPY	ETF	529.2	529.2	529.2	529.2	100.0
2024-06-05 05:02:00	SPY	ETF	529.19	529.19	529.18	529.19	2300.0
2024-06-05 05:05:00	SPY	ETF	529.24	529.24	529.24	529.24	100.0
2024-06-05 05:06:00	SPY	ETF	529.26	529.27	529.25	529.26	6222.0
2024-06-05 05:07:00	SPY	ETF	529.29	529.29	529.29	529.29	100.0
2024-06-05 05:08:00	SPY	ETF	529.23	529.23	529.23	529.23	170.0
2024-06-05 05:09:00	SPY	ETF	529.32	529.32	529.32	529.32	200.0
2024-06-05 05:13:00	SPY	ETF	529.33	529.33	529.33	529.33	120.0
2024-06-05 05:14:00	SPY	ETF	529.28	529.3	529.28	529.3	15000.0
2024-06-05 05:15:00	SPY	ETF	529.24	529.24	529.24	529.24	200.0
2024-06-05 05:16:00	SPY	ETF	529.23	529.23	529.17	529.17	600.0
2024-06-05 05:18:00	SPY	ETF	529.23	529.23	529.23	529.23	100.0
2024-06-05 05:20:00	SPY	ETF	529.34	529.34	529.34	529.34	100.0
2024-06-05 05:21:00	SPY	ETF	529.36	529.36	529.32	529.32	200.0
2024-06-05 05:22:00	SPY	ETF	529.32	529.32	529.27	529.27	200.0
2024-06-05 05:28:00	SPY	ETF	529.25	529.25	529.25	529.25	100.0
2024-06-05 05:32:00	SPY	ETF	529.27	529.27	529.25	529.25	215.0
2024-06-05 05:37:00	SPY	ETF	529.25	529.28	529.25	529.28	1600.0
2024-06-05 05:40:00	SPY	ETF	529.29	529.29	529.29	529.29	100.0
2024-06-05 05:41:00	SPY	ETF	529.27	529.31	529.27	529.31	400.0
2024-06-05 05:42:00	SPY	ETF	529.3	529.3	529.3	529.3	188.0
2024-06-05 05:44:00	SPY	ETF	529.3	529.31	529.3	529.31	200.0
2024-06-05 05:45:00	SPY	ETF	529.32	529.32	529.32	529.32	100.0
2024-06-05 05:49:00	SPY	ETF	529.48	529.5	529.48	529.5	487.0
2024-06-05 05:50:00	SPY	ETF	529.56	529.56	529.56	529.56	100.0

> showing 50 of 289,200 rows — these rows as CSV

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