PREVIEW / etf_daily / 2008-10-10

all etf daily files

  file:    by_date/etf_daily/2008/2008-10-10.parquet
  size:    27 KB
  rows:    616

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-10-10	SPY	ETF	86.76	93.94	83.58	88.5	871026300.0
2008-10-10	QQQ	ETF	30.52	32.48	29.38	31.32	472453186.0
2008-10-10	IWM	ETF	47.66	54.67	46.51	52.45	205089400.0
2008-10-10	DIA	ETF	82.39	89.08	78.94	83.75	73755500.0
2008-10-10	GLD	ETF	89.59	90.72	81.38	83.22	45067300.0
2008-10-10	TLT	ETF	96.61	96.91	95.51	95.95	2200000.0
2008-10-10	AAXJ	ETF	32.36	32.82	30.37	32.55	7600.0
2008-10-10	ACWI	ETF	31.3	32.8	29.83	31.74	135000.0
2008-10-10	ACWX	ETF	29.38	30.5	28.234	29.876	74025.0
2008-10-10	ADRE	ETF	25.25	28.01	24.23	26.14	784827.0
2008-10-10	AFK	ETF	25.07	25.312	24.3	24.3	1385.0
2008-10-10	AGG	ETF	91.3	91.99	86.8	88.4	1559700.0
2008-10-10	AIA	ETF	25.6	27.49	24.5	27.4799	32462.0
2008-10-10	AIQ	ETF	38.6	41.7	36.73	41.7	83452.0
2008-10-10	AIS	ETF	0.49	0.5	0.41	0.5	109010.0
2008-10-10	AIVI	ETF	37.4	38.58	35.76	37.32	64500.0
2008-10-10	ARB	ETF	36.74	40.82	35.83	39.98	567010.0
2008-10-10	BAL	ETF	30.67	31.24	30.67	31.2399	975.0
2008-10-10	BBH	ETF	50.22	52.1567	47.87	50.5833	1970700.0
2008-10-10	BIL	ETF	92.0	92.1	91.48	92.06	351150.0
2008-10-10	BITS	ETF	16.0	16.64	15.2	15.32	7748.0
2008-10-10	BIV	ETF	68.94	69.57	67.04	67.12	108000.0
2008-10-10	BJK	ETF	18.35	18.35	16.2	16.2	4400.0
2008-10-10	BKF	ETF	21.51	24.97	21.0	23.8	109683.0
2008-10-10	BLV	ETF	67.13	68.5	65.54	66.25	34500.0
2008-10-10	BMVP	ETF	9.2333	10.5365	9.0335	10.0933	102142.0
2008-10-10	BND	ETF	70.25	71.59	67.0	69.96	648000.0
2008-10-10	BNE	ETF	6.3	6.5	5.7	6.08	466081.0
2008-10-10	BOSS	ETF	15.69	15.69	15.69	15.69	200.0
2008-10-10	BRF	ETF	14.53	14.62	14.48	14.6	38450.0
2008-10-10	BSV	ETF	76.5	76.96	74.75	75.04	243000.0
2008-10-10	BTF	ETF	50.99999999999999	51.3	42.0	51.3	28610.800000000003
2008-10-10	BWX	ETF	23.71	24.225	21.5	24.0	1310750.0
2008-10-10	CBON	ETF	3.84	4.002	3.54	3.85	126324.0
2008-10-10	CDL	ETF	0.37	0.4	0.33	0.35	1114036.0
2008-10-10	CEF	ETF	11.74	12.0	10.25	10.85	4059100.0
2008-10-10	CGO	ETF	7.07	7.59	6.5	7.42	94004.0
2008-10-10	CGW	ETF	14.34	15.48	13.89	15.36	323891.0
2008-10-10	CHB	ETF	3.19	4.5	2.95	3.33	3191648.0
2008-10-10	CHI	ETF	5.81	6.55	5.5	6.34	571797.0
2008-10-10	CHIC	ETF	8.75	9.53	8.37	9.27	629406.0
2008-10-10	CHW	ETF	4.13	4.82	3.58	4.55	697278.0
2008-10-10	CHY	ETF	7.8	7.8	6.5	7.55	820972.0
2008-10-10	CMF	ETF	47.14	47.215	43.66	46.082	33210.0
2008-10-10	CNXT	ETF	2.26	2.3901	2.1	2.3	882106.0
2008-10-10	COW	ETF	35.99	36.73	33.12	36.05	134043.0
2008-10-10	CPI	ETF	22.4	22.4	22.0	22.0	800.0
2008-10-10	CPST	ETF	0.94	1.21	0.94	1.2	4255111.0
2008-10-10	CSA	ETF	12.34	14.3	11.91	14.3	169294.0
2008-10-10	CSB	ETF	10.84	12.0	8.54	11.63	78572.0

> showing 50 of 616 rows — these rows as CSV

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