PREVIEW / etf_daily / 2012-03-02

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-02.parquet
  size:    38 KB
  rows:    928

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
2012-03-02	SPY	ETF	137.64	137.82	137.0	137.31	120638300.0
2012-03-02	QQQ	ETF	64.83	65.0784	64.66	64.87	33358160.0
2012-03-02	IWM	ETF	81.42	81.64	79.84	80.25	70789500.0
2012-03-02	DIA	ETF	129.54	129.79	129.08	129.55	3818700.0
2012-03-02	GLD	ETF	166.23	166.83	165.63	166.34	9298100.0
2012-03-02	TLT	ETF	116.6	117.48	116.55	117.15	6669600.0
2012-03-02	AAXJ	ETF	58.3	58.32	57.96	58.2	495900.0
2012-03-02	ACTV	ETF	15.94	16.05	15.82	15.97	643886.0
2012-03-02	ACWI	ETF	46.8	46.89	46.63	46.74	624300.0
2012-03-02	ACWV	ETF	53.64	53.69	53.6	53.65	3600.0
2012-03-02	ACWX	ETF	41.25	41.3	41.07	41.19	353705.0
2012-03-02	ADRE	ETF	44.04	44.29	44.04	44.16	18246.0
2012-03-02	AFK	ETF	30.5	30.51	30.22	30.4599	30938.0
2012-03-02	AGEM	ETF	24.59	24.59	24.17	24.17	3191.0
2012-03-02	AGG	ETF	110.32	110.51	110.3	110.5	863900.0
2012-03-02	AGQ	ETF	257.4	258.8	248.04	254.24	671525.0
2012-03-02	AGZ	ETF	112.69	112.84	112.69	112.726	18902.0
2012-03-02	AIA	ETF	45.56	45.6	45.38	45.4625	8549.0
2012-03-02	AIQ	ETF	6.55	6.8	6.4	6.7	13140.0
2012-03-02	AIS	ETF	2.63	2.64	2.59	2.59	610665.0
2012-03-02	AIVI	ETF	42.28	42.28	42.05	42.13	38100.0
2012-03-02	AMJ	ETF	41.11	41.12	40.8	40.82	875839.0
2012-03-02	AMLP	ETF	85.65	85.7	85.05	85.3	254040.0
2012-03-02	AOA	ETF	36.07	36.13	35.96	36.0	7400.0
2012-03-02	AOK	ETF	30.37	30.37	30.0809	30.13	30460.0
2012-03-02	AOM	ETF	31.2	31.205	31.1101	31.111	18986.0
2012-03-02	AOR	ETF	33.1	33.159	33.03	33.03	17378.0
2012-03-02	ARB	ETF	34.07	34.3	33.23	33.29	333357.0
2012-03-02	ARGT	ETF	23.18	23.2	23.1	23.1	450.0
2012-03-02	ASEA	ETF	16.08	16.15	16.04	16.05	7400.0
2012-03-02	AWAY	ETF	26.48	26.76	26.42	26.595	219627.0
2012-03-02	BAB	ETF	29.25	29.46	29.25	29.41	172682.0
2012-03-02	BAL	ETF	54.57	54.622	53.43	53.7	24075.0
2012-03-02	BALT	ETF	4.44	4.4721	4.12	4.15	213584.0
2012-03-02	BBH	ETF	42.57	42.67	42.34	42.62	12400.0
2012-03-02	BCM	ETF	46.57	46.7	46.5499	46.66	1557.0
2012-03-02	BIB	ETF	11.4437	11.4838	11.2883	11.3405	29872.0
2012-03-02	BICK	ETF	27.97	28.03	27.89	27.9	30757.0
2012-03-02	BIL	ETF	91.64	91.64	91.62	91.64	186600.0
2012-03-02	BIS	ETF	3937.6	3937.6	3868.8	3884.8	17.5
2012-03-02	BITS	ETF	21.6	22.08	21.4	21.64	960.0
2012-03-02	BIV	ETF	87.77	87.98	87.7	87.93	221700.0
2012-03-02	BJK	ETF	34.86	35.31	34.7	34.81	81300.0
2012-03-02	BKF	ETF	44.08	44.35	44.017	44.24	1043010.0
2012-03-02	BKLN	ETF	24.53	24.57	24.51	24.55	91600.0
2012-03-02	BLNG	ETF	53.0699	53.0699	53.05	53.05	8884.0
2012-03-02	BLV	ETF	91.26	91.74	91.26	91.49	23500.0
2012-03-02	BMVP	ETF	15.25	15.25	15.13	15.14	600.0
2012-03-02	BND	ETF	83.59	83.79	83.58	83.74	1074400.0
2012-03-02	BNO	ETF	43.545	43.6	43.075	43.235	86800.0

> showing 50 of 928 rows — these rows as CSV

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