PREVIEW / etf_1hour / 2026-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-05-19.parquet
  size:    711 KB
  rows:    28,160

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-19 04:00:00	SPY	ETF	738.97	739.33	735.35	737.44	169782.0
2026-05-19 05:00:00	SPY	ETF	737.12	737.13	734.56	735.94	93132.0
2026-05-19 06:00:00	SPY	ETF	735.86	736.2	734.55	736.08	68730.0
2026-05-19 07:00:00	SPY	ETF	736.08	736.6	735.0	735.0	158736.0
2026-05-19 08:00:00	SPY	ETF	735.01	737.65	734.65	736.1665	265425.0
2026-05-19 09:00:00	SPY	ETF	736.26	736.39	733.09	735.33	4172858.0
2026-05-19 10:00:00	SPY	ETF	735.31	735.34	731.53	733.16	6436872.0
2026-05-19 11:00:00	SPY	ETF	733.16	733.96	731.7	732.99	3279054.0
2026-05-19 12:00:00	SPY	ETF	733.0	736.3	732.32	736.12	3909210.0
2026-05-19 13:00:00	SPY	ETF	736.12	737.65	735.92	736.77	4499447.0
2026-05-19 14:00:00	SPY	ETF	736.83	737.31	734.2	734.45	4462384.0
2026-05-19 15:00:00	SPY	ETF	734.41	736.15	732.575	733.76	9623651.0
2026-05-19 16:00:00	SPY	ETF	733.79	734.3726	733.03	733.31	1879081.0
2026-05-19 17:00:00	SPY	ETF	733.425	733.7	733.3	733.6	124872.0
2026-05-19 18:00:00	SPY	ETF	733.55	734.05	732.85	733.53	170366.0
2026-05-19 19:00:00	SPY	ETF	733.53	735.34	733.5	734.25	79520.0
2026-05-19 04:00:00	QQQ	ETF	706.55	706.55	700.76	703.53	183672.0
2026-05-19 05:00:00	QQQ	ETF	703.31	703.4	699.53	701.32	137510.0
2026-05-19 06:00:00	QQQ	ETF	701.32	701.74	699.53	701.46	195594.0
2026-05-19 07:00:00	QQQ	ETF	701.58	702.13	699.95	699.95	172624.0
2026-05-19 08:00:00	QQQ	ETF	699.9	701.95	699.43	701.251	380202.0
2026-05-19 09:00:00	QQQ	ETF	701.38	706.409	698.72	701.87	5303997.0
2026-05-19 10:00:00	QQQ	ETF	701.91	702.05	695.25	698.67	8659249.0
2026-05-19 11:00:00	QQQ	ETF	698.65	700.44	696.83	699.0	4511018.0
2026-05-19 12:00:00	QQQ	ETF	698.99	704.26	698.42	703.97	4341790.0
2026-05-19 13:00:00	QQQ	ETF	703.95	706.49	703.655	705.15	4089847.0
2026-05-19 14:00:00	QQQ	ETF	705.18	705.93	702.02	702.44	3002524.0
2026-05-19 15:00:00	QQQ	ETF	702.44	704.87	700.2	701.54	5988514.0
2026-05-19 16:00:00	QQQ	ETF	701.55	702.0	700.72	700.96	1334427.0
2026-05-19 17:00:00	QQQ	ETF	700.9	701.7	700.88	701.7	158115.0
2026-05-19 18:00:00	QQQ	ETF	701.7	702.3	700.264	701.24	141169.0
2026-05-19 19:00:00	QQQ	ETF	701.27	703.95	701.13	702.26	139659.0
2026-05-19 04:00:00	IWM	ETF	276.51	276.59	274.56	275.73	49785.0
2026-05-19 05:00:00	IWM	ETF	275.49	275.5	274.1	274.85	27186.0
2026-05-19 06:00:00	IWM	ETF	274.74	275.02	274.0	274.92	70238.0
2026-05-19 07:00:00	IWM	ETF	274.9891	275.089	274.05	274.05	88166.0
2026-05-19 08:00:00	IWM	ETF	274.04	274.7009	273.83	274.6	103107.0
2026-05-19 09:00:00	IWM	ETF	274.62	274.62	271.58	272.27	3874232.0
2026-05-19 10:00:00	IWM	ETF	272.25	272.29	270.63	271.4999	5125128.0
2026-05-19 11:00:00	IWM	ETF	271.48	272.845	271.26	272.31	1754264.0
2026-05-19 12:00:00	IWM	ETF	272.33	274.01	272.02	273.96	1638486.0
2026-05-19 13:00:00	IWM	ETF	273.96	275.075	273.67	274.07	2358804.0
2026-05-19 14:00:00	IWM	ETF	274.09	274.67	273.115	273.2999	2214018.0
2026-05-19 15:00:00	IWM	ETF	273.29	274.3	272.68	273.01	3874016.0
2026-05-19 16:00:00	IWM	ETF	273.04	273.15	272.74	272.97	1022380.0
2026-05-19 17:00:00	IWM	ETF	272.9	273.2664	272.8	272.89	395393.0
2026-05-19 18:00:00	IWM	ETF	272.89	273.05	272.6	272.96	66568.0
2026-05-19 19:00:00	IWM	ETF	272.97	273.74	272.97	273.2	25936.0
2026-05-19 04:00:00	DIA	ETF	496.09	497.63	495.96	496.98	3225.0
2026-05-19 05:00:00	DIA	ETF	496.76	496.76	495.5	496.02	542.0

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

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