PREVIEW / etf_1hour / 2025-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-07-14.parquet
  size:    659 KB
  rows:    25,848

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-14 04:00:00	SPY	ETF	621.42	621.91	621.1	621.67	44708.0
2025-07-14 05:00:00	SPY	ETF	621.65	622.09	621.63	622.08	38348.0
2025-07-14 06:00:00	SPY	ETF	622.05	622.1	621.63	621.69	59391.0
2025-07-14 07:00:00	SPY	ETF	621.74	622.31	621.47	621.88	133937.0
2025-07-14 08:00:00	SPY	ETF	621.86	622.31	620.0	622.0	286383.0
2025-07-14 09:00:00	SPY	ETF	622.02	623.46	621.77	622.67	5639872.0
2025-07-14 10:00:00	SPY	ETF	622.67	623.71	622.26	623.48	6480960.0
2025-07-14 11:00:00	SPY	ETF	623.47	624.39	623.2801	623.95	5288791.0
2025-07-14 12:00:00	SPY	ETF	623.94	624.48	623.63	624.28	3315786.0
2025-07-14 13:00:00	SPY	ETF	624.285	624.98	624.28	624.68	3792490.0
2025-07-14 14:00:00	SPY	ETF	624.68	625.1581	624.595	624.94	3123257.0
2025-07-14 15:00:00	SPY	ETF	624.94	625.12	624.3	624.74	8822158.0
2025-07-14 16:00:00	SPY	ETF	624.73	624.87	624.39	624.6	1829319.0
2025-07-14 17:00:00	SPY	ETF	624.52	624.77	624.44	624.66	60323.0
2025-07-14 18:00:00	SPY	ETF	624.55	624.55	623.85	623.91	56828.0
2025-07-14 19:00:00	SPY	ETF	623.93	624.17	623.81	624.12	40021.0
2025-07-14 04:00:00	QQQ	ETF	552.51	552.93	552.16	552.65	82356.0
2025-07-14 05:00:00	QQQ	ETF	552.66	553.05	552.5	552.96	33081.0
2025-07-14 06:00:00	QQQ	ETF	552.93	552.98	552.28	552.4	49237.0
2025-07-14 07:00:00	QQQ	ETF	552.5	553.0	552.16	552.71	73040.0
2025-07-14 08:00:00	QQQ	ETF	552.61	554.615	550.8	552.91	220596.0
2025-07-14 09:00:00	QQQ	ETF	552.91	554.87	551.63	553.27	4812366.0
2025-07-14 10:00:00	QQQ	ETF	553.28	555.18	553.15	555.17	4530540.0
2025-07-14 11:00:00	QQQ	ETF	555.16	555.9199	555.01	555.5801	3595312.0
2025-07-14 12:00:00	QQQ	ETF	555.57	556.32	555.36	556.16	2353535.0
2025-07-14 13:00:00	QQQ	ETF	556.17	556.945	556.1581	556.4201	3113899.0
2025-07-14 14:00:00	QQQ	ETF	556.42	556.79	556.225	556.57	2005169.0
2025-07-14 15:00:00	QQQ	ETF	556.58	556.76	555.7488	556.18	4248675.0
2025-07-14 16:00:00	QQQ	ETF	556.18	556.3	555.9	556.22	981649.0
2025-07-14 17:00:00	QQQ	ETF	556.2	556.33	556.0	556.22	42080.0
2025-07-14 18:00:00	QQQ	ETF	556.22	556.22	555.4	555.44	92026.0
2025-07-14 19:00:00	QQQ	ETF	555.38	555.73	555.35	555.68	30527.0
2025-07-14 04:00:00	IWM	ETF	219.86	220.9	219.86	220.89	29237.0
2025-07-14 05:00:00	IWM	ETF	220.92	221.14	220.77	221.0	13106.0
2025-07-14 06:00:00	IWM	ETF	221.0	221.14	220.93	221.06	4748.0
2025-07-14 07:00:00	IWM	ETF	221.08	221.23	220.8	221.09	41290.0
2025-07-14 08:00:00	IWM	ETF	221.05	221.1599	219.64	220.79	153454.0
2025-07-14 09:00:00	IWM	ETF	220.77	222.65	220.62	221.74	3532654.0
2025-07-14 10:00:00	IWM	ETF	221.74	222.6601	221.61	222.185	3343912.0
2025-07-14 11:00:00	IWM	ETF	222.17	222.51	221.655	222.245	2209242.0
2025-07-14 12:00:00	IWM	ETF	222.23	222.79	221.87	222.715	1777321.0
2025-07-14 13:00:00	IWM	ETF	222.72	222.978	222.505	222.675	1793849.0
2025-07-14 14:00:00	IWM	ETF	222.68	223.1174	222.665	222.86	1617153.0
2025-07-14 15:00:00	IWM	ETF	222.86	223.335	222.72	223.21	4221963.0
2025-07-14 16:00:00	IWM	ETF	223.21	223.27	222.97	223.11	843424.0
2025-07-14 17:00:00	IWM	ETF	223.03	223.19	222.96	223.09	36436.0
2025-07-14 18:00:00	IWM	ETF	222.99	222.99	222.74	222.9	18464.0
2025-07-14 19:00:00	IWM	ETF	222.71	222.91	222.7	222.91	9004.0
2025-07-14 04:00:00	DIA	ETF	442.06	442.06	441.65	441.99	1571.0
2025-07-14 05:00:00	DIA	ETF	442.12	442.3	442.0	442.3	370.0

> showing 50 of 25,848 rows — these rows as CSV

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