PREVIEW / etf_daily / 2005-08-12

all etf daily files

  file:    by_date/etf_daily/2005/2005-08-12.parquet
  size:    15 KB
  rows:    276

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2005-08-12	SPY	ETF	123.57	123.69	122.75	123.06	54776900.0
2005-08-12	QQQ	ETF	39.12	39.32	38.97	39.21	86470098.0
2005-08-12	IWM	ETF	66.04	66.07	65.13	65.52	25523100.0
2005-08-12	DIA	ETF	106.65	106.68	105.8	106.01	5361800.0
2005-08-12	GLD	ETF	44.49	44.72	44.43	44.49	2428500.0
2005-08-12	TLT	ETF	92.62	93.44	92.57	93.31	1765100.0
2005-08-12	AAA	ETF	56.58	56.76	56.54	56.6	15200.0
2005-08-12	ADRE	ETF	103.1	103.1	100.0401	100.83	12536.0
2005-08-12	AFK	ETF	25.71	25.73	25.62	25.62	7000.0
2005-08-12	AGG	ETF	101.59	101.88	101.54	101.83	93400.0
2005-08-12	AIQ	ETF	46.55	46.55	45.15	46.0	14000.0
2005-08-12	AIS	ETF	0.95	0.95	0.92	0.95	53700.0
2005-08-12	ARB	ETF	41.98	42.23	41.36	41.88	190700.0
2005-08-12	BAB	ETF	52.39	52.8	52.32	52.67	56700.0
2005-08-12	BBH	ETF	63.7633	63.7667	63.16	63.52	932100.0
2005-08-12	BCM	ETF	59.97	60.12	59.61	59.64	25200.0
2005-08-12	BIS	ETF	678.4	680.0	651.2	659.2	33.75
2005-08-12	BITS	ETF	14.24	14.24	13.196	13.4	6632.0
2005-08-12	BKF	ETF	31.1	31.1	30.76	30.9	38600.0
2005-08-12	BNE	ETF	13.77	13.77	13.5	13.62	132100.0
2005-08-12	BRF	ETF	15.44	15.46	15.4	15.45	4000.0
2005-08-12	BTF	ETF	85.64999999999999	85.74999999999999	85.1	85.7	580.0
2005-08-12	CBON	ETF	33.0	33.58	32.5	33.37	8448.0
2005-08-12	CDC	ETF	3.8	3.9	3.8	3.81	3100.0
2005-08-12	CDL	ETF	13.57	13.6	13.23	13.55	293400.0
2005-08-12	CEF	ETF	5.39	5.39	5.33	5.38	247700.0
2005-08-12	CEW	ETF	26.68	26.76	26.68	26.76	600.0
2005-08-12	CHB	ETF	12.0	12.07	11.61	11.91	383900.0
2005-08-12	CHI	ETF	20.45	20.63	20.21	20.23	120200.0
2005-08-12	CHIC	ETF	14.41	14.71	14.35	14.52	368930.0
2005-08-12	CHIR	ETF	36.7101	36.8499	36.3399	36.7101	937556.0
2005-08-12	CHY	ETF	16.5	16.5373	16.4	16.4	84200.0
2005-08-12	CIL	ETF	25.78	25.78	25.73	25.73	700.0
2005-08-12	CN	ETF	34.57	34.57	34.0	34.15	16400.0
2005-08-12	CNXT	ETF	1.74	1.7501	1.69	1.72	3454279.0
2005-08-12	CPI	ETF	23.4	23.4	23.4	23.4	1100.0
2005-08-12	CPST	ETF	3.25	3.34	3.12	3.2	1738608.0
2005-08-12	CSB	ETF	31.65	31.69	31.4	31.51	8100.0
2005-08-12	CSM	ETF	2.4175	2.42	2.4175	2.42	6400.0
2005-08-12	CSQ	ETF	14.26	14.32	14.19	14.23	230500.0
2005-08-12	CTEC	ETF	53.849999999999994	54.699999999999996	52.449999999999996	54.3	4281.8
2005-08-12	CURE	ETF	0.3	0.3	0.2762	0.2762	2364408.0
2005-08-12	CYA	ETF	75.0	80.0	75.0	80.0	330.0
2005-08-12	CYB	ETF	3.65	3.65	3.3	3.34	35800.0
2005-08-12	DGT	ETF	65.5	65.53	65.14	65.19	2700.0
2005-08-12	DIG	ETF	13.4625	13.4625	13.4375	13.45	4320.0
2005-08-12	DIV	ETF	13.5	13.65	13.452	13.6	10500.0
2005-08-12	DRIV	ETF	37.62	38.88	37.23	38.515	1243243.0
2005-08-12	DUSA	ETF	10.94	11.16	10.51	10.8	106492.0
2005-08-12	DVY	ETF	63.28	63.46	62.87	63.25	463900.0

> showing 50 of 276 rows — these rows as CSV

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