PREVIEW / etf_1min / 2023-05-02

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-05-02.parquet
  size:    4.7 MB
  rows:    267,712

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-05-02 04:00:00	SPY	ETF	415.16	415.25	415.16	415.25	1118.0
2023-05-02 04:01:00	SPY	ETF	415.25	415.25	415.25	415.25	100.0
2023-05-02 04:03:00	SPY	ETF	415.14	415.15	415.12	415.14	600.0
2023-05-02 04:06:00	SPY	ETF	415.24	415.24	415.17	415.17	600.0
2023-05-02 04:08:00	SPY	ETF	415.12	415.12	415.12	415.12	400.0
2023-05-02 04:09:00	SPY	ETF	415.28	415.28	415.28	415.28	205.0
2023-05-02 04:10:00	SPY	ETF	415.2	415.2	415.2	415.2	424.0
2023-05-02 04:14:00	SPY	ETF	415.18	415.18	415.18	415.18	200.0
2023-05-02 04:19:00	SPY	ETF	415.21	415.21	415.21	415.21	100.0
2023-05-02 04:22:00	SPY	ETF	415.17	415.18	415.17	415.18	975.0
2023-05-02 04:24:00	SPY	ETF	415.02	415.02	415.0	415.0	1170.0
2023-05-02 04:26:00	SPY	ETF	415.09	415.09	415.09	415.09	809.0
2023-05-02 04:27:00	SPY	ETF	415.1	415.1	415.1	415.1	400.0
2023-05-02 04:29:00	SPY	ETF	415.1	415.1	415.1	415.1	299.0
2023-05-02 04:30:00	SPY	ETF	415.14	415.14	415.14	415.14	1000.0
2023-05-02 04:31:00	SPY	ETF	415.18	415.18	415.17	415.17	600.0
2023-05-02 04:34:00	SPY	ETF	415.15	415.15	415.15	415.15	500.0
2023-05-02 04:35:00	SPY	ETF	415.05	415.05	415.05	415.05	1000.0
2023-05-02 04:36:00	SPY	ETF	415.01	415.01	414.96	414.96	2906.0
2023-05-02 04:39:00	SPY	ETF	415.04	415.1	415.04	415.1	2699.0
2023-05-02 04:40:00	SPY	ETF	415.11	415.11	415.11	415.11	940.0
2023-05-02 04:41:00	SPY	ETF	415.21	415.21	415.21	415.21	300.0
2023-05-02 04:42:00	SPY	ETF	415.2	415.2	415.2	415.2	100.0
2023-05-02 04:46:00	SPY	ETF	415.23	415.25	415.23	415.25	1450.0
2023-05-02 04:50:00	SPY	ETF	415.2	415.2	415.2	415.2	500.0
2023-05-02 04:51:00	SPY	ETF	415.19	415.19	415.19	415.19	100.0
2023-05-02 04:52:00	SPY	ETF	415.15	415.15	415.15	415.15	300.0
2023-05-02 04:53:00	SPY	ETF	415.07	415.09	415.07	415.09	1700.0
2023-05-02 04:54:00	SPY	ETF	415.01	415.01	415.01	415.01	1000.0
2023-05-02 04:56:00	SPY	ETF	415.01	415.01	415.01	415.01	120.0
2023-05-02 04:57:00	SPY	ETF	415.05	415.05	415.05	415.05	1000.0
2023-05-02 05:00:00	SPY	ETF	415.06	415.06	415.06	415.06	300.0
2023-05-02 05:01:00	SPY	ETF	415.08	415.08	415.08	415.08	1436.0
2023-05-02 05:05:00	SPY	ETF	415.11	415.11	415.11	415.11	231.0
2023-05-02 05:07:00	SPY	ETF	414.96	414.96	414.96	414.96	500.0
2023-05-02 05:13:00	SPY	ETF	415.03	415.03	414.91	414.91	200.0
2023-05-02 05:14:00	SPY	ETF	414.91	414.91	414.91	414.91	100.0
2023-05-02 05:15:00	SPY	ETF	414.89	414.92	414.89	414.92	1048.0
2023-05-02 05:20:00	SPY	ETF	415.1	415.1	415.1	415.1	600.0
2023-05-02 05:22:00	SPY	ETF	414.99	414.99	414.99	414.99	380.0
2023-05-02 05:27:00	SPY	ETF	414.98	414.98	414.98	414.98	100.0
2023-05-02 05:28:00	SPY	ETF	415.04	415.05	415.04	415.04	14600.0
2023-05-02 05:29:00	SPY	ETF	415.03	415.03	415.0	415.0	28400.0
2023-05-02 05:30:00	SPY	ETF	415.0	415.0	414.93	414.94	12925.0
2023-05-02 05:31:00	SPY	ETF	414.94	414.94	414.94	414.94	240.0
2023-05-02 05:32:00	SPY	ETF	414.97	414.98	414.97	414.98	760.0
2023-05-02 05:36:00	SPY	ETF	415.02	415.02	415.02	415.02	975.0
2023-05-02 05:37:00	SPY	ETF	415.06	415.12	415.06	415.1	7702.0
2023-05-02 05:39:00	SPY	ETF	415.2	415.28	415.2	415.26	7389.0
2023-05-02 05:41:00	SPY	ETF	415.35	415.38	415.35	415.38	1991.0

> showing 50 of 267,712 rows — these rows as CSV

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