PREVIEW / etf_daily / 2008-10-14

all etf daily files

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

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-14	SPY	ETF	104.7	105.53	97.11	99.85	546268300.0
2008-10-14	QQQ	ETF	36.1	36.15	33.19	33.61	342311616.0
2008-10-14	IWM	ETF	58.75	58.85	53.86	55.38	131474600.0
2008-10-14	DIA	ETF	97.9	98.8	90.9	93.67	58571000.0
2008-10-14	GLD	ETF	82.4	83.31	81.61	82.2	12383200.0
2008-10-14	TLT	ETF	94.25	95.26	93.9	94.11	2100000.0
2008-10-14	AAXJ	ETF	39.68	39.68	35.74	37.43	9900.0
2008-10-14	ACWI	ETF	36.46	37.61	35.0	35.45	124600.0
2008-10-14	ACWX	ETF	35.03	35.49	33.22	33.57	160757.0
2008-10-14	ADRE	ETF	33.99	34.0	30.37	31.21	482382.0
2008-10-14	AFK	ETF	28.4	28.4	27.47	27.56	3152.0
2008-10-14	AGG	ETF	92.63	95.25	92.6	93.75	773100.0
2008-10-14	AIA	ETF	33.04	33.04	29.61	30.8	40109.0
2008-10-14	AIQ	ETF	44.95	45.05	41.1	42.1	34736.0
2008-10-14	AIS	ETF	0.51	0.51	0.47	0.5	42717.0
2008-10-14	AIVI	ETF	44.57	44.73	41.6	42.58	25900.0
2008-10-14	ARB	ETF	41.19	41.27	37.68	38.18	336305.0
2008-10-14	BAL	ETF	31.54	31.54	31.2701	31.2701	600.0
2008-10-14	BBH	ETF	56.6633	57.0567	54.1833	54.3333	821400.0
2008-10-14	BIL	ETF	91.6	91.88	91.54	91.86	195150.0
2008-10-14	BITS	ETF	17.2	17.2	14.2	16.0	6952.0
2008-10-14	BIV	ETF	70.45	71.21	69.23	70.78	78600.0
2008-10-14	BJK	ETF	21.27	21.27	19.9	19.94	2100.0
2008-10-14	BKF	ETF	31.5	31.75	27.78	28.7	110454.0
2008-10-14	BLV	ETF	68.0	69.02	68.0	68.61	24100.0
2008-10-14	BMVP	ETF	11.57	12.47	11.07	11.35	143194.0
2008-10-14	BND	ETF	74.17	74.47	72.62	73.8	368600.0
2008-10-14	BNE	ETF	6.93	7.14	6.34	6.46	146901.0
2008-10-14	BOSS	ETF	15.2	17.0	15.2	17.0	1100.0
2008-10-14	BRF	ETF	14.7	14.7	14.68	14.68	5300.0
2008-10-14	BSV	ETF	71.52	75.0	71.28	74.45	362100.0
2008-10-14	BTF	ETF	61.699999999999996	63.49999999999999	60.815	62.0995	8896.0
2008-10-14	BWX	ETF	24.235	25.1945	24.205	24.54	428480.0
2008-10-14	CBON	ETF	4.24	4.24	3.79	3.79	43870.0
2008-10-14	CDL	ETF	0.3501	0.4	0.3	0.33	1013459.0
2008-10-14	CEF	ETF	10.68	11.14	10.57	11.05	1042200.0
2008-10-14	CGO	ETF	9.85	10.02	9.7	9.89	78538.0
2008-10-14	CGW	ETF	18.37	18.37	16.98	17.41	52583.0
2008-10-14	CHB	ETF	4.51	4.59	3.8	3.98	1875271.0
2008-10-14	CHI	ETF	8.61	8.97	8.15	8.71	416667.0
2008-10-14	CHIC	ETF	9.9	9.99	8.93	9.15	376809.0
2008-10-14	CHW	ETF	6.34	6.71	6.0	6.39	410200.0
2008-10-14	CHY	ETF	9.15	9.15	7.35	7.49	972072.0
2008-10-14	CMF	ETF	45.795	46.0	45.625	46.0	5514.0
2008-10-14	CNXT	ETF	2.89	2.9	2.56	2.59	420346.0
2008-10-14	COW	ETF	37.7	37.89	37.03	37.03	20961.0
2008-10-14	CPI	ETF	22.25	22.25	22.25	22.25	1000.0
2008-10-14	CPST	ETF	1.44	1.44	1.29	1.38	3454531.0
2008-10-14	CSA	ETF	14.85	14.85	13.01	13.71	90389.0
2008-10-14	CSB	ETF	13.15	15.0	13.11	14.96	22550.0

> showing 50 of 609 rows — these rows as CSV

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