PREVIEW / etf_1hour / 2025-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-05-12.parquet
  size:    683 KB
  rows:    26,598

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-05-12 04:00:00	SPY	ETF	571.12	580.05	571.11	579.48	212631.0
2025-05-12 05:00:00	SPY	ETF	579.5	580.46	579.32	580.31	121519.0
2025-05-12 06:00:00	SPY	ETF	580.33	582.53	580.04	582.26	951807.0
2025-05-12 07:00:00	SPY	ETF	582.2	582.92	580.28	581.0	946632.0
2025-05-12 08:00:00	SPY	ETF	582.0201	582.9001	572.48	581.29	660278.0
2025-05-12 09:00:00	SPY	ETF	581.32	581.9	578.34	578.79	8163782.0
2025-05-12 10:00:00	SPY	ETF	578.8	580.5	577.04	579.05	8055954.0
2025-05-12 11:00:00	SPY	ETF	579.06	579.7315	578.035	578.1695	5571940.0
2025-05-12 12:00:00	SPY	ETF	578.16	581.22	577.9775	581.06	4354513.0
2025-05-12 13:00:00	SPY	ETF	581.08	582.43	580.97	581.5006	4906745.0
2025-05-12 14:00:00	SPY	ETF	581.51	582.58	581.32	581.54	4164938.0
2025-05-12 15:00:00	SPY	ETF	581.55	583.0	580.8	582.84	12530608.0
2025-05-12 16:00:00	SPY	ETF	582.84	583.96	564.4344	583.2	6064794.0
2025-05-12 17:00:00	SPY	ETF	583.2084	583.2084	583.03	583.17	92558.0
2025-05-12 18:00:00	SPY	ETF	583.17	583.24	582.33	582.3507	128371.0
2025-05-12 19:00:00	SPY	ETF	582.5	583.37	582.11	582.13	51109.0
2025-05-12 04:00:00	QQQ	ETF	497.33	506.5	496.33	506.0	349068.0
2025-05-12 05:00:00	QQQ	ETF	506.05	506.92	505.97	506.76	159422.0
2025-05-12 06:00:00	QQQ	ETF	506.74	508.55	506.23	508.4	326491.0
2025-05-12 07:00:00	QQQ	ETF	508.28	508.85	506.14	506.91	531496.0
2025-05-12 08:00:00	QQQ	ETF	507.66	508.6697	487.605	506.95	819374.0
2025-05-12 09:00:00	QQQ	ETF	506.92	507.4799	502.78	503.8	5812827.0
2025-05-12 10:00:00	QQQ	ETF	503.83	505.32	501.48	503.41	4873340.0
2025-05-12 11:00:00	QQQ	ETF	503.45	504.28	503.03	503.31	2311557.0
2025-05-12 12:00:00	QQQ	ETF	503.33	506.17	503.13	506.01	2444169.0
2025-05-12 13:00:00	QQQ	ETF	506.0593	507.38	505.895	506.75	2595434.0
2025-05-12 14:00:00	QQQ	ETF	506.77	507.59	506.42	506.46	2239363.0
2025-05-12 15:00:00	QQQ	ETF	506.46	507.89	505.58	507.8	5309109.0
2025-05-12 16:00:00	QQQ	ETF	507.79	508.9	507.52	508.0	2775438.0
2025-05-12 17:00:00	QQQ	ETF	508.0	508.12	507.81	507.87	71452.0
2025-05-12 18:00:00	QQQ	ETF	507.91	508.0	506.93	507.02	74261.0
2025-05-12 19:00:00	QQQ	ETF	507.0801	508.08	506.8	506.8	99976.0
2025-05-12 04:00:00	IWM	ETF	208.52	208.67	207.02	207.22	172183.0
2025-05-12 05:00:00	IWM	ETF	207.19	209.73	207.12	209.55	209819.0
2025-05-12 06:00:00	IWM	ETF	209.66	211.06	209.24	211.04	584372.0
2025-05-12 07:00:00	IWM	ETF	211.03	211.05	209.69	209.76	461044.0
2025-05-12 08:00:00	IWM	ETF	210.63	211.81	204.66	209.2	782575.0
2025-05-12 09:00:00	IWM	ETF	209.22	209.73	208.24	208.37	6618253.0
2025-05-12 10:00:00	IWM	ETF	208.43	208.86	205.82	206.6	4278438.0
2025-05-12 11:00:00	IWM	ETF	206.6	206.87	206.08	206.35	2240126.0
2025-05-12 12:00:00	IWM	ETF	206.36	207.92	206.26	207.88	2183888.0
2025-05-12 13:00:00	IWM	ETF	207.88	208.52	207.79	207.89	1785136.0
2025-05-12 14:00:00	IWM	ETF	207.89	208.13	207.57	207.66	1957526.0
2025-05-12 15:00:00	IWM	ETF	207.67	208.13	207.52	207.91	5875998.0
2025-05-12 16:00:00	IWM	ETF	207.87	208.3	207.81	208.05	1873801.0
2025-05-12 17:00:00	IWM	ETF	207.9918	208.1	207.9	208.1	8823.0
2025-05-12 18:00:00	IWM	ETF	208.06	208.06	207.59	207.62	10522.0
2025-05-12 19:00:00	IWM	ETF	207.63	207.9389	207.38	207.42	34600.0
2025-05-12 04:00:00	DIA	ETF	420.52	421.21	420.2	420.85	10723.0
2025-05-12 05:00:00	DIA	ETF	420.79	421.32	420.75	421.32	2600.0

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

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