PREVIEW / etf_1hour / 2025-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-02-06.parquet
  size:    623 KB
  rows:    23,694

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-06 04:00:00	SPY	ETF	605.59	606.03	605.45	605.48	15225.0
2025-02-06 05:00:00	SPY	ETF	605.48	605.75	605.16	605.16	14542.0
2025-02-06 06:00:00	SPY	ETF	605.1	605.1	604.34	604.5	48655.0
2025-02-06 07:00:00	SPY	ETF	604.47	605.35	604.33	605.3	184204.0
2025-02-06 08:00:00	SPY	ETF	604.36	606.0304	604.3318	605.68	119582.0
2025-02-06 09:00:00	SPY	ETF	605.7	606.22	604.94	605.2699	2828967.0
2025-02-06 10:00:00	SPY	ETF	605.22	605.945	604.16	604.62	2416008.0
2025-02-06 11:00:00	SPY	ETF	604.63	605.6999	604.54	605.12	1608456.0
2025-02-06 12:00:00	SPY	ETF	605.13	605.78	604.75	605.61	1270702.0
2025-02-06 13:00:00	SPY	ETF	605.61	605.99	605.0401	605.16	1558681.0
2025-02-06 14:00:00	SPY	ETF	605.15	605.49	602.63	603.73	3848585.0
2025-02-06 15:00:00	SPY	ETF	603.72	606.4525	603.53	606.34	6650282.0
2025-02-06 16:00:00	SPY	ETF	606.36	606.47	603.32	605.12	4991508.0
2025-02-06 17:00:00	SPY	ETF	605.17	605.18	604.52	604.66	124912.0
2025-02-06 18:00:00	SPY	ETF	604.55	605.7	604.5	605.63	54743.0
2025-02-06 19:00:00	SPY	ETF	605.6	605.99	605.41	605.99	22018.0
2025-02-06 04:00:00	QQQ	ETF	527.98	528.61	527.71	527.71	33944.0
2025-02-06 05:00:00	QQQ	ETF	527.78	528.09	527.3	527.34	27084.0
2025-02-06 06:00:00	QQQ	ETF	527.37	527.37	525.88	526.11	62402.0
2025-02-06 07:00:00	QQQ	ETF	526.12	527.01	525.7	526.94	125420.0
2025-02-06 08:00:00	QQQ	ETF	526.03	528.51	525.6305	527.27	237581.0
2025-02-06 09:00:00	QQQ	ETF	527.3	528.4	526.4	527.62	2330463.0
2025-02-06 10:00:00	QQQ	ETF	527.63	529.02	526.44	527.1994	2623126.0
2025-02-06 11:00:00	QQQ	ETF	527.19	528.2	526.77	527.1498	1348879.0
2025-02-06 12:00:00	QQQ	ETF	527.18	528.575	526.63	528.23	1194012.0
2025-02-06 13:00:00	QQQ	ETF	528.25	528.84	527.89	528.24	964980.0
2025-02-06 14:00:00	QQQ	ETF	528.2	528.58	525.7412	526.59	1801818.0
2025-02-06 15:00:00	QQQ	ETF	526.56	529.81	526.33	529.59	2560103.0
2025-02-06 16:00:00	QQQ	ETF	529.58	529.67	527.0	528.91	1372559.0
2025-02-06 17:00:00	QQQ	ETF	528.95	528.9999	527.68	527.94	226078.0
2025-02-06 18:00:00	QQQ	ETF	528.01	529.179	528.0	529.12	135130.0
2025-02-06 19:00:00	QQQ	ETF	529.1	529.38	528.88	529.38	59664.0
2025-02-06 04:00:00	IWM	ETF	230.0	230.21	229.77	230.01	19033.0
2025-02-06 05:00:00	IWM	ETF	230.14	230.29	230.08	230.09	9834.0
2025-02-06 06:00:00	IWM	ETF	230.01	230.09	229.81	229.94	32391.0
2025-02-06 07:00:00	IWM	ETF	229.97	230.1	229.74	230.1	35716.0
2025-02-06 08:00:00	IWM	ETF	229.9114	230.21	229.76	230.15	97729.0
2025-02-06 09:00:00	IWM	ETF	230.16	230.7	229.26	229.33	1946511.0
2025-02-06 10:00:00	IWM	ETF	229.35	230.2	229.04	229.27	1631766.0
2025-02-06 11:00:00	IWM	ETF	229.28	230.06	229.07	229.09	1233639.0
2025-02-06 12:00:00	IWM	ETF	229.1248	229.77	228.96	229.6	874064.0
2025-02-06 13:00:00	IWM	ETF	229.56	229.71	228.64	228.68	1003355.0
2025-02-06 14:00:00	IWM	ETF	228.68	228.685	227.3	227.92	2220572.0
2025-02-06 15:00:00	IWM	ETF	227.91	228.79	227.76	228.67	2393952.0
2025-02-06 16:00:00	IWM	ETF	228.65	228.69	227.66	228.5	972393.0
2025-02-06 17:00:00	IWM	ETF	228.49	229.12	228.49	228.68	113260.0
2025-02-06 18:00:00	IWM	ETF	228.67	229.06	228.4	228.92	63059.0
2025-02-06 19:00:00	IWM	ETF	229.05	229.09	228.76	228.9685	11105.0
2025-02-06 04:00:00	DIA	ETF	449.78	449.8	449.61	449.61	636.0
2025-02-06 05:00:00	DIA	ETF	449.69	450.33	449.69	450.33	900.0

> showing 50 of 23,694 rows — these rows as CSV

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