PREVIEW / etf_1hour / 2025-03-17

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-03-17.parquet
  size:    638 KB
  rows:    24,653

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-03-17 04:00:00	SPY	ETF	559.83	560.56	559.41	560.56	30724.0
2025-03-17 05:00:00	SPY	ETF	560.35	560.9	560.13	560.52	54550.0
2025-03-17 06:00:00	SPY	ETF	560.35	561.96	560.35	561.91	25368.0
2025-03-17 07:00:00	SPY	ETF	561.95	562.55	561.49	561.49	143102.0
2025-03-17 08:00:00	SPY	ETF	562.27	563.9	559.18	563.2	657869.0
2025-03-17 09:00:00	SPY	ETF	563.16	566.36	562.27	565.65	4739681.0
2025-03-17 10:00:00	SPY	ETF	565.7	566.2863	563.67	563.98	4176930.0
2025-03-17 11:00:00	SPY	ETF	564.02	565.23	562.8	563.8142	3129741.0
2025-03-17 12:00:00	SPY	ETF	563.83	565.27	563.29	564.6	2241508.0
2025-03-17 13:00:00	SPY	ETF	564.595	567.37	563.9616	567.115	2836387.0
2025-03-17 14:00:00	SPY	ETF	567.1	569.71	567.085	569.2	4944739.0
2025-03-17 15:00:00	SPY	ETF	569.17	569.31	566.82	567.02	8414918.0
2025-03-17 16:00:00	SPY	ETF	567.02	567.15	566.39	566.98	3608542.0
2025-03-17 17:00:00	SPY	ETF	567.03	567.07	566.6499	566.89	174144.0
2025-03-17 18:00:00	SPY	ETF	566.89	567.58	566.89	567.46	107523.0
2025-03-17 19:00:00	SPY	ETF	567.49	567.49	566.8	566.98	44371.0
2025-03-17 04:00:00	QQQ	ETF	476.99	477.85	476.64	477.63	61683.0
2025-03-17 05:00:00	QQQ	ETF	477.58	478.04	477.28	477.74	35127.0
2025-03-17 06:00:00	QQQ	ETF	477.77	479.32	477.73	479.17	83764.0
2025-03-17 07:00:00	QQQ	ETF	479.06	479.93	478.98	479.21	131075.0
2025-03-17 08:00:00	QQQ	ETF	479.22	481.46	476.12	480.83	611394.0
2025-03-17 09:00:00	QQQ	ETF	480.8	483.14	479.18	481.6954	3958011.0
2025-03-17 10:00:00	QQQ	ETF	481.71	482.36	478.83	479.19	3537395.0
2025-03-17 11:00:00	QQQ	ETF	479.23	480.34	477.8	479.06	2551379.0
2025-03-17 12:00:00	QQQ	ETF	479.07	480.61	478.44	479.51	1890547.0
2025-03-17 13:00:00	QQQ	ETF	479.43	482.78	478.9	482.35	2350571.0
2025-03-17 14:00:00	QQQ	ETF	482.34	485.84	482.32	485.34	6078387.0
2025-03-17 15:00:00	QQQ	ETF	485.34	485.51	482.61	482.73	6954815.0
2025-03-17 16:00:00	QQQ	ETF	482.73	482.8703	481.73	482.73	2549611.0
2025-03-17 17:00:00	QQQ	ETF	482.76	482.9899	482.6	482.88	38360.0
2025-03-17 18:00:00	QQQ	ETF	482.88	483.39	482.68	483.11	63860.0
2025-03-17 19:00:00	QQQ	ETF	483.2	483.2	482.44	482.54	86755.0
2025-03-17 04:00:00	IWM	ETF	201.51	201.7	201.11	201.67	22628.0
2025-03-17 05:00:00	IWM	ETF	201.58	201.86	201.58	201.71	5895.0
2025-03-17 06:00:00	IWM	ETF	201.69	202.12	201.69	202.04	7101.0
2025-03-17 07:00:00	IWM	ETF	202.05	202.3	201.88	201.88	18523.0
2025-03-17 08:00:00	IWM	ETF	202.11	203.0	201.1	202.71	145604.0
2025-03-17 09:00:00	IWM	ETF	202.71	204.78	202.47	203.82	2339485.0
2025-03-17 10:00:00	IWM	ETF	203.82	204.11	203.1	203.75	2523619.0
2025-03-17 11:00:00	IWM	ETF	203.77	204.87	203.72	203.99	1423658.0
2025-03-17 12:00:00	IWM	ETF	203.98	204.74	203.79	204.45	1251850.0
2025-03-17 13:00:00	IWM	ETF	204.43	205.215	204.18	205.14	1347308.0
2025-03-17 14:00:00	IWM	ETF	205.12	206.02	205.11	205.74	2529089.0
2025-03-17 15:00:00	IWM	ETF	205.75	205.9473	205.3	205.37	4567408.0
2025-03-17 16:00:00	IWM	ETF	205.45	205.45	204.96	205.14	2513239.0
2025-03-17 17:00:00	IWM	ETF	205.18	205.26	205.1005	205.23	3848.0
2025-03-17 18:00:00	IWM	ETF	205.21	205.34	205.01	205.13	26694.0
2025-03-17 19:00:00	IWM	ETF	205.1	205.13	204.94	205.13	38821.0
2025-03-17 04:00:00	DIA	ETF	413.38	413.43	412.83	413.43	2300.0
2025-03-17 05:00:00	DIA	ETF	413.35	413.66	413.34	413.66	600.0

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

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