PREVIEW / etf_1hour / 2024-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-01-22.parquet
  size:    539 KB
  rows:    20,014

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-01-22 04:00:00	SPY	ETF	483.67	483.88	483.0	483.88	34247.0
2024-01-22 05:00:00	SPY	ETF	483.77	483.99	483.66	483.77	22249.0
2024-01-22 06:00:00	SPY	ETF	483.73	484.13	483.73	483.81	28449.0
2024-01-22 07:00:00	SPY	ETF	483.81	484.44	483.62	484.4	343160.0
2024-01-22 08:00:00	SPY	ETF	483.87	484.41	483.37	484.03	497025.0
2024-01-22 09:00:00	SPY	ETF	484.03	485.2	483.74	485.02	7827763.0
2024-01-22 10:00:00	SPY	ETF	485.0199	485.22	483.21	483.55	10483040.0
2024-01-22 11:00:00	SPY	ETF	483.56	484.21	482.96	484.07	5650962.0
2024-01-22 12:00:00	SPY	ETF	484.07	484.16	483.19	483.75	4366819.0
2024-01-22 13:00:00	SPY	ETF	483.77	483.98	482.78	483.84	5563353.0
2024-01-22 14:00:00	SPY	ETF	483.845	484.01	483.02	483.635	5976449.0
2024-01-22 15:00:00	SPY	ETF	483.65	484.2	483.32	483.52	11684514.0
2024-01-22 16:00:00	SPY	ETF	483.52	483.6	483.33	483.45	2288118.0
2024-01-22 17:00:00	SPY	ETF	483.41	483.49	483.34	483.35	20448.0
2024-01-22 18:00:00	SPY	ETF	483.4	483.66	483.261	483.51	22099.0
2024-01-22 19:00:00	SPY	ETF	483.51	483.67	483.45	483.54	13464.0
2024-01-22 04:00:00	QQQ	ETF	423.5	423.76	423.28	423.63	60782.0
2024-01-22 05:00:00	QQQ	ETF	423.63	423.83	423.39	423.56	46040.0
2024-01-22 06:00:00	QQQ	ETF	423.57	424.0	423.53	423.54	56612.0
2024-01-22 07:00:00	QQQ	ETF	423.56	424.685	423.52	424.45	361837.0
2024-01-22 08:00:00	QQQ	ETF	423.53	424.67	420.865	423.36	419019.0
2024-01-22 09:00:00	QQQ	ETF	423.39	424.7275	422.49	423.68	6166937.0
2024-01-22 10:00:00	QQQ	ETF	423.68	423.927	421.19	421.47	7544236.0
2024-01-22 11:00:00	QQQ	ETF	421.49	423.01	421.23	422.958	3701862.0
2024-01-22 12:00:00	QQQ	ETF	422.96	423.0	421.75	422.28	2399369.0
2024-01-22 13:00:00	QQQ	ETF	422.29	422.37	421.12	422.1996	2712887.0
2024-01-22 14:00:00	QQQ	ETF	422.2	422.39	421.3001	421.95	2289053.0
2024-01-22 15:00:00	QQQ	ETF	421.96	422.4487	421.59	421.72	5126044.0
2024-01-22 16:00:00	QQQ	ETF	421.72	421.74	421.36	421.63	1826389.0
2024-01-22 17:00:00	QQQ	ETF	421.65	421.72	421.5	421.6	13566.0
2024-01-22 18:00:00	QQQ	ETF	421.6	422.04	421.5	421.85	49056.0
2024-01-22 19:00:00	QQQ	ETF	421.8299	422.06	421.76	421.96	49274.0
2024-01-22 04:00:00	IWM	ETF	192.94	193.24	192.86	193.17	33617.0
2024-01-22 05:00:00	IWM	ETF	193.15	193.26	193.03	193.05	17749.0
2024-01-22 06:00:00	IWM	ETF	193.05	193.66	193.02	193.35	21541.0
2024-01-22 07:00:00	IWM	ETF	193.33	193.73	193.32	193.65	122450.0
2024-01-22 08:00:00	IWM	ETF	193.28	194.38	192.895	194.34	471600.0
2024-01-22 09:00:00	IWM	ETF	194.32	196.495	194.06	196.25	6398348.0
2024-01-22 10:00:00	IWM	ETF	196.25	196.82	195.215	195.57	7380582.0
2024-01-22 11:00:00	IWM	ETF	195.57	195.99	195.23	195.865	3383323.0
2024-01-22 12:00:00	IWM	ETF	195.87	195.9	195.24	195.46	2384334.0
2024-01-22 13:00:00	IWM	ETF	195.46	195.67	194.72	195.37	3047430.0
2024-01-22 14:00:00	IWM	ETF	195.38	195.67	194.83	195.64	2884991.0
2024-01-22 15:00:00	IWM	ETF	195.64	196.68	195.37	196.6	7491622.0
2024-01-22 16:00:00	IWM	ETF	196.54	196.67	196.5	196.56	1048574.0
2024-01-22 17:00:00	IWM	ETF	196.6	196.65	196.55	196.62	29119.0
2024-01-22 18:00:00	IWM	ETF	196.64	196.92	196.53	196.9	81539.0
2024-01-22 19:00:00	IWM	ETF	196.92	196.98	196.75	196.85	72612.0
2024-01-22 04:00:00	DIA	ETF	378.94	379.13	378.8	379.13	1300.0
2024-01-22 05:00:00	DIA	ETF	379.13	379.13	379.12	379.12	1491.0

> showing 50 of 20,014 rows — these rows as CSV

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