PREVIEW / etf_1hour / 2023-12-26

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-26.parquet
  size:    519 KB
  rows:    18,917

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-12-26 04:00:00	SPY	ETF	474.41	474.54	474.03	474.31	13547.0
2023-12-26 05:00:00	SPY	ETF	474.32	474.45	474.29	474.45	5767.0
2023-12-26 06:00:00	SPY	ETF	474.45	474.49	474.14	474.27	7993.0
2023-12-26 07:00:00	SPY	ETF	474.23	474.27	473.83	474.27	36014.0
2023-12-26 08:00:00	SPY	ETF	474.2	474.64	473.83	474.25	132751.0
2023-12-26 09:00:00	SPY	ETF	474.25	474.81	473.99	474.67	3171136.0
2023-12-26 10:00:00	SPY	ETF	474.68	475.19	474.53	474.9	4198250.0
2023-12-26 11:00:00	SPY	ETF	474.91	475.14	474.58	475.0799	2948045.0
2023-12-26 12:00:00	SPY	ETF	475.08	475.4	474.85	475.05	2772477.0
2023-12-26 13:00:00	SPY	ETF	475.06	475.46	475.0202	475.2	2265590.0
2023-12-26 14:00:00	SPY	ETF	475.2	475.78	475.1697	475.7599	3219100.0
2023-12-26 15:00:00	SPY	ETF	475.76	476.58	475.29	475.59	12918018.0
2023-12-26 16:00:00	SPY	ETF	475.59	475.82	475.5	475.8	2583993.0
2023-12-26 17:00:00	SPY	ETF	475.75	475.84	475.65	475.84	28548.0
2023-12-26 18:00:00	SPY	ETF	475.86	476.0797	475.79	475.79	29956.0
2023-12-26 19:00:00	SPY	ETF	475.82	475.83	475.57	475.59	30635.0
2023-12-26 04:00:00	QQQ	ETF	409.6	409.6	409.1	409.33	20844.0
2023-12-26 05:00:00	QQQ	ETF	409.3	409.45	409.19	409.37	6908.0
2023-12-26 06:00:00	QQQ	ETF	409.36	409.36	409.13	409.32	3272.0
2023-12-26 07:00:00	QQQ	ETF	409.22	409.4	408.79	409.37	51098.0
2023-12-26 08:00:00	QQQ	ETF	409.02	409.86	408.71	409.14	94702.0
2023-12-26 09:00:00	QQQ	ETF	409.14	410.24	409.14	409.97	2507243.0
2023-12-26 10:00:00	QQQ	ETF	409.98	410.415	409.53	409.9599	2318098.0
2023-12-26 11:00:00	QQQ	ETF	409.96	410.26	409.59	410.17	1433090.0
2023-12-26 12:00:00	QQQ	ETF	410.16	410.32	409.8201	410.04	1311335.0
2023-12-26 13:00:00	QQQ	ETF	410.045	410.45	409.99	410.0812	1186624.0
2023-12-26 14:00:00	QQQ	ETF	410.085	410.69	410.04	410.6597	1287523.0
2023-12-26 15:00:00	QQQ	ETF	410.66	411.56	410.5687	410.865	5061002.0
2023-12-26 16:00:00	QQQ	ETF	410.865	411.04	410.7991	411.01	1114540.0
2023-12-26 17:00:00	QQQ	ETF	411.01	411.15	410.9	411.08	13349.0
2023-12-26 18:00:00	QQQ	ETF	411.08	411.32	410.96	411.02	47138.0
2023-12-26 19:00:00	QQQ	ETF	411.0	411.05	410.86	410.89	23707.0
2023-12-26 04:00:00	IWM	ETF	202.19	202.28	202.09	202.18	9870.0
2023-12-26 05:00:00	IWM	ETF	202.17	202.37	202.12	202.36	5836.0
2023-12-26 06:00:00	IWM	ETF	202.42	202.42	202.2	202.21	7661.0
2023-12-26 07:00:00	IWM	ETF	202.2	202.32	201.99	202.23	44022.0
2023-12-26 08:00:00	IWM	ETF	202.2	202.384	202.0	202.32	87372.0
2023-12-26 09:00:00	IWM	ETF	202.36	202.61	201.69	202.14	2862643.0
2023-12-26 10:00:00	IWM	ETF	202.14	202.72	202.14	202.62	2451172.0
2023-12-26 11:00:00	IWM	ETF	202.61	203.145	202.51	203.09	1938228.0
2023-12-26 12:00:00	IWM	ETF	203.09	203.72	203.015	203.346	2863599.0
2023-12-26 13:00:00	IWM	ETF	203.35	204.02	203.34	203.86	1934533.0
2023-12-26 14:00:00	IWM	ETF	203.86	204.3299	203.84	204.25	2351055.0
2023-12-26 15:00:00	IWM	ETF	204.255	204.56	203.9	204.0	6284872.0
2023-12-26 16:00:00	IWM	ETF	204.01	204.13	203.85	204.02	1064749.0
2023-12-26 17:00:00	IWM	ETF	204.0	204.1	203.96	204.09	13835.0
2023-12-26 18:00:00	IWM	ETF	204.05	204.26	204.01	204.06	26638.0
2023-12-26 19:00:00	IWM	ETF	204.05	204.07	203.94	204.0	41399.0
2023-12-26 04:00:00	DIA	ETF	374.42	374.45	374.35	374.35	900.0
2023-12-26 05:00:00	DIA	ETF	374.38	374.4	374.38	374.4	525.0

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

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