PREVIEW / etf_30min / 2023-03-02

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-02.parquet
  size:    682 KB
  rows:    27,172

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-03-02 04:00:00	SPY	ETF	392.88	393.07	392.5	392.8	36114.0
2023-03-02 04:30:00	SPY	ETF	392.76	392.85	392.55	392.58	3901.0
2023-03-02 05:00:00	SPY	ETF	392.29	392.89	391.94	392.89	26719.0
2023-03-02 05:30:00	SPY	ETF	392.9	392.97	392.51	392.95	29288.0
2023-03-02 06:00:00	SPY	ETF	393.09	393.61	393.09	393.24	46315.0
2023-03-02 06:30:00	SPY	ETF	393.22	393.63	393.15	393.59	27675.0
2023-03-02 07:00:00	SPY	ETF	393.59	393.96	393.31	393.32	111217.0
2023-03-02 07:30:00	SPY	ETF	393.32	393.5	392.95	393.12	199436.0
2023-03-02 08:00:00	SPY	ETF	393.759	393.96	391.96	393.15	326125.0
2023-03-02 08:30:00	SPY	ETF	393.07	393.07	392.2	392.44	481015.0
2023-03-02 09:00:00	SPY	ETF	392.45	392.99	392.43	392.67	393769.0
2023-03-02 09:30:00	SPY	ETF	392.69	393.58	392.33	393.2199	7765356.0
2023-03-02 10:00:00	SPY	ETF	393.23	394.12	392.81	394.0	6194387.0
2023-03-02 10:30:00	SPY	ETF	394.03	394.47	393.52	394.275	3962550.0
2023-03-02 11:00:00	SPY	ETF	394.275	394.65	393.61	393.69	3833579.0
2023-03-02 11:30:00	SPY	ETF	393.69	394.06	393.4699	393.91	2711358.0
2023-03-02 12:00:00	SPY	ETF	393.925	394.14	393.454	393.895	2367124.0
2023-03-02 12:30:00	SPY	ETF	393.9	394.58	393.855	394.4	2345995.0
2023-03-02 13:00:00	SPY	ETF	394.4	394.55	394.01	394.0599	2081393.0
2023-03-02 13:30:00	SPY	ETF	394.065	396.18	394.05	396.139	5603824.0
2023-03-02 14:00:00	SPY	ETF	396.14	397.08	396.04	396.945	5739380.0
2023-03-02 14:30:00	SPY	ETF	396.95	397.17	396.32	396.81	4088497.0
2023-03-02 15:00:00	SPY	ETF	396.811	397.63	396.43	397.44	4546118.0
2023-03-02 15:30:00	SPY	ETF	397.43	398.69	397.31	397.79	12113657.0
2023-03-02 16:00:00	SPY	ETF	397.78	397.96	397.41	397.59	3161893.0
2023-03-02 16:30:00	SPY	ETF	397.62	397.75	397.42	397.53	238002.0
2023-03-02 17:00:00	SPY	ETF	397.59	397.6	397.42	397.54	44376.0
2023-03-02 17:30:00	SPY	ETF	397.5	397.56	397.47	397.51	31949.0
2023-03-02 18:00:00	SPY	ETF	397.51	397.51	397.2	397.24	82131.0
2023-03-02 18:30:00	SPY	ETF	397.26	397.26	397.0	397.1	91200.0
2023-03-02 19:00:00	SPY	ETF	397.1	397.38	396.91	396.91	56776.0
2023-03-02 19:30:00	SPY	ETF	396.9	397.22	396.85	397.2	58128.0
2023-03-02 04:00:00	QQQ	ETF	289.45	290.0	288.86	289.03	72367.0
2023-03-02 04:30:00	QQQ	ETF	289.03	289.14	288.74	288.84	17041.0
2023-03-02 05:00:00	QQQ	ETF	288.73	289.14	288.25	289.14	31762.0
2023-03-02 05:30:00	QQQ	ETF	289.12	289.23	288.75	289.23	28549.0
2023-03-02 06:00:00	QQQ	ETF	289.18	289.86	289.18	289.44	48715.0
2023-03-02 06:30:00	QQQ	ETF	289.46	289.75	289.37	289.75	66498.0
2023-03-02 07:00:00	QQQ	ETF	289.79	290.1	289.5	289.52	154586.0
2023-03-02 07:30:00	QQQ	ETF	289.56	289.68	289.03	289.18	188837.0
2023-03-02 08:00:00	QQQ	ETF	289.2	291.418	288.25	289.01	292367.0
2023-03-02 08:30:00	QQQ	ETF	289.0	289.08	288.2	288.29	522878.0
2023-03-02 09:00:00	QQQ	ETF	288.27	288.68	288.25	288.64	448721.0
2023-03-02 09:30:00	QQQ	ETF	288.66	289.965	288.37	289.6	5166079.0
2023-03-02 10:00:00	QQQ	ETF	289.64	290.43	289.02	290.09	3850864.0
2023-03-02 10:30:00	QQQ	ETF	290.13	290.48	289.6	290.25	2645060.0
2023-03-02 11:00:00	QQQ	ETF	290.25	290.6	289.456	289.495	2514360.0
2023-03-02 11:30:00	QQQ	ETF	289.51	289.88	289.28	289.83	1986011.0
2023-03-02 12:00:00	QQQ	ETF	289.838	290.14	289.55	289.93	1465230.0
2023-03-02 12:30:00	QQQ	ETF	289.93	290.53	289.84	290.2999	1722980.0

> showing 50 of 27,172 rows — these rows as CSV

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