PREVIEW / etf_1hour / 2025-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-05-02.parquet
  size:    637 KB
  rows:    24,576

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-05-02 04:00:00	SPY	ETF	560.98	561.74	559.79	559.79	37129.0
2025-05-02 05:00:00	SPY	ETF	559.65	561.2	559.4	560.9	22129.0
2025-05-02 06:00:00	SPY	ETF	560.73	561.4	560.66	560.99	51981.0
2025-05-02 07:00:00	SPY	ETF	561.0	561.38	560.07	560.43	254770.0
2025-05-02 08:00:00	SPY	ETF	561.04	565.29	560.2	565.1	1079915.0
2025-05-02 09:00:00	SPY	ETF	565.15	565.93	562.38	563.62	5173785.0
2025-05-02 10:00:00	SPY	ETF	563.6449	566.32	563.27	565.8	4774182.0
2025-05-02 11:00:00	SPY	ETF	565.8	566.39	564.46	566.2299	3548158.0
2025-05-02 12:00:00	SPY	ETF	566.23	568.0796	566.16	567.5	5313214.0
2025-05-02 13:00:00	SPY	ETF	567.5	567.77	566.36	567.25	2648026.0
2025-05-02 14:00:00	SPY	ETF	567.25	568.38	566.45	567.1	3832803.0
2025-05-02 15:00:00	SPY	ETF	567.08	567.93	566.02	566.62	11104443.0
2025-05-02 16:00:00	SPY	ETF	566.63	567.49	566.54	567.06	3659432.0
2025-05-02 17:00:00	SPY	ETF	567.07	567.25	566.86	566.9	155313.0
2025-05-02 18:00:00	SPY	ETF	566.88	566.9	566.69	566.72	17654.0
2025-05-02 19:00:00	SPY	ETF	566.6722	566.95	566.5522	566.83	21622.0
2025-05-02 04:00:00	QQQ	ETF	481.99	483.11	481.2	481.2	113060.0
2025-05-02 05:00:00	QQQ	ETF	481.2	482.68	481.08	482.34	30744.0
2025-05-02 06:00:00	QQQ	ETF	482.29	483.3	482.23	482.77	69780.0
2025-05-02 07:00:00	QQQ	ETF	482.75	483.28	482.0	482.49	108123.0
2025-05-02 08:00:00	QQQ	ETF	482.93	486.89	481.2996	486.6	757441.0
2025-05-02 09:00:00	QQQ	ETF	486.71	487.7	484.83	486.05	3871137.0
2025-05-02 10:00:00	QQQ	ETF	486.09	488.67	485.84	488.2812	3825996.0
2025-05-02 11:00:00	QQQ	ETF	488.3	489.24	487.35	489.0	2550483.0
2025-05-02 12:00:00	QQQ	ETF	489.02	490.67	488.92	490.08	3920032.0
2025-05-02 13:00:00	QQQ	ETF	490.075	490.37	489.0	489.6847	2408458.0
2025-05-02 14:00:00	QQQ	ETF	489.69	490.91	489.07	489.5992	2326357.0
2025-05-02 15:00:00	QQQ	ETF	489.59	489.97	487.96	488.86	5711526.0
2025-05-02 16:00:00	QQQ	ETF	488.87	489.902	488.67	489.2	1506537.0
2025-05-02 17:00:00	QQQ	ETF	488.9511	489.1	488.8	488.9	25040.0
2025-05-02 18:00:00	QQQ	ETF	488.85	489.1	488.8	488.93	23258.0
2025-05-02 19:00:00	QQQ	ETF	488.93	489.0	488.75	488.92	22234.0
2025-05-02 04:00:00	IWM	ETF	198.5	198.56	197.57	197.57	31456.0
2025-05-02 05:00:00	IWM	ETF	197.58	198.03	197.5	197.91	7226.0
2025-05-02 06:00:00	IWM	ETF	197.91	198.08	197.75	198.0	20262.0
2025-05-02 07:00:00	IWM	ETF	198.01	198.05	197.62	197.79	21814.0
2025-05-02 08:00:00	IWM	ETF	198.05	199.45	197.52	199.16	553923.0
2025-05-02 09:00:00	IWM	ETF	199.12	199.38	197.97	198.52	2597038.0
2025-05-02 10:00:00	IWM	ETF	198.5	199.84	198.328	199.66	2098575.0
2025-05-02 11:00:00	IWM	ETF	199.67	200.135	199.15	199.98	2082144.0
2025-05-02 12:00:00	IWM	ETF	199.97	201.21	199.96	200.85	3880476.0
2025-05-02 13:00:00	IWM	ETF	200.85	201.03	200.4424	200.89	1777144.0
2025-05-02 14:00:00	IWM	ETF	200.88	201.2	200.4175	200.58	2161040.0
2025-05-02 15:00:00	IWM	ETF	200.58	200.93	200.34	200.44	4725847.0
2025-05-02 16:00:00	IWM	ETF	200.44	200.7787	200.37	200.43	2407527.0
2025-05-02 17:00:00	IWM	ETF	200.59	200.7	200.17	200.17	13012.0
2025-05-02 18:00:00	IWM	ETF	200.43	200.57	200.37	200.4	3542.0
2025-05-02 19:00:00	IWM	ETF	200.5	200.58	200.21	200.26	2598.0
2025-05-02 04:00:00	DIA	ETF	409.67	410.13	409.12	409.37	6350.0
2025-05-02 05:00:00	DIA	ETF	408.8	409.42	408.63	409.42	1450.0

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

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