PREVIEW / etf_1hour / 2025-02-28

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-02-28.parquet
  size:    639 KB
  rows:    24,739

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-02-28 04:00:00	SPY	ETF	586.1	587.23	586.1	586.9	32540.0
2025-02-28 05:00:00	SPY	ETF	587.0	587.47	586.79	587.06	19062.0
2025-02-28 06:00:00	SPY	ETF	587.15	587.6	587.0	587.23	59308.0
2025-02-28 07:00:00	SPY	ETF	587.21	587.25	586.01	586.69	301339.0
2025-02-28 08:00:00	SPY	ETF	586.81	587.52	584.81	586.24	502077.0
2025-02-28 09:00:00	SPY	ETF	586.34	586.73	583.27	586.03	6710346.0
2025-02-28 10:00:00	SPY	ETF	586.01	588.8998	585.225	588.86	5669846.0
2025-02-28 11:00:00	SPY	ETF	588.87	589.03	585.83	587.34	3362813.0
2025-02-28 12:00:00	SPY	ETF	587.3647	588.3	583.6	583.6866	4311189.0
2025-02-28 13:00:00	SPY	ETF	583.69	586.52	582.44	583.6025	7825737.0
2025-02-28 14:00:00	SPY	ETF	583.6	588.25	583.531	588.1	5378954.0
2025-02-28 15:00:00	SPY	ETF	588.09	594.72	587.7	594.07	16317413.0
2025-02-28 16:00:00	SPY	ETF	594.05	594.2	593.05	593.45	8133504.0
2025-02-28 17:00:00	SPY	ETF	593.4499	594.18	593.34	593.73	141774.0
2025-02-28 18:00:00	SPY	ETF	593.76	593.92	593.75	593.8799	113907.0
2025-02-28 19:00:00	SPY	ETF	593.87	594.3	593.51	594.3	220080.0
2025-02-28 04:00:00	QQQ	ETF	500.72	502.36	500.72	501.74	80683.0
2025-02-28 05:00:00	QQQ	ETF	501.94	502.2	501.48	501.77	51726.0
2025-02-28 06:00:00	QQQ	ETF	501.78	502.18	501.61	501.85	38323.0
2025-02-28 07:00:00	QQQ	ETF	501.81	501.81	499.86	500.81	279935.0
2025-02-28 08:00:00	QQQ	ETF	501.64	502.3796	499.35	500.32	827381.0
2025-02-28 09:00:00	QQQ	ETF	500.46	501.39	496.93	500.16	5625589.0
2025-02-28 10:00:00	QQQ	ETF	500.14	504.67	499.24	504.27	5268886.0
2025-02-28 11:00:00	QQQ	ETF	504.25	504.64	500.94	502.685	3082335.0
2025-02-28 12:00:00	QQQ	ETF	502.69	503.9499	498.811	498.875	3026831.0
2025-02-28 13:00:00	QQQ	ETF	498.8363	501.92	497.54	498.905	3892275.0
2025-02-28 14:00:00	QQQ	ETF	498.91	503.28	498.8205	503.05	2540493.0
2025-02-28 15:00:00	QQQ	ETF	503.05	508.78	502.39	508.22	8289892.0
2025-02-28 16:00:00	QQQ	ETF	508.21	508.39	506.95	507.86	2134090.0
2025-02-28 17:00:00	QQQ	ETF	507.87	508.1799	507.87	508.13	59320.0
2025-02-28 18:00:00	QQQ	ETF	508.0	508.25	507.9	508.16	22238.0
2025-02-28 19:00:00	QQQ	ETF	508.3	508.6	508.17	508.32	43999.0
2025-02-28 04:00:00	IWM	ETF	211.99	212.52	211.99	212.35	21084.0
2025-02-28 05:00:00	IWM	ETF	212.48	212.53	212.21	212.41	10369.0
2025-02-28 06:00:00	IWM	ETF	212.43	212.5	212.1	212.26	13818.0
2025-02-28 07:00:00	IWM	ETF	212.22	212.39	211.96	212.16	65056.0
2025-02-28 08:00:00	IWM	ETF	212.37	212.4904	211.63	212.0	552017.0
2025-02-28 09:00:00	IWM	ETF	212.08	212.67	210.955	212.27	2658237.0
2025-02-28 10:00:00	IWM	ETF	212.25	213.995	212.1	213.96	3732130.0
2025-02-28 11:00:00	IWM	ETF	213.96	214.14	212.77	213.6	1902586.0
2025-02-28 12:00:00	IWM	ETF	213.6	213.84	211.83	211.83	2541884.0
2025-02-28 13:00:00	IWM	ETF	211.84	212.89	211.14	211.7	2926373.0
2025-02-28 14:00:00	IWM	ETF	211.68	213.06	211.66	213.0	1846099.0
2025-02-28 15:00:00	IWM	ETF	212.98	214.66	212.84	214.66	5428820.0
2025-02-28 16:00:00	IWM	ETF	214.65	214.66	214.2399	214.49	1773717.0
2025-02-28 17:00:00	IWM	ETF	214.35	214.64	214.33	214.42	24202.0
2025-02-28 18:00:00	IWM	ETF	214.42	214.46	214.2	214.3794	22742.0
2025-02-28 19:00:00	IWM	ETF	214.3525	214.57	214.26	214.38	6009.0
2025-02-28 04:00:00	DIA	ETF	433.41	433.64	433.35	433.41	6421.0
2025-02-28 05:00:00	DIA	ETF	433.5	433.9	433.49	433.85	4294.0

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

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