PREVIEW / etf_daily / 2011-04-20

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-20.parquet
  size:    36 KB
  rows:    845

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-04-20	SPY	ETF	132.88	133.39	132.79	133.1	156133800.0
2011-04-20	QQQ	ETF	57.59	57.94	56.6051	57.875	67397439.0
2011-04-20	IWM	ETF	83.5	83.9	83.25	83.83	47061100.0
2011-04-20	DIA	ETF	123.93	124.53	123.76	124.34	6708700.0
2011-04-20	GLD	ETF	146.37	146.84	145.74	146.5	13716800.0
2011-04-20	TLT	ETF	93.07	93.26	92.61	92.68	6754100.0
2011-04-20	AADR	ETF	31.48	31.48	31.32	31.32	6700.0
2011-04-20	AAXJ	ETF	64.74	64.78	64.44	64.77	242800.0
2011-04-20	ACWI	ETF	49.02	49.2	49.01	49.13	308700.0
2011-04-20	ACWX	ETF	46.38	46.48	46.31	46.48	30172.0
2011-04-20	ADRE	ETF	48.44	48.81	48.31	48.54	54171.0
2011-04-20	AFK	ETF	33.62	33.85	33.52	33.82	128720.0
2011-04-20	AGG	ETF	105.75	105.83	105.64	105.69	388800.0
2011-04-20	AGQ	ETF	627.54	646.52	613.16	641.12	1766250.0
2011-04-20	AGZ	ETF	109.73	109.75	109.52	109.56	20719.0
2011-04-20	AIA	ETF	48.86	49.04	48.82	49.03	17533.0
2011-04-20	AIQ	ETF	23.0	23.1	22.75	22.95	24056.0
2011-04-20	AIS	ETF	1.66	1.66	1.63	1.65	247606.0
2011-04-20	AIVI	ETF	48.48	48.67	48.42	48.62	16900.0
2011-04-20	AMJ	ETF	38.38	38.38	38.19	38.28	945209.0
2011-04-20	AMLP	ETF	82.5	82.65	82.25	82.45	225000.0
2011-04-20	AOA	ETF	36.14	36.28	36.14	36.19	7400.0
2011-04-20	AOK	ETF	29.29	29.37	29.29	29.31	23054.0
2011-04-20	AOM	ETF	30.77	30.8	30.723	30.77	20299.0
2011-04-20	AOR	ETF	32.8	32.8108	32.77	32.7876	17974.0
2011-04-20	ARB	ETF	35.95	36.43	35.648	36.42	134369.0
2011-04-20	ARGT	ETF	30.5	30.5	30.3	30.3	2300.0
2011-04-20	ASEA	ETF	16.43	16.53	16.43	16.48	5200.0
2011-04-20	BAB	ETF	25.58	25.59	25.52	25.56	190993.0
2011-04-20	BAL	ETF	96.03	96.85	92.21	92.76	189299.0
2011-04-20	BALT	ETF	8.37	8.37	7.93	8.11	220247.0
2011-04-20	BBH	ETF	36.9	37.0367	36.7633	37.0333	42300.0
2011-04-20	BIB	ETF	9.3837	9.395	9.2963	9.3912	93968.0
2011-04-20	BICK	ETF	34.86	35.0	34.7701	34.84	17340.0
2011-04-20	BIL	ETF	91.72	91.72	91.7	91.7	102200.0
2011-04-20	BIS	ETF	6393.6	6393.6	6308.8	6324.784	4.94
2011-04-20	BITS	ETF	25.0	25.0	24.48	24.4804	2181.0
2011-04-20	BIV	ETF	82.64	82.64	82.41	82.51	143700.0
2011-04-20	BJK	ETF	34.34	34.51	34.32	34.34	14400.0
2011-04-20	BKF	ETF	50.71	51.06	50.71	51.03	154146.0
2011-04-20	BKLN	ETF	25.28	25.28	25.22	25.28	136000.0
2011-04-20	BLV	ETF	79.07	79.28	78.91	78.91	28100.0
2011-04-20	BMVP	ETF	15.73	15.78	15.73	15.78	4734.0
2011-04-20	BND	ETF	80.43	80.5	80.36	80.38	631200.0
2011-04-20	BNO	ETF	40.69	41.295	40.6	41.18	142000.0
2011-04-20	BOSS	ETF	56.87	57.7	56.87	57.7	100.0
2011-04-20	BRF	ETF	58.95	59.5	58.88	59.32	185031.0
2011-04-20	BSCE	ETF	20.98	21.02	20.97	21.02	8621.0
2011-04-20	BSV	ETF	80.46	80.49	80.43	80.43	1393400.0
2011-04-20	BTF	ETF	82.94999999999999	83.604	82.94999999999999	83.236	3855.0

> showing 50 of 845 rows — these rows as CSV

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