PREVIEW / etf_daily / 2011-03-15

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-15.parquet
  size:    36 KB
  rows:    834

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-03-15	SPY	ETF	126.59	129.33	126.5	128.56	359585400.0
2011-03-15	QQQ	ETF	54.64	55.82	54.47	55.49	101275331.0
2011-03-15	IWM	ETF	77.96	79.67	77.57	79.04	84941700.0
2011-03-15	DIA	ETF	117.1	119.13	116.92	118.43	14786600.0
2011-03-15	GLD	ETF	135.35	136.94	135.23	136.27	23465100.0
2011-03-15	TLT	ETF	92.8	93.05	92.36	92.88	14893800.0
2011-03-15	AADR	ETF	29.15	29.56	29.06	29.56	7700.0
2011-03-15	AAXJ	ETF	58.8	60.11	58.67	59.92	687000.0
2011-03-15	ACWI	ETF	45.28	46.67	45.25	46.48	811000.0
2011-03-15	ACWX	ETF	41.76	43.21	41.53	43.01	251496.0
2011-03-15	ADRE	ETF	45.0	46.09	44.78	45.94	118395.0
2011-03-15	AFK	ETF	31.24	31.46	30.9	31.14	44694.0
2011-03-15	AGG	ETF	106.0	106.06	105.71	105.73	672500.0
2011-03-15	AGQ	ETF	367.82	386.6	348.36	378.52	878250.0
2011-03-15	AGZ	ETF	110.11	110.11	109.66	109.87	16343.0
2011-03-15	AIA	ETF	44.02	45.0	43.78	45.0	57526.0
2011-03-15	AIQ	ETF	19.95	20.35	19.8	19.8	18846.0
2011-03-15	AIS	ETF	1.63	1.63	1.54	1.57	351677.0
2011-03-15	AIVI	ETF	43.5	44.44	43.16	44.34	39700.0
2011-03-15	AMJ	ETF	36.15	36.18	35.34	35.86	3278518.0
2011-03-15	AMLP	ETF	79.05	79.5	78.45	79.15	147820.0
2011-03-15	AOA	ETF	34.1	34.77	34.01	34.75	29600.0
2011-03-15	AOK	ETF	28.87	29.02	28.87	29.0199	15832.0
2011-03-15	AOM	ETF	30.0	30.18	29.9	30.14	52250.0
2011-03-15	AOR	ETF	31.54	31.9099	31.44	31.8201	14591.0
2011-03-15	ARB	ETF	36.21	36.6	35.87	36.29	244804.0
2011-03-15	ARGT	ETF	28.76	28.82	28.1	28.82	6550.0
2011-03-15	ASEA	ETF	14.82	14.95	14.7	14.95	14100.0
2011-03-15	BAB	ETF	25.36	25.45	25.25	25.29	198772.0
2011-03-15	BAL	ETF	97.64	99.18	97.0	97.29	149517.0
2011-03-15	BALT	ETF	8.61	8.86	8.4	8.77	184993.0
2011-03-15	BBH	ETF	34.0167	34.3967	33.9833	34.2567	40500.0
2011-03-15	BICK	ETF	30.69	31.255	30.6	31.11	58695.0
2011-03-15	BIL	ETF	91.74	91.74	91.7	91.74	754300.0
2011-03-15	BITS	ETF	25.2	25.48	24.0	24.8	6025.0
2011-03-15	BIV	ETF	83.45	83.5	83.1	83.15	128500.0
2011-03-15	BJK	ETF	29.5	30.16	29.4	30.09	37300.0
2011-03-15	BKF	ETF	46.43	47.59	46.25	47.42	354877.0
2011-03-15	BKLN	ETF	24.79	24.98	24.57	24.59	177700.0
2011-03-15	BLV	ETF	78.83	78.85	78.44	78.6	22100.0
2011-03-15	BMVP	ETF	14.69	14.98	14.68	14.91	25732.0
2011-03-15	BND	ETF	80.67	80.69	80.45	80.46	601100.0
2011-03-15	BNO	ETF	36.195	36.875	35.99	36.19	227400.0
2011-03-15	BRF	ETF	50.77	52.37	50.51	52.28	460627.0
2011-03-15	BSCE	ETF	21.03	21.04	20.96	21.0	13344.0
2011-03-15	BSV	ETF	80.74	80.74	80.59	80.59	366900.0
2011-03-15	BTF	ETF	80.99999999999999	82.10000000000001	80.15	81.75	3746.0
2011-03-15	BWX	ETF	29.975	30.0388	29.805	29.97	238292.0
2011-03-15	BWZ	ETF	37.95	38.33	37.8	38.25	26577.0
2011-03-15	BZQ	ETF	2732.8	2740.8	2590.4	2604.8	1022.0

> showing 50 of 834 rows — these rows as CSV

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