PREVIEW / etf_daily / 2008-07-16

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-16.parquet
  size:    27 KB
  rows:    606

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
2008-07-16	SPY	ETF	121.45	124.57	121.1	123.96	371642900.0
2008-07-16	QQQ	ETF	44.3	45.38	43.92	45.34	186047787.0
2008-07-16	IWM	ETF	66.31	68.49	65.79	68.3	112222900.0
2008-07-16	DIA	ETF	109.73	112.47	109.2	112.17	31071000.0
2008-07-16	GLD	ETF	96.27	96.5	94.34	94.44	19897400.0
2008-07-16	TLT	ETF	92.08	92.24	91.21	91.26	3435900.0
2008-07-16	ACWI	ETF	46.56	47.35	46.43	47.27	640000.0
2008-07-16	ACWX	ETF	47.2236	47.948	47.12	47.948	5829.0
2008-07-16	ADRE	ETF	47.26	48.28	46.88	48.25	3109578.0
2008-07-16	AFK	ETF	41.41	41.41	40.4	40.4	1520.0
2008-07-16	AGG	ETF	100.51	100.52	100.0	100.0	487400.0
2008-07-16	AIA	ETF	39.97	40.12	38.64	39.971	12225.0
2008-07-16	AIQ	ETF	42.5	43.4	42.2	43.35	26682.0
2008-07-16	AIS	ETF	0.69	0.74	0.69	0.74	43551.0
2008-07-16	AIVI	ETF	55.72	57.35	55.72	57.35	15600.0
2008-07-16	ARB	ETF	46.45	46.45	45.26	45.58	460691.0
2008-07-16	BBH	ETF	60.59	60.6867	59.67	59.7367	689100.0
2008-07-16	BIL	ETF	91.86	91.88	91.8	91.86	375100.0
2008-07-16	BITS	ETF	22.4	23.84	22.24	23.76	1081.0
2008-07-16	BIV	ETF	76.41	76.61	76.23	76.23	17900.0
2008-07-16	BJK	ETF	28.49	28.49	28.0	28.3	400.0
2008-07-16	BKF	ETF	47.99	50.0	47.98	50.0	34920.0
2008-07-16	BLV	ETF	73.94	73.94	73.29	73.3	7400.0
2008-07-16	BMVP	ETF	14.51	14.76	14.49	14.75	90974.0
2008-07-16	BND	ETF	76.06	76.1	75.64	75.76	152000.0
2008-07-16	BNE	ETF	11.3	11.83	11.19	11.81	145798.0
2008-07-16	BSV	ETF	77.39	77.46	77.22	77.28	121000.0
2008-07-16	BTF	ETF	81.4	81.99999999999999	80.05	81.89999999999999	4397.0
2008-07-16	BWX	ETF	28.21	28.26	28.0	28.125	290552.0
2008-07-16	CBON	ETF	2.95	3.3	2.95	3.21	170576.0
2008-07-16	CDL	ETF	0.69	0.8599	0.69	0.82	1417713.0
2008-07-16	CEF	ETF	13.79	13.82	13.36	13.51	1486800.0
2008-07-16	CGO	ETF	14.45	14.59	14.2501	14.59	23826.0
2008-07-16	CGW	ETF	21.51	22.23	21.47	22.15	57749.0
2008-07-16	CHB	ETF	4.5	4.81	4.4	4.7	2924749.0
2008-07-16	CHI	ETF	12.03	13.08	12.03	13.05	159376.0
2008-07-16	CHIC	ETF	16.18	17.22	16.09	16.99	411159.0
2008-07-16	CHW	ETF	10.27	10.33	9.9	10.31	176467.0
2008-07-16	CHY	ETF	11.26	12.18	11.26	12.18	226653.0
2008-07-16	CMF	ETF	52.035	52.035	51.7	51.8725	9824.0
2008-07-16	CN	ETF	57.91	60.61	57.91	60.61	453717.0
2008-07-16	COW	ETF	43.19	43.71	43.02	43.71	46806.0
2008-07-16	CPST	ETF	3.65	3.75	3.5	3.74	3801944.0
2008-07-16	CSA	ETF	16.7	17.84	16.7	17.83	35988.0
2008-07-16	CSB	ETF	13.0	15.8	13.0	15.19	93949.0
2008-07-16	CSD	ETF	20.27	20.68	20.18	20.68	3200.0
2008-07-16	CSQ	ETF	10.11	10.4164	9.9	10.35	352362.0
2008-07-16	CUT	ETF	18.43	18.43	17.39	17.92	44600.0
2008-07-16	CVY	ETF	19.06	19.56	19.04	19.56	17300.0
2008-07-16	CWI	ETF	22.8933	23.7867	22.72	23.7867	51450.0

> showing 50 of 606 rows — these rows as CSV

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