PREVIEW / etf_1hour / 2024-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-12-20.parquet
  size:    630 KB
  rows:    24,480

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
2024-12-20 04:00:00	SPY	ETF	581.98	581.98	579.45	579.67	83388.0
2024-12-20 05:00:00	SPY	ETF	579.8	580.3	579.14	579.92	66401.0
2024-12-20 06:00:00	SPY	ETF	579.98	580.47	579.24	579.42	111210.0
2024-12-20 07:00:00	SPY	ETF	579.4	579.68	577.74	579.59	458155.0
2024-12-20 08:00:00	SPY	ETF	579.36	583.82	577.7494	581.33	1104666.0
2024-12-20 09:00:00	SPY	ETF	581.26	584.18	580.6	582.06	6812938.0
2024-12-20 10:00:00	SPY	ETF	582.09	589.28	582.08	588.26	9173007.0
2024-12-20 11:00:00	SPY	ETF	588.29	594.9	588.1	594.42	8755365.0
2024-12-20 12:00:00	SPY	ETF	594.41	595.75	593.81	594.55	4924740.0
2024-12-20 13:00:00	SPY	ETF	594.56	594.6195	591.85	592.0699	5652796.0
2024-12-20 14:00:00	SPY	ETF	592.02	593.94	591.62	592.4999	4961576.0
2024-12-20 15:00:00	SPY	ETF	592.5	592.89	589.47	590.87	20891986.0
2024-12-20 16:00:00	SPY	ETF	590.91	592.55	589.5	590.32	10227259.0
2024-12-20 17:00:00	SPY	ETF	590.36	591.7	589.92	591.49	348800.0
2024-12-20 18:00:00	SPY	ETF	591.54	592.17	591.15	592.17	58720.0
2024-12-20 19:00:00	SPY	ETF	592.2	592.3	592.0	592.12	114724.0
2024-12-20 04:00:00	QQQ	ETF	510.97	511.46	507.79	508.11	220725.0
2024-12-20 05:00:00	QQQ	ETF	508.18	508.74	507.51	507.78	94865.0
2024-12-20 06:00:00	QQQ	ETF	507.62	508.17	506.97	507.39	159815.0
2024-12-20 07:00:00	QQQ	ETF	507.34	507.67	505.41	507.651	384631.0
2024-12-20 08:00:00	QQQ	ETF	507.36	512.5	505.4581	510.6	1159003.0
2024-12-20 09:00:00	QQQ	ETF	510.5	512.84	509.29	510.92	4631983.0
2024-12-20 10:00:00	QQQ	ETF	511.0	518.7799	510.965	517.8401	5248855.0
2024-12-20 11:00:00	QQQ	ETF	517.88	524.28	517.63	523.42	4704869.0
2024-12-20 12:00:00	QQQ	ETF	523.45	524.82	522.88	523.54	2709760.0
2024-12-20 13:00:00	QQQ	ETF	523.55	523.79	520.975	521.2901	3409315.0
2024-12-20 14:00:00	QQQ	ETF	521.26	523.37	520.82	522.02	2839623.0
2024-12-20 15:00:00	QQQ	ETF	522.04	522.37	517.66	518.82	7944909.0
2024-12-20 16:00:00	QQQ	ETF	518.8	520.27	517.57	518.51	3245542.0
2024-12-20 17:00:00	QQQ	ETF	518.63	519.5	518.15	519.5	101756.0
2024-12-20 18:00:00	QQQ	ETF	519.5	520.36	519.5	520.36	51801.0
2024-12-20 19:00:00	QQQ	ETF	520.34	520.9	520.34	520.9	40043.0
2024-12-20 04:00:00	IWM	ETF	218.3	218.36	217.71	217.91	51624.0
2024-12-20 05:00:00	IWM	ETF	217.94	217.94	216.93	217.12	73080.0
2024-12-20 06:00:00	IWM	ETF	217.1	217.34	216.7	217.1	39789.0
2024-12-20 07:00:00	IWM	ETF	217.16	217.94	216.95	217.63	157406.0
2024-12-20 08:00:00	IWM	ETF	217.6	219.3303	217.0	218.82	1022065.0
2024-12-20 09:00:00	IWM	ETF	218.8099	221.51	218.07	220.9	5616290.0
2024-12-20 10:00:00	IWM	ETF	220.96	223.22	220.33	222.65	5701052.0
2024-12-20 11:00:00	IWM	ETF	222.69	224.655	222.63	224.2	4559039.0
2024-12-20 12:00:00	IWM	ETF	224.2	224.225	223.13	223.56	3152266.0
2024-12-20 13:00:00	IWM	ETF	223.5599	223.61	222.235	222.79	3753121.0
2024-12-20 14:00:00	IWM	ETF	222.75	223.92	222.42	223.13	3341401.0
2024-12-20 15:00:00	IWM	ETF	223.12	223.26	221.48	222.035	8321582.0
2024-12-20 16:00:00	IWM	ETF	222.05	222.8	221.36	222.08	2983663.0
2024-12-20 17:00:00	IWM	ETF	222.02	222.42	221.86	222.42	27541.0
2024-12-20 18:00:00	IWM	ETF	222.4	222.53	222.2	222.42	37752.0
2024-12-20 19:00:00	IWM	ETF	222.42	222.79	222.42	222.79	26618.0
2024-12-20 04:00:00	DIA	ETF	421.88	421.93	421.13	421.26	9937.0
2024-12-20 05:00:00	DIA	ETF	421.47	421.47	420.87	421.21	9498.0

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

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