PREVIEW / etf_1min / 2023-08-02

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-08-02.parquet
  size:    5.0 MB
  rows:    281,075

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-08-02 04:00:00	SPY	ETF	452.78	454.7	452.64	452.69	16106.0
2023-08-02 04:01:00	SPY	ETF	452.66	452.66	452.59	452.63	10800.0
2023-08-02 04:02:00	SPY	ETF	452.58	452.59	452.33	452.35	5531.0
2023-08-02 04:03:00	SPY	ETF	452.29	452.29	452.24	452.28	1115.0
2023-08-02 04:04:00	SPY	ETF	452.28	452.36	452.28	452.31	2464.0
2023-08-02 04:05:00	SPY	ETF	452.32	452.46	452.32	452.44	3173.0
2023-08-02 04:06:00	SPY	ETF	452.45	452.45	452.4	452.4	798.0
2023-08-02 04:07:00	SPY	ETF	452.38	452.38	452.38	452.38	125.0
2023-08-02 04:08:00	SPY	ETF	452.47	452.5	452.4	452.4	8130.0
2023-08-02 04:09:00	SPY	ETF	452.4	452.41	452.3	452.3	8969.0
2023-08-02 04:10:00	SPY	ETF	452.25	452.25	452.22	452.23	2488.0
2023-08-02 04:11:00	SPY	ETF	452.18	452.25	452.18	452.25	397.0
2023-08-02 04:13:00	SPY	ETF	452.28	452.34	452.26	452.34	1603.0
2023-08-02 04:14:00	SPY	ETF	452.3	452.3	452.3	452.3	300.0
2023-08-02 04:15:00	SPY	ETF	452.23	452.28	452.23	452.28	600.0
2023-08-02 04:16:00	SPY	ETF	452.2	452.2	452.15	452.15	730.0
2023-08-02 04:17:00	SPY	ETF	452.08	452.12	452.04	452.06	657.0
2023-08-02 04:18:00	SPY	ETF	452.08	452.08	452.0	452.0	5009.0
2023-08-02 04:19:00	SPY	ETF	451.93	451.97	451.74	451.74	1700.0
2023-08-02 04:20:00	SPY	ETF	451.8	451.81	451.77	451.77	362.0
2023-08-02 04:21:00	SPY	ETF	451.86	451.91	451.86	451.9	709.0
2023-08-02 04:22:00	SPY	ETF	451.92	452.0	451.92	452.0	575.0
2023-08-02 04:23:00	SPY	ETF	452.0	452.0	452.0	452.0	360.0
2023-08-02 04:24:00	SPY	ETF	451.99	452.02	451.99	452.01	1040.0
2023-08-02 04:25:00	SPY	ETF	452.08	452.08	452.08	452.08	109.0
2023-08-02 04:27:00	SPY	ETF	452.06	452.06	452.02	452.02	300.0
2023-08-02 04:28:00	SPY	ETF	452.06	452.08	452.03	452.08	1038.0
2023-08-02 04:29:00	SPY	ETF	452.12	452.12	452.12	452.12	300.0
2023-08-02 04:30:00	SPY	ETF	452.15	452.15	452.05	452.05	1093.0
2023-08-02 04:31:00	SPY	ETF	451.97	451.97	451.97	451.97	300.0
2023-08-02 04:33:00	SPY	ETF	451.91	451.92	451.91	451.92	448.0
2023-08-02 04:36:00	SPY	ETF	451.96	451.96	451.96	451.96	200.0
2023-08-02 04:37:00	SPY	ETF	451.9	451.95	451.9	451.95	1589.0
2023-08-02 04:38:00	SPY	ETF	451.96	451.97	451.96	451.97	1975.0
2023-08-02 04:39:00	SPY	ETF	451.88	451.88	451.88	451.88	198.0
2023-08-02 04:40:00	SPY	ETF	451.88	451.91	451.88	451.91	231.0
2023-08-02 04:42:00	SPY	ETF	451.94	451.94	451.94	451.94	109.0
2023-08-02 04:43:00	SPY	ETF	451.98	452.01	451.98	452.01	700.0
2023-08-02 04:46:00	SPY	ETF	452.1	452.1	452.08	452.1	1209.0
2023-08-02 04:47:00	SPY	ETF	452.09	452.09	451.99	451.99	680.0
2023-08-02 04:48:00	SPY	ETF	451.93	451.98	451.9	451.9	2990.0
2023-08-02 04:49:00	SPY	ETF	451.88	451.88	451.88	451.88	100.0
2023-08-02 04:50:00	SPY	ETF	451.99	451.99	451.99	451.99	291.0
2023-08-02 04:51:00	SPY	ETF	452.01	452.01	452.01	452.01	100.0
2023-08-02 04:53:00	SPY	ETF	452.14	452.21	452.14	452.2	1498.0
2023-08-02 04:54:00	SPY	ETF	452.23	452.23	452.23	452.23	100.0
2023-08-02 04:55:00	SPY	ETF	452.38	452.38	452.38	452.38	400.0
2023-08-02 04:58:00	SPY	ETF	452.49	452.59	452.49	452.59	414.0
2023-08-02 04:59:00	SPY	ETF	452.65	452.74	452.65	452.73	1900.0
2023-08-02 05:00:00	SPY	ETF	452.7	452.7	452.68	452.68	802.0

> showing 50 of 281,075 rows — these rows as CSV

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