PREVIEW / etf_1min / 2023-10-26

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-10-26.parquet
  size:    5.1 MB
  rows:    291,598

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-10-26 04:00:00	SPY	ETF	414.88	415.0	414.77	414.77	5546.0
2023-10-26 04:01:00	SPY	ETF	414.76	414.85	414.75	414.85	7098.0
2023-10-26 04:02:00	SPY	ETF	414.89	415.0	414.89	415.0	2000.0
2023-10-26 04:03:00	SPY	ETF	414.92	415.15	414.92	415.15	2034.0
2023-10-26 04:04:00	SPY	ETF	415.13	415.15	415.13	415.15	622.0
2023-10-26 04:05:00	SPY	ETF	415.13	415.13	415.09	415.13	1458.0
2023-10-26 04:06:00	SPY	ETF	415.15	415.26	415.15	415.26	1692.0
2023-10-26 04:07:00	SPY	ETF	415.23	415.23	415.2	415.22	1418.0
2023-10-26 04:08:00	SPY	ETF	415.29	415.32	415.29	415.32	630.0
2023-10-26 04:09:00	SPY	ETF	415.33	415.35	415.33	415.35	777.0
2023-10-26 04:10:00	SPY	ETF	415.37	415.4	415.36	415.36	2450.0
2023-10-26 04:11:00	SPY	ETF	415.43	415.43	415.35	415.4	588.0
2023-10-26 04:12:00	SPY	ETF	415.33	415.33	415.25	415.25	908.0
2023-10-26 04:13:00	SPY	ETF	415.27	415.27	415.27	415.27	209.0
2023-10-26 04:14:00	SPY	ETF	415.39	415.39	415.39	415.39	124.0
2023-10-26 04:15:00	SPY	ETF	415.38	415.38	415.27	415.27	525.0
2023-10-26 04:16:00	SPY	ETF	415.29	415.3	415.29	415.3	825.0
2023-10-26 04:17:00	SPY	ETF	415.25	415.25	415.25	415.25	119.0
2023-10-26 04:18:00	SPY	ETF	415.19	415.29	415.19	415.29	350.0
2023-10-26 04:19:00	SPY	ETF	415.34	415.35	415.33	415.35	737.0
2023-10-26 04:20:00	SPY	ETF	415.34	415.34	415.24	415.24	420.0
2023-10-26 04:21:00	SPY	ETF	415.17	415.17	415.17	415.17	119.0
2023-10-26 04:22:00	SPY	ETF	415.07	415.11	415.07	415.1	460.0
2023-10-26 04:23:00	SPY	ETF	414.98	415.02	414.97	415.02	561.0
2023-10-26 04:25:00	SPY	ETF	414.98	414.99	414.98	414.99	500.0
2023-10-26 04:27:00	SPY	ETF	414.99	414.99	414.99	414.99	100.0
2023-10-26 04:28:00	SPY	ETF	414.92	414.92	414.92	414.92	400.0
2023-10-26 04:29:00	SPY	ETF	414.86	414.86	414.82	414.86	650.0
2023-10-26 04:30:00	SPY	ETF	415.0	415.0	415.0	415.0	100.0
2023-10-26 04:32:00	SPY	ETF	415.0	415.1	415.0	415.1	1000.0
2023-10-26 04:33:00	SPY	ETF	415.2	415.2	415.2	415.2	700.0
2023-10-26 04:34:00	SPY	ETF	415.2	415.24	415.2	415.24	200.0
2023-10-26 04:39:00	SPY	ETF	415.1	415.1	415.1	415.1	900.0
2023-10-26 04:40:00	SPY	ETF	415.05	415.05	415.03	415.03	229.0
2023-10-26 04:41:00	SPY	ETF	415.01	415.01	415.01	415.01	300.0
2023-10-26 04:43:00	SPY	ETF	414.91	414.91	414.91	414.91	100.0
2023-10-26 04:46:00	SPY	ETF	414.94	414.95	414.94	414.95	596.0
2023-10-26 04:47:00	SPY	ETF	414.94	414.94	414.94	414.94	165.0
2023-10-26 04:57:00	SPY	ETF	415.02	415.02	415.02	415.02	100.0
2023-10-26 04:58:00	SPY	ETF	415.06	415.09	415.06	415.09	200.0
2023-10-26 04:59:00	SPY	ETF	415.04	415.04	415.04	415.04	600.0
2023-10-26 05:00:00	SPY	ETF	415.2	415.2	415.12	415.12	600.0
2023-10-26 05:01:00	SPY	ETF	415.12	415.12	415.05	415.05	3850.0
2023-10-26 05:02:00	SPY	ETF	415.03	415.03	415.03	415.03	300.0
2023-10-26 05:05:00	SPY	ETF	415.31	415.31	415.31	415.31	500.0
2023-10-26 05:08:00	SPY	ETF	415.4	415.4	415.4	415.4	450.0
2023-10-26 05:09:00	SPY	ETF	415.4	415.4	415.4	415.4	1650.0
2023-10-26 05:10:00	SPY	ETF	415.36	415.48	415.36	415.48	500.0
2023-10-26 05:14:00	SPY	ETF	415.09	415.09	415.08	415.08	2800.0
2023-10-26 05:15:00	SPY	ETF	415.05	415.05	415.02	415.02	2550.0

> showing 50 of 291,598 rows — these rows as CSV

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