PREVIEW / etf_1hour / 2023-03-02

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-02.parquet
  size:    469 KB
  rows:    16,954

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.58	40015.0
2023-03-02 05:00:00	SPY	ETF	392.29	392.97	391.94	392.95	56007.0
2023-03-02 06:00:00	SPY	ETF	393.09	393.63	393.09	393.59	73990.0
2023-03-02 07:00:00	SPY	ETF	393.59	393.96	392.95	393.12	310653.0
2023-03-02 08:00:00	SPY	ETF	393.759	393.96	391.96	392.44	807140.0
2023-03-02 09:00:00	SPY	ETF	392.45	393.58	392.33	393.2199	8159125.0
2023-03-02 10:00:00	SPY	ETF	393.23	394.47	392.81	394.275	10156937.0
2023-03-02 11:00:00	SPY	ETF	394.275	394.65	393.4699	393.91	6544937.0
2023-03-02 12:00:00	SPY	ETF	393.925	394.58	393.454	394.4	4713119.0
2023-03-02 13:00:00	SPY	ETF	394.4	396.18	394.01	396.139	7685217.0
2023-03-02 14:00:00	SPY	ETF	396.14	397.17	396.04	396.81	9827877.0
2023-03-02 15:00:00	SPY	ETF	396.811	398.69	396.43	397.79	16659775.0
2023-03-02 16:00:00	SPY	ETF	397.78	397.96	397.41	397.53	3399895.0
2023-03-02 17:00:00	SPY	ETF	397.59	397.6	397.42	397.51	76325.0
2023-03-02 18:00:00	SPY	ETF	397.51	397.51	397.0	397.1	173331.0
2023-03-02 19:00:00	SPY	ETF	397.1	397.38	396.85	397.2	114904.0
2023-03-02 04:00:00	QQQ	ETF	289.45	290.0	288.74	288.84	89408.0
2023-03-02 05:00:00	QQQ	ETF	288.73	289.23	288.25	289.23	60311.0
2023-03-02 06:00:00	QQQ	ETF	289.18	289.86	289.18	289.75	115213.0
2023-03-02 07:00:00	QQQ	ETF	289.79	290.1	289.03	289.18	343423.0
2023-03-02 08:00:00	QQQ	ETF	289.2	291.418	288.2	288.29	815245.0
2023-03-02 09:00:00	QQQ	ETF	288.27	289.965	288.25	289.6	5614800.0
2023-03-02 10:00:00	QQQ	ETF	289.64	290.48	289.02	290.25	6495924.0
2023-03-02 11:00:00	QQQ	ETF	290.25	290.6	289.28	289.83	4500371.0
2023-03-02 12:00:00	QQQ	ETF	289.838	290.53	289.55	290.2999	3188210.0
2023-03-02 13:00:00	QQQ	ETF	290.295	292.13	289.99	292.085	4733336.0
2023-03-02 14:00:00	QQQ	ETF	292.1	293.37	292.1	292.9	6124197.0
2023-03-02 15:00:00	QQQ	ETF	292.9	294.43	292.52	293.7	8309834.0
2023-03-02 16:00:00	QQQ	ETF	293.71	293.86	293.26	293.35	1279930.0
2023-03-02 17:00:00	QQQ	ETF	293.31	293.61	293.24	293.251	372421.0
2023-03-02 18:00:00	QQQ	ETF	293.25	293.25	292.891	293.02	97739.0
2023-03-02 19:00:00	QQQ	ETF	293.01	293.3	292.66	293.05	88862.0
2023-03-02 04:00:00	IWM	ETF	187.29	188.0	186.95	186.98	21147.0
2023-03-02 05:00:00	IWM	ETF	186.9	187.31	186.6	187.31	12329.0
2023-03-02 06:00:00	IWM	ETF	187.32	187.63	187.32	187.6	19341.0
2023-03-02 07:00:00	IWM	ETF	187.61	187.8	187.32	187.4	22781.0
2023-03-02 08:00:00	IWM	ETF	187.7	187.73	186.82	186.91	95656.0
2023-03-02 09:00:00	IWM	ETF	186.9499	187.23	186.12	186.97	2559165.0
2023-03-02 10:00:00	IWM	ETF	186.92	187.64	186.32	187.36	1968749.0
2023-03-02 11:00:00	IWM	ETF	187.38	187.82	187.24	187.55	1088435.0
2023-03-02 12:00:00	IWM	ETF	187.555	187.97	187.31	187.68	815748.0
2023-03-02 13:00:00	IWM	ETF	187.7	188.39	187.33	188.37	1277221.0
2023-03-02 14:00:00	IWM	ETF	188.37	188.92	188.26	188.63	1953600.0
2023-03-02 15:00:00	IWM	ETF	188.63	189.3	188.41	188.92	2773699.0
2023-03-02 16:00:00	IWM	ETF	188.87	189.13	188.75	188.87	802533.0
2023-03-02 17:00:00	IWM	ETF	188.76	188.859	188.5	188.77	32258.0
2023-03-02 18:00:00	IWM	ETF	188.74	188.79	188.48	188.59	10756.0
2023-03-02 19:00:00	IWM	ETF	188.66	188.77	188.48	188.65	22931.0
2023-03-02 04:00:00	DIA	ETF	327.25	327.25	327.01	327.01	12000.0
2023-03-02 05:00:00	DIA	ETF	327.0	327.42	326.7	327.42	4600.0

> showing 50 of 16,954 rows — these rows as CSV

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