PREVIEW / etf_daily / 2011-05-23

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-23.parquet
  size:    36 KB
  rows:    853

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-05-23	SPY	ETF	131.98	132.72	131.59	132.06	168700000.0
2011-05-23	QQQ	ETF	56.99	57.15	56.65	56.92	43678437.0
2011-05-23	IWM	ETF	81.42	81.95	81.23	81.37	50696600.0
2011-05-23	DIA	ETF	123.22	123.88	123.03	123.52	5901700.0
2011-05-23	GLD	ETF	147.04	147.95	146.97	147.83	15937600.0
2011-05-23	TLT	ETF	95.73	96.19	95.59	95.78	6300000.0
2011-05-23	AADR	ETF	30.7	30.8	30.63	30.66	5600.0
2011-05-23	AAXJ	ETF	61.32	61.36	60.93	61.26	684000.0
2011-05-23	ACWI	ETF	47.91	47.92	47.59	47.76	124400.0
2011-05-23	ACWX	ETF	44.18	44.29	43.94	44.17	127646.0
2011-05-23	ADRE	ETF	44.76	45.04	44.64	45.04	43371.0
2011-05-23	AFK	ETF	32.14	32.34	32.019	32.118	25593.0
2011-05-23	AGG	ETF	107.19	107.23	107.07	107.08	804100.0
2011-05-23	AGQ	ETF	336.54	347.18	335.84	345.46	842250.0
2011-05-23	AGZ	ETF	110.5499	110.55	110.33	110.377	7730.0
2011-05-23	AIA	ETF	46.45	46.48	46.24	46.456	20962.0
2011-05-23	AIQ	ETF	20.65	20.8	20.1	20.35	18879.0
2011-05-23	AIS	ETF	1.74	1.74	1.67	1.7	528911.0
2011-05-23	AIVI	ETF	46.69	47.02	46.5	46.9	16000.0
2011-05-23	AMJ	ETF	36.63	36.82	36.6178	36.77	1634118.0
2011-05-23	AMLP	ETF	78.75	79.2	78.5	79.15	115420.0
2011-05-23	AOA	ETF	35.63	35.77	35.55	35.67	15500.0
2011-05-23	AOK	ETF	29.35	29.42	29.29	29.3409	46237.0
2011-05-23	AOM	ETF	30.65	30.67	30.5848	30.6189	38215.0
2011-05-23	AOR	ETF	32.55	32.5728	32.49	32.53	16108.0
2011-05-23	ARB	ETF	41.4	41.45	40.46	41.04	120974.0
2011-05-23	ARGT	ETF	29.2	29.2	29.0	29.1	2900.0
2011-05-23	ASEA	ETF	15.93	16.12	15.8	16.08	22100.0
2011-05-23	BAB	ETF	26.48	26.49	26.37	26.39	98754.0
2011-05-23	BAL	ETF	85.01	86.55	85.01	85.63	52377.0
2011-05-23	BALT	ETF	6.38	6.7	6.33	6.49	232387.0
2011-05-23	BBH	ETF	35.0	35.07	34.9333	35.03	105300.0
2011-05-23	BCM	ETF	46.22	46.31	46.22	46.31	500.0
2011-05-23	BIB	ETF	9.8413	9.8413	9.5013	9.6638	154264.0
2011-05-23	BICK	ETF	31.59	31.59	31.3	31.54	59018.0
2011-05-23	BIL	ETF	91.72	91.72	91.7	91.72	328750.0
2011-05-23	BIS	ETF	5992.0	6121.6	5992.0	6094.4	12.8
2011-05-23	BITS	ETF	23.56	23.56	22.86	22.86	175.0
2011-05-23	BIV	ETF	84.32	84.33	84.11	84.15	108500.0
2011-05-23	BJK	ETF	33.6	33.6	33.27	33.41	3900.0
2011-05-23	BKF	ETF	46.36	46.36	45.94	46.272	145757.0
2011-05-23	BKLN	ETF	25.11	25.16	25.1	25.14	95900.0
2011-05-23	BLV	ETF	81.59	81.74	81.48	81.55	35900.0
2011-05-23	BMVP	ETF	15.5933	15.6452	15.56	15.5933	7209.0
2011-05-23	BND	ETF	81.53	81.53	81.37	81.37	540400.0
2011-05-23	BNO	ETF	36.345	36.7	36.26	36.7	25800.0
2011-05-23	BRF	ETF	54.15	54.29	53.5	53.94	186214.0
2011-05-23	BSCE	ETF	21.17	21.19	21.1	21.16	48782.0
2011-05-23	BSV	ETF	80.99	80.99	80.88	80.89	582900.0
2011-05-23	BTF	ETF	83.6	83.85	83.0	83.4505	3339.6000000000004

> showing 50 of 853 rows — these rows as CSV

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