PREVIEW / etf_1hour / 2025-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2025/2025-03-10.parquet
  size:    662 KB
  rows:    26,090

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-10 04:00:00	SPY	ETF	572.7	573.24	568.8	569.21	82943.0
2025-03-10 05:00:00	SPY	ETF	568.92	571.45	568.75	570.33	48427.0
2025-03-10 06:00:00	SPY	ETF	570.5	570.85	569.12	569.3	87095.0
2025-03-10 07:00:00	SPY	ETF	569.36	570.74	568.65	569.06	220616.0
2025-03-10 08:00:00	SPY	ETF	569.13	574.12	567.21	568.54	505240.0
2025-03-10 09:00:00	SPY	ETF	568.51	569.54	566.36	567.36	5845365.0
2025-03-10 10:00:00	SPY	ETF	567.32	567.32	563.06	563.94	8602368.0
2025-03-10 11:00:00	SPY	ETF	563.95	566.62	563.64	563.84	6603513.0
2025-03-10 12:00:00	SPY	ETF	563.8	565.11	562.45	563.0	4756535.0
2025-03-10 13:00:00	SPY	ETF	562.99	563.17	560.1	560.42	5446896.0
2025-03-10 14:00:00	SPY	ETF	560.41	561.53	557.07	557.3	7492753.0
2025-03-10 15:00:00	SPY	ETF	557.3	562.4698	555.59	560.75	18695735.0
2025-03-10 16:00:00	SPY	ETF	560.75	561.4	559.74	561.25	5875170.0
2025-03-10 17:00:00	SPY	ETF	561.28	561.47	560.25	560.25	239253.0
2025-03-10 18:00:00	SPY	ETF	560.3	560.88	558.97	559.52	358479.0
2025-03-10 19:00:00	SPY	ETF	559.6606	559.85	556.9	558.58	262322.0
2025-03-10 04:00:00	QQQ	ETF	488.69	489.13	485.12	485.52	80863.0
2025-03-10 05:00:00	QQQ	ETF	485.32	487.7	485.26	486.37	151827.0
2025-03-10 06:00:00	QQQ	ETF	486.55	486.9	484.93	485.59	102743.0
2025-03-10 07:00:00	QQQ	ETF	485.7	486.89	484.51	485.19	169871.0
2025-03-10 08:00:00	QQQ	ETF	485.26	491.422	483.03	484.25	518412.0
2025-03-10 09:00:00	QQQ	ETF	484.34	484.9	480.2	481.25	5207320.0
2025-03-10 10:00:00	QQQ	ETF	481.25	481.25	474.715	475.53	8099951.0
2025-03-10 11:00:00	QQQ	ETF	475.54	479.1372	475.4	476.3462	5563784.0
2025-03-10 12:00:00	QQQ	ETF	476.32	477.6	474.77	475.245	3415963.0
2025-03-10 13:00:00	QQQ	ETF	475.25	475.48	472.32	472.785	5331232.0
2025-03-10 14:00:00	QQQ	ETF	472.79	474.14	470.05	470.27	4976670.0
2025-03-10 15:00:00	QQQ	ETF	470.27	475.45	468.66	473.3	13811829.0
2025-03-10 16:00:00	QQQ	ETF	473.3	473.8	472.18	473.5	4762996.0
2025-03-10 17:00:00	QQQ	ETF	473.54	473.64	471.98	472.0	155491.0
2025-03-10 18:00:00	QQQ	ETF	472.07	473.15	471.01	471.22	374178.0
2025-03-10 19:00:00	QQQ	ETF	471.23	471.72	467.77	469.42	490751.0
2025-03-10 04:00:00	IWM	ETF	205.0	205.07	203.02	203.21	42734.0
2025-03-10 05:00:00	IWM	ETF	203.27	204.36	203.22	203.88	14787.0
2025-03-10 06:00:00	IWM	ETF	204.03	204.15	203.7	203.75	27962.0
2025-03-10 07:00:00	IWM	ETF	203.75	204.3	203.47	203.83	144364.0
2025-03-10 08:00:00	IWM	ETF	203.98	205.13	203.16	203.7	218240.0
2025-03-10 09:00:00	IWM	ETF	203.76	204.74	203.0601	203.4	3033127.0
2025-03-10 10:00:00	IWM	ETF	203.39	203.39	201.92	202.5	3340413.0
2025-03-10 11:00:00	IWM	ETF	202.55	204.04	202.51	202.65	3549657.0
2025-03-10 12:00:00	IWM	ETF	202.625	203.6	202.19	202.21	1883831.0
2025-03-10 13:00:00	IWM	ETF	202.19	202.27	200.565	200.615	2815218.0
2025-03-10 14:00:00	IWM	ETF	200.61	200.9	199.2	199.29	3775626.0
2025-03-10 15:00:00	IWM	ETF	199.28	202.1	198.75	200.72	8603387.0
2025-03-10 16:00:00	IWM	ETF	200.71	201.1	200.38	201.05	1956245.0
2025-03-10 17:00:00	IWM	ETF	201.04	201.05	200.58	200.79	44553.0
2025-03-10 18:00:00	IWM	ETF	200.87	201.28	200.4	200.85	99706.0
2025-03-10 19:00:00	IWM	ETF	200.8717	200.8717	199.66	200.28	238330.0
2025-03-10 04:00:00	DIA	ETF	426.1	426.1	424.0	424.0	1742.0
2025-03-10 05:00:00	DIA	ETF	425.06	425.49	424.7	424.7	1413.0

> showing 50 of 26,090 rows — these rows as CSV

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