PREVIEW / etf_1hour / 2023-01-24

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-24.parquet
  size:    467 KB
  rows:    17,067

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-01-24 04:00:00	SPY	ETF	400.18	400.51	399.95	400.08	38019.0
2023-01-24 05:00:00	SPY	ETF	400.1	400.13	399.61	400.0	29292.0
2023-01-24 06:00:00	SPY	ETF	400.04	400.04	399.45	399.77	38279.0
2023-01-24 07:00:00	SPY	ETF	399.75	399.83	399.38	399.66	97530.0
2023-01-24 08:00:00	SPY	ETF	399.6	400.85	398.43	398.82	736163.0
2023-01-24 09:00:00	SPY	ETF	398.76	400.15	397.98	398.376	6274253.0
2023-01-24 10:00:00	SPY	ETF	398.39	400.75	397.64	400.49	8031821.0
2023-01-24 11:00:00	SPY	ETF	400.5	400.712	399.71	400.05	5687099.0
2023-01-24 12:00:00	SPY	ETF	400.03	400.54	399.22	400.04	3718290.0
2023-01-24 13:00:00	SPY	ETF	400.04	401.15	399.4407	400.78	4941701.0
2023-01-24 14:00:00	SPY	ETF	400.77	401.005	399.95	400.87	4549423.0
2023-01-24 15:00:00	SPY	ETF	400.87	401.06	399.29	400.17	7356659.0
2023-01-24 16:00:00	SPY	ETF	400.18	401.81	399.98	400.95	3068232.0
2023-01-24 17:00:00	SPY	ETF	401.08	401.11	400.67	400.88	186359.0
2023-01-24 18:00:00	SPY	ETF	400.88	401.04	398.59	398.89	395136.0
2023-01-24 19:00:00	SPY	ETF	398.94	399.12	398.24	398.54	250151.0
2023-01-24 04:00:00	QQQ	ETF	288.88	289.0	288.3	288.4	95383.0
2023-01-24 05:00:00	QQQ	ETF	288.45	288.45	287.96	288.23	33506.0
2023-01-24 06:00:00	QQQ	ETF	288.24	288.24	287.73	287.86	83157.0
2023-01-24 07:00:00	QQQ	ETF	287.86	288.01	287.61	287.79	60770.0
2023-01-24 08:00:00	QQQ	ETF	287.89	289.176	286.73	287.04	474411.0
2023-01-24 09:00:00	QQQ	ETF	287.04	289.55	286.84	287.88	5469840.0
2023-01-24 10:00:00	QQQ	ETF	287.91	289.29	286.78	289.03	5679434.0
2023-01-24 11:00:00	QQQ	ETF	289.04	289.194	288.23	288.6801	2907010.0
2023-01-24 12:00:00	QQQ	ETF	288.67	289.17	287.95	288.25	2616529.0
2023-01-24 13:00:00	QQQ	ETF	288.235	289.19	287.61	288.8261	2670005.0
2023-01-24 14:00:00	QQQ	ETF	288.8	288.84	288.1	288.71	2232351.0
2023-01-24 15:00:00	QQQ	ETF	288.71	288.84	287.2855	288.41	5074354.0
2023-01-24 16:00:00	QQQ	ETF	288.4	290.9	287.81	290.01	4214253.0
2023-01-24 17:00:00	QQQ	ETF	290.01	290.57	289.27	290.05	429701.0
2023-01-24 18:00:00	QQQ	ETF	290.05	290.12	286.34	286.8	1413610.0
2023-01-24 19:00:00	QQQ	ETF	286.8	286.97	286.08	286.32	431691.0
2023-01-24 04:00:00	IWM	ETF	187.27	187.44	187.08	187.2	11689.0
2023-01-24 05:00:00	IWM	ETF	187.24	187.26	187.01	187.17	8713.0
2023-01-24 06:00:00	IWM	ETF	187.11	187.17	186.89	187.14	7155.0
2023-01-24 07:00:00	IWM	ETF	187.11	187.11	186.92	186.99	12095.0
2023-01-24 08:00:00	IWM	ETF	187.02	187.2404	186.42	186.59	33021.0
2023-01-24 09:00:00	IWM	ETF	186.57	187.06	185.96	186.0	2047200.0
2023-01-24 10:00:00	IWM	ETF	186.02	187.62	185.88	187.53	1474686.0
2023-01-24 11:00:00	IWM	ETF	187.54	187.73	187.15	187.275	1014837.0
2023-01-24 12:00:00	IWM	ETF	187.26	187.66	186.9	187.36	849700.0
2023-01-24 13:00:00	IWM	ETF	187.36	187.83	187.12	187.57	998138.0
2023-01-24 14:00:00	IWM	ETF	187.57	187.5886	187.13	187.46	935029.0
2023-01-24 15:00:00	IWM	ETF	187.48	187.575	186.725	186.89	2475954.0
2023-01-24 16:00:00	IWM	ETF	186.93	187.42	186.63	186.72	2049475.0
2023-01-24 17:00:00	IWM	ETF	186.88	186.93	186.62	186.76	1508675.0
2023-01-24 18:00:00	IWM	ETF	186.76	186.85	186.27	186.56	107136.0
2023-01-24 19:00:00	IWM	ETF	186.5	186.68	186.23	186.38	68631.0
2023-01-24 05:00:00	DIA	ETF	335.83	335.83	335.7	335.7	1900.0
2023-01-24 06:00:00	DIA	ETF	335.35	335.66	335.35	335.65	4270.0

> showing 50 of 17,067 rows — these rows as CSV

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