PREVIEW / etf_1hour / 2026-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-03-20.parquet
  size:    637 KB
  rows:    25,430

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-03-20 04:00:00	SPY	ETF	659.2	659.81	658.42	658.69	49891.0
2026-03-20 05:00:00	SPY	ETF	658.57	659.1	655.15	655.58	136502.0
2026-03-20 06:00:00	SPY	ETF	655.67	655.71	653.2	654.74	291134.0
2026-03-20 07:00:00	SPY	ETF	654.78	656.31	654.59	655.77	538736.0
2026-03-20 08:00:00	SPY	ETF	655.75	659.75	653.26	656.6	751419.0
2026-03-20 09:00:00	SPY	ETF	656.66	657.05	653.0	653.15	10025234.0
2026-03-20 10:00:00	SPY	ETF	653.17	653.8111	651.2	652.12	12429268.0
2026-03-20 11:00:00	SPY	ETF	652.11	654.16	651.5	652.945	8364235.0
2026-03-20 12:00:00	SPY	ETF	652.97	653.99	651.95	652.77	6978676.0
2026-03-20 13:00:00	SPY	ETF	652.76	653.25	650.55	651.4	7935260.0
2026-03-20 14:00:00	SPY	ETF	651.41	651.695	647.64	648.07	15987935.0
2026-03-20 15:00:00	SPY	ETF	648.08	648.645	644.72	648.54	31313092.0
2026-03-20 16:00:00	SPY	ETF	648.51	656.8393	647.14	650.97	10425189.0
2026-03-20 17:00:00	SPY	ETF	650.97	655.0	650.09	654.36	3463780.0
2026-03-20 18:00:00	SPY	ETF	654.35	655.45	653.0	654.25	745894.0
2026-03-20 19:00:00	SPY	ETF	654.25	654.32	653.25	653.28	281102.0
2026-03-20 04:00:00	QQQ	ETF	593.87	594.2	592.78	592.85	122579.0
2026-03-20 05:00:00	QQQ	ETF	592.83	593.44	589.23	589.74	283979.0
2026-03-20 06:00:00	QQQ	ETF	589.91	589.94	587.06	589.16	338272.0
2026-03-20 07:00:00	QQQ	ETF	589.2	590.64	588.97	590.05	350614.0
2026-03-20 08:00:00	QQQ	ETF	590.08	594.3	587.19	591.26	762707.0
2026-03-20 09:00:00	QQQ	ETF	591.33	592.04	586.16	586.3	7958451.0
2026-03-20 10:00:00	QQQ	ETF	586.3	587.34	584.97	585.9	11437177.0
2026-03-20 11:00:00	QQQ	ETF	585.8987	587.63	585.1	586.91	6851685.0
2026-03-20 12:00:00	QQQ	ETF	586.91	587.94	585.08	585.94	6072337.0
2026-03-20 13:00:00	QQQ	ETF	585.94	586.42	583.38	584.48	5486700.0
2026-03-20 14:00:00	QQQ	ETF	584.48	584.71	581.06	581.55	7756309.0
2026-03-20 15:00:00	QQQ	ETF	581.57	582.15	578.54	582.11	15514990.0
2026-03-20 16:00:00	QQQ	ETF	582.07	591.5542	581.69	584.45	2886426.0
2026-03-20 17:00:00	QQQ	ETF	584.43	588.4	582.06	586.3	1727621.0
2026-03-20 18:00:00	QQQ	ETF	586.29	587.43	585.88	587.05	401695.0
2026-03-20 19:00:00	QQQ	ETF	587.05	587.6	586.6808	587.12	320284.0
2026-03-20 04:00:00	IWM	ETF	248.9	250.0	248.05	248.05	127482.0
2026-03-20 05:00:00	IWM	ETF	248.22	248.25	245.7	245.93	100173.0
2026-03-20 06:00:00	IWM	ETF	245.98	246.22	244.75	245.73	156641.0
2026-03-20 07:00:00	IWM	ETF	245.96	246.89	245.79	246.73	135016.0
2026-03-20 08:00:00	IWM	ETF	246.7	249.0	245.05	246.93	304833.0
2026-03-20 09:00:00	IWM	ETF	246.89	247.5	244.965	245.05	5036786.0
2026-03-20 10:00:00	IWM	ETF	245.06	245.46	243.39	244.14	6183861.0
2026-03-20 11:00:00	IWM	ETF	244.14	245.54	243.69	244.395	3633371.0
2026-03-20 12:00:00	IWM	ETF	244.4	245.07	243.65	244.49	3196872.0
2026-03-20 13:00:00	IWM	ETF	244.5	244.605	242.85	243.575	3896483.0
2026-03-20 14:00:00	IWM	ETF	243.57	243.74	241.22	241.515	5609020.0
2026-03-20 15:00:00	IWM	ETF	241.515	242.34	240.33	242.23	9398549.0
2026-03-20 16:00:00	IWM	ETF	242.23	247.8108	242.07	243.19	3014857.0
2026-03-20 17:00:00	IWM	ETF	243.07	245.99	242.22	245.65	1582085.0
2026-03-20 18:00:00	IWM	ETF	245.66	246.55	245.65	245.76	310304.0
2026-03-20 19:00:00	IWM	ETF	245.76	245.85	245.1	245.2218	62354.0
2026-03-20 04:00:00	DIA	ETF	461.08	461.48	460.68	460.8	1447.0
2026-03-20 05:00:00	DIA	ETF	460.64	460.88	458.31	458.32	21274.0

> showing 50 of 25,430 rows — these rows as CSV

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