PREVIEW / etf_daily / 2012-03-22

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-22.parquet
  size:    38 KB
  rows:    932

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-22	SPY	ETF	139.18	139.55	138.74	139.2	135216700.0
2012-03-22	QQQ	ETF	66.71	67.14	66.68	66.98	56960468.0
2012-03-22	IWM	ETF	82.09	82.46	81.62	82.13	60102900.0
2012-03-22	DIA	ETF	130.24	130.55	129.86	130.17	6987900.0
2012-03-22	GLD	ETF	158.2	159.71	158.13	159.57	11107700.0
2012-03-22	TLT	ETF	112.29	112.37	111.87	112.15	8009800.0
2012-03-22	AADR	ETF	30.83	30.83	30.83	30.83	200.0
2012-03-22	AAXJ	ETF	56.48	56.48	56.0	56.22	248900.0
2012-03-22	ACTV	ETF	16.58	16.67	16.5	16.59	104806.0
2012-03-22	ACWI	ETF	46.62	46.77	46.47	46.7	794100.0
2012-03-22	ACWV	ETF	53.6	53.72	53.47	53.67	3200.0
2012-03-22	ACWX	ETF	40.46	40.62	40.38	40.58	135454.0
2012-03-22	ADRE	ETF	42.04	42.2	41.956	42.13	15608.0
2012-03-22	AFK	ETF	29.39	29.61	29.2	29.51	17012.0
2012-03-22	AGEM	ETF	23.0701	23.2	23.07	23.2	5992.0
2012-03-22	AGG	ETF	109.35	109.47	109.35	109.45	666900.0
2012-03-22	AGQ	ETF	207.0	210.08	202.64	206.88	592725.0
2012-03-22	AGZ	ETF	112.38	112.38	112.15	112.35	10126.0
2012-03-22	AIA	ETF	44.53	44.53	44.19	44.33	24730.0
2012-03-22	AIQ	ETF	7.55	7.75	7.1	7.55	48260.0
2012-03-22	AIS	ETF	3.04	3.08	2.95	3.02	1247694.0
2012-03-22	AIVI	ETF	41.68	41.83	41.56	41.77	52600.0
2012-03-22	AMJ	ETF	39.77	40.07	39.66	39.75	1114551.0
2012-03-22	AMLP	ETF	83.5	84.15	83.5	84.0	340360.0
2012-03-22	AOA	ETF	36.19	36.22	36.11	36.21	8400.0
2012-03-22	AOK	ETF	30.03	30.0499	29.9836	30.01	37789.0
2012-03-22	AOM	ETF	31.12	31.15	31.0601	31.09	5856.0
2012-03-22	AOR	ETF	33.17	33.182	33.091	33.1299	10997.0
2012-03-22	ARB	ETF	35.49	36.15	35.425	36.12	119904.0
2012-03-22	ARGT	ETF	21.84	21.84	21.52	21.68	1500.0
2012-03-22	ASEA	ETF	15.96	16.01	15.83	15.94	9400.0
2012-03-22	AWAY	ETF	25.02	25.16	24.795	25.07	342885.0
2012-03-22	BAB	ETF	28.75	28.86	28.75	28.83	172231.0
2012-03-22	BAL	ETF	53.88	54.54	53.782	54.43	69934.0
2012-03-22	BALT	ETF	3.94	3.985	3.85	3.89	193382.0
2012-03-22	BBH	ETF	42.68	42.9	42.43	42.85	22700.0
2012-03-22	BCM	ETF	45.323	45.323	45.323	45.323	100.0
2012-03-22	BIB	ETF	11.4375	11.5563	11.3264	11.5563	21840.0
2012-03-22	BICK	ETF	26.62	26.62	26.2621	26.31	14761.0
2012-03-22	BIL	ETF	91.66	91.66	91.64	91.66	106150.0
2012-03-22	BIS	ETF	3849.6	3849.616	3849.6	3849.616	1.275
2012-03-22	BIV	ETF	86.63	86.63	86.46	86.53	141500.0
2012-03-22	BJK	ETF	35.5	35.74	35.33	35.43	14200.0
2012-03-22	BKF	ETF	41.31	41.31	40.68	40.95	339158.0
2012-03-22	BKLN	ETF	24.49	24.52	24.49	24.5	122600.0
2012-03-22	BLNG	ETF	49.75	49.9801	49.69	49.7799	3875.0
2012-03-22	BLV	ETF	88.67	88.78	88.51	88.64	23800.0
2012-03-22	BMVP	ETF	15.26	15.37	15.26	15.35	3175.0
2012-03-22	BND	ETF	82.97	83.05	82.95	83.01	1169100.0
2012-03-22	BNO	ETF	43.1	43.26	42.95	43.21	114400.0

> showing 50 of 932 rows — these rows as CSV

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