PREVIEW / etf_1hour / 2026-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-05-05.parquet
  size:    718 KB
  rows:    28,816

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-05-05 04:00:00	SPY	ETF	719.89	720.75	718.6913	720.61	72151.0
2026-05-05 05:00:00	SPY	ETF	720.39	720.86	720.11	720.54	19552.0
2026-05-05 06:00:00	SPY	ETF	720.64	721.2	720.4	720.58	59066.0
2026-05-05 07:00:00	SPY	ETF	720.61	721.1	719.96	720.94	182938.0
2026-05-05 08:00:00	SPY	ETF	720.87	721.95	720.72	721.3	274851.0
2026-05-05 09:00:00	SPY	ETF	721.26	722.79	721.22	722.53	3798636.0
2026-05-05 10:00:00	SPY	ETF	722.6	723.67	721.79	723.14	5072816.0
2026-05-05 11:00:00	SPY	ETF	723.15	723.65	722.91	723.04	2295006.0
2026-05-05 12:00:00	SPY	ETF	723.04	723.87	722.96	723.47	1968681.0
2026-05-05 13:00:00	SPY	ETF	723.47	724.22	723.12	724.01	2269795.0
2026-05-05 14:00:00	SPY	ETF	724.01	724.7	724.0	724.32	2258208.0
2026-05-05 15:00:00	SPY	ETF	724.33	725.04	723.27	723.74	7666912.0
2026-05-05 16:00:00	SPY	ETF	723.71	725.39	723.1	724.59	2788154.0
2026-05-05 17:00:00	SPY	ETF	724.57	725.03	724.57	724.84	75433.0
2026-05-05 18:00:00	SPY	ETF	724.92	727.07	724.4	726.69	226241.0
2026-05-05 19:00:00	SPY	ETF	726.68	726.92	726.27	726.46	80242.0
2026-05-05 04:00:00	QQQ	ETF	674.85	676.78	673.98	676.52	157252.0
2026-05-05 05:00:00	QQQ	ETF	676.36	677.15	676.07	676.65	69272.0
2026-05-05 06:00:00	QQQ	ETF	676.71	677.26	676.37	676.63	76809.0
2026-05-05 07:00:00	QQQ	ETF	676.62	676.93	675.82	676.89	185657.0
2026-05-05 08:00:00	QQQ	ETF	676.85	678.36	676.53	677.63	321701.0
2026-05-05 09:00:00	QQQ	ETF	677.64	680.92	677.51	680.2199	4484934.0
2026-05-05 10:00:00	QQQ	ETF	680.23	681.58	679.01	680.53	3809441.0
2026-05-05 11:00:00	QQQ	ETF	680.55	681.81	680.34	681.31	2477909.0
2026-05-05 12:00:00	QQQ	ETF	681.315	681.94	680.42	681.2701	2006124.0
2026-05-05 13:00:00	QQQ	ETF	681.282	682.29	680.87	682.1	1711342.0
2026-05-05 14:00:00	QQQ	ETF	682.0901	682.72	681.95	682.3099	1689074.0
2026-05-05 15:00:00	QQQ	ETF	682.302	682.7734	680.8683	681.53	3411121.0
2026-05-05 16:00:00	QQQ	ETF	681.51	684.1622	680.99	683.29	2069891.0
2026-05-05 17:00:00	QQQ	ETF	683.24	684.4	683.04	684.25	205070.0
2026-05-05 18:00:00	QQQ	ETF	684.36	688.27	684.22	687.27	347827.0
2026-05-05 19:00:00	QQQ	ETF	687.4	687.58	686.62	687.25	171554.0
2026-05-05 04:00:00	IWM	ETF	278.96	279.59	278.37	279.33	48868.0
2026-05-05 05:00:00	IWM	ETF	279.23	279.74	279.14	279.51	16425.0
2026-05-05 06:00:00	IWM	ETF	279.49	279.73	279.09	279.22	36534.0
2026-05-05 07:00:00	IWM	ETF	279.21	279.77	278.77	279.72	171438.0
2026-05-05 08:00:00	IWM	ETF	279.67	280.36	278.63	280.08	397525.0
2026-05-05 09:00:00	IWM	ETF	280.09	280.93	279.91	280.46	2898536.0
2026-05-05 10:00:00	IWM	ETF	280.53	282.34	280.3	281.9	5505536.0
2026-05-05 11:00:00	IWM	ETF	281.905	282.34	281.66	281.99	1908805.0
2026-05-05 12:00:00	IWM	ETF	282.0	282.48	281.65	281.675	1193411.0
2026-05-05 13:00:00	IWM	ETF	281.685	282.365	281.595	282.09	1088754.0
2026-05-05 14:00:00	IWM	ETF	282.09	282.76	282.09	282.68	1046725.0
2026-05-05 15:00:00	IWM	ETF	282.67	282.945	282.22	282.58	3100061.0
2026-05-05 16:00:00	IWM	ETF	282.56	282.83	277.7727	282.28	1514304.0
2026-05-05 17:00:00	IWM	ETF	282.29	282.4	282.08	282.23	13393.0
2026-05-05 18:00:00	IWM	ETF	282.21	284.23	282.21	284.23	203875.0
2026-05-05 19:00:00	IWM	ETF	284.24	284.33	283.35	283.42	125853.0
2026-05-05 04:00:00	DIA	ETF	489.86	491.3	489.85	490.76	5232.0
2026-05-05 05:00:00	DIA	ETF	490.61	491.03	490.56	491.03	1040.0

> showing 50 of 28,816 rows — these rows as CSV

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