PREVIEW / etf_1hour / 2023-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-25.parquet
  size:    486 KB
  rows:    17,726

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-25 04:00:00	SPY	ETF	431.88	432.02	429.13	429.71	115336.0
2023-09-25 05:00:00	SPY	ETF	429.7	430.29	429.6	430.25	48060.0
2023-09-25 06:00:00	SPY	ETF	430.31	430.56	429.82	430.23	67274.0
2023-09-25 07:00:00	SPY	ETF	430.2	430.45	429.11	429.27	396048.0
2023-09-25 08:00:00	SPY	ETF	429.26	432.06	428.75	429.0617	550212.0
2023-09-25 09:00:00	SPY	ETF	429.1	430.76	428.23	430.56	6175731.0
2023-09-25 10:00:00	SPY	ETF	430.57	430.71	429.21	429.215	8008012.0
2023-09-25 11:00:00	SPY	ETF	429.211	431.69	429.14	431.27	7810610.0
2023-09-25 12:00:00	SPY	ETF	431.26	432.02	430.61	431.08	4854771.0
2023-09-25 13:00:00	SPY	ETF	431.1	431.85	430.62	431.47	4759958.0
2023-09-25 14:00:00	SPY	ETF	431.48	431.73	430.78	430.84	5754070.0
2023-09-25 15:00:00	SPY	ETF	430.86	432.27	429.98	432.22	13113007.0
2023-09-25 16:00:00	SPY	ETF	432.22	432.61	430.1728	432.55	3944768.0
2023-09-25 17:00:00	SPY	ETF	432.61	432.64	432.23	432.53	83119.0
2023-09-25 18:00:00	SPY	ETF	432.53	432.53	432.24	432.32	74960.0
2023-09-25 19:00:00	SPY	ETF	432.28	432.28	432.1	432.1	41179.0
2023-09-25 04:00:00	QQQ	ETF	359.34	359.52	356.35	357.3	228088.0
2023-09-25 05:00:00	QQQ	ETF	357.25	357.92	357.17	357.7	66127.0
2023-09-25 06:00:00	QQQ	ETF	357.78	358.15	357.29	357.82	37234.0
2023-09-25 07:00:00	QQQ	ETF	357.78	358.05	356.71	356.9	211577.0
2023-09-25 08:00:00	QQQ	ETF	356.89	359.6	356.39	356.89	485945.0
2023-09-25 09:00:00	QQQ	ETF	356.85	358.68	355.93	358.18	5797957.0
2023-09-25 10:00:00	QQQ	ETF	358.2	358.4	356.725	356.79	5407139.0
2023-09-25 11:00:00	QQQ	ETF	356.786	359.27	356.77	358.77	5000467.0
2023-09-25 12:00:00	QQQ	ETF	358.76	359.6	357.91	358.35	3046952.0
2023-09-25 13:00:00	QQQ	ETF	358.36	359.25	358.05	358.82	2564374.0
2023-09-25 14:00:00	QQQ	ETF	358.81	359.15	358.03	358.16	2608624.0
2023-09-25 15:00:00	QQQ	ETF	358.17	359.7	357.38	359.65	6007827.0
2023-09-25 16:00:00	QQQ	ETF	359.64	360.08	358.2253	360.03	1081388.0
2023-09-25 17:00:00	QQQ	ETF	359.99	360.14	359.88	360.11	73458.0
2023-09-25 18:00:00	QQQ	ETF	360.1	360.1	359.75	359.8	78015.0
2023-09-25 19:00:00	QQQ	ETF	359.8	359.8	359.56	359.58	89561.0
2023-09-25 04:00:00	IWM	ETF	177.35	177.36	176.15	176.28	10315.0
2023-09-25 05:00:00	IWM	ETF	176.28	176.49	176.24	176.33	7606.0
2023-09-25 06:00:00	IWM	ETF	176.42	176.42	175.94	176.2	7849.0
2023-09-25 07:00:00	IWM	ETF	176.26	176.35	175.97	176.03	61595.0
2023-09-25 08:00:00	IWM	ETF	176.19	176.34	175.71	175.72	114547.0
2023-09-25 09:00:00	IWM	ETF	175.73	177.265	175.5	177.215	3179100.0
2023-09-25 10:00:00	IWM	ETF	177.21	177.29	176.3	176.39	2447694.0
2023-09-25 11:00:00	IWM	ETF	176.39	177.57	176.38	177.38	2757865.0
2023-09-25 12:00:00	IWM	ETF	177.39	177.8599	177.261	177.63	1751767.0
2023-09-25 13:00:00	IWM	ETF	177.63	177.8499	177.24	177.585	1796725.0
2023-09-25 14:00:00	IWM	ETF	177.59	177.7	177.14	177.19	1657737.0
2023-09-25 15:00:00	IWM	ETF	177.2	177.55	176.885	177.49	4009396.0
2023-09-25 16:00:00	IWM	ETF	177.46	177.75	177.46	177.71	736138.0
2023-09-25 17:00:00	IWM	ETF	177.73	177.85	177.51	177.7	7691.0
2023-09-25 18:00:00	IWM	ETF	177.6	177.64	177.54	177.55	4674.0
2023-09-25 19:00:00	IWM	ETF	177.51	177.56	177.48	177.51	12246.0
2023-09-25 04:00:00	DIA	ETF	338.9	338.9	338.83	338.83	1100.0
2023-09-25 05:00:00	DIA	ETF	339.21	339.36	339.21	339.25	1020.0

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

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