PREVIEW / etf_1hour / 2023-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-21.parquet
  size:    494 KB
  rows:    18,093

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-21 04:00:00	SPY	ETF	437.73	437.85	436.81	437.03	62786.0
2023-09-21 05:00:00	SPY	ETF	437.01	437.23	436.44	436.48	39327.0
2023-09-21 06:00:00	SPY	ETF	436.53	436.53	435.86	436.13	107963.0
2023-09-21 07:00:00	SPY	ETF	436.09	436.3	435.18	435.31	369818.0
2023-09-21 08:00:00	SPY	ETF	436.1481	437.79	434.5	435.16	951318.0
2023-09-21 09:00:00	SPY	ETF	435.22	435.97	434.11	434.15	8697748.0
2023-09-21 10:00:00	SPY	ETF	434.145	435.57	434.01	434.105	12379081.0
2023-09-21 11:00:00	SPY	ETF	434.12	434.57	433.65	433.92	7305239.0
2023-09-21 12:00:00	SPY	ETF	433.92	434.17	433.43	433.577	5997816.0
2023-09-21 13:00:00	SPY	ETF	433.58	434.9	433.49	434.42	6311138.0
2023-09-21 14:00:00	SPY	ETF	434.43	434.49	433.07	433.08	8124502.0
2023-09-21 15:00:00	SPY	ETF	433.08	433.39	431.23	431.41	24546047.0
2023-09-21 16:00:00	SPY	ETF	431.42	434.2004	430.81	431.01	5255396.0
2023-09-21 17:00:00	SPY	ETF	430.96	431.09	430.88	431.09	104915.0
2023-09-21 18:00:00	SPY	ETF	431.09	431.58	431.09	431.44	164581.0
2023-09-21 19:00:00	SPY	ETF	431.43	431.48	431.05	431.12	51316.0
2023-09-21 04:00:00	QQQ	ETF	363.5	363.64	362.36	362.54	70168.0
2023-09-21 05:00:00	QQQ	ETF	362.5	362.83	362.0	362.13	135709.0
2023-09-21 06:00:00	QQQ	ETF	362.14	362.15	361.56	361.75	83030.0
2023-09-21 07:00:00	QQQ	ETF	361.85	361.97	360.68	360.76	452586.0
2023-09-21 08:00:00	QQQ	ETF	361.34	364.813	359.8	360.2	1348139.0
2023-09-21 09:00:00	QQQ	ETF	360.2	361.6	359.435	359.5	9434510.0
2023-09-21 10:00:00	QQQ	ETF	359.47	361.56	359.17	360.2094	10152640.0
2023-09-21 11:00:00	QQQ	ETF	360.21	360.81	359.61	359.82	5411347.0
2023-09-21 12:00:00	QQQ	ETF	359.81	360.44	359.2273	359.86	4823523.0
2023-09-21 13:00:00	QQQ	ETF	359.86	361.12	359.795	360.59	4109990.0
2023-09-21 14:00:00	QQQ	ETF	360.6084	360.67	359.2	359.29	4059185.0
2023-09-21 15:00:00	QQQ	ETF	359.27	359.64	357.69	357.755	12230798.0
2023-09-21 16:00:00	QQQ	ETF	357.76	357.93	357.32	357.48	2198231.0
2023-09-21 17:00:00	QQQ	ETF	357.48	357.86	357.37	357.41	390091.0
2023-09-21 18:00:00	QQQ	ETF	357.45	357.99	357.45	357.88	108462.0
2023-09-21 19:00:00	QQQ	ETF	357.89	357.89	357.43	357.55	79928.0
2023-09-21 04:00:00	IWM	ETF	179.43	179.57	179.21	179.21	7366.0
2023-09-21 05:00:00	IWM	ETF	179.3	179.35	179.1	179.1	10345.0
2023-09-21 06:00:00	IWM	ETF	179.01	179.01	178.65	178.72	40908.0
2023-09-21 07:00:00	IWM	ETF	178.75	178.93	178.43	178.51	62447.0
2023-09-21 08:00:00	IWM	ETF	178.78	179.32	178.34	178.78	183683.0
2023-09-21 09:00:00	IWM	ETF	178.77	178.92	177.34	177.4	4695363.0
2023-09-21 10:00:00	IWM	ETF	177.39	178.43	177.35	177.73	4880543.0
2023-09-21 11:00:00	IWM	ETF	177.725	178.215	177.54	178.05	2962326.0
2023-09-21 12:00:00	IWM	ETF	178.05	178.06	177.685	177.8	1633705.0
2023-09-21 13:00:00	IWM	ETF	177.8	178.51	177.73	178.27	2513182.0
2023-09-21 14:00:00	IWM	ETF	178.28	178.305	177.8	177.8099	2299678.0
2023-09-21 15:00:00	IWM	ETF	177.8	177.93	177.08	177.11	5211692.0
2023-09-21 16:00:00	IWM	ETF	177.07	177.2	176.95	177.03	1241747.0
2023-09-21 17:00:00	IWM	ETF	177.06	177.1	177.01	177.1	11564.0
2023-09-21 18:00:00	IWM	ETF	177.09	177.34	177.09	177.34	20352.0
2023-09-21 19:00:00	IWM	ETF	177.32	177.32	177.07	177.0896	25366.0
2023-09-21 04:00:00	DIA	ETF	344.0	344.05	343.56	343.56	1025.0
2023-09-21 05:00:00	DIA	ETF	343.52	343.52	343.26	343.26	2050.0

> showing 50 of 18,093 rows — these rows as CSV

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