PREVIEW / etf_1hour / 2025-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-31.parquet
  size:    671 KB
  rows:    26,215

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-07-31 04:00:00	SPY	ETF	640.64	641.46	640.22	640.98	66696.0
2025-07-31 05:00:00	SPY	ETF	641.0	641.02	640.4	640.57	37711.0
2025-07-31 06:00:00	SPY	ETF	640.56	640.95	639.97	640.08	114187.0
2025-07-31 07:00:00	SPY	ETF	640.01	640.41	639.69	639.83	234741.0
2025-07-31 08:00:00	SPY	ETF	640.23	641.52	639.66	640.39	531048.0
2025-07-31 09:00:00	SPY	ETF	640.34	640.39	637.69	639.34	9086493.0
2025-07-31 10:00:00	SPY	ETF	639.345	639.809	636.5099	636.61	8915573.0
2025-07-31 11:00:00	SPY	ETF	636.605	637.55	635.06	637.54	7754950.0
2025-07-31 12:00:00	SPY	ETF	637.55	638.31	637.21	637.79	4699063.0
2025-07-31 13:00:00	SPY	ETF	637.78	637.79	633.065	633.47	9172225.0
2025-07-31 14:00:00	SPY	ETF	633.47	635.125	631.43	634.15	9822658.0
2025-07-31 15:00:00	SPY	ETF	634.16	634.85	630.765	631.97	20276237.0
2025-07-31 16:00:00	SPY	ETF	631.97	634.2	630.65	631.76	4442835.0
2025-07-31 17:00:00	SPY	ETF	631.66	632.47	631.26	631.26	303440.0
2025-07-31 18:00:00	SPY	ETF	631.2	632.17	629.99	630.73	245628.0
2025-07-31 19:00:00	SPY	ETF	630.74	631.21	630.36	631.08	101318.0
2025-07-31 04:00:00	QQQ	ETF	576.05	577.0	575.67	575.79	136307.0
2025-07-31 05:00:00	QQQ	ETF	575.82	575.93	575.39	575.41	64916.0
2025-07-31 06:00:00	QQQ	ETF	575.44	575.9	575.21	575.38	38684.0
2025-07-31 07:00:00	QQQ	ETF	575.25	575.8	574.7	574.96	162883.0
2025-07-31 08:00:00	QQQ	ETF	574.98	576.93	574.7	575.91	354312.0
2025-07-31 09:00:00	QQQ	ETF	575.91	575.92	571.2	572.66	6835098.0
2025-07-31 10:00:00	QQQ	ETF	572.665	573.37	569.42	569.58	5371038.0
2025-07-31 11:00:00	QQQ	ETF	569.57	570.6	568.175	570.6	5193421.0
2025-07-31 12:00:00	QQQ	ETF	570.6	571.42	569.975	570.275	2886733.0
2025-07-31 13:00:00	QQQ	ETF	570.29	570.315	565.33	565.9	5815623.0
2025-07-31 14:00:00	QQQ	ETF	565.89	567.71	563.87	566.49	5957733.0
2025-07-31 15:00:00	QQQ	ETF	566.49	567.17	564.0118	565.0	8100693.0
2025-07-31 16:00:00	QQQ	ETF	565.01	567.36	563.51	564.42	2299789.0
2025-07-31 17:00:00	QQQ	ETF	564.41	565.11	563.3	563.37	286519.0
2025-07-31 18:00:00	QQQ	ETF	564.09	564.69	562.44	563.43	237989.0
2025-07-31 19:00:00	QQQ	ETF	563.13	563.8999	562.87	563.61	198894.0
2025-07-31 04:00:00	IWM	ETF	221.28	221.51	221.17	221.34	43075.0
2025-07-31 05:00:00	IWM	ETF	221.26	221.36	220.67	220.94	12225.0
2025-07-31 06:00:00	IWM	ETF	220.91	221.0	220.5	220.5	19676.0
2025-07-31 07:00:00	IWM	ETF	220.51	220.65	220.26	220.37	150308.0
2025-07-31 08:00:00	IWM	ETF	220.52	221.48	220.01	220.47	338219.0
2025-07-31 09:00:00	IWM	ETF	220.52	221.68	219.88	221.6	5799958.0
2025-07-31 10:00:00	IWM	ETF	221.61	222.02	220.205	220.23	4212067.0
2025-07-31 11:00:00	IWM	ETF	220.23	221.02	219.89	220.9	3767561.0
2025-07-31 12:00:00	IWM	ETF	220.9	221.49	220.69	221.2801	2327421.0
2025-07-31 13:00:00	IWM	ETF	221.28	221.29	219.27	219.49	4263500.0
2025-07-31 14:00:00	IWM	ETF	219.5	220.28	218.88	219.97	3994878.0
2025-07-31 15:00:00	IWM	ETF	219.995	220.42	219.045	219.43	7225556.0
2025-07-31 16:00:00	IWM	ETF	219.42	224.56	219.2	219.26	1522223.0
2025-07-31 17:00:00	IWM	ETF	219.19	219.34	218.81	219.0	105359.0
2025-07-31 18:00:00	IWM	ETF	219.0	219.71	218.94	219.27	110942.0
2025-07-31 19:00:00	IWM	ETF	219.21	219.49	219.06	219.22	68749.0
2025-07-31 04:00:00	DIA	ETF	446.7	446.81	446.35	446.55	5300.0
2025-07-31 05:00:00	DIA	ETF	446.55	446.55	446.02	446.29	3100.0

> showing 50 of 26,215 rows — these rows as CSV

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