PREVIEW / etf_1hour / 2026-06-10

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-06-10.parquet
  size:    724 KB
  rows:    28,920

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-06-10 04:00:00	SPY	ETF	735.47	735.47	731.26	731.5	147736.0
2026-06-10 05:00:00	SPY	ETF	731.55	732.13	729.95	731.7	175255.0
2026-06-10 06:00:00	SPY	ETF	731.7	732.53	730.48	732.34	100350.0
2026-06-10 07:00:00	SPY	ETF	732.37	732.51	728.31	730.32	1133852.0
2026-06-10 08:00:00	SPY	ETF	730.2	736.8	730.0	732.9404	1351240.0
2026-06-10 09:00:00	SPY	ETF	732.98	736.98	731.5	735.72	4665829.0
2026-06-10 10:00:00	SPY	ETF	735.75	738.38	732.26	732.84	5732974.0
2026-06-10 11:00:00	SPY	ETF	732.87	734.42	728.49	731.95	6627086.0
2026-06-10 12:00:00	SPY	ETF	731.98	732.51	729.4	730.3601	2795313.0
2026-06-10 13:00:00	SPY	ETF	730.36	731.37	727.86	730.66	3947512.0
2026-06-10 14:00:00	SPY	ETF	730.69	731.77	727.0	727.43	4459768.0
2026-06-10 15:00:00	SPY	ETF	727.44	728.13	725.33	725.42	11313229.0
2026-06-10 16:00:00	SPY	ETF	725.43	730.974	723.56	724.6	4430936.0
2026-06-10 17:00:00	SPY	ETF	724.55	724.96	724.23	724.39	146343.0
2026-06-10 18:00:00	SPY	ETF	724.31	724.58	722.28	722.32	332845.0
2026-06-10 19:00:00	SPY	ETF	722.31	724.2192	721.23	722.88	386443.0
2026-06-10 04:00:00	QQQ	ETF	704.95	705.45	698.955	699.26	520815.0
2026-06-10 05:00:00	QQQ	ETF	699.38	700.99	697.49	699.72	241138.0
2026-06-10 06:00:00	QQQ	ETF	699.6	701.2831	697.91	700.96	265994.0
2026-06-10 07:00:00	QQQ	ETF	700.91	701.36	695.66	697.39	803033.0
2026-06-10 08:00:00	QQQ	ETF	697.46	707.3	696.89	701.11	1750791.0
2026-06-10 09:00:00	QQQ	ETF	701.11	709.17	699.62	705.7	6971193.0
2026-06-10 10:00:00	QQQ	ETF	705.75	711.28	701.69	702.79	6535099.0
2026-06-10 11:00:00	QQQ	ETF	702.8	704.878	696.18	701.69	9322557.0
2026-06-10 12:00:00	QQQ	ETF	701.73	702.64	697.03	698.3	4566011.0
2026-06-10 13:00:00	QQQ	ETF	698.34	700.15	695.87	699.82	4305302.0
2026-06-10 14:00:00	QQQ	ETF	699.88	701.07	694.87	695.65	3758250.0
2026-06-10 15:00:00	QQQ	ETF	695.6501	697.1	692.93	693.72	8522366.0
2026-06-10 16:00:00	QQQ	ETF	693.71	693.98	690.9	692.29	2695326.0
2026-06-10 17:00:00	QQQ	ETF	692.18	692.6	691.55	691.74	245313.0
2026-06-10 18:00:00	QQQ	ETF	691.9	692.24	688.92	689.25	460479.0
2026-06-10 19:00:00	QQQ	ETF	689.18	691.62	687.4	689.73	499174.0
2026-06-10 04:00:00	IWM	ETF	283.89	284.47	282.13	282.19	81804.0
2026-06-10 05:00:00	IWM	ETF	282.33	283.1	281.76	282.93	63181.0
2026-06-10 06:00:00	IWM	ETF	282.87	283.31	282.3	283.06	76884.0
2026-06-10 07:00:00	IWM	ETF	283.15	283.4	280.8	282.38	475898.0
2026-06-10 08:00:00	IWM	ETF	282.37	285.8	282.2	284.43	601806.0
2026-06-10 09:00:00	IWM	ETF	284.41	288.96	283.9	287.93	4275620.0
2026-06-10 10:00:00	IWM	ETF	287.95	289.0	284.91	285.375	4790881.0
2026-06-10 11:00:00	IWM	ETF	285.4	286.54	282.98	285.16	6435886.0
2026-06-10 12:00:00	IWM	ETF	285.19	285.36	283.59	284.32	2959000.0
2026-06-10 13:00:00	IWM	ETF	284.35	284.83	283.08	284.72	2711283.0
2026-06-10 14:00:00	IWM	ETF	284.725	285.15	282.43	282.96	3031914.0
2026-06-10 15:00:00	IWM	ETF	282.98	283.05	281.76	282.02	5014056.0
2026-06-10 16:00:00	IWM	ETF	282.05	282.08	281.11	281.56	1980851.0
2026-06-10 17:00:00	IWM	ETF	281.51	281.74	281.22	281.65	125716.0
2026-06-10 18:00:00	IWM	ETF	281.56	281.56	279.91	280.21	77400.0
2026-06-10 19:00:00	IWM	ETF	280.05	280.88	279.65	280.3192	67562.0
2026-06-10 04:00:00	DIA	ETF	507.92	508.93	506.57	506.57	6477.0
2026-06-10 05:00:00	DIA	ETF	506.32	506.59	505.37	506.59	806.0

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

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