PREVIEW / etf_daily / 2008-06-16

all etf daily files

  file:    by_date/etf_daily/2008/2008-06-16.parquet
  size:    26 KB
  rows:    588

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-06-16	SPY	ETF	135.55	136.93	135.46	136.23	185832500.0
2008-06-16	QQQ	ETF	48.12	49.02	48.07	48.8	136343825.0
2008-06-16	IWM	ETF	73.05	74.09	72.95	73.78	67157700.0
2008-06-16	DIA	ETF	122.53	123.37	122.25	122.66	11578600.0
2008-06-16	GLD	ETF	88.2	88.2	86.97	87.01	6993700.0
2008-06-16	TLT	ETF	89.11	89.18	88.62	88.89	1756800.0
2008-06-16	ACWI	ETF	51.32	51.68	51.32	51.61	3300.0
2008-06-16	ACWX	ETF	52.17	52.69	52.17	52.53	18897.0
2008-06-16	ADRE	ETF	52.46	52.89	52.33	52.61	307883.0
2008-06-16	AGG	ETF	99.57	99.6	99.19	99.31	460400.0
2008-06-16	AIA	ETF	43.64	43.64	43.3	43.63	2860.0
2008-06-16	AIQ	ETF	46.5	47.25	46.25	47.2	78016.0
2008-06-16	AIS	ETF	0.81	0.81	0.78	0.78	38160.0
2008-06-16	AIVI	ETF	63.31	63.49	63.09	63.42	11000.0
2008-06-16	ARB	ETF	50.9	51.25	50.15	50.9	269049.0
2008-06-16	BBH	ETF	55.6667	55.9367	55.0	55.75	369000.0
2008-06-16	BIL	ETF	91.76	91.78	91.72	91.76	186350.0
2008-06-16	BITS	ETF	27.12	27.48	26.84	26.84	3130.0
2008-06-16	BIV	ETF	75.91	75.91	75.43	75.69	33600.0
2008-06-16	BJK	ETF	34.58	34.75	34.25	34.31	6000.0
2008-06-16	BKF	ETF	54.98	54.98	54.28	54.32	30201.0
2008-06-16	BLV	ETF	73.33	73.48	72.95	73.36	7100.0
2008-06-16	BMVP	ETF	15.5667	16.0933	15.5567	16.0667	22566.0
2008-06-16	BND	ETF	75.2	75.45	75.15	75.25	168500.0
2008-06-16	BNE	ETF	15.1	15.13	14.92	15.08	85047.0
2008-06-16	BRF	ETF	14.76	14.76	14.73	14.73	2000.0
2008-06-16	BSV	ETF	76.76	76.79	76.64	76.69	37300.0
2008-06-16	BTF	ETF	101.3	101.44999999999999	100.85000000000001	101.14999999999999	4218.6
2008-06-16	BWX	ETF	26.94	27.1	26.83	26.87	259066.0
2008-06-16	CBON	ETF	6.87	6.87	6.47	6.59	108215.0
2008-06-16	CDL	ETF	1.46	1.51	1.44	1.5	1373791.0
2008-06-16	CEF	ETF	12.4	12.41	12.22	12.22	529800.0
2008-06-16	CGO	ETF	16.19	16.19	15.95	16.17	19951.0
2008-06-16	CGW	ETF	25.46	25.46	24.61	24.83	69073.0
2008-06-16	CHB	ETF	7.56	7.56	7.28	7.52	1340549.0
2008-06-16	CHI	ETF	15.23	15.31	15.0	15.06	64938.0
2008-06-16	CHIC	ETF	18.58	18.72	18.3	18.64	310919.0
2008-06-16	CHW	ETF	11.99	12.14	11.99	12.05	85659.0
2008-06-16	CHY	ETF	14.23	14.23	13.9	14.01	79091.0
2008-06-16	CMF	ETF	51.815	51.815	51.68	51.785	9186.0
2008-06-16	CN	ETF	56.37	56.81	56.23	56.76	173590.0
2008-06-16	CNXT	ETF	0.6602	0.6602	0.59	0.6	4031314.0
2008-06-16	COW	ETF	44.23	45.25	43.99	44.43	697691.0
2008-06-16	CPI	ETF	21.15	21.6	21.1	21.3161	1400.0
2008-06-16	CPST	ETF	3.75	3.88	3.73	3.82	4096678.0
2008-06-16	CSA	ETF	19.0	19.04	18.7	18.86	61641.0
2008-06-16	CSB	ETF	20.14	20.2	19.71	20.18	30050.0
2008-06-16	CSD	ETF	23.54	23.65	23.51	23.65	5000.0
2008-06-16	CSQ	ETF	12.3	12.45	12.21	12.43	240256.0
2008-06-16	CUT	ETF	20.73	20.74	20.53	20.63	25400.0

> showing 50 of 588 rows — these rows as CSV

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