PREVIEW / etf_daily / 2008-07-29

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-29.parquet
  size:    27 KB
  rows:    608

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-29	SPY	ETF	123.98	126.38	123.64	126.28	261505600.0
2008-07-29	QQQ	ETF	44.63	45.54	44.57	45.34	142291409.0
2008-07-29	IWM	ETF	69.68	71.4	69.61	71.18	122965400.0
2008-07-29	DIA	ETF	111.6	113.91	111.51	113.85	17201400.0
2008-07-29	GLD	ETF	91.23	91.27	90.09	90.59	12992200.0
2008-07-29	TLT	ETF	90.66	90.99	90.31	90.68	1349100.0
2008-07-29	ACWI	ETF	47.13	47.77	47.13	47.7	15700.0
2008-07-29	ACWX	ETF	47.7	48.26	47.7	48.17	12050.0
2008-07-29	ADRE	ETF	46.41	46.96	46.16	46.96	278514.0
2008-07-29	AFK	ETF	40.43	40.43	39.65	39.65	1250.0
2008-07-29	AGG	ETF	99.8	99.89	99.54	99.79	279200.0
2008-07-29	AIA	ETF	40.17	41.48	40.17	41.447	15897.0
2008-07-29	AIQ	ETF	45.05	47.0	44.7	45.65	50375.0
2008-07-29	AIS	ETF	0.7	0.75	0.65	0.75	268709.0
2008-07-29	AIVI	ETF	57.86	58.97	57.68	58.82	28800.0
2008-07-29	ARB	ETF	45.41	46.8	45.0	46.31	222835.0
2008-07-29	BBH	ETF	66.6633	67.4433	66.6633	67.03	728400.0
2008-07-29	BIL	ETF	91.84	91.86	91.8	91.84	70550.0
2008-07-29	BITS	ETF	22.72	23.32	21.48	23.32	4883.0
2008-07-29	BIV	ETF	75.83	76.12	75.79	75.92	34400.0
2008-07-29	BJK	ETF	30.4	30.5	30.03	30.35	600.0
2008-07-29	BKF	ETF	47.36	47.9	46.97	47.72	24067.0
2008-07-29	BLV	ETF	73.16	73.39	73.01	73.39	1200.0
2008-07-29	BMVP	ETF	14.63	14.9264	14.63	14.9177	47119.0
2008-07-29	BND	ETF	75.77	75.77	75.51	75.69	90100.0
2008-07-29	BNE	ETF	12.44	13.24	12.4	13.05	139204.0
2008-07-29	BOSS	ETF	23.25	23.25	21.85	21.85	300.0
2008-07-29	BRF	ETF	14.72	14.78	14.71	14.74	38355.0
2008-07-29	BSV	ETF	77.25	77.29	77.08	77.13	73900.0
2008-07-29	BTF	ETF	80.95	81.75	80.85000000000001	81.75	6825.0
2008-07-29	BWX	ETF	27.825	27.825	27.675	27.675	204694.0
2008-07-29	CBON	ETF	4.02	4.4699	3.86	4.33	244330.0
2008-07-29	CDL	ETF	0.9	0.97	0.89	0.91	919819.0
2008-07-29	CEF	ETF	12.9	12.95	12.71	12.79	516200.0
2008-07-29	CGO	ETF	15.02	15.05	14.91	15.0499	8176.0
2008-07-29	CGW	ETF	23.21	23.35	23.05	23.24	61666.0
2008-07-29	CHB	ETF	3.54	3.97	3.5	3.84	2352018.0
2008-07-29	CHI	ETF	13.34	13.47	13.3	13.4	80044.0
2008-07-29	CHIC	ETF	12.53	13.05	12.22	12.97	659939.0
2008-07-29	CHW	ETF	10.94	10.94	10.8282	10.86	108817.0
2008-07-29	CHY	ETF	12.88	12.88	12.66	12.83	102193.0
2008-07-29	CMF	ETF	51.225	51.349	51.2	51.349	16564.0
2008-07-29	CN	ETF	58.5	60.52	58.46	60.43	145229.0
2008-07-29	COW	ETF	43.16	43.23	42.73	43.14	19568.0
2008-07-29	CPST	ETF	3.01	3.28	3.01	3.27	3948808.0
2008-07-29	CSA	ETF	18.5	18.9624	18.5	18.9	84194.0
2008-07-29	CSB	ETF	18.86	18.97	18.0	18.02	34164.0
2008-07-29	CSD	ETF	20.88	21.15	20.81	21.15	21200.0
2008-07-29	CSQ	ETF	10.84	10.97	10.64	10.97	284559.0
2008-07-29	CUT	ETF	18.16	18.5	18.16	18.5	55100.0

> showing 50 of 608 rows — these rows as CSV

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