PREVIEW / etf_daily / 2011-11-02

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-02.parquet
  size:    37 KB
  rows:    877

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-11-02	SPY	ETF	123.83	124.4	122.79	123.99	244717600.0
2011-11-02	QQQ	ETF	57.01	57.16	56.385	56.92	65178760.0
2011-11-02	IWM	ETF	72.62	73.3	71.83	73.15	63821300.0
2011-11-02	DIA	ETF	117.8	118.52	117.17	118.13	7605000.0
2011-11-02	GLD	ETF	168.59	169.74	167.3	169.06	14530500.0
2011-11-02	TLT	ETF	116.63	118.36	116.42	117.96	13181100.0
2011-11-02	AADR	ETF	28.51	28.51	28.51	28.51	400.0
2011-11-02	AAXJ	ETF	54.31	54.41	53.71	54.33	315600.0
2011-11-02	ACTV	ETF	12.95	13.14	12.83	13.02	152014.0
2011-11-02	ACWI	ETF	42.75	43.14	42.57	42.99	543100.0
2011-11-02	ACWV	ETF	50.48	50.54	50.19	50.54	2200.0
2011-11-02	ACWX	ETF	38.15	38.55	37.968	38.3	121198.0
2011-11-02	ADRE	ETF	40.77	41.121	40.61	40.99	24027.0
2011-11-02	AFK	ETF	28.22	28.649	28.22	28.45	3274.0
2011-11-02	AGEM	ETF	22.36	22.677	22.36	22.6	10980.0
2011-11-02	AGG	ETF	109.97	110.34	109.92	110.27	732400.0
2011-11-02	AGQ	ETF	262.24	269.84	259.04	265.4	373275.0
2011-11-02	AGZ	ETF	112.79	112.79	112.16	112.4	36143.0
2011-11-02	AIA	ETF	41.82	42.17	41.65	42.17	34759.0
2011-11-02	AIQ	ETF	5.8	6.1	5.6	5.95	19878.0
2011-11-02	AIS	ETF	2.22	2.289	2.22	2.26	490580.0
2011-11-02	AIVI	ETF	40.64	40.96	40.41	40.78	49300.0
2011-11-02	AMJ	ETF	37.29	37.54	36.8892	37.08	984793.0
2011-11-02	AMLP	ETF	80.2	80.65	80.0	80.05	214180.0
2011-11-02	AOA	ETF	32.95	33.14	32.79	32.97	11100.0
2011-11-02	AOK	ETF	29.28	29.35	29.2555	29.35	12282.0
2011-11-02	AOM	ETF	29.96	30.03	29.89	30.01	51944.0
2011-11-02	AOR	ETF	31.05	31.2	31.0	31.14	18386.0
2011-11-02	ARB	ETF	39.51	40.82	39.51	40.56	158785.0
2011-11-02	ARGT	ETF	21.58	21.58	21.52	21.58	1550.0
2011-11-02	ASEA	ETF	15.08	15.26	15.0	15.14	2300.0
2011-11-02	AWAY	ETF	34.99	35.2	33.71	33.78	173595.0
2011-11-02	BAB	ETF	28.44	28.6372	28.1903	28.49	160652.0
2011-11-02	BAL	ETF	61.69	61.86	60.6116	60.72	50857.0
2011-11-02	BALT	ETF	5.6	5.66	5.38	5.53	113706.0
2011-11-02	BBH	ETF	35.1533	35.1533	34.6433	34.6833	10200.0
2011-11-02	BCM	ETF	44.76	44.76	44.3	44.33	524.0
2011-11-02	BIB	ETF	7.5	7.5312	7.25	7.4238	13200.0
2011-11-02	BICK	ETF	26.06	26.34	25.9206	26.16	7121.0
2011-11-02	BIL	ETF	91.7	91.7	91.68	91.68	284650.0
2011-11-02	BITS	ETF	23.56	23.92	22.6	23.2	7131.0
2011-11-02	BIV	ETF	87.77	88.0	87.62	88.0	135800.0
2011-11-02	BJK	ETF	32.51	32.7	32.25	32.55	46600.0
2011-11-02	BKF	ETF	40.09	40.41	39.712	40.39	142328.0
2011-11-02	BKLN	ETF	23.98	23.98	23.8	23.94	39000.0
2011-11-02	BLV	ETF	91.21	92.08	90.83	91.96	166300.0
2011-11-02	BMVP	ETF	13.66	13.75	13.63	13.71	6867.0
2011-11-02	BND	ETF	83.78	84.03	83.78	83.98	1038100.0
2011-11-02	BNO	ETF	38.01	38.165	37.24	37.485	76600.0
2011-11-02	BRF	ETF	45.6	46.116	45.15	45.82	94611.0

> showing 50 of 877 rows — these rows as CSV

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