PREVIEW / etf_1hour / 2025-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-02-07.parquet
  size:    624 KB
  rows:    23,785

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-07 04:00:00	SPY	ETF	605.6	606.32	605.6	606.23	4656.0
2025-02-07 05:00:00	SPY	ETF	606.33	606.49	606.19	606.24	1826.0
2025-02-07 06:00:00	SPY	ETF	606.32	606.69	606.09	606.6	13814.0
2025-02-07 07:00:00	SPY	ETF	606.61	606.65	606.28	606.31	41985.0
2025-02-07 08:00:00	SPY	ETF	606.63	607.22	604.4	606.77	918684.0
2025-02-07 09:00:00	SPY	ETF	606.79	608.13	606.38	607.8103	2729638.0
2025-02-07 10:00:00	SPY	ETF	607.77	607.81	601.18	603.41	7541565.0
2025-02-07 11:00:00	SPY	ETF	603.45	604.5395	601.29	601.5988	6784264.0
2025-02-07 12:00:00	SPY	ETF	601.57	602.85	600.64	602.16	3198807.0
2025-02-07 13:00:00	SPY	ETF	602.17	603.75	601.13	601.235	1738334.0
2025-02-07 14:00:00	SPY	ETF	601.226	601.6	600.34	601.12	2395771.0
2025-02-07 15:00:00	SPY	ETF	601.11	601.26	600.05	600.78	5550382.0
2025-02-07 16:00:00	SPY	ETF	600.78	606.4184	600.77	600.87	2264615.0
2025-02-07 17:00:00	SPY	ETF	600.96	601.1	600.7	600.7	569169.0
2025-02-07 18:00:00	SPY	ETF	600.7	601.1	600.5	600.5999	73080.0
2025-02-07 19:00:00	SPY	ETF	600.6	600.6	600.21	600.2299	44647.0
2025-02-07 04:00:00	QQQ	ETF	529.0	529.58	528.73	529.45	25508.0
2025-02-07 05:00:00	QQQ	ETF	529.39	529.68	529.28	529.32	33376.0
2025-02-07 06:00:00	QQQ	ETF	529.54	529.81	529.02	529.77	73512.0
2025-02-07 07:00:00	QQQ	ETF	529.74	529.88	529.46	529.66	48803.0
2025-02-07 08:00:00	QQQ	ETF	529.72	531.0	527.9	529.85	661407.0
2025-02-07 09:00:00	QQQ	ETF	529.95	532.1	529.63	530.64	1868816.0
2025-02-07 10:00:00	QQQ	ETF	530.57	530.58	523.68	526.21	5747347.0
2025-02-07 11:00:00	QQQ	ETF	526.18	527.03	523.49	523.91	2681532.0
2025-02-07 12:00:00	QQQ	ETF	523.95	525.27	522.91	524.55	2320339.0
2025-02-07 13:00:00	QQQ	ETF	524.56	526.4	523.76	523.87	1387338.0
2025-02-07 14:00:00	QQQ	ETF	523.8	524.16	522.46	523.4724	1839730.0
2025-02-07 15:00:00	QQQ	ETF	523.44	523.74	522.19	522.94	3099496.0
2025-02-07 16:00:00	QQQ	ETF	522.92	523.3462	522.65	522.7	1126586.0
2025-02-07 17:00:00	QQQ	ETF	522.71	522.92	522.27	522.3	444805.0
2025-02-07 18:00:00	QQQ	ETF	522.28	522.28	521.94	521.96	38694.0
2025-02-07 19:00:00	QQQ	ETF	521.9984	522.0	521.56	521.85	13918.0
2025-02-07 04:00:00	IWM	ETF	228.96	229.18	228.85	229.05	8226.0
2025-02-07 05:00:00	IWM	ETF	229.09	229.09	228.86	228.9	7666.0
2025-02-07 06:00:00	IWM	ETF	228.85	229.04	228.81	229.01	10365.0
2025-02-07 07:00:00	IWM	ETF	228.97	229.0	228.59	228.86	35915.0
2025-02-07 08:00:00	IWM	ETF	228.7	230.2	227.07	228.33	759758.0
2025-02-07 09:00:00	IWM	ETF	228.33	229.2499	228.2	229.07	2093857.0
2025-02-07 10:00:00	IWM	ETF	228.67	229.08	225.64	226.64	6080098.0
2025-02-07 11:00:00	IWM	ETF	226.66	227.23	225.58	225.93	3126053.0
2025-02-07 12:00:00	IWM	ETF	225.91	226.63	225.58	225.94	1916783.0
2025-02-07 13:00:00	IWM	ETF	225.94	226.77	225.73	225.75	964142.0
2025-02-07 14:00:00	IWM	ETF	225.76	226.27	225.65	226.07	1197190.0
2025-02-07 15:00:00	IWM	ETF	226.06	226.2701	225.59	225.98	2722734.0
2025-02-07 16:00:00	IWM	ETF	226.0	226.2	225.96	226.18	955944.0
2025-02-07 17:00:00	IWM	ETF	226.12	226.2	226.06	226.06	16325.0
2025-02-07 18:00:00	IWM	ETF	226.02	226.1	225.7525	225.83	10625.0
2025-02-07 19:00:00	IWM	ETF	225.83	225.98	225.51	225.6	2543.0
2025-02-07 04:00:00	DIA	ETF	447.4	447.4	447.4	447.4	250.0
2025-02-07 05:00:00	DIA	ETF	447.67	447.67	447.67	447.67	200.0

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

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