PREVIEW / etf_1min / 2023-10-02

all etf 1-min files

  file:    by_date/etf_1min/2023/2023-10-02.parquet
  size:    4.9 MB
  rows:    281,621

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-02 04:00:00	SPY	ETF	429.0	429.82	429.0	429.82	1125.0
2023-10-02 04:01:00	SPY	ETF	429.97	430.0	429.97	430.0	1108.0
2023-10-02 04:02:00	SPY	ETF	430.01	430.01	429.85	429.85	1300.0
2023-10-02 04:03:00	SPY	ETF	429.81	429.85	429.81	429.85	2841.0
2023-10-02 04:04:00	SPY	ETF	429.96	430.13	429.96	430.13	4051.0
2023-10-02 04:05:00	SPY	ETF	430.16	430.18	430.1	430.18	9104.0
2023-10-02 04:06:00	SPY	ETF	430.08	430.08	430.0	430.0	425.0
2023-10-02 04:07:00	SPY	ETF	429.83	429.83	429.78	429.78	1851.0
2023-10-02 04:08:00	SPY	ETF	429.92	429.97	429.92	429.97	1049.0
2023-10-02 04:10:00	SPY	ETF	429.77	429.77	429.77	429.77	136.0
2023-10-02 04:13:00	SPY	ETF	429.75	429.77	429.75	429.77	500.0
2023-10-02 04:14:00	SPY	ETF	429.87	429.87	429.79	429.79	324.0
2023-10-02 04:15:00	SPY	ETF	429.66	429.66	429.61	429.61	1427.0
2023-10-02 04:16:00	SPY	ETF	429.52	429.52	429.52	429.52	100.0
2023-10-02 04:19:00	SPY	ETF	429.64	429.64	429.64	429.64	100.0
2023-10-02 04:20:00	SPY	ETF	429.55	429.55	429.55	429.55	100.0
2023-10-02 04:26:00	SPY	ETF	429.79	429.79	429.79	429.79	300.0
2023-10-02 04:33:00	SPY	ETF	429.7	429.7	429.7	429.7	384.0
2023-10-02 04:34:00	SPY	ETF	429.76	429.76	429.76	429.76	100.0
2023-10-02 04:35:00	SPY	ETF	429.8	429.8	429.8	429.8	107.0
2023-10-02 04:36:00	SPY	ETF	429.85	429.85	429.84	429.84	800.0
2023-10-02 04:37:00	SPY	ETF	429.83	429.83	429.83	429.83	100.0
2023-10-02 04:38:00	SPY	ETF	429.97	430.0	429.97	430.0	2100.0
2023-10-02 04:40:00	SPY	ETF	429.92	429.92	429.92	429.92	100.0
2023-10-02 04:43:00	SPY	ETF	430.04	430.05	430.04	430.05	200.0
2023-10-02 04:44:00	SPY	ETF	429.95	429.95	429.95	429.95	133.0
2023-10-02 04:48:00	SPY	ETF	429.93	429.93	429.93	429.93	141.0
2023-10-02 04:50:00	SPY	ETF	429.82	429.82	429.82	429.82	350.0
2023-10-02 04:51:00	SPY	ETF	429.81	429.81	429.81	429.81	105.0
2023-10-02 04:52:00	SPY	ETF	429.75	429.75	429.75	429.75	400.0
2023-10-02 04:53:00	SPY	ETF	429.65	429.66	429.61	429.61	400.0
2023-10-02 04:56:00	SPY	ETF	429.59	429.59	429.59	429.59	500.0
2023-10-02 04:57:00	SPY	ETF	429.55	429.55	429.55	429.55	113.0
2023-10-02 04:58:00	SPY	ETF	429.52	429.52	429.49	429.49	600.0
2023-10-02 04:59:00	SPY	ETF	429.5	429.5	429.5	429.5	100.0
2023-10-02 05:00:00	SPY	ETF	429.42	429.42	429.42	429.42	104.0
2023-10-02 05:03:00	SPY	ETF	429.3	429.3	429.25	429.25	1195.0
2023-10-02 05:05:00	SPY	ETF	429.03	429.03	429.0	429.0	710.0
2023-10-02 05:06:00	SPY	ETF	428.96	428.96	428.96	428.96	450.0
2023-10-02 05:07:00	SPY	ETF	428.96	428.96	428.92	428.92	200.0
2023-10-02 05:08:00	SPY	ETF	428.94	428.94	428.94	428.94	100.0
2023-10-02 05:09:00	SPY	ETF	429.0	429.0	428.98	428.98	300.0
2023-10-02 05:12:00	SPY	ETF	429.11	429.11	429.11	429.11	200.0
2023-10-02 05:14:00	SPY	ETF	429.19	429.5	429.15	429.15	10414.0
2023-10-02 05:15:00	SPY	ETF	429.12	429.5	429.08	429.1	11597.0
2023-10-02 05:17:00	SPY	ETF	429.07	429.1	429.07	429.1	226.0
2023-10-02 05:18:00	SPY	ETF	428.9	428.9	428.9	428.9	249.0
2023-10-02 05:20:00	SPY	ETF	429.05	429.05	429.05	429.05	150.0
2023-10-02 05:22:00	SPY	ETF	429.16	429.16	429.16	429.16	200.0
2023-10-02 05:23:00	SPY	ETF	429.18	429.18	429.18	429.18	100.0

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

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