PREVIEW / etf_1hour / 2023-09-06

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-06.parquet
  size:    478 KB
  rows:    17,312

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-06 04:00:00	SPY	ETF	448.09	448.6	447.98	448.31	9454.0
2023-09-06 05:00:00	SPY	ETF	448.52	448.53	448.26	448.53	4365.0
2023-09-06 06:00:00	SPY	ETF	448.43	448.63	448.36	448.36	7662.0
2023-09-06 07:00:00	SPY	ETF	448.37	448.58	448.17	448.33	63251.0
2023-09-06 08:00:00	SPY	ETF	448.26	449.12	447.89	448.42	174600.0
2023-09-06 09:00:00	SPY	ETF	448.44	448.51	447.41	447.9554	4856117.0
2023-09-06 10:00:00	SPY	ETF	447.92	447.92	445.6	445.6701	10874813.0
2023-09-06 11:00:00	SPY	ETF	445.685	446.01	445.17	445.55	7843983.0
2023-09-06 12:00:00	SPY	ETF	445.55	445.745	444.01	444.25	6412459.0
2023-09-06 13:00:00	SPY	ETF	444.25	445.57	443.81	445.31	6423123.0
2023-09-06 14:00:00	SPY	ETF	445.31	446.18	445.16	445.945	5936771.0
2023-09-06 15:00:00	SPY	ETF	445.935	446.4	445.33	446.19	11627957.0
2023-09-06 16:00:00	SPY	ETF	446.19	446.22	444.8119	446.06	2328562.0
2023-09-06 17:00:00	SPY	ETF	446.05	446.22	445.9	446.03	525869.0
2023-09-06 18:00:00	SPY	ETF	446.04	446.13	445.9	445.94	66145.0
2023-09-06 19:00:00	SPY	ETF	446.05	446.18	446.0	446.13	44256.0
2023-09-06 04:00:00	QQQ	ETF	377.0	377.1	376.39	376.84	35941.0
2023-09-06 05:00:00	QQQ	ETF	376.83	377.02	376.5	376.97	22319.0
2023-09-06 06:00:00	QQQ	ETF	376.84	377.16	376.84	377.07	21583.0
2023-09-06 07:00:00	QQQ	ETF	377.06	377.49	376.89	377.11	109532.0
2023-09-06 08:00:00	QQQ	ETF	377.29	378.353	375.92	377.2	277324.0
2023-09-06 09:00:00	QQQ	ETF	377.19	377.63	376.33	376.92	3613392.0
2023-09-06 10:00:00	QQQ	ETF	376.9	376.9	374.245	374.25	7962010.0
2023-09-06 11:00:00	QQQ	ETF	374.26	374.83	373.61	374.215	4463748.0
2023-09-06 12:00:00	QQQ	ETF	374.22	374.57	372.76	373.095	4199009.0
2023-09-06 13:00:00	QQQ	ETF	373.08	374.25	372.7	373.83	3693251.0
2023-09-06 14:00:00	QQQ	ETF	373.84	374.64	373.56	374.22	3327900.0
2023-09-06 15:00:00	QQQ	ETF	374.21	374.96	373.65	374.805	6211246.0
2023-09-06 16:00:00	QQQ	ETF	374.74	374.81	374.46	374.55	899475.0
2023-09-06 17:00:00	QQQ	ETF	374.55	374.74	374.46	374.55	133025.0
2023-09-06 18:00:00	QQQ	ETF	374.56	374.63	374.38	374.47	45225.0
2023-09-06 19:00:00	QQQ	ETF	374.48	374.69	374.46	374.61	64928.0
2023-09-06 04:00:00	IWM	ETF	186.69	186.69	186.14	186.48	12010.0
2023-09-06 05:00:00	IWM	ETF	186.54	186.66	186.4	186.66	8478.0
2023-09-06 06:00:00	IWM	ETF	186.65	186.73	186.48	186.49	10107.0
2023-09-06 07:00:00	IWM	ETF	186.48	186.74	186.38	186.68	15902.0
2023-09-06 08:00:00	IWM	ETF	186.51	187.05	186.24	187.01	57943.0
2023-09-06 09:00:00	IWM	ETF	186.98	188.09	186.875	187.25	3260676.0
2023-09-06 10:00:00	IWM	ETF	187.23	187.3	186.01	186.13	4563909.0
2023-09-06 11:00:00	IWM	ETF	186.13	186.14	185.55	185.695	2633231.0
2023-09-06 12:00:00	IWM	ETF	185.69	185.84	185.09	185.23	1803119.0
2023-09-06 13:00:00	IWM	ETF	185.22	185.82	185.0923	185.64	2188363.0
2023-09-06 14:00:00	IWM	ETF	185.63	186.185	185.565	186.01	1823319.0
2023-09-06 15:00:00	IWM	ETF	186.005	186.28	185.81	186.17	3937348.0
2023-09-06 16:00:00	IWM	ETF	186.13	187.0	185.99	186.1	608164.0
2023-09-06 17:00:00	IWM	ETF	186.09	186.13	186.0	186.04	226015.0
2023-09-06 18:00:00	IWM	ETF	186.13	186.15	186.04	186.12	6845.0
2023-09-06 19:00:00	IWM	ETF	186.16	186.27	186.15	186.25	25700.0
2023-09-06 04:00:00	DIA	ETF	347.11	347.11	346.37	346.43	6280.0
2023-09-06 06:00:00	DIA	ETF	346.53	346.53	346.53	346.53	525.0

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

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