PREVIEW / etf_daily / 2011-03-24

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-24.parquet
  size:    35 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-24	SPY	ETF	130.4	131.09	129.67	130.9	159129800.0
2011-03-24	QQQ	ETF	56.12	56.82	55.82	56.7	69502337.0
2011-03-24	IWM	ETF	81.49	81.79	80.74	81.51	52850900.0
2011-03-24	DIA	ETF	121.25	121.65	120.72	121.46	4827100.0
2011-03-24	GLD	ETF	140.27	141.28	138.83	139.22	17016600.0
2011-03-24	TLT	ETF	92.76	92.88	92.39	92.4	9477600.0
2011-03-24	AADR	ETF	29.98	30.25	29.98	30.25	1100.0
2011-03-24	AAXJ	ETF	61.37	61.74	60.95	61.68	149000.0
2011-03-24	ACWI	ETF	47.8	48.12	47.52	48.02	488100.0
2011-03-24	ACWX	ETF	44.65	45.06	44.53	45.0	36473.0
2011-03-24	ADRE	ETF	46.93	47.3	46.8915	47.17	90165.0
2011-03-24	AFK	ETF	32.56	32.56	31.86	32.51	8058.0
2011-03-24	AGG	ETF	105.46	105.53	105.28	105.34	1570000.0
2011-03-24	AGQ	ETF	451.9	462.92	431.1	435.72	1091150.0
2011-03-24	AGZ	ETF	109.61	109.61	109.28	109.38	25444.0
2011-03-24	AIA	ETF	46.2	46.5082	46.074	46.48	16145.0
2011-03-24	AIQ	ETF	20.85	21.35	20.5	21.35	16683.0
2011-03-24	AIS	ETF	1.64	1.6608	1.63	1.64	156368.0
2011-03-24	AIVI	ETF	46.05	46.39	45.94	46.3	38300.0
2011-03-24	AMJ	ETF	37.5	37.65	37.39	37.65	547444.0
2011-03-24	AMLP	ETF	81.05	81.45	81.0	81.45	91880.0
2011-03-24	AOA	ETF	35.46	35.58	35.31	35.56	7200.0
2011-03-24	AOK	ETF	29.14	29.15	29.1	29.15	4103.0
2011-03-24	AOM	ETF	30.45	30.5	30.39	30.464	42690.0
2011-03-24	AOR	ETF	32.2572	32.39	32.2572	32.39	10382.0
2011-03-24	ARB	ETF	37.74	38.2	37.51	38.03	109510.0
2011-03-24	ARGT	ETF	29.58	29.58	29.3	29.52	850.0
2011-03-24	ASEA	ETF	15.69	15.72	15.51	15.71	4300.0
2011-03-24	BAB	ETF	25.43	25.43	25.25	25.325	166128.0
2011-03-24	BAL	ETF	104.29	109.28	103.5701	108.07	178605.0
2011-03-24	BALT	ETF	9.07	9.09	8.93	9.0	48308.0
2011-03-24	BBH	ETF	34.65	35.0933	34.63	35.0033	34500.0
2011-03-24	BIB	ETF	7.896	7.9437	7.885	7.9437	3400.0
2011-03-24	BICK	ETF	32.03	32.27	31.99	32.17	27692.0
2011-03-24	BIL	ETF	91.7	91.72	91.7	91.7	557950.0
2011-03-24	BITS	ETF	24.88	24.92	24.0	24.76	7976.0
2011-03-24	BIV	ETF	82.49	82.57	82.27	82.32	103700.0
2011-03-24	BJK	ETF	31.17	31.73	31.17	31.73	4100.0
2011-03-24	BKF	ETF	48.85	49.14	48.56	48.88	186937.0
2011-03-24	BKLN	ETF	24.96	24.98	24.93	24.97	37400.0
2011-03-24	BLV	ETF	78.74	78.8	78.49	78.59	25300.0
2011-03-24	BMVP	ETF	15.24	15.36	15.21	15.36	3990.0
2011-03-24	BND	ETF	80.39	80.42	80.27	80.29	650000.0
2011-03-24	BNO	ETF	38.145	38.465	38.07	38.4	320800.0
2011-03-24	BRF	ETF	53.72	53.8	53.25	53.78	153736.0
2011-03-24	BSCE	ETF	20.96	20.96	20.926	20.926	10988.0
2011-03-24	BSV	ETF	80.43	80.45	80.33	80.33	298400.0
2011-03-24	BTF	ETF	83.8	84.25	83.75	84.25	1978.6000000000001
2011-03-24	BWX	ETF	30.24	30.295	30.156	30.22	185736.0
2011-03-24	BWZ	ETF	38.48	38.62	38.42	38.586	18497.0

> showing 50 of 834 rows — these rows as CSV

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