PREVIEW / etf_1hour / 2025-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-06-20.parquet
  size:    642 KB
  rows:    24,819

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
2025-06-20 04:00:00	SPY	ETF	595.23	596.9	593.67	593.7	57978.0
2025-06-20 05:00:00	SPY	ETF	593.83	594.99	593.83	594.94	32670.0
2025-06-20 06:00:00	SPY	ETF	594.94	595.02	594.29	594.76	32062.0
2025-06-20 07:00:00	SPY	ETF	594.72	597.3	594.67	596.16	287715.0
2025-06-20 08:00:00	SPY	ETF	595.03	597.9	594.2	597.72	781589.0
2025-06-20 09:00:00	SPY	ETF	597.77	599.46	597.16	597.35	6935179.0
2025-06-20 10:00:00	SPY	ETF	597.35	597.59	593.98	594.38	8397435.0
2025-06-20 11:00:00	SPY	ETF	594.37	596.37	593.5	594.702	6114727.0
2025-06-20 12:00:00	SPY	ETF	594.71	595.7	594.225	595.315	4107279.0
2025-06-20 13:00:00	SPY	ETF	595.33	595.97	592.86	594.04	5664378.0
2025-06-20 14:00:00	SPY	ETF	594.03	595.35	593.36	593.6	4600816.0
2025-06-20 15:00:00	SPY	ETF	593.62	594.97	593.24	594.23	12953408.0
2025-06-20 16:00:00	SPY	ETF	594.23	595.74	593.99	595.08	7349438.0
2025-06-20 17:00:00	SPY	ETF	595.09	595.15	594.8001	594.85	126096.0
2025-06-20 18:00:00	SPY	ETF	595.13	595.55	594.98	595.21	76891.0
2025-06-20 19:00:00	SPY	ETF	595.21	595.48	595.17	595.31	30658.0
2025-06-20 04:00:00	QQQ	ETF	528.57	529.16	527.1	527.19	60914.0
2025-06-20 05:00:00	QQQ	ETF	527.34	528.27	527.26	528.12	34390.0
2025-06-20 06:00:00	QQQ	ETF	528.15	528.32	527.68	528.07	55693.0
2025-06-20 07:00:00	QQQ	ETF	528.08	530.6	528.04	529.72	124774.0
2025-06-20 08:00:00	QQQ	ETF	528.27	531.45	527.4496	531.13	319287.0
2025-06-20 09:00:00	QQQ	ETF	531.16	533.56	530.7	530.86	4947124.0
2025-06-20 10:00:00	QQQ	ETF	530.86	531.17	525.64	526.13	6228774.0
2025-06-20 11:00:00	QQQ	ETF	526.11	528.6	525.1	526.842	5244701.0
2025-06-20 12:00:00	QQQ	ETF	526.85	528.14	526.52	527.73	3176811.0
2025-06-20 13:00:00	QQQ	ETF	527.73	528.42	524.88	526.6404	4414992.0
2025-06-20 14:00:00	QQQ	ETF	526.62	528.09	525.84	526.07	3399364.0
2025-06-20 15:00:00	QQQ	ETF	526.075	527.1	525.6	526.71	6685740.0
2025-06-20 16:00:00	QQQ	ETF	526.68	528.37	526.65	527.52	5679090.0
2025-06-20 17:00:00	QQQ	ETF	527.52	527.61	526.89	527.25	81256.0
2025-06-20 18:00:00	QQQ	ETF	527.11	527.48	527.06	527.32	30167.0
2025-06-20 19:00:00	QQQ	ETF	527.31	527.5901	527.25	527.5599	35255.0
2025-06-20 04:00:00	IWM	ETF	209.21	209.64	208.75	208.75	46801.0
2025-06-20 05:00:00	IWM	ETF	208.81	210.04	208.81	209.98	23163.0
2025-06-20 06:00:00	IWM	ETF	209.95	210.55	209.83	210.28	24962.0
2025-06-20 07:00:00	IWM	ETF	210.26	212.24	210.26	211.28	148848.0
2025-06-20 08:00:00	IWM	ETF	210.67	212.5	208.73	212.14	219160.0
2025-06-20 09:00:00	IWM	ETF	212.15	212.15	210.08	210.56	3757746.0
2025-06-20 10:00:00	IWM	ETF	210.59	210.81	209.23	209.465	4177616.0
2025-06-20 11:00:00	IWM	ETF	209.45	209.84	209.0	209.02	3334849.0
2025-06-20 12:00:00	IWM	ETF	209.035	209.575	208.96	209.36	2014854.0
2025-06-20 13:00:00	IWM	ETF	209.35	209.62	208.46	208.89	2328979.0
2025-06-20 14:00:00	IWM	ETF	208.88	209.43	208.8	208.9	1628755.0
2025-06-20 15:00:00	IWM	ETF	208.9	209.66	208.83	209.21	5086372.0
2025-06-20 16:00:00	IWM	ETF	209.21	209.84	209.13	209.83	1851345.0
2025-06-20 17:00:00	IWM	ETF	209.8	209.91	209.56	209.62	3830.0
2025-06-20 18:00:00	IWM	ETF	209.64	209.74	209.4	209.46	35234.0
2025-06-20 19:00:00	IWM	ETF	209.46	209.54	209.43	209.52	9072.0
2025-06-20 04:00:00	DIA	ETF	421.11	421.68	420.42	420.42	12050.0
2025-06-20 05:00:00	DIA	ETF	420.44	420.44	420.44	420.44	100.0

> showing 50 of 24,819 rows — these rows as CSV

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