PREVIEW / etf_1hour / 2023-02-24

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-24.parquet
  size:    464 KB
  rows:    16,989

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-02-24 04:00:00	SPY	ETF	399.8	399.93	399.41	399.42	45053.0
2023-02-24 05:00:00	SPY	ETF	399.37	399.63	398.97	399.18	25967.0
2023-02-24 06:00:00	SPY	ETF	399.1	399.1	398.07	398.25	75806.0
2023-02-24 07:00:00	SPY	ETF	398.27	398.34	397.95	398.05	163149.0
2023-02-24 08:00:00	SPY	ETF	398.09	400.48	395.17	395.7	1727411.0
2023-02-24 09:00:00	SPY	ETF	395.67	396.47	394.16	394.49	10426599.0
2023-02-24 10:00:00	SPY	ETF	394.48	395.4	393.64	394.1	14492950.0
2023-02-24 11:00:00	SPY	ETF	394.11	396.6981	393.98	395.88	11531799.0
2023-02-24 12:00:00	SPY	ETF	395.88	396.11	394.56	394.66	7298837.0
2023-02-24 13:00:00	SPY	ETF	394.66	395.88	394.2914	395.58	6836366.0
2023-02-24 14:00:00	SPY	ETF	395.59	397.06	395.12	396.81	8068265.0
2023-02-24 15:00:00	SPY	ETF	396.79	397.25	395.05	396.39	21758522.0
2023-02-24 16:00:00	SPY	ETF	396.4	398.0	396.08	396.3	3904273.0
2023-02-24 17:00:00	SPY	ETF	396.3	396.43	396.2846	396.34	44398.0
2023-02-24 18:00:00	SPY	ETF	396.31	396.38	396.25	396.38	8277.0
2023-02-24 19:00:00	SPY	ETF	396.31	396.34	396.0	396.2	28226.0
2023-02-24 04:00:00	QQQ	ETF	295.2	295.68	294.9	294.91	60017.0
2023-02-24 05:00:00	QQQ	ETF	294.9	295.1	294.55	294.77	33709.0
2023-02-24 06:00:00	QQQ	ETF	294.71	294.74	293.9	294.28	124760.0
2023-02-24 07:00:00	QQQ	ETF	294.3	294.5	294.05	294.25	221294.0
2023-02-24 08:00:00	QQQ	ETF	294.25	297.042	291.28	291.86	2000622.0
2023-02-24 09:00:00	QQQ	ETF	291.84	292.97	290.82	291.31	10033844.0
2023-02-24 10:00:00	QQQ	ETF	291.28	291.73	290.05	290.35	10968813.0
2023-02-24 11:00:00	QQQ	ETF	290.36	292.34	290.06	291.67	8381972.0
2023-02-24 12:00:00	QQQ	ETF	291.68	291.85	290.39	290.55	4597685.0
2023-02-24 13:00:00	QQQ	ETF	290.56	291.3	290.22	291.08	4353109.0
2023-02-24 14:00:00	QQQ	ETF	291.08	292.2108	290.61	292.06	5176015.0
2023-02-24 15:00:00	QQQ	ETF	292.04	292.41	290.57	291.82	10908997.0
2023-02-24 16:00:00	QQQ	ETF	291.82	292.01	291.64	291.87	1454649.0
2023-02-24 17:00:00	QQQ	ETF	291.88	291.91	291.76	291.87	474804.0
2023-02-24 18:00:00	QQQ	ETF	291.84	291.9	291.71	291.75	13900.0
2023-02-24 19:00:00	QQQ	ETF	291.75	291.91	291.75	291.75	28558.0
2023-02-24 04:00:00	IWM	ETF	189.0	189.16	188.96	188.99	7148.0
2023-02-24 05:00:00	IWM	ETF	189.01	189.01	188.72	188.87	11311.0
2023-02-24 06:00:00	IWM	ETF	188.68	188.69	188.15	188.18	12723.0
2023-02-24 07:00:00	IWM	ETF	188.24	188.24	187.99	187.99	129768.0
2023-02-24 08:00:00	IWM	ETF	188.17	188.64	186.63	186.86	278745.0
2023-02-24 09:00:00	IWM	ETF	186.81	187.17	185.78	186.54	3851697.0
2023-02-24 10:00:00	IWM	ETF	186.53	187.3175	185.83	186.35	3223738.0
2023-02-24 11:00:00	IWM	ETF	186.36	187.78	186.26	187.32	2391002.0
2023-02-24 12:00:00	IWM	ETF	187.33	187.4	186.39	186.39	1156645.0
2023-02-24 13:00:00	IWM	ETF	186.415	186.945	186.25	186.83	1084809.0
2023-02-24 14:00:00	IWM	ETF	186.835	187.69	186.7	187.59	1508732.0
2023-02-24 15:00:00	IWM	ETF	187.59	187.73	186.75	187.5	3778868.0
2023-02-24 16:00:00	IWM	ETF	187.51	187.51	187.32	187.43	1233055.0
2023-02-24 17:00:00	IWM	ETF	187.43	187.45	187.37	187.4	6294.0
2023-02-24 18:00:00	IWM	ETF	187.44	187.45	187.35	187.37	9813.0
2023-02-24 19:00:00	IWM	ETF	187.43	187.47	187.31	187.38	15386.0
2023-02-24 06:00:00	DIA	ETF	330.26	330.26	329.88	329.88	3199.0
2023-02-24 07:00:00	DIA	ETF	329.699	329.82	329.699	329.8	1100.0

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

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