PREVIEW / etf_1hour / 2023-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-22.parquet
  size:    469 KB
  rows:    17,040

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-06-22 04:00:00	SPY	ETF	434.46	434.46	433.76	434.1	24671.0
2023-06-22 05:00:00	SPY	ETF	434.17	434.58	434.09	434.35	15808.0
2023-06-22 06:00:00	SPY	ETF	434.35	434.39	433.64	433.85	102896.0
2023-06-22 07:00:00	SPY	ETF	433.88	434.07	433.48	434.02	390619.0
2023-06-22 08:00:00	SPY	ETF	433.8	434.94	433.56	434.01	275242.0
2023-06-22 09:00:00	SPY	ETF	433.95	435.0899	433.6	434.7472	5887125.0
2023-06-22 10:00:00	SPY	ETF	434.79	436.02	434.03	434.5295	8554552.0
2023-06-22 11:00:00	SPY	ETF	434.52	435.83	434.48	435.57	5156601.0
2023-06-22 12:00:00	SPY	ETF	435.58	435.67	434.885	435.24	4393870.0
2023-06-22 13:00:00	SPY	ETF	435.24	435.69	434.415	435.655	4494965.0
2023-06-22 14:00:00	SPY	ETF	435.65	436.45	435.465	436.4	5742434.0
2023-06-22 15:00:00	SPY	ETF	436.4	436.62	435.335	436.54	11616989.0
2023-06-22 16:00:00	SPY	ETF	436.54	436.81	436.19	436.7	2239800.0
2023-06-22 17:00:00	SPY	ETF	436.67	436.89	436.6	436.77	82831.0
2023-06-22 18:00:00	SPY	ETF	436.77	436.82	436.57	436.7	154129.0
2023-06-22 19:00:00	SPY	ETF	436.74	436.76	436.56	436.58	65107.0
2023-06-22 04:00:00	QQQ	ETF	361.1	361.19	360.74	360.88	26842.0
2023-06-22 05:00:00	QQQ	ETF	361.0	361.62	360.92	361.46	47265.0
2023-06-22 06:00:00	QQQ	ETF	361.58	361.63	360.52	360.69	56766.0
2023-06-22 07:00:00	QQQ	ETF	360.7	361.05	360.34	360.98	194727.0
2023-06-22 08:00:00	QQQ	ETF	360.57	362.171	360.46	360.91	373681.0
2023-06-22 09:00:00	QQQ	ETF	360.83	363.42	360.22	363.0839	5126989.0
2023-06-22 10:00:00	QQQ	ETF	363.11	364.69	362.43	363.06	6864211.0
2023-06-22 11:00:00	QQQ	ETF	363.05	365.45	363.03	364.9	4835210.0
2023-06-22 12:00:00	QQQ	ETF	364.91	364.935	363.752	364.14	2958021.0
2023-06-22 13:00:00	QQQ	ETF	364.14	364.84	363.0806	364.785	2837460.0
2023-06-22 14:00:00	QQQ	ETF	364.79	365.68	364.36	365.63	3238627.0
2023-06-22 15:00:00	QQQ	ETF	365.64	366.33	364.635	366.2	7016107.0
2023-06-22 16:00:00	QQQ	ETF	366.22	366.79	366.04	366.68	926372.0
2023-06-22 17:00:00	QQQ	ETF	366.67	366.82	366.66	366.82	46960.0
2023-06-22 18:00:00	QQQ	ETF	366.79	366.79	366.54	366.56	30868.0
2023-06-22 19:00:00	QQQ	ETF	366.57	366.59	366.43	366.45	35409.0
2023-06-22 04:00:00	IWM	ETF	184.03	184.46	184.03	184.3	7441.0
2023-06-22 05:00:00	IWM	ETF	184.43	184.68	184.4	184.57	6257.0
2023-06-22 06:00:00	IWM	ETF	184.54	184.6	184.34	184.39	7302.0
2023-06-22 07:00:00	IWM	ETF	184.42	184.5	184.18	184.295	16996.0
2023-06-22 08:00:00	IWM	ETF	184.2413	184.57	184.17	184.51	118532.0
2023-06-22 09:00:00	IWM	ETF	184.49	184.6	182.485	183.03	4098500.0
2023-06-22 10:00:00	IWM	ETF	183.03	183.91	182.8	183.13	3935480.0
2023-06-22 11:00:00	IWM	ETF	183.13	183.62	182.63	183.57	2685368.0
2023-06-22 12:00:00	IWM	ETF	183.58	183.665	183.115	183.29	1609316.0
2023-06-22 13:00:00	IWM	ETF	183.3	183.6	183.0	183.575	1736285.0
2023-06-22 14:00:00	IWM	ETF	183.58	183.93	183.41	183.8	1866792.0
2023-06-22 15:00:00	IWM	ETF	183.805	183.88	183.05	183.31	5349876.0
2023-06-22 16:00:00	IWM	ETF	183.33	183.43	183.13	183.39	825664.0
2023-06-22 17:00:00	IWM	ETF	183.36	183.47	183.35	183.44	4509.0
2023-06-22 18:00:00	IWM	ETF	183.4	183.5	183.36	183.5	13254.0
2023-06-22 19:00:00	IWM	ETF	183.49	183.55	183.36	183.37	11588.0
2023-06-22 04:00:00	DIA	ETF	338.64	338.85	338.64	338.85	410.0
2023-06-22 06:00:00	DIA	ETF	338.5	338.5	338.5	338.5	1000.0

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

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