PREVIEW / etf_1hour / 2025-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-05-05.parquet
  size:    641 KB
  rows:    25,032

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-05 04:00:00	SPY	ETF	563.85	564.49	561.7	562.19	72842.0
2025-05-05 05:00:00	SPY	ETF	562.12	562.94	561.76	562.58	38719.0
2025-05-05 06:00:00	SPY	ETF	562.62	562.83	562.2	562.74	59214.0
2025-05-05 07:00:00	SPY	ETF	562.79	562.91	561.83	562.23	198652.0
2025-05-05 08:00:00	SPY	ETF	562.78	563.9	561.89	562.6	385790.0
2025-05-05 09:00:00	SPY	ETF	562.575	563.3	561.7	562.99	3901681.0
2025-05-05 10:00:00	SPY	ETF	563.07	565.19	562.43	565.0	4832926.0
2025-05-05 11:00:00	SPY	ETF	565.01	565.31	563.84	565.0	3542496.0
2025-05-05 12:00:00	SPY	ETF	565.0	565.9599	564.8188	565.61	2314459.0
2025-05-05 13:00:00	SPY	ETF	565.6	566.08	564.84	565.6801	1855342.0
2025-05-05 14:00:00	SPY	ETF	565.68	566.65	565.5702	565.785	2627859.0
2025-05-05 15:00:00	SPY	ETF	565.78	565.88	563.09	563.53	7243345.0
2025-05-05 16:00:00	SPY	ETF	563.55	564.512	562.72	563.24	2127669.0
2025-05-05 17:00:00	SPY	ETF	563.25	563.35	562.95	563.02	191342.0
2025-05-05 18:00:00	SPY	ETF	562.95	563.398	562.7	562.8202	54582.0
2025-05-05 19:00:00	SPY	ETF	562.89	563.19	562.75	562.81	20016.0
2025-05-05 04:00:00	QQQ	ETF	485.82	486.2	483.93	484.35	125251.0
2025-05-05 05:00:00	QQQ	ETF	484.42	485.02	484.0	484.7	45823.0
2025-05-05 06:00:00	QQQ	ETF	484.64	484.78	483.99	484.58	79015.0
2025-05-05 07:00:00	QQQ	ETF	484.69	484.84	483.68	483.96	150997.0
2025-05-05 08:00:00	QQQ	ETF	484.6	486.76	483.7	484.5	334598.0
2025-05-05 09:00:00	QQQ	ETF	484.46	486.15	484.1	485.75	2869865.0
2025-05-05 10:00:00	QQQ	ETF	485.78	487.17	484.64	486.9237	3150220.0
2025-05-05 11:00:00	QQQ	ETF	486.87	487.4	485.99	486.89	2114473.0
2025-05-05 12:00:00	QQQ	ETF	486.9	487.95	486.7	487.68	1288111.0
2025-05-05 13:00:00	QQQ	ETF	487.67	488.17	486.98	487.89	1584312.0
2025-05-05 14:00:00	QQQ	ETF	487.8978	489.03	487.77	488.085	1681860.0
2025-05-05 15:00:00	QQQ	ETF	488.08	488.14	485.5	485.95	3557418.0
2025-05-05 16:00:00	QQQ	ETF	485.97	486.07	484.5	485.4	1302249.0
2025-05-05 17:00:00	QQQ	ETF	485.33	485.4	484.82	485.01	32654.0
2025-05-05 18:00:00	QQQ	ETF	484.85	485.2993	484.65	484.84	44724.0
2025-05-05 19:00:00	QQQ	ETF	484.78	485.18	484.52	484.63	36031.0
2025-05-05 04:00:00	IWM	ETF	198.57	198.85	198.28	198.39	33541.0
2025-05-05 05:00:00	IWM	ETF	198.49	198.9	198.36	198.78	17729.0
2025-05-05 06:00:00	IWM	ETF	198.79	198.91	198.63	198.82	7183.0
2025-05-05 07:00:00	IWM	ETF	198.87	199.0	198.46	198.73	35537.0
2025-05-05 08:00:00	IWM	ETF	198.96	198.98	198.32	198.85	120570.0
2025-05-05 09:00:00	IWM	ETF	198.74	199.24	198.08	198.87	2516312.0
2025-05-05 10:00:00	IWM	ETF	198.89	200.2	198.61	200.16	2796866.0
2025-05-05 11:00:00	IWM	ETF	200.15	200.29	199.74	200.08	1560278.0
2025-05-05 12:00:00	IWM	ETF	200.0805	200.29	199.93	200.18	891827.0
2025-05-05 13:00:00	IWM	ETF	200.16	200.34	199.68	200.15	1187549.0
2025-05-05 14:00:00	IWM	ETF	200.15	200.5	199.955	199.99	1097013.0
2025-05-05 15:00:00	IWM	ETF	199.9804	200.115	198.84	198.99	3342884.0
2025-05-05 16:00:00	IWM	ETF	198.94	199.0	198.68	198.91	1182046.0
2025-05-05 17:00:00	IWM	ETF	198.88	198.93	198.63	198.93	18004.0
2025-05-05 18:00:00	IWM	ETF	198.83	199.0	198.74	198.78	12675.0
2025-05-05 19:00:00	IWM	ETF	198.8	198.83	198.68	198.7	12482.0
2025-05-05 04:00:00	DIA	ETF	410.99	410.99	410.81	410.81	300.0
2025-05-05 05:00:00	DIA	ETF	410.01	410.53	410.01	410.49	1414.0

> showing 50 of 25,032 rows — these rows as CSV

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