PREVIEW / etf_daily / 2005-08-16

all etf daily files

  file:    by_date/etf_daily/2005/2005-08-16.parquet
  size:    15 KB
  rows:    278

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-16	SPY	ETF	123.44	123.52	122.09	122.21	71942100.0
2005-08-16	QQQ	ETF	39.3	39.33	38.74	38.81	94913030.0
2005-08-16	IWM	ETF	66.07	66.08	65.06	65.06	18698200.0
2005-08-16	DIA	ETF	106.24	106.4	105.23	105.4	6792700.0
2005-08-16	GLD	ETF	44.06	44.57	44.05	44.55	1882600.0
2005-08-16	TLT	ETF	93.68	93.9	93.5	93.72	1311000.0
2005-08-16	AAA	ETF	56.33	56.33	55.93	55.99	3800.0
2005-08-16	ADRE	ETF	101.44	101.44	99.86	99.87	9008.0
2005-08-16	AFK	ETF	25.62	25.72	25.59	25.72	10700.0
2005-08-16	AGG	ETF	101.84	102.03	101.84	101.98	279600.0
2005-08-16	AIQ	ETF	47.05	47.45	46.2	46.75	12840.0
2005-08-16	AIS	ETF	0.96	0.9785	0.91	0.93	149600.0
2005-08-16	ARB	ETF	42.5	42.63	41.88	41.93	237900.0
2005-08-16	BAB	ETF	52.78	53.01	52.43	52.5	16500.0
2005-08-16	BBH	ETF	64.0133	64.2667	63.2033	63.2367	2447100.0
2005-08-16	BCM	ETF	59.06	59.06	58.27	58.48	44000.0
2005-08-16	BITS	ETF	12.64	13.96	12.64	13.08	12800.0
2005-08-16	BKF	ETF	32.19	32.23	31.24	31.3	19300.0
2005-08-16	BNE	ETF	13.6	13.8	13.58	13.68	119100.0
2005-08-16	BRF	ETF	15.45	15.49	15.38	15.46	10600.0
2005-08-16	BTF	ETF	85.95	86.05	85.74999999999999	85.8	980.0
2005-08-16	CBON	ETF	32.53	32.88	32.5	32.5	9347.0
2005-08-16	CDC	ETF	3.65	3.65	3.45	3.45	15300.0
2005-08-16	CDL	ETF	13.69	13.78	13.37	13.43	428900.0
2005-08-16	CEF	ETF	5.33	5.4	5.31	5.4	445800.0
2005-08-16	CEW	ETF	26.75	27.0	26.75	27.0	300.0
2005-08-16	CHB	ETF	11.96	12.02	11.87	11.91	488400.0
2005-08-16	CHI	ETF	20.19	20.48	20.171	20.33	96700.0
2005-08-16	CHIC	ETF	14.49	14.62	13.77	13.84	312030.0
2005-08-16	CHIR	ETF	36.72	36.75	36.0099	36.06	819041.0
2005-08-16	CHY	ETF	16.35	16.37	16.25	16.29	88400.0
2005-08-16	CIZ	ETF	23.6	23.6	23.6	23.6	300.0
2005-08-16	CN	ETF	35.05	35.3	34.92	34.93	10800.0
2005-08-16	CNXT	ETF	1.69	1.69	1.57	1.59	12902380.0
2005-08-16	CPI	ETF	23.25	23.25	23.25	23.25	1700.0
2005-08-16	CPST	ETF	3.05	3.12	2.84	2.95	1498121.0
2005-08-16	CSB	ETF	31.45	31.75	31.45	31.68	9800.0
2005-08-16	CSM	ETF	2.42	2.42	2.42	2.42	800.0
2005-08-16	CSQ	ETF	14.2	14.23	14.11	14.16	312400.0
2005-08-16	CTEC	ETF	53.349999999999994	54.74999999999999	53.099999999999994	54.74999999999999	6286.8
2005-08-16	CURE	ETF	0.2675	0.2675	0.25	0.25	1488400.0
2005-08-16	CYA	ETF	71.2	72.6	64.0	66.0	1205.0
2005-08-16	CYB	ETF	3.5	3.6	3.45	3.48	21400.0
2005-08-16	DGT	ETF	65.1	65.1	64.68	64.68	2300.0
2005-08-16	DIG	ETF	13.375	13.5	13.375	13.375	4080.0
2005-08-16	DIV	ETF	13.7	13.7	13.5	13.57	13200.0
2005-08-16	DRIV	ETF	39.4	39.5	37.98	37.98	605047.0
2005-08-16	DSI	ETF	5.785	5.785	5.75	5.78	13200.0
2005-08-16	DUSA	ETF	10.99	11.05	10.87	11.0	94993.0
2005-08-16	DVY	ETF	63.5	63.5	62.76	62.79	365900.0

> showing 50 of 278 rows — these rows as CSV

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