PREVIEW / etf_1hour / 2005-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-24.parquet
  size:    33 KB
  rows:    989

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
2005-10-24 07:00:00	SPY	ETF	118.49	118.52	118.49	118.52	21000.0
2005-10-24 08:00:00	SPY	ETF	118.42	118.54	115.52	118.39	246400.0
2005-10-24 09:00:00	SPY	ETF	118.41	119.01	117.88	118.93	14663900.0
2005-10-24 10:00:00	SPY	ETF	118.93	119.18	118.51	118.67	10814600.0
2005-10-24 11:00:00	SPY	ETF	118.69	119.27	118.64	119.09	7795300.0
2005-10-24 12:00:00	SPY	ETF	119.09	119.55	119.07	119.39	8529000.0
2005-10-24 13:00:00	SPY	ETF	119.38	119.57	119.23	119.51	6686400.0
2005-10-24 14:00:00	SPY	ETF	119.53	119.61	119.33	119.4	5369400.0
2005-10-24 15:00:00	SPY	ETF	119.38	120.06	119.35	120.03	14593900.0
2005-10-24 16:00:00	SPY	ETF	120.04	120.07	119.03	119.9	2086700.0
2005-10-24 17:00:00	SPY	ETF	119.9	119.92	119.87	119.91	60800.0
2005-10-24 18:00:00	SPY	ETF	119.87	119.94	119.6263	119.94	34100.0
2005-10-24 19:00:00	SPY	ETF	119.92	120.0	119.92	120.0	24700.0
2005-10-24 09:00:00	QQQ	ETF	38.72	38.76	36.67	38.72	12909700.0
2005-10-24 10:00:00	QQQ	ETF	38.71	38.81	38.47	38.54	17756500.0
2005-10-24 11:00:00	QQQ	ETF	38.54	38.79	38.53	38.75	15726200.0
2005-10-24 12:00:00	QQQ	ETF	38.75	38.97	38.73	38.94	14078600.0
2005-10-24 13:00:00	QQQ	ETF	38.94	38.97	38.85	38.93	9512300.0
2005-10-24 14:00:00	QQQ	ETF	38.92	38.96	38.82	38.84	9333000.0
2005-10-24 15:00:00	QQQ	ETF	38.84	39.16	38.84	39.15	15363800.0
2005-10-24 08:00:00	IWM	ETF	63.16	63.22	63.14	63.14	83100.0
2005-10-24 09:00:00	IWM	ETF	63.12	63.74	63.1	63.63	8003600.0
2005-10-24 10:00:00	IWM	ETF	63.61	63.85	63.3	63.45	6053300.0
2005-10-24 11:00:00	IWM	ETF	63.45	63.85	63.4	63.72	4373000.0
2005-10-24 12:00:00	IWM	ETF	63.72	63.98	63.67	63.93	2757200.0
2005-10-24 13:00:00	IWM	ETF	63.93	64.05	63.82	64.01	2219800.0
2005-10-24 14:00:00	IWM	ETF	64.01	64.05	63.81	63.85	2042800.0
2005-10-24 15:00:00	IWM	ETF	63.84	64.29	63.81	64.29	3850900.0
2005-10-24 16:00:00	IWM	ETF	64.27	64.36	64.24	64.28	78900.0
2005-10-24 17:00:00	IWM	ETF	64.28	64.28	64.28	64.28	1500.0
2005-10-24 08:00:00	DIA	ETF	102.48	102.59	102.44	102.53	127900.0
2005-10-24 09:00:00	DIA	ETF	102.52	102.83	102.52	102.75	918400.0
2005-10-24 10:00:00	DIA	ETF	102.75	102.93	102.44	102.56	2814400.0
2005-10-24 11:00:00	DIA	ETF	102.56	103.15	102.54	103.02	1051500.0
2005-10-24 12:00:00	DIA	ETF	103.03	103.35	103.0001	103.24	1557400.0
2005-10-24 13:00:00	DIA	ETF	103.24	103.37	103.09	103.33	1688200.0
2005-10-24 14:00:00	DIA	ETF	103.34	103.4	103.18	103.22	774800.0
2005-10-24 15:00:00	DIA	ETF	103.21	103.82	103.17	103.79	1939800.0
2005-10-24 16:00:00	DIA	ETF	103.81	103.82	103.66	103.67	210600.0
2005-10-24 17:00:00	DIA	ETF	103.67	103.67	103.67	103.67	100.0
2005-10-24 19:00:00	DIA	ETF	103.73	103.73	103.73	103.73	1000.0
2005-10-24 08:00:00	GLD	ETF	46.41	46.41	46.33	46.33	600.0
2005-10-24 09:00:00	GLD	ETF	46.35	46.46	46.35	46.41	118200.0
2005-10-24 10:00:00	GLD	ETF	46.4101	46.6	46.4	46.54	605800.0
2005-10-24 11:00:00	GLD	ETF	46.53	46.73	46.4	46.71	374700.0
2005-10-24 12:00:00	GLD	ETF	46.7	46.7	46.5	46.52	472700.0
2005-10-24 13:00:00	GLD	ETF	46.539	46.5799	46.31	46.4	193600.0
2005-10-24 14:00:00	GLD	ETF	46.4	46.49	46.35	46.4	110400.0
2005-10-24 15:00:00	GLD	ETF	46.4	46.41	46.35	46.38	152300.0
2005-10-24 08:00:00	TLT	ETF	91.39	91.39	91.32	91.32	4300.0

> showing 50 of 989 rows — these rows as CSV

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