PREVIEW / etf_1hour / 2023-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-14.parquet
  size:    478 KB
  rows:    17,458

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
2023-08-14 04:00:00	SPY	ETF	447.06	447.36	446.0	446.47	31466.0
2023-08-14 05:00:00	SPY	ETF	446.37	446.7	446.14	446.3	15171.0
2023-08-14 06:00:00	SPY	ETF	446.44	446.92	446.26	446.87	32350.0
2023-08-14 07:00:00	SPY	ETF	446.63	446.8	445.97	446.27	106473.0
2023-08-14 08:00:00	SPY	ETF	446.6514	447.0196	444.42	445.05	361677.0
2023-08-14 09:00:00	SPY	ETF	445.0	445.2962	444.38	445.19	4839724.0
2023-08-14 10:00:00	SPY	ETF	445.19	447.6	444.9306	447.23	8012802.0
2023-08-14 11:00:00	SPY	ETF	447.23	447.76	446.57	447.13	4571714.0
2023-08-14 12:00:00	SPY	ETF	447.14	447.46	446.37	447.2199	3218235.0
2023-08-14 13:00:00	SPY	ETF	447.235	447.65	446.74	447.111	3112953.0
2023-08-14 14:00:00	SPY	ETF	447.12	447.195	446.3	446.76	3955282.0
2023-08-14 15:00:00	SPY	ETF	446.77	448.11	446.49	448.09	8642850.0
2023-08-14 16:00:00	SPY	ETF	448.09	448.18	447.99	448.08	2634116.0
2023-08-14 17:00:00	SPY	ETF	448.08	448.19	447.95	448.08	160778.0
2023-08-14 18:00:00	SPY	ETF	448.06	448.83	447.95	448.76	58518.0
2023-08-14 19:00:00	SPY	ETF	448.78	448.78	448.41	448.56	28506.0
2023-08-14 04:00:00	QQQ	ETF	368.62	368.75	367.2	367.5	88812.0
2023-08-14 05:00:00	QQQ	ETF	367.4	367.61	367.08	367.22	79725.0
2023-08-14 06:00:00	QQQ	ETF	367.34	367.86	367.26	367.58	33971.0
2023-08-14 07:00:00	QQQ	ETF	367.54	367.59	366.7	367.0	167032.0
2023-08-14 08:00:00	QQQ	ETF	367.5409	367.57	365.1	365.85	385409.0
2023-08-14 09:00:00	QQQ	ETF	365.84	366.88	364.7	366.64	5005831.0
2023-08-14 10:00:00	QQQ	ETF	366.65	369.83	366.285	369.365	6670016.0
2023-08-14 11:00:00	QQQ	ETF	369.39	369.785	368.55	368.97	4074142.0
2023-08-14 12:00:00	QQQ	ETF	368.975	369.37	368.0	369.035	3235151.0
2023-08-14 13:00:00	QQQ	ETF	369.05	369.77	368.79	369.228	2708052.0
2023-08-14 14:00:00	QQQ	ETF	369.23	369.325	368.38	369.0018	2615945.0
2023-08-14 15:00:00	QQQ	ETF	369.03	370.47	368.8007	370.46	5938862.0
2023-08-14 16:00:00	QQQ	ETF	370.44	370.63	370.1429	370.63	1391105.0
2023-08-14 17:00:00	QQQ	ETF	370.59	370.69	370.59	370.65	34144.0
2023-08-14 18:00:00	QQQ	ETF	370.63	371.45	370.5	371.34	120370.0
2023-08-14 19:00:00	QQQ	ETF	371.39	371.45	371.0	371.17	118705.0
2023-08-14 04:00:00	IWM	ETF	191.54	191.64	191.11	191.11	7812.0
2023-08-14 05:00:00	IWM	ETF	191.1	191.3	191.01	191.12	8517.0
2023-08-14 06:00:00	IWM	ETF	191.16	191.45	191.0	191.29	43315.0
2023-08-14 07:00:00	IWM	ETF	191.26	191.32	190.96	191.09	32433.0
2023-08-14 08:00:00	IWM	ETF	190.96	191.07	190.18	190.43	91451.0
2023-08-14 09:00:00	IWM	ETF	190.4	190.41	188.64	188.98	3298273.0
2023-08-14 10:00:00	IWM	ETF	188.96	190.0962	188.8	189.7999	2904259.0
2023-08-14 11:00:00	IWM	ETF	189.8	190.33	189.49	190.14	1703909.0
2023-08-14 12:00:00	IWM	ETF	190.14	190.43	189.92	190.345	1949432.0
2023-08-14 13:00:00	IWM	ETF	190.35	190.48	190.14	190.31	951514.0
2023-08-14 14:00:00	IWM	ETF	190.31	190.425	190.09	190.39	1126890.0
2023-08-14 15:00:00	IWM	ETF	190.39	190.7	190.26	190.68	3069019.0
2023-08-14 16:00:00	IWM	ETF	190.66	190.93	190.61	190.91	726056.0
2023-08-14 17:00:00	IWM	ETF	190.88	190.98	190.83	190.86	10346.0
2023-08-14 18:00:00	IWM	ETF	190.87	191.08	190.66	191.08	12289.0
2023-08-14 19:00:00	IWM	ETF	190.97	190.98	190.85	190.89	10417.0
2023-08-14 04:00:00	DIA	ETF	353.64	353.64	353.42	353.47	1601.0
2023-08-14 05:00:00	DIA	ETF	353.63	353.63	353.62	353.62	410.0

> showing 50 of 17,458 rows — these rows as CSV

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