PREVIEW / etf_daily / 2012-02-09

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-09.parquet
  size:    38 KB
  rows:    916

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-09	SPY	ETF	135.41	135.59	134.56	135.36	148602900.0
2012-02-09	QQQ	ETF	62.67	62.98	62.32	62.91	46856294.0
2012-02-09	IWM	ETF	83.02	83.03	81.84	82.4	48712500.0
2012-02-09	DIA	ETF	128.96	129.12	128.3	128.76	5416600.0
2012-02-09	GLD	ETF	170.01	170.37	167.67	168.02	16085200.0
2012-02-09	TLT	ETF	115.86	116.04	114.62	115.49	11477700.0
2012-02-09	AAXJ	ETF	57.52	57.52	57.04	57.37	282100.0
2012-02-09	ACTV	ETF	15.15	15.31	15.06	15.31	224027.0
2012-02-09	ACWI	ETF	46.07	46.16	45.82	46.02	920600.0
2012-02-09	ACWX	ETF	40.8	40.8	40.47	40.62	196444.0
2012-02-09	ADRE	ETF	43.89	44.05	43.67	44.05	33670.0
2012-02-09	AFK	ETF	29.12	29.14	28.96	29.05	9270.0
2012-02-09	AGEM	ETF	23.74	24.032	23.74	24.032	746.0
2012-02-09	AGG	ETF	110.37	110.42	110.18	110.26	1068400.0
2012-02-09	AGQ	ETF	251.8	253.24	243.4	244.64	500750.0
2012-02-09	AGZ	ETF	112.68	112.8277	112.584	112.76	13406.0
2012-02-09	AIA	ETF	44.2	44.2	43.988	44.12	26715.0
2012-02-09	AIQ	ETF	6.65	6.75	6.4	6.6	115272.0
2012-02-09	AIS	ETF	2.76	2.79	2.67	2.68	1309910.0
2012-02-09	AIVI	ETF	41.92	41.92	41.57	41.82	87700.0
2012-02-09	AMJ	ETF	40.21	40.44	40.13	40.39	571979.0
2012-02-09	AMLP	ETF	84.0	84.05	83.7	84.0	415340.0
2012-02-09	AOA	ETF	35.74	35.74	35.57	35.67	32200.0
2012-02-09	AOK	ETF	30.05	30.05	29.95	29.9944	23214.0
2012-02-09	AOM	ETF	31.0	31.0	30.909	30.97	124543.0
2012-02-09	AOR	ETF	32.88	32.88	32.7525	32.84	29063.0
2012-02-09	ARB	ETF	34.42	34.95	34.19	34.9	270969.0
2012-02-09	ARGT	ETF	23.22	23.26	23.1	23.26	6750.0
2012-02-09	ASEA	ETF	15.97	16.07	15.96	16.0	3000.0
2012-02-09	AWAY	ETF	26.37	26.79	25.46	26.18	271979.0
2012-02-09	BAB	ETF	29.1	29.12	28.93	29.04	202827.0
2012-02-09	BAL	ETF	57.92	57.92	55.6001	56.06	28028.0
2012-02-09	BALT	ETF	4.29	4.45	4.13	4.38	258581.0
2012-02-09	BBH	ETF	43.25	43.3833	43.0	43.3233	17400.0
2012-02-09	BCM	ETF	46.0	46.12	45.93	45.93	1125.0
2012-02-09	BIB	ETF	11.3863	11.3863	11.225	11.2788	34416.0
2012-02-09	BICK	ETF	27.91	28.11	27.82	27.902	10030.0
2012-02-09	BIL	ETF	91.64	91.66	91.64	91.64	130150.0
2012-02-09	BIS	ETF	3940.8	3971.04	3936.0	3971.04	22.5
2012-02-09	BITS	ETF	22.04	22.48	21.76	21.76	1325.0
2012-02-09	BIV	ETF	87.49	87.55	87.29	87.51	653000.0
2012-02-09	BJK	ETF	33.8	33.9	33.74	33.82	25300.0
2012-02-09	BKF	ETF	43.22	43.26	42.879	43.19	94766.0
2012-02-09	BKLN	ETF	24.55	24.59	24.53	24.57	264000.0
2012-02-09	BLV	ETF	90.58	90.58	89.7	90.32	78000.0
2012-02-09	BMVP	ETF	15.06	15.08	14.98	15.08	3151.0
2012-02-09	BND	ETF	83.65	83.65	83.53	83.64	937500.0
2012-02-09	BNO	ETF	41.125	41.28	40.85	41.27	145000.0
2012-02-09	BOIL	ETF	1300000.0	1414000.0	1245000.0	1306000.0	9.0
2012-02-09	BOSS	ETF	68.53	69.62	68.53	69.62	100.0

> showing 50 of 916 rows — these rows as CSV

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