PREVIEW / etf_daily / 2012-02-29

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-29.parquet
  size:    38 KB
  rows:    922

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-02-29	SPY	ETF	137.76	138.19	136.54	137.02	185934700.0
2012-02-29	QQQ	ETF	64.74	64.96	64.2	64.41	59784393.0
2012-02-29	IWM	ETF	82.55	82.96	80.97	81.05	64213200.0
2012-02-29	DIA	ETF	130.02	130.37	129.09	129.29	7724200.0
2012-02-29	GLD	ETF	173.19	173.59	164.0	164.29	44149000.0
2012-02-29	TLT	ETF	118.37	118.42	116.96	117.43	14235000.0
2012-02-29	AADR	ETF	30.52	30.55	30.45	30.45	800.0
2012-02-29	AAXJ	ETF	58.32	58.67	58.0	58.13	529500.0
2012-02-29	ACTV	ETF	16.0	16.06	15.8536	16.0	309532.0
2012-02-29	ACWI	ETF	47.05	47.17	46.58	46.68	1768300.0
2012-02-29	ACWV	ETF	53.6	53.6	53.6	53.6	400.0
2012-02-29	ACWX	ETF	41.6	41.68	40.99	41.03	213444.0
2012-02-29	ADRE	ETF	44.34	44.48	43.73	43.73	51692.0
2012-02-29	AFK	ETF	30.41	30.47	30.024	30.108	28146.0
2012-02-29	AGEM	ETF	24.63	24.63	24.19	24.19	1020.0
2012-02-29	AGG	ETF	110.94	110.94	110.6	110.76	1993600.0
2012-02-29	AGQ	ETF	291.4	298.6	241.84	251.52	2785825.0
2012-02-29	AGZ	ETF	113.01	113.01	112.23	112.82	52110.0
2012-02-29	AIA	ETF	45.7	45.91	45.48	45.48	15735.0
2012-02-29	AIQ	ETF	7.2	7.65	6.8	6.8	21141.0
2012-02-29	AIS	ETF	2.59	2.61	2.51	2.52	1176766.0
2012-02-29	AIVI	ETF	42.82	42.92	42.19	42.26	60700.0
2012-02-29	AMJ	ETF	40.87	40.99	40.74	40.8	849458.0
2012-02-29	AMLP	ETF	85.45	85.9	85.1	85.45	330480.0
2012-02-29	AOA	ETF	36.23	36.31	35.91	35.96	15700.0
2012-02-29	AOK	ETF	30.22	30.22	30.11	30.11	10456.0
2012-02-29	AOM	ETF	31.29	31.32	31.0931	31.15	29933.0
2012-02-29	AOR	ETF	33.24	33.2595	33.03	33.05	14279.0
2012-02-29	ARB	ETF	34.07	34.47	33.44	33.44	341531.0
2012-02-29	ARGT	ETF	23.02	23.02	22.58	22.6	700.0
2012-02-29	ASEA	ETF	16.12	16.2	16.02	16.13	57500.0
2012-02-29	AWAY	ETF	26.1	26.56	25.5852	26.48	404861.0
2012-02-29	BAB	ETF	29.53	29.55	29.33	29.42	139084.0
2012-02-29	BAL	ETF	55.85	56.1499	54.62	54.68	49059.0
2012-02-29	BALT	ETF	4.72	4.72	4.54	4.58	282412.0
2012-02-29	BBH	ETF	42.46	42.65	42.16	42.18	9600.0
2012-02-29	BCM	ETF	47.19	47.3	46.424	46.48	55852.0
2012-02-29	BIB	ETF	11.315	11.4518	11.1951	11.208	52976.0
2012-02-29	BICK	ETF	28.07	28.0982	27.69	27.7575	90757.0
2012-02-29	BIL	ETF	91.64	91.66	91.64	91.66	453600.0
2012-02-29	BIS	ETF	3920.0	3958.4	3875.2	3958.4	17.9
2012-02-29	BITS	ETF	21.56	21.92	21.56	21.92	350.0
2012-02-29	BIV	ETF	88.2	88.2	87.9	88.05	224400.0
2012-02-29	BJK	ETF	34.58	34.58	34.27	34.43	20200.0
2012-02-29	BKF	ETF	44.28	44.48	43.79	43.8	499055.0
2012-02-29	BKLN	ETF	24.51	24.51	24.42	24.46	137800.0
2012-02-29	BLNG	ETF	54.24	54.24	52.99	53.073	2925.0
2012-02-29	BLV	ETF	92.35	92.38	91.56	91.86	43200.0
2012-02-29	BMVP	ETF	15.27	15.33	15.14	15.14	21685.0
2012-02-29	BND	ETF	84.04	84.05	83.83	83.9	1128100.0

> showing 50 of 922 rows — these rows as CSV

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