PREVIEW / etf_1hour / 2023-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-15.parquet
  size:    486 KB
  rows:    17,584

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-15 04:00:00	SPY	ETF	446.03	447.72	445.66	446.64	122399.0
2023-08-15 05:00:00	SPY	ETF	446.55	446.6	445.94	446.17	87431.0
2023-08-15 06:00:00	SPY	ETF	446.13	446.39	445.13	445.41	174059.0
2023-08-15 07:00:00	SPY	ETF	445.68	445.84	444.72	445.0	488034.0
2023-08-15 08:00:00	SPY	ETF	445.6792	448.92	444.56	445.06	472332.0
2023-08-15 09:00:00	SPY	ETF	445.0	446.64	444.94	445.25	6458753.0
2023-08-15 10:00:00	SPY	ETF	445.24	445.27	443.47	443.93	10500479.0
2023-08-15 11:00:00	SPY	ETF	443.941	445.1897	443.93	445.105	5301784.0
2023-08-15 12:00:00	SPY	ETF	445.12	445.35	443.81	444.1227	5032176.0
2023-08-15 13:00:00	SPY	ETF	444.14	444.69	443.67	444.04	5122260.0
2023-08-15 14:00:00	SPY	ETF	444.05	444.62	443.72	444.26	4249552.0
2023-08-15 15:00:00	SPY	ETF	444.255	444.36	442.3	442.94	17004146.0
2023-08-15 16:00:00	SPY	ETF	442.94	444.11	442.72	442.89	4480467.0
2023-08-15 17:00:00	SPY	ETF	442.9	444.11	442.86	442.93	306292.0
2023-08-15 18:00:00	SPY	ETF	442.93	443.14	442.87	443.04	59739.0
2023-08-15 19:00:00	SPY	ETF	443.08	443.27	443.03	443.2	33118.0
2023-08-15 04:00:00	QQQ	ETF	368.96	370.27	368.47	369.45	217862.0
2023-08-15 05:00:00	QQQ	ETF	369.45	369.54	368.83	369.05	56061.0
2023-08-15 06:00:00	QQQ	ETF	369.03	369.18	367.78	368.33	207892.0
2023-08-15 07:00:00	QQQ	ETF	368.36	368.75	367.82	368.04	175330.0
2023-08-15 08:00:00	QQQ	ETF	368.3581	371.72	367.6	368.4	565922.0
2023-08-15 09:00:00	QQQ	ETF	368.31	370.169	368.1399	368.3091	4543607.0
2023-08-15 10:00:00	QQQ	ETF	368.3	368.32	366.53	367.2	8151600.0
2023-08-15 11:00:00	QQQ	ETF	367.2	368.66	367.2	368.625	3328543.0
2023-08-15 12:00:00	QQQ	ETF	368.64	368.93	367.48	367.83	2959023.0
2023-08-15 13:00:00	QQQ	ETF	367.795	368.3588	367.25	367.69	2085554.0
2023-08-15 14:00:00	QQQ	ETF	367.69	368.17	367.28	367.83	2022580.0
2023-08-15 15:00:00	QQQ	ETF	367.82	367.88	365.74	366.42	7240077.0
2023-08-15 16:00:00	QQQ	ETF	366.42	367.08	366.23	366.58	1319634.0
2023-08-15 17:00:00	QQQ	ETF	366.59	366.68	366.52	366.6	21901.0
2023-08-15 18:00:00	QQQ	ETF	366.65	366.86	366.56	366.72	52407.0
2023-08-15 19:00:00	QQQ	ETF	366.76	366.99	366.65	366.86	45447.0
2023-08-15 04:00:00	IWM	ETF	190.19	190.19	189.38	189.8	22238.0
2023-08-15 05:00:00	IWM	ETF	189.79	189.89	189.5	189.66	12858.0
2023-08-15 06:00:00	IWM	ETF	189.78	189.9	189.2	189.35	89481.0
2023-08-15 07:00:00	IWM	ETF	189.56	189.58	188.85	189.01	201663.0
2023-08-15 08:00:00	IWM	ETF	189.36	190.51	188.64	188.95	183612.0
2023-08-15 09:00:00	IWM	ETF	188.89	189.71	188.53	189.06	3584587.0
2023-08-15 10:00:00	IWM	ETF	189.0527	189.11	188.085	188.7007	3867736.0
2023-08-15 11:00:00	IWM	ETF	188.71	189.25	188.71	188.87	1959197.0
2023-08-15 12:00:00	IWM	ETF	188.86	189.02	188.14	188.37	1795791.0
2023-08-15 13:00:00	IWM	ETF	188.37	188.56	188.14	188.31	1533610.0
2023-08-15 14:00:00	IWM	ETF	188.32	188.65	188.27	188.55	1314453.0
2023-08-15 15:00:00	IWM	ETF	188.55	188.71	188.035	188.18	4829887.0
2023-08-15 16:00:00	IWM	ETF	188.14	188.37	188.1	188.27	744894.0
2023-08-15 17:00:00	IWM	ETF	188.26	188.26	188.14	188.18	62892.0
2023-08-15 18:00:00	IWM	ETF	188.25	188.37	188.19	188.26	29623.0
2023-08-15 19:00:00	IWM	ETF	188.35	188.48	188.28	188.33	34577.0
2023-08-15 04:00:00	DIA	ETF	351.54	352.81	351.24	351.64	5736.0
2023-08-15 05:00:00	DIA	ETF	351.47	351.75	351.42	351.42	1025.0

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

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