PREVIEW / etf_1hour / 2023-09-11

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-11.parquet
  size:    472 KB
  rows:    17,279

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-09-11 04:00:00	SPY	ETF	446.61	447.52	446.5	446.81	25697.0
2023-09-11 05:00:00	SPY	ETF	446.93	447.39	446.93	447.37	8845.0
2023-09-11 06:00:00	SPY	ETF	447.37	447.51	447.02	447.51	41343.0
2023-09-11 07:00:00	SPY	ETF	447.46	447.7	447.21	447.3	99767.0
2023-09-11 08:00:00	SPY	ETF	447.44	448.0	446.03	447.98	213718.0
2023-09-11 09:00:00	SPY	ETF	447.98	448.77	446.93	446.97	6858182.0
2023-09-11 10:00:00	SPY	ETF	446.98	447.86	446.71	446.9	7652688.0
2023-09-11 11:00:00	SPY	ETF	446.89	447.49	446.4699	446.8901	5107886.0
2023-09-11 12:00:00	SPY	ETF	446.9	447.78	446.8601	447.72	5019171.0
2023-09-11 13:00:00	SPY	ETF	447.72	448.48	447.5	448.3799	5474466.0
2023-09-11 14:00:00	SPY	ETF	448.38	448.56	448.0	448.4331	4725519.0
2023-09-11 15:00:00	SPY	ETF	448.44	448.7	448.02	448.48	8887524.0
2023-09-11 16:00:00	SPY	ETF	448.48	448.59	448.22	448.25	1821013.0
2023-09-11 17:00:00	SPY	ETF	448.29	448.29	448.01	448.02	38376.0
2023-09-11 18:00:00	SPY	ETF	448.13	448.24	447.9	448.0096	33757.0
2023-09-11 19:00:00	SPY	ETF	448.01	448.1299	447.94	448.0	19651.0
2023-09-11 04:00:00	QQQ	ETF	374.83	375.05	373.05	374.36	54612.0
2023-09-11 05:00:00	QQQ	ETF	374.5	374.77	374.5	374.75	36544.0
2023-09-11 06:00:00	QQQ	ETF	374.69	374.83	374.44	374.81	20161.0
2023-09-11 07:00:00	QQQ	ETF	374.9	375.5	374.71	375.11	159430.0
2023-09-11 08:00:00	QQQ	ETF	374.08	375.77	372.859	375.73	611213.0
2023-09-11 09:00:00	QQQ	ETF	375.75	376.31	374.0	374.29	5723877.0
2023-09-11 10:00:00	QQQ	ETF	374.31	374.93	373.66	374.12	5104836.0
2023-09-11 11:00:00	QQQ	ETF	374.1	375.23	373.8703	374.37	3330224.0
2023-09-11 12:00:00	QQQ	ETF	374.39	375.2099	374.23	375.0199	2471178.0
2023-09-11 13:00:00	QQQ	ETF	375.04	376.81	374.84	376.77	3544327.0
2023-09-11 14:00:00	QQQ	ETF	376.78	377.16	376.42	376.97	3027072.0
2023-09-11 15:00:00	QQQ	ETF	376.98	377.49	376.67	376.96	4623200.0
2023-09-11 16:00:00	QQQ	ETF	376.97	377.16	376.85	376.88	1060054.0
2023-09-11 17:00:00	QQQ	ETF	376.86	376.96	376.5	376.64	74700.0
2023-09-11 18:00:00	QQQ	ETF	376.64	376.7403	376.47	376.48	75141.0
2023-09-11 19:00:00	QQQ	ETF	376.49	376.74	376.49	376.61	35819.0
2023-09-11 04:00:00	IWM	ETF	184.9	185.12	184.65	184.68	18222.0
2023-09-11 05:00:00	IWM	ETF	184.72	185.02	184.72	184.99	11765.0
2023-09-11 06:00:00	IWM	ETF	184.98	185.18	184.8	185.18	52966.0
2023-09-11 07:00:00	IWM	ETF	185.12	185.14	184.8	184.84	42987.0
2023-09-11 08:00:00	IWM	ETF	185.09	185.24	184.11	185.2	71103.0
2023-09-11 09:00:00	IWM	ETF	185.25	185.72	184.405	184.46	2517646.0
2023-09-11 10:00:00	IWM	ETF	184.455	185.56	184.335	184.93	2185563.0
2023-09-11 11:00:00	IWM	ETF	184.92	184.93	184.34	184.5	1355088.0
2023-09-11 12:00:00	IWM	ETF	184.5	184.82	184.44	184.69	966288.0
2023-09-11 13:00:00	IWM	ETF	184.68	185.035	184.548	184.75	1262156.0
2023-09-11 14:00:00	IWM	ETF	184.745	184.745	184.395	184.43	1164555.0
2023-09-11 15:00:00	IWM	ETF	184.43	184.6	184.2	184.39	3177749.0
2023-09-11 16:00:00	IWM	ETF	184.36	184.5	184.32	184.36	471527.0
2023-09-11 17:00:00	IWM	ETF	184.36	184.36	184.28	184.36	4324.0
2023-09-11 18:00:00	IWM	ETF	184.36	184.38	184.18	184.18	64808.0
2023-09-11 19:00:00	IWM	ETF	184.23	184.31	184.17	184.25	61233.0
2023-09-11 05:00:00	DIA	ETF	347.28	347.28	347.28	347.28	100.0
2023-09-11 07:00:00	DIA	ETF	347.38	347.38	346.89	346.92	16733.0

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

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