PREVIEW / etf_1hour / 2023-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-22.parquet
  size:    472 KB
  rows:    17,349

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-09-22 04:00:00	SPY	ETF	432.46	432.46	431.58	432.1	28403.0
2023-09-22 05:00:00	SPY	ETF	432.08	432.61	431.85	432.51	18578.0
2023-09-22 06:00:00	SPY	ETF	432.51	432.63	432.15	432.4	46814.0
2023-09-22 07:00:00	SPY	ETF	432.39	432.47	432.06	432.4	173757.0
2023-09-22 08:00:00	SPY	ETF	432.3217	433.24	431.88	432.85	614797.0
2023-09-22 09:00:00	SPY	ETF	432.89	433.05	431.67	432.4536	7650902.0
2023-09-22 10:00:00	SPY	ETF	432.465	433.81	431.96	433.66	10821357.0
2023-09-22 11:00:00	SPY	ETF	433.67	434.1	432.89	432.91	6879156.0
2023-09-22 12:00:00	SPY	ETF	432.92	433.76	432.655	433.4	4803321.0
2023-09-22 13:00:00	SPY	ETF	433.4082	433.46	431.21	431.62	8408324.0
2023-09-22 14:00:00	SPY	ETF	431.61	431.81	430.55	431.07	8047743.0
2023-09-22 15:00:00	SPY	ETF	431.05	433.21	429.99	430.38	24064863.0
2023-09-22 16:00:00	SPY	ETF	430.39	433.6078	430.35	430.43	4865173.0
2023-09-22 17:00:00	SPY	ETF	430.41	431.18	430.41	430.85	211659.0
2023-09-22 18:00:00	SPY	ETF	430.89	430.9	430.66	430.7	27039.0
2023-09-22 19:00:00	SPY	ETF	430.66	430.8	430.4	430.6	42568.0
2023-09-22 04:00:00	QQQ	ETF	358.93	359.33	358.63	359.2	164948.0
2023-09-22 05:00:00	QQQ	ETF	359.16	359.61	358.91	359.57	32294.0
2023-09-22 06:00:00	QQQ	ETF	359.5	359.66	359.22	359.49	33697.0
2023-09-22 07:00:00	QQQ	ETF	359.38	359.42	359.05	359.3	134571.0
2023-09-22 08:00:00	QQQ	ETF	358.27	360.46	358.128	360.03	1160857.0
2023-09-22 09:00:00	QQQ	ETF	360.06	360.21	358.44	359.94	6092183.0
2023-09-22 10:00:00	QQQ	ETF	359.945	361.51	359.03	361.38	6956026.0
2023-09-22 11:00:00	QQQ	ETF	361.39	361.8	360.565	360.5999	4308257.0
2023-09-22 12:00:00	QQQ	ETF	360.6	361.68	360.45	361.32	2524315.0
2023-09-22 13:00:00	QQQ	ETF	361.325	361.37	358.95	359.12	4333504.0
2023-09-22 14:00:00	QQQ	ETF	359.11	359.31	357.9099	358.5	4283474.0
2023-09-22 15:00:00	QQQ	ETF	358.5	360.6001	357.59	357.94	9194969.0
2023-09-22 16:00:00	QQQ	ETF	357.94	358.5	357.91	358.1	1801495.0
2023-09-22 17:00:00	QQQ	ETF	358.1	358.5	358.1	358.35	42538.0
2023-09-22 18:00:00	QQQ	ETF	358.4	358.4	358.2	358.2	16360.0
2023-09-22 19:00:00	QQQ	ETF	358.19	358.27	358.05	358.23	18291.0
2023-09-22 04:00:00	IWM	ETF	177.55	177.64	177.31	177.5	27917.0
2023-09-22 05:00:00	IWM	ETF	177.41	177.7	177.41	177.65	6870.0
2023-09-22 06:00:00	IWM	ETF	177.65	177.78	177.56	177.71	12183.0
2023-09-22 07:00:00	IWM	ETF	177.71	177.71	177.53	177.64	31368.0
2023-09-22 08:00:00	IWM	ETF	177.65	178.0	177.44	177.81	48959.0
2023-09-22 09:00:00	IWM	ETF	177.74	178.37	177.1625	177.48	3079145.0
2023-09-22 10:00:00	IWM	ETF	177.48	178.04	177.19	177.92	3240398.0
2023-09-22 11:00:00	IWM	ETF	177.92	177.965	177.25	177.265	2025603.0
2023-09-22 12:00:00	IWM	ETF	177.26	177.64	177.1	177.37	1684769.0
2023-09-22 13:00:00	IWM	ETF	177.37	177.55	176.91	177.04	1670407.0
2023-09-22 14:00:00	IWM	ETF	177.04	177.09	176.6	176.89	1727572.0
2023-09-22 15:00:00	IWM	ETF	176.885	177.66	176.56	176.63	4516632.0
2023-09-22 16:00:00	IWM	ETF	176.67	176.82	176.62	176.81	875753.0
2023-09-22 17:00:00	IWM	ETF	176.81	177.0	176.74	176.83	64597.0
2023-09-22 18:00:00	IWM	ETF	176.93	176.95	176.8	176.8	1007.0
2023-09-22 19:00:00	IWM	ETF	176.8	177.0	176.7	177.0	2943.0
2023-09-22 04:00:00	DIA	ETF	340.6	340.64	340.55	340.63	2040.0
2023-09-22 05:00:00	DIA	ETF	340.65	340.97	340.65	340.96	950.0

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

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