PREVIEW / etf_daily / 2009-02-27

all etf daily files

  file:    by_date/etf_daily/2009/2009-02-27.parquet
  size:    28 KB
  rows:    636

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
2009-02-27	SPY	ETF	74.01	75.69	73.81	73.93	470510900.0
2009-02-27	QQQ	ETF	27.49	27.98	27.39	27.53	204492546.0
2009-02-27	IWM	ETF	38.72	39.88	38.64	39.15	87450900.0
2009-02-27	DIA	ETF	70.63	72.0	70.37	70.76	35756000.0
2009-02-27	GLD	ETF	94.31	94.53	91.03	92.63	30588700.0
2009-02-27	TLT	ETF	102.57	103.01	101.21	101.88	3267700.0
2009-02-27	AAXJ	ETF	28.61	28.87	28.37	28.51	134800.0
2009-02-27	ACWI	ETF	27.86	27.86	25.8	25.94	45400.0
2009-02-27	ACWX	ETF	23.96	24.43	23.81	24.04	92388.0
2009-02-27	ADRE	ETF	24.65	25.01	24.21	24.59	286025.0
2009-02-27	AFK	ETF	18.56	18.56	18.02	18.02	700.0
2009-02-27	AGG	ETF	100.62	100.95	100.5	100.69	463800.0
2009-02-27	AGQ	ETF	83.48	84.5	78.0	81.54	130250.0
2009-02-27	AGZ	ETF	106.9	107.52	106.58	107.52	17484.0
2009-02-27	AIA	ETF	21.97	22.23	21.89	22.18	1861.0
2009-02-27	AIQ	ETF	41.9	43.05	41.0	41.0	27863.0
2009-02-27	AIS	ETF	0.42	0.43	0.402	0.42	56146.0
2009-02-27	AIVI	ETF	26.14	26.7	25.79	26.37	26900.0
2009-02-27	AOA	ETF	20.13	20.55	19.62	20.29	58800.0
2009-02-27	AOK	ETF	24.29	24.29	24.2	24.2	1223.0
2009-02-27	AOM	ETF	23.85	23.85	22.56	23.1	5857.0
2009-02-27	AOR	ETF	21.82	22.047	21.82	21.9	9052.0
2009-02-27	ARB	ETF	12.52	13.2	12.52	12.94	409811.0
2009-02-27	BAL	ETF	24.8	24.8	24.61	24.61	200.0
2009-02-27	BBH	ETF	55.08	56.11	54.3933	54.5533	847200.0
2009-02-27	BIL	ETF	91.72	91.78	91.7	91.74	142750.0
2009-02-27	BITS	ETF	17.36	18.8	17.34	17.52	2600.0
2009-02-27	BIV	ETF	76.09	76.18	75.58	75.75	66800.0
2009-02-27	BJK	ETF	14.38	14.38	14.38	14.38	200.0
2009-02-27	BKF	ETF	21.82	21.9892	21.25	21.58	73747.0
2009-02-27	BLV	ETF	73.18	73.18	72.66	72.91	9000.0
2009-02-27	BMVP	ETF	9.21	9.3846	9.17	9.2333	154323.0
2009-02-27	BND	ETF	76.51	76.61	76.29	76.59	548700.0
2009-02-27	BNE	ETF	1.85	1.85	1.52	1.58	192953.0
2009-02-27	BSV	ETF	78.7	78.85	78.42	78.67	184600.0
2009-02-27	BTF	ETF	39.24999999999999	39.449999999999996	38.1	38.75	8225.4
2009-02-27	BWX	ETF	24.48	24.575	24.455	24.47	144194.0
2009-02-27	CBON	ETF	1.12	1.12	0.9	0.9	35136.0
2009-02-27	CDL	ETF	0.14	0.15	0.09	0.09	3272507.0
2009-02-27	CEF	ETF	12.05	12.2	11.52	11.77	1785900.0
2009-02-27	CGO	ETF	8.49	8.738	8.45	8.5	13119.0
2009-02-27	CGW	ETF	11.49	11.97	11.28	11.6	40181.0
2009-02-27	CHB	ETF	0.37	0.38	0.28	0.29	485627.0
2009-02-27	CHI	ETF	7.66	8.07	7.39	8.04	197071.0
2009-02-27	CHIC	ETF	5.11	5.59	5.11	5.26	133101.0
2009-02-27	CHW	ETF	5.05	5.1	4.95	5.03	208572.0
2009-02-27	CHY	ETF	7.87	8.11	7.76	8.11	329034.0
2009-02-27	CMF	ETF	51.53	51.655	51.2	51.2194	20130.0
2009-02-27	CNXT	ETF	0.48	0.48	0.42	0.4418	201452.0
2009-02-27	COW	ETF	30.99	31.5642	30.99	31.42	22112.0

> showing 50 of 636 rows — these rows as CSV

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