PREVIEW / etf_1min / 2024-08-01

all etf 1-min files

  file:    by_date/etf_1min/2024/2024-08-01.parquet
  size:    5.9 MB
  rows:    337,192

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-08-01 04:00:00	SPY	ETF	552.26	552.3	552.15	552.15	608.0
2024-08-01 04:01:00	SPY	ETF	552.35	552.35	552.29	552.29	200.0
2024-08-01 04:02:00	SPY	ETF	552.3	552.3	552.0	552.0	2575.0
2024-08-01 04:03:00	SPY	ETF	551.98	552.06	551.97	552.06	1059.0
2024-08-01 04:04:00	SPY	ETF	552.11	552.18	552.11	552.14	1993.0
2024-08-01 04:05:00	SPY	ETF	552.0	552.06	552.0	552.03	2451.0
2024-08-01 04:07:00	SPY	ETF	552.05	552.05	551.9	551.9	587.0
2024-08-01 04:08:00	SPY	ETF	551.71	551.78	551.5	551.6	2202.0
2024-08-01 04:09:00	SPY	ETF	551.61	551.61	551.61	551.61	154.0
2024-08-01 04:10:00	SPY	ETF	551.4	551.4	551.21	551.21	1443.0
2024-08-01 04:11:00	SPY	ETF	551.15	551.15	550.88	550.91	2191.0
2024-08-01 04:12:00	SPY	ETF	550.85	550.85	550.69	550.84	3556.0
2024-08-01 04:13:00	SPY	ETF	551.07	551.07	551.07	551.07	135.0
2024-08-01 04:14:00	SPY	ETF	551.08	551.08	551.08	551.08	200.0
2024-08-01 04:15:00	SPY	ETF	550.99	551.3	550.95	551.3	766.0
2024-08-01 04:16:00	SPY	ETF	551.29	551.39	551.29	551.39	200.0
2024-08-01 04:17:00	SPY	ETF	551.4	551.51	551.28	551.51	1233.0
2024-08-01 04:18:00	SPY	ETF	551.51	551.51	551.41	551.42	1117.0
2024-08-01 04:19:00	SPY	ETF	551.51	551.51	551.2	551.2	1770.0
2024-08-01 04:20:00	SPY	ETF	551.0	551.06	550.89	550.89	700.0
2024-08-01 04:21:00	SPY	ETF	550.89	550.92	550.78	550.78	1704.0
2024-08-01 04:22:00	SPY	ETF	550.89	550.89	550.73	550.73	452.0
2024-08-01 04:23:00	SPY	ETF	550.86	551.01	550.86	550.98	441.0
2024-08-01 04:24:00	SPY	ETF	551.04	551.2	551.04	551.2	880.0
2024-08-01 04:25:00	SPY	ETF	550.99	551.02	550.99	551.02	314.0
2024-08-01 04:27:00	SPY	ETF	550.9	551.0	550.9	551.0	1513.0
2024-08-01 04:29:00	SPY	ETF	551.3	551.32	551.3	551.32	1300.0
2024-08-01 04:30:00	SPY	ETF	551.26	551.38	551.21	551.21	1165.0
2024-08-01 04:31:00	SPY	ETF	551.03	551.19	551.03	551.19	500.0
2024-08-01 04:33:00	SPY	ETF	551.47	551.47	551.47	551.47	100.0
2024-08-01 04:34:00	SPY	ETF	551.48	551.62	551.48	551.62	700.0
2024-08-01 04:37:00	SPY	ETF	551.26	551.32	551.26	551.32	527.0
2024-08-01 04:38:00	SPY	ETF	551.24	551.24	551.23	551.23	500.0
2024-08-01 04:39:00	SPY	ETF	550.99	551.07	550.99	551.07	2750.0
2024-08-01 04:40:00	SPY	ETF	551.01	551.01	550.85	550.85	2242.0
2024-08-01 04:41:00	SPY	ETF	550.88	550.88	550.69	550.69	679.0
2024-08-01 04:42:00	SPY	ETF	550.67	550.67	550.67	550.67	100.0
2024-08-01 04:44:00	SPY	ETF	551.16	551.16	551.16	551.16	123.0
2024-08-01 04:45:00	SPY	ETF	551.08	551.08	551.08	551.08	100.0
2024-08-01 04:47:00	SPY	ETF	551.05	551.05	551.05	551.05	100.0
2024-08-01 04:49:00	SPY	ETF	551.13	551.13	551.04	551.04	236.0
2024-08-01 04:50:00	SPY	ETF	551.33	551.33	551.2	551.22	1349.0
2024-08-01 04:51:00	SPY	ETF	551.22	551.22	551.04	551.04	3801.0
2024-08-01 04:52:00	SPY	ETF	551.21	551.21	551.16	551.16	375.0
2024-08-01 04:53:00	SPY	ETF	551.0	551.06	551.0	551.06	1100.0
2024-08-01 04:54:00	SPY	ETF	550.99	550.99	550.99	550.99	100.0
2024-08-01 04:55:00	SPY	ETF	550.9	550.9	550.9	550.9	1000.0
2024-08-01 04:57:00	SPY	ETF	551.09	551.09	551.09	551.09	248.0
2024-08-01 05:01:00	SPY	ETF	551.07	551.08	551.07	551.08	450.0
2024-08-01 05:02:00	SPY	ETF	551.0	551.0	551.0	551.0	100.0

> showing 50 of 337,192 rows — these rows as CSV

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