PREVIEW / etf_1hour / 2025-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-05-08.parquet
  size:    640 KB
  rows:    24,666

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-08 04:00:00	SPY	ETF	556.5	567.04	556.5	567.04	50507.0
2025-05-08 05:00:00	SPY	ETF	567.0	567.82	566.74	567.48	46640.0
2025-05-08 06:00:00	SPY	ETF	567.4	567.96	567.19	567.9	200630.0
2025-05-08 07:00:00	SPY	ETF	567.91	568.0	566.0	566.5	299710.0
2025-05-08 08:00:00	SPY	ETF	567.56	568.0	564.5	565.71	926013.0
2025-05-08 09:00:00	SPY	ETF	565.65	565.8	563.56	564.1298	3426135.0
2025-05-08 10:00:00	SPY	ETF	564.14	565.16	561.7	562.6	6745630.0
2025-05-08 11:00:00	SPY	ETF	562.55	569.65	562.03	568.38	10155478.0
2025-05-08 12:00:00	SPY	ETF	568.3962	570.31	568.34	570.12	3849052.0
2025-05-08 13:00:00	SPY	ETF	570.11	570.205	567.6	567.6899	2782901.0
2025-05-08 14:00:00	SPY	ETF	567.68	569.13	567.42	568.35	3430077.0
2025-05-08 15:00:00	SPY	ETF	568.34	569.37	564.54	564.92	12819976.0
2025-05-08 16:00:00	SPY	ETF	564.92	565.61	564.67	564.7599	3233188.0
2025-05-08 17:00:00	SPY	ETF	564.89	565.2	564.8502	565.19	201104.0
2025-05-08 18:00:00	SPY	ETF	565.14	565.22	564.43	564.8507	110132.0
2025-05-08 19:00:00	SPY	ETF	564.91	565.09	564.01	564.32	116073.0
2025-05-08 04:00:00	QQQ	ETF	488.15	490.19	488.0	490.09	94909.0
2025-05-08 05:00:00	QQQ	ETF	490.11	490.88	489.79	490.51	73922.0
2025-05-08 06:00:00	QQQ	ETF	490.55	490.75	490.05	490.69	133988.0
2025-05-08 07:00:00	QQQ	ETF	490.69	490.71	489.05	489.33	222084.0
2025-05-08 08:00:00	QQQ	ETF	490.7	490.7	482.938	488.83	615244.0
2025-05-08 09:00:00	QQQ	ETF	488.78	488.98	486.075	486.8	2725508.0
2025-05-08 10:00:00	QQQ	ETF	486.82	487.6	484.17	485.0686	3695230.0
2025-05-08 11:00:00	QQQ	ETF	484.95	492.17	484.5	491.12	6528024.0
2025-05-08 12:00:00	QQQ	ETF	491.12	492.7	491.04	492.55	3438857.0
2025-05-08 13:00:00	QQQ	ETF	492.54	492.64	490.53	490.6	2405376.0
2025-05-08 14:00:00	QQQ	ETF	490.58	492.23	490.23	491.42	2110123.0
2025-05-08 15:00:00	QQQ	ETF	491.42	492.56	487.99	488.22	4897472.0
2025-05-08 16:00:00	QQQ	ETF	488.25	490.5946	488.02	488.44	1537524.0
2025-05-08 17:00:00	QQQ	ETF	488.32	489.03	488.3001	488.67	56464.0
2025-05-08 18:00:00	QQQ	ETF	488.63	488.89	487.93	488.48	76636.0
2025-05-08 19:00:00	QQQ	ETF	488.48	488.66	487.6217	487.98	90675.0
2025-05-08 04:00:00	IWM	ETF	199.33	200.13	199.22	200.06	41102.0
2025-05-08 05:00:00	IWM	ETF	200.03	200.3	199.85	200.21	13076.0
2025-05-08 06:00:00	IWM	ETF	200.13	200.62	200.13	200.53	68981.0
2025-05-08 07:00:00	IWM	ETF	200.53	200.58	199.9	200.06	49177.0
2025-05-08 08:00:00	IWM	ETF	200.25	200.521	198.83	199.75	280017.0
2025-05-08 09:00:00	IWM	ETF	199.75	200.02	198.82	199.08	2059071.0
2025-05-08 10:00:00	IWM	ETF	199.09	199.88	198.26	198.58	2896394.0
2025-05-08 11:00:00	IWM	ETF	198.56	202.1038	198.36	201.6	6080047.0
2025-05-08 12:00:00	IWM	ETF	201.59	202.735	201.54	202.64	2800066.0
2025-05-08 13:00:00	IWM	ETF	202.63	202.65	201.77	201.86	2213437.0
2025-05-08 14:00:00	IWM	ETF	201.83	202.45	201.61	202.03	1711157.0
2025-05-08 15:00:00	IWM	ETF	202.02	202.55	201.12	201.23	4057480.0
2025-05-08 16:00:00	IWM	ETF	201.24	201.55	200.83	200.86	2409617.0
2025-05-08 17:00:00	IWM	ETF	200.91	201.24	200.91	201.01	44341.0
2025-05-08 18:00:00	IWM	ETF	201.01	201.01	200.67	200.84	35496.0
2025-05-08 19:00:00	IWM	ETF	200.78	200.83	200.44	200.6	60997.0
2025-05-08 05:00:00	DIA	ETF	414.25	414.65	414.25	414.65	560.0
2025-05-08 06:00:00	DIA	ETF	414.69	415.13	414.69	415.12	2500.0

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

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