PREVIEW / etf_daily / 2012-04-20

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-20.parquet
  size:    38 KB
  rows:    931

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-04-20	SPY	ETF	138.33	138.83	137.87	137.95	143199600.0
2012-04-20	QQQ	ETF	66.22	66.51	65.58	65.68	59906831.0
2012-04-20	IWM	ETF	80.28	80.97	80.06	80.21	46632000.0
2012-04-20	DIA	ETF	129.96	130.53	129.9	129.98	5686800.0
2012-04-20	GLD	ETF	159.25	159.91	159.2	159.54	9148800.0
2012-04-20	TLT	ETF	116.56	117.13	116.33	117.07	5043300.0
2012-04-20	AAXJ	ETF	56.17	56.34	56.02	56.05	107100.0
2012-04-20	ACTV	ETF	16.68	16.8	16.6	16.74	193426.0
2012-04-20	ACWI	ETF	46.36	46.49	46.22	46.22	357400.0
2012-04-20	ACWV	ETF	54.25	54.25	54.25	54.25	100.0
2012-04-20	ACWX	ETF	39.94	40.1	39.88	39.88	139060.0
2012-04-20	ADRE	ETF	41.36	41.59	41.26	41.27	19730.0
2012-04-20	AFK	ETF	29.14	29.35	29.07	29.19	5171.0
2012-04-20	AGEM	ETF	23.07	23.07	22.94	22.94	1236.0
2012-04-20	AGG	ETF	110.48	110.52	110.37	110.48	1530200.0
2012-04-20	AGQ	ETF	208.12	209.36	206.6	207.68	157575.0
2012-04-20	AGZ	ETF	112.94	112.94	112.6908	112.84	10602.0
2012-04-20	AIA	ETF	44.54	44.726	44.448	44.5	7786.0
2012-04-20	AIQ	ETF	7.2	7.2	7.05	7.1	10888.0
2012-04-20	AIS	ETF	3.1	3.1	2.98	2.99	906103.0
2012-04-20	AIVI	ETF	40.08	40.33	39.96	40.13	54200.0
2012-04-20	AMJ	ETF	39.35	39.57	39.28	39.4	1117670.0
2012-04-20	AMLP	ETF	83.35	83.55	83.25	83.3	299980.0
2012-04-20	ANGL	ETF	25.63	25.65	25.53	25.56	2900.0
2012-04-20	AOA	ETF	35.89	35.99	35.84	35.87	5300.0
2012-04-20	AOK	ETF	30.0599	30.08	30.02	30.02	7804.0
2012-04-20	AOM	ETF	31.08	31.12	31.0425	31.05	13194.0
2012-04-20	AOR	ETF	33.05	33.1	32.994	33.0099	5162.0
2012-04-20	ARB	ETF	38.81	39.59	38.55	38.95	497957.0
2012-04-20	ARGT	ETF	18.66	18.96	18.66	18.9	1650.0
2012-04-20	ASEA	ETF	16.24	16.28	16.16	16.2	1900.0
2012-04-20	AWAY	ETF	24.1	24.36	24.0	24.06	446991.0
2012-04-20	BAB	ETF	29.34	29.45	29.1363	29.45	104420.0
2012-04-20	BAL	ETF	56.19	56.83	56.0601	56.75	41975.0
2012-04-20	BALT	ETF	4.56	4.67	4.53	4.64	160195.0
2012-04-20	BBH	ETF	44.52	44.96	44.52	44.76	14400.0
2012-04-20	BCM	ETF	44.4601	44.54	44.4055	44.514	2154.0
2012-04-20	BIB	ETF	11.725	11.725	11.71	11.71	3200.0
2012-04-20	BICK	ETF	25.84	25.86	25.725	25.75	2372.0
2012-04-20	BIL	ETF	91.66	91.66	91.64	91.64	58400.0
2012-04-20	BIS	ETF	3764.8	3764.8	3705.6	3705.6	8.75
2012-04-20	BIV	ETF	87.6	87.72	87.46	87.67	301200.0
2012-04-20	BJK	ETF	36.97	37.09	36.77	36.86	3900.0
2012-04-20	BKF	ETF	40.76	40.919	40.63	40.66	66657.0
2012-04-20	BKLN	ETF	24.44	24.45	24.39	24.45	130200.0
2012-04-20	BLNG	ETF	49.784	50.06	49.784	50.06	415.0
2012-04-20	BLV	ETF	90.96	91.36	90.75	91.32	17000.0
2012-04-20	BMVP	ETF	15.41	15.41	15.34	15.34	1841.0
2012-04-20	BND	ETF	83.74	83.76	83.63	83.73	592900.0
2012-04-20	BNO	ETF	42.06	42.06	41.755	41.9	21000.0

> showing 50 of 931 rows — these rows as CSV

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