PREVIEW / etf_daily / 2008-04-09

all etf daily files

  file:    by_date/etf_daily/2008/2008-04-09.parquet
  size:    26 KB
  rows:    580

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-04-09	SPY	ETF	136.61	136.8	134.89	135.83	195610600.0
2008-04-09	QQQ	ETF	45.47	45.49	44.63	44.9	127256916.0
2008-04-09	IWM	ETF	71.09	71.35	69.45	69.81	71772700.0
2008-04-09	DIA	ETF	126.05	126.2	124.67	125.65	15037200.0
2008-04-09	GLD	ETF	90.3	92.37	90.24	92.29	10572400.0
2008-04-09	TLT	ETF	94.56	95.64	94.55	95.35	2883600.0
2008-04-09	ACWI	ETF	51.32	51.32	51.03	51.12	4300.0
2008-04-09	ACWX	ETF	52.27	52.28	52.27	52.28	559.0
2008-04-09	ADRE	ETF	51.73	51.982	50.91	51.17	216944.0
2008-04-09	AGG	ETF	102.61	103.0	102.46	102.89	492700.0
2008-04-09	AIA	ETF	45.3	45.43	44.36	44.65	6200.0
2008-04-09	AIQ	ETF	43.5	43.95	43.05	43.15	27980.0
2008-04-09	AIS	ETF	0.91	0.9178	0.9	0.9	57100.0
2008-04-09	AIVI	ETF	66.17	66.21	65.45	65.53	14500.0
2008-04-09	ARB	ETF	44.87	45.08	44.14	44.79	187500.0
2008-04-09	BBH	ETF	57.63	57.6433	56.5533	56.95	618900.0
2008-04-09	BIL	ETF	91.7	91.78	91.7	91.76	33900.0
2008-04-09	BITS	ETF	23.56	24.44	22.48	23.2	7704.0
2008-04-09	BIV	ETF	78.78	79.44	78.78	78.9	24900.0
2008-04-09	BJK	ETF	40.44	40.44	40.44	40.44	300.0
2008-04-09	BKF	ETF	52.43	52.6	51.71	51.71	23900.0
2008-04-09	BLV	ETF	76.63	77.21	76.63	77.11	1900.0
2008-04-09	BMVP	ETF	15.72	15.758	15.62	15.6633	38400.0
2008-04-09	BND	ETF	77.52	77.72	77.34	77.65	78500.0
2008-04-09	BNE	ETF	15.85	15.85	15.29	15.63	294900.0
2008-04-09	BOSS	ETF	35.64	36.95	35.64	36.95	100.0
2008-04-09	BRF	ETF	14.63	14.64	14.62	14.63	23800.0
2008-04-09	BSV	ETF	78.3	78.76	78.3	78.73	50100.0
2008-04-09	BTF	ETF	103.3	103.49999999999999	101.99999999999999	101.99999999999999	3840.0
2008-04-09	BWX	ETF	28.62	28.9	28.62	28.75	170618.0
2008-04-09	CBON	ETF	12.28	12.58	11.72	12.06	42970.0
2008-04-09	CDL	ETF	1.87	1.87	1.7	1.79	581438.0
2008-04-09	CEF	ETF	12.77	13.2	12.77	13.15	541500.0
2008-04-09	CGO	ETF	16.36	16.39	15.92	16.11	34500.0
2008-04-09	CGW	ETF	24.99	25.0	23.885	23.99	99431.0
2008-04-09	CHB	ETF	10.52	10.6	9.9	10.02	1357865.0
2008-04-09	CHI	ETF	14.54	14.54	14.13	14.1324	76501.0
2008-04-09	CHIC	ETF	17.2	17.2	16.54	16.67	567282.0
2008-04-09	CHW	ETF	11.76	11.776	11.44	11.46	146624.0
2008-04-09	CHY	ETF	13.33	13.33	12.9	12.92	110050.0
2008-04-09	CMF	ETF	51.92	52.405	51.92	52.375	4600.0
2008-04-09	CN	ETF	56.2	56.2	54.51	54.88	309357.0
2008-04-09	CNXT	ETF	0.616	0.6299	0.58	0.59	1867909.0
2008-04-09	COW	ETF	41.52	41.63	40.7	40.94	33600.0
2008-04-09	CPI	ETF	17.6	17.6	17.5	17.5	300.0
2008-04-09	CPST	ETF	2.56	2.56	2.43	2.46	1395709.0
2008-04-09	CSA	ETF	16.31	16.34	15.41	15.58	59923.0
2008-04-09	CSB	ETF	21.5	21.64	21.0	21.46	48300.0
2008-04-09	CSD	ETF	23.58	23.58	23.27	23.27	2200.0
2008-04-09	CSQ	ETF	12.27	12.29	12.05	12.1	302400.0

> showing 50 of 580 rows — these rows as CSV

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