PREVIEW / etf_1hour / 2026-03-19

all etf 1-hour files

  file:    by_date/etf_1hour/2026/2026-03-19.parquet
  size:    648 KB
  rows:    25,677

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-19 04:00:00	SPY	ETF	660.44	660.63	658.72	659.65	132970.0
2026-03-19 05:00:00	SPY	ETF	660.0	662.06	658.58	661.6	399950.0
2026-03-19 06:00:00	SPY	ETF	661.52	661.62	660.4	660.68	163435.0
2026-03-19 07:00:00	SPY	ETF	660.69	661.22	658.94	659.95	381785.0
2026-03-19 08:00:00	SPY	ETF	660.62	662.06	656.4	656.95	1397968.0
2026-03-19 09:00:00	SPY	ETF	656.9703	658.96	655.17	658.66	12231309.0
2026-03-19 10:00:00	SPY	ETF	658.64	659.47	656.04	657.7985	10191796.0
2026-03-19 11:00:00	SPY	ETF	657.79	659.71	656.18	657.925	10635719.0
2026-03-19 12:00:00	SPY	ETF	657.91	659.04	656.61	657.168	7941243.0
2026-03-19 13:00:00	SPY	ETF	657.16	657.88	655.61	657.24	6269666.0
2026-03-19 14:00:00	SPY	ETF	657.23	658.81	656.32	658.45	8664389.0
2026-03-19 15:00:00	SPY	ETF	658.44	662.98	658.39	659.735	24497968.0
2026-03-19 16:00:00	SPY	ETF	659.73	661.29	659.33	660.8	6177584.0
2026-03-19 17:00:00	SPY	ETF	660.74	661.14	660.74	661.14	131322.0
2026-03-19 18:00:00	SPY	ETF	661.17	661.78	660.58	661.51	129256.0
2026-03-19 19:00:00	SPY	ETF	661.54	661.97	660.88	661.1	85828.0
2026-03-19 04:00:00	QQQ	ETF	592.61	593.47	591.44	592.3	206766.0
2026-03-19 05:00:00	QQQ	ETF	592.52	594.85	591.38	594.27	386431.0
2026-03-19 06:00:00	QQQ	ETF	594.27	594.27	593.02	593.48	128882.0
2026-03-19 07:00:00	QQQ	ETF	593.47	593.97	591.5	592.4	344552.0
2026-03-19 08:00:00	QQQ	ETF	591.63	595.22	589.45	589.99	1140091.0
2026-03-19 09:00:00	QQQ	ETF	589.97	591.76	587.08	591.3	9398157.0
2026-03-19 10:00:00	QQQ	ETF	591.28	592.37	589.05	591.04	10133285.0
2026-03-19 11:00:00	QQQ	ETF	591.03	593.13	588.8	590.68	7699942.0
2026-03-19 12:00:00	QQQ	ETF	590.67	591.8	589.45	590.21	5533091.0
2026-03-19 13:00:00	QQQ	ETF	590.2	590.88	588.37	590.13	5865069.0
2026-03-19 14:00:00	QQQ	ETF	590.13	591.83	589.33	591.46	6036132.0
2026-03-19 15:00:00	QQQ	ETF	591.46	595.8	591.41	592.99	13413125.0
2026-03-19 16:00:00	QQQ	ETF	592.98	594.38	592.75	594.02	1694536.0
2026-03-19 17:00:00	QQQ	ETF	594.0	594.64	594.0	594.5	157403.0
2026-03-19 18:00:00	QQQ	ETF	594.44	594.95	593.72	594.5098	136493.0
2026-03-19 19:00:00	QQQ	ETF	594.5	595.01	593.8	594.11	121180.0
2026-03-19 04:00:00	IWM	ETF	245.0	245.45	244.15	244.5	81951.0
2026-03-19 05:00:00	IWM	ETF	244.62	245.69	243.82	245.49	183296.0
2026-03-19 06:00:00	IWM	ETF	245.35	245.44	244.45	244.62	45828.0
2026-03-19 07:00:00	IWM	ETF	244.65	244.89	243.71	244.6	320635.0
2026-03-19 08:00:00	IWM	ETF	244.51	246.21	242.93	243.1	583923.0
2026-03-19 09:00:00	IWM	ETF	243.05	244.91	242.14	244.91	4875462.0
2026-03-19 10:00:00	IWM	ETF	244.88	245.61	243.82	245.13	4542110.0
2026-03-19 11:00:00	IWM	ETF	245.12	246.39	244.26	245.15	3994196.0
2026-03-19 12:00:00	IWM	ETF	245.16	246.01	244.65	245.34	3603973.0
2026-03-19 13:00:00	IWM	ETF	245.34	245.475	243.84	244.74	2497128.0
2026-03-19 14:00:00	IWM	ETF	244.72	246.635	244.58	246.57	3693450.0
2026-03-19 15:00:00	IWM	ETF	246.59	250.085	246.5	247.62	12625597.0
2026-03-19 16:00:00	IWM	ETF	247.63	248.37	247.38	248.1	1013322.0
2026-03-19 17:00:00	IWM	ETF	248.11	248.3	248.05	248.06	16462.0
2026-03-19 18:00:00	IWM	ETF	248.14	248.88	248.06	248.6	84695.0
2026-03-19 19:00:00	IWM	ETF	248.66	249.0	248.54	248.7085	37535.0
2026-03-19 04:00:00	DIA	ETF	462.15	462.72	461.37	461.89	13016.0
2026-03-19 05:00:00	DIA	ETF	462.34	463.51	461.07	463.26	34927.0

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

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