PREVIEW / etf_daily / 2011-12-02

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-02.parquet
  size:    37 KB
  rows:    886

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
2011-12-02	SPY	ETF	126.12	126.5	124.78	124.86	221109700.0
2011-12-02	QQQ	ETF	57.33	57.34	56.57	56.62	36938344.0
2011-12-02	IWM	ETF	74.09	74.63	73.31	73.5	47671500.0
2011-12-02	DIA	ETF	121.22	121.4	120.0	120.06	5584400.0
2011-12-02	GLD	ETF	170.65	170.8	169.36	169.82	8433200.0
2011-12-02	TLT	ETF	116.62	118.68	116.56	118.64	7764900.0
2011-12-02	AADR	ETF	28.56	29.07	28.44	28.51	22300.0
2011-12-02	AAXJ	ETF	52.76	53.12	52.24	52.38	658600.0
2011-12-02	ACTV	ETF	12.48	12.56	12.37	12.5	331774.0
2011-12-02	ACWI	ETF	43.42	43.45	42.84	42.89	401700.0
2011-12-02	ACWX	ETF	38.53	38.53	37.97	37.99	357692.0
2011-12-02	ADRE	ETF	40.51	40.62	40.06	40.12	33775.0
2011-12-02	AFK	ETF	27.48	27.67	27.23	27.47	12955.0
2011-12-02	AGEM	ETF	22.16	22.39	22.16	22.1944	3112.0
2011-12-02	AGG	ETF	108.81	109.21	108.76	109.12	917500.0
2011-12-02	AGQ	ETF	248.2	248.72	233.72	237.08	675225.0
2011-12-02	AGZ	ETF	112.32	112.37	112.1515	112.3	10395.0
2011-12-02	AIA	ETF	41.57	41.72	41.1	41.12	38182.0
2011-12-02	AIQ	ETF	5.9	6.0	5.75	5.85	37818.0
2011-12-02	AIS	ETF	2.65	2.74	2.61	2.74	2391994.0
2011-12-02	AIVI	ETF	40.99	40.99	40.24	40.32	164000.0
2011-12-02	AMJ	ETF	37.59	37.62	37.28	37.47	1194660.0
2011-12-02	AMLP	ETF	80.95	80.95	80.5	80.8	202280.0
2011-12-02	AOA	ETF	33.34	33.45	33.1	33.1	11800.0
2011-12-02	AOK	ETF	29.28	29.31	29.23	29.3	140619.0
2011-12-02	AOM	ETF	29.99	30.04	29.92	29.97	15217.0
2011-12-02	AOR	ETF	31.33	31.33	31.2	31.2	76421.0
2011-12-02	ARB	ETF	38.29	38.4	37.41	37.47	171147.0
2011-12-02	ARGT	ETF	23.22	23.24	23.02	23.02	2600.0
2011-12-02	ASEA	ETF	15.13	15.13	15.0	15.0	2900.0
2011-12-02	AWAY	ETF	26.45	27.25	25.9	25.94	817289.0
2011-12-02	BAB	ETF	28.33	28.53	28.2145	28.52	95817.0
2011-12-02	BAL	ETF	56.61	56.94	56.35	56.72	17548.0
2011-12-02	BALT	ETF	5.04	5.05	4.87	5.05	68144.0
2011-12-02	BBH	ETF	35.1067	35.4567	34.96	35.02	28800.0
2011-12-02	BCM	ETF	44.52	44.52	44.52	44.52	448.0
2011-12-02	BIB	ETF	8.4087	8.4488	8.2351	8.2351	120896.0
2011-12-02	BICK	ETF	24.96	25.14	24.8506	24.93	5164.0
2011-12-02	BIL	ETF	91.68	91.68	91.66	91.68	353750.0
2011-12-02	BIS	ETF	5454.4	5497.6	5440.0	5497.6	5.95
2011-12-02	BITS	ETF	21.8	21.8	21.32	21.44	1500.0
2011-12-02	BIV	ETF	86.72	87.2	86.67	87.19	273300.0
2011-12-02	BJK	ETF	31.92	31.92	31.48	31.51	9400.0
2011-12-02	BKF	ETF	39.05	39.14	38.46	38.5	94112.0
2011-12-02	BKLN	ETF	23.95	23.95	23.8	23.8	119100.0
2011-12-02	BLV	ETF	89.64	90.69	89.46	90.59	50700.0
2011-12-02	BMVP	ETF	13.743	13.793	13.69	13.694	6199.0
2011-12-02	BND	ETF	83.08	83.42	83.03	83.4	2347000.0
2011-12-02	BNO	ETF	37.97	38.205	37.735	38.175	29200.0
2011-12-02	BOIL	ETF	3030000.0	3043000.0	2991000.0	2998000.0	0.4

> showing 50 of 886 rows — these rows as CSV

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