PREVIEW / etf_1hour / 2025-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-03-07.parquet
  size:    645 KB
  rows:    24,595

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
2025-03-07 04:00:00	SPY	ETF	574.34	575.54	574.17	575.22	17508.0
2025-03-07 05:00:00	SPY	ETF	574.94	574.94	574.0	574.54	27940.0
2025-03-07 06:00:00	SPY	ETF	574.49	575.12	574.43	574.75	30614.0
2025-03-07 07:00:00	SPY	ETF	574.74	574.74	572.87	573.43	254393.0
2025-03-07 08:00:00	SPY	ETF	574.5	578.22	571.25	571.7494	2031297.0
2025-03-07 09:00:00	SPY	ETF	571.73	576.0678	570.4	573.95	5596342.0
2025-03-07 10:00:00	SPY	ETF	573.95	575.069	568.4281	570.91	9457887.0
2025-03-07 11:00:00	SPY	ETF	570.92	571.26	565.63	567.1	6822478.0
2025-03-07 12:00:00	SPY	ETF	567.12	573.08	565.8	570.185	9009006.0
2025-03-07 13:00:00	SPY	ETF	570.19	575.3	570.13	575.24	5857586.0
2025-03-07 14:00:00	SPY	ETF	575.27	577.31	574.13	575.1735	6480460.0
2025-03-07 15:00:00	SPY	ETF	575.16	577.39	572.81	575.85	9554061.0
2025-03-07 16:00:00	SPY	ETF	575.85	575.99	574.36	575.41	3663585.0
2025-03-07 17:00:00	SPY	ETF	575.59	575.75	574.82	574.95	208478.0
2025-03-07 18:00:00	SPY	ETF	575.02	575.02	574.75	574.8493	83958.0
2025-03-07 19:00:00	SPY	ETF	574.85	574.85	574.35	574.71	44812.0
2025-03-07 04:00:00	QQQ	ETF	490.43	491.79	490.2	491.09	72034.0
2025-03-07 05:00:00	QQQ	ETF	491.13	491.13	490.16	490.6	32338.0
2025-03-07 06:00:00	QQQ	ETF	490.43	491.29	490.0	490.75	112941.0
2025-03-07 07:00:00	QQQ	ETF	490.72	490.72	488.61	489.32	295986.0
2025-03-07 08:00:00	QQQ	ETF	489.32	492.89	487.26	487.92	1123422.0
2025-03-07 09:00:00	QQQ	ETF	487.92	492.18	486.92	489.75	5125154.0
2025-03-07 10:00:00	QQQ	ETF	489.7	490.98	483.57	486.75	6738829.0
2025-03-07 11:00:00	QQQ	ETF	486.77	487.11	480.53	482.1625	5889516.0
2025-03-07 12:00:00	QQQ	ETF	482.19	488.3224	480.73	484.93	5429772.0
2025-03-07 13:00:00	QQQ	ETF	485.0	490.62	484.94	490.46	4424971.0
2025-03-07 14:00:00	QQQ	ETF	490.47	492.97	489.26	491.02	4917307.0
2025-03-07 15:00:00	QQQ	ETF	491.02	493.28	488.71	491.81	5526226.0
2025-03-07 16:00:00	QQQ	ETF	491.81	492.0	489.87	491.19	1682999.0
2025-03-07 17:00:00	QQQ	ETF	491.28	491.31	490.71	490.71	92623.0
2025-03-07 18:00:00	QQQ	ETF	490.7175	491.07	490.7175	491.06	24593.0
2025-03-07 19:00:00	QQQ	ETF	490.9001	490.9988	490.61	490.901	16291.0
2025-03-07 04:00:00	IWM	ETF	205.61	206.25	205.6	205.9	25435.0
2025-03-07 05:00:00	IWM	ETF	205.85	205.9	205.47	205.9	9745.0
2025-03-07 06:00:00	IWM	ETF	205.82	205.93	205.7	205.92	11259.0
2025-03-07 07:00:00	IWM	ETF	205.91	206.35	205.38	205.77	69306.0
2025-03-07 08:00:00	IWM	ETF	205.94	208.34	204.5	205.17	1064912.0
2025-03-07 09:00:00	IWM	ETF	205.17	206.5	204.18	205.68	4612264.0
2025-03-07 10:00:00	IWM	ETF	205.67	206.29	203.2	204.19	4817954.0
2025-03-07 11:00:00	IWM	ETF	204.18	204.27	201.89	202.39	3511571.0
2025-03-07 12:00:00	IWM	ETF	202.42	205.035	201.73	203.97	4292386.0
2025-03-07 13:00:00	IWM	ETF	203.98	206.31	203.95	206.3	3267062.0
2025-03-07 14:00:00	IWM	ETF	206.31	207.105	205.75	206.29	3081440.0
2025-03-07 15:00:00	IWM	ETF	206.29	207.11	205.74	205.97	5059729.0
2025-03-07 16:00:00	IWM	ETF	205.95	206.06	205.61	205.98	1793404.0
2025-03-07 17:00:00	IWM	ETF	206.02	206.3	204.95	205.19	180001.0
2025-03-07 18:00:00	IWM	ETF	205.1	205.5002	205.1	205.3	82550.0
2025-03-07 19:00:00	IWM	ETF	205.38	205.49	205.25	205.44	26773.0
2025-03-07 04:00:00	DIA	ETF	426.58	427.11	426.58	427.11	1550.0
2025-03-07 05:00:00	DIA	ETF	426.81	426.81	426.57	426.75	1400.0

> showing 50 of 24,595 rows — these rows as CSV

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