PREVIEW / etf_1hour / 2026-04-13

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-04-13.parquet
  size:    743 KB
  rows:    29,722

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
2026-04-13 04:00:00	SPY	ETF	675.5	675.98	673.98	675.42	517831.0
2026-04-13 05:00:00	SPY	ETF	675.4	675.98	675.24	675.37	185555.0
2026-04-13 06:00:00	SPY	ETF	675.39	675.96	675.13	675.96	233873.0
2026-04-13 07:00:00	SPY	ETF	675.91	677.08	674.35	674.61	622689.0
2026-04-13 08:00:00	SPY	ETF	674.6	676.39	674.22	676.25	439171.0
2026-04-13 09:00:00	SPY	ETF	676.25	679.405	676.13	679.18	4778419.0
2026-04-13 10:00:00	SPY	ETF	679.22	680.66	678.4	680.62	4467758.0
2026-04-13 11:00:00	SPY	ETF	680.61	680.61	679.22	679.495	3443710.0
2026-04-13 12:00:00	SPY	ETF	679.49	682.83	679.015	682.33	5601084.0
2026-04-13 13:00:00	SPY	ETF	682.33	682.82	681.87	682.13	3254712.0
2026-04-13 14:00:00	SPY	ETF	682.14	683.47	682.12	683.29	3601515.0
2026-04-13 15:00:00	SPY	ETF	683.3	686.28	683.04	686.005	10063596.0
2026-04-13 16:00:00	SPY	ETF	686.01	686.7	685.77	686.57	5672356.0
2026-04-13 17:00:00	SPY	ETF	686.63	686.65	686.3	686.4	86790.0
2026-04-13 18:00:00	SPY	ETF	686.42	686.79	686.3	686.58	73776.0
2026-04-13 19:00:00	SPY	ETF	686.59	686.96	686.4	686.44	56455.0
2026-04-13 20:00:00	SPY	ETF	686.44	686.47	686.39	686.44	5601.0
2026-04-13 04:00:00	QQQ	ETF	606.2	607.45	605.48	606.68	233133.0
2026-04-13 05:00:00	QQQ	ETF	606.65	607.47	606.65	607.05	44193.0
2026-04-13 06:00:00	QQQ	ETF	607.07	607.89	606.92	607.86	64591.0
2026-04-13 07:00:00	QQQ	ETF	607.82	608.93	602.68	606.52	500628.0
2026-04-13 08:00:00	QQQ	ETF	606.5	610.612	606.05	608.403	278792.0
2026-04-13 09:00:00	QQQ	ETF	608.4	611.41	608.066	611.099	4337654.0
2026-04-13 10:00:00	QQQ	ETF	611.1	612.88	610.16	612.85	4042938.0
2026-04-13 11:00:00	QQQ	ETF	612.845	612.85	611.42	611.75	2249327.0
2026-04-13 12:00:00	QQQ	ETF	611.74	614.71	611.07	614.18	3755240.0
2026-04-13 13:00:00	QQQ	ETF	614.19	614.83	613.82	614.035	2060422.0
2026-04-13 14:00:00	QQQ	ETF	614.04	615.2	613.81	614.98	1861668.0
2026-04-13 15:00:00	QQQ	ETF	614.985	617.51	614.66	617.365	4011985.0
2026-04-13 16:00:00	QQQ	ETF	617.365	626.74	617.18	618.303	3284359.0
2026-04-13 17:00:00	QQQ	ETF	618.32	618.47	618.0	618.24	94115.0
2026-04-13 18:00:00	QQQ	ETF	618.24	618.7	617.94	618.604	116583.0
2026-04-13 19:00:00	QQQ	ETF	618.62	619.2	618.4	618.463	125214.0
2026-04-13 20:00:00	QQQ	ETF	618.478	618.48	618.45	618.45	1909.0
2026-04-13 04:00:00	IWM	ETF	258.82	259.06	257.67	258.82	54088.0
2026-04-13 05:00:00	IWM	ETF	258.83	259.21	258.75	258.93	21212.0
2026-04-13 06:00:00	IWM	ETF	258.87	259.17	258.75	259.11	46533.0
2026-04-13 07:00:00	IWM	ETF	259.21	259.83	258.64	258.81	219487.0
2026-04-13 08:00:00	IWM	ETF	258.733	260.1	258.68	259.95	220823.0
2026-04-13 09:00:00	IWM	ETF	259.93	261.91	259.9	261.9	3006424.0
2026-04-13 10:00:00	IWM	ETF	261.89	262.63	261.56	262.44	2427804.0
2026-04-13 11:00:00	IWM	ETF	262.43	262.46	261.57	261.845	1280097.0
2026-04-13 12:00:00	IWM	ETF	261.835	264.32	261.58	263.91	2477009.0
2026-04-13 13:00:00	IWM	ETF	263.91	264.17	263.655	263.665	1170529.0
2026-04-13 14:00:00	IWM	ETF	263.67	264.59	263.67	264.37	1507144.0
2026-04-13 15:00:00	IWM	ETF	264.37	265.36	264.34	265.005	3053998.0
2026-04-13 16:00:00	IWM	ETF	265.01	265.34	264.89	265.31	1374073.0
2026-04-13 17:00:00	IWM	ETF	265.32	265.39	265.11	265.32	54695.0
2026-04-13 18:00:00	IWM	ETF	265.38	265.9	265.38	265.82	75628.0
2026-04-13 19:00:00	IWM	ETF	265.85	266.07	265.55	265.639	32397.0

> showing 50 of 29,722 rows — these rows as CSV

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