PREVIEW / etf_1hour / 2023-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-17.parquet
  size:    489 KB
  rows:    17,667

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-10-17 04:00:00	SPY	ETF	436.02	436.02	434.68	434.8	42136.0
2023-10-17 05:00:00	SPY	ETF	434.77	435.6	434.77	435.25	12028.0
2023-10-17 06:00:00	SPY	ETF	435.2	435.4	434.69	435.06	41717.0
2023-10-17 07:00:00	SPY	ETF	434.93	435.09	434.44	435.04	163582.0
2023-10-17 08:00:00	SPY	ETF	434.9492	436.03	433.56	433.58	764578.0
2023-10-17 09:00:00	SPY	ETF	433.59	433.71	432.45	432.72	7823170.0
2023-10-17 10:00:00	SPY	ETF	432.72	435.7	432.59	435.135	9862954.0
2023-10-17 11:00:00	SPY	ETF	435.14	437.5167	434.94	437.265	8272279.0
2023-10-17 12:00:00	SPY	ETF	437.27	438.14	436.6	436.79	7684867.0
2023-10-17 13:00:00	SPY	ETF	436.8	437.01	434.615	434.8738	6907430.0
2023-10-17 14:00:00	SPY	ETF	434.88	435.695	434.225	434.5771	7957120.0
2023-10-17 15:00:00	SPY	ETF	434.57	436.115	434.3	436.09	12334647.0
2023-10-17 16:00:00	SPY	ETF	436.085	437.3228	432.9516	435.81	2274936.0
2023-10-17 17:00:00	SPY	ETF	435.84	435.86	435.61	435.7	46945.0
2023-10-17 18:00:00	SPY	ETF	435.7	435.71	435.44	435.5	117638.0
2023-10-17 19:00:00	SPY	ETF	435.52	435.52	435.04	435.06	44880.0
2023-10-17 04:00:00	QQQ	ETF	369.48	369.53	368.24	368.49	71977.0
2023-10-17 05:00:00	QQQ	ETF	368.41	369.18	368.41	368.81	19669.0
2023-10-17 06:00:00	QQQ	ETF	368.8	368.99	368.3	368.43	43452.0
2023-10-17 07:00:00	QQQ	ETF	368.43	368.51	367.9	368.44	82377.0
2023-10-17 08:00:00	QQQ	ETF	368.4006	369.687	366.39	366.46	596275.0
2023-10-17 09:00:00	QQQ	ETF	366.42	366.53	363.66	364.38	7324361.0
2023-10-17 10:00:00	QQQ	ETF	364.4	368.19	364.2001	367.3107	8128275.0
2023-10-17 11:00:00	QQQ	ETF	367.31	369.31	366.96	369.0399	6069109.0
2023-10-17 12:00:00	QQQ	ETF	369.04	369.92	368.85	369.07	4291064.0
2023-10-17 13:00:00	QQQ	ETF	369.08	369.31	367.07	367.38	3746602.0
2023-10-17 14:00:00	QQQ	ETF	367.39	368.27	366.78	367.13	4427827.0
2023-10-17 15:00:00	QQQ	ETF	367.11	368.3701	366.75	368.26	5924476.0
2023-10-17 16:00:00	QQQ	ETF	368.265	368.48	367.93	368.28	1190575.0
2023-10-17 17:00:00	QQQ	ETF	368.3	368.3	367.9	368.15	792467.0
2023-10-17 18:00:00	QQQ	ETF	368.13	368.13	367.9	367.99	33373.0
2023-10-17 19:00:00	QQQ	ETF	368.0	368.0	367.49	367.52	44054.0
2023-10-17 04:00:00	IWM	ETF	172.79	172.81	171.99	171.99	9263.0
2023-10-17 05:00:00	IWM	ETF	172.01	172.45	171.97	172.29	8892.0
2023-10-17 06:00:00	IWM	ETF	172.29	172.4	171.93	172.14	38563.0
2023-10-17 07:00:00	IWM	ETF	172.12	172.38	171.83	172.36	96079.0
2023-10-17 08:00:00	IWM	ETF	172.18	172.64	171.84	172.21	316134.0
2023-10-17 09:00:00	IWM	ETF	172.12	174.17	171.89	174.055	5988122.0
2023-10-17 10:00:00	IWM	ETF	174.07	175.085	173.67	174.92	5760524.0
2023-10-17 11:00:00	IWM	ETF	174.92	176.06	174.73	176.01	4638249.0
2023-10-17 12:00:00	IWM	ETF	176.01	176.42	175.5	175.6	3481947.0
2023-10-17 13:00:00	IWM	ETF	175.61	175.88	174.99	175.06	2999477.0
2023-10-17 14:00:00	IWM	ETF	175.08	175.51	174.855	174.98	3111979.0
2023-10-17 15:00:00	IWM	ETF	174.98	175.3	174.82	174.98	5825776.0
2023-10-17 16:00:00	IWM	ETF	174.95	175.1383	174.6923	174.97	1184108.0
2023-10-17 17:00:00	IWM	ETF	175.0	175.37	174.95	175.01	144828.0
2023-10-17 18:00:00	IWM	ETF	175.0	175.0	174.8	174.86	21754.0
2023-10-17 19:00:00	IWM	ETF	174.85	174.85	174.63	174.63	16326.0
2023-10-17 04:00:00	DIA	ETF	339.31	339.31	338.93	338.93	600.0
2023-10-17 05:00:00	DIA	ETF	339.27	339.27	339.23	339.23	750.0

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

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