PREVIEW / etf_daily / 2011-03-10

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-10.parquet
  size:    36 KB
  rows:    833

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-10	SPY	ETF	131.0	131.18	129.81	129.94	301291800.0
2011-03-10	QQQ	ETF	56.39	56.52	55.91	56.14	102991509.0
2011-03-10	IWM	ETF	81.0	81.03	79.7	79.97	107642100.0
2011-03-10	DIA	ETF	120.95	121.05	119.62	119.73	15698000.0
2011-03-10	GLD	ETF	138.5	138.5	136.85	137.77	15559100.0
2011-03-10	TLT	ETF	90.87	92.1	90.64	92.07	13385800.0
2011-03-10	AADR	ETF	30.22	30.22	29.99	29.99	300.0
2011-03-10	AAXJ	ETF	61.21	61.33	60.59	60.69	415300.0
2011-03-10	ACWI	ETF	47.88	47.88	47.43	47.52	287100.0
2011-03-10	ACWX	ETF	44.7	44.7	44.24	44.32	246787.0
2011-03-10	ADRE	ETF	46.42	46.5	45.9709	46.04	78760.0
2011-03-10	AFK	ETF	32.3	32.68	31.75	31.99	32293.0
2011-03-10	AGG	ETF	105.41	105.66	105.28	105.61	467900.0
2011-03-10	AGQ	ETF	401.54	403.3	386.92	399.12	739400.0
2011-03-10	AGZ	ETF	109.44	109.73	109.2	109.7096	13817.0
2011-03-10	AIA	ETF	46.03	46.03	45.63	45.69	26411.0
2011-03-10	AIQ	ETF	21.25	21.25	19.85	20.45	21001.0
2011-03-10	AIS	ETF	1.6	1.65	1.59	1.61	455022.0
2011-03-10	AIVI	ETF	45.84	45.84	45.25	45.45	18900.0
2011-03-10	AMJ	ETF	36.86	37.12	36.3	36.62	1843851.0
2011-03-10	AMLP	ETF	81.0	81.25	79.75	80.15	205140.0
2011-03-10	AOA	ETF	35.39	35.39	35.09	35.13	11600.0
2011-03-10	AOK	ETF	29.11	29.11	29.03	29.1	12819.0
2011-03-10	AOM	ETF	30.42	30.42	30.31	30.318	19800.0
2011-03-10	AOR	ETF	32.28	32.28	32.1101	32.1101	26043.0
2011-03-10	ARB	ETF	39.24	39.31	37.73	37.91	138043.0
2011-03-10	ARGT	ETF	30.16	30.16	29.36	29.54	17700.0
2011-03-10	ASEA	ETF	15.45	15.54	15.26	15.3	4400.0
2011-03-10	BAB	ETF	25.27	25.4	25.1603	25.4	313202.0
2011-03-10	BAL	ETF	106.09	106.69	103.18	104.29	248393.0
2011-03-10	BALT	ETF	8.7	8.74	8.5	8.69	289690.0
2011-03-10	BBH	ETF	34.5733	34.5933	34.4067	34.4267	19200.0
2011-03-10	BIB	ETF	7.9	7.9	7.6918	7.7038	4200.0
2011-03-10	BICK	ETF	31.81	31.81	31.21	31.22	29793.0
2011-03-10	BIL	ETF	91.7	91.72	91.7	91.7	140200.0
2011-03-10	BIS	ETF	7734.4	7734.4	7720.0	7734.4	63.0
2011-03-10	BITS	ETF	25.84	25.84	25.6	25.6	125.0
2011-03-10	BIV	ETF	82.6	82.88	82.39	82.8	99400.0
2011-03-10	BJK	ETF	30.98	31.13	30.81	30.82	19800.0
2011-03-10	BKF	ETF	48.0	48.38	47.59	47.62	126714.0
2011-03-10	BKLN	ETF	25.04	25.05	25.01	25.03	373800.0
2011-03-10	BLV	ETF	77.91	78.49	77.25	78.43	205200.0
2011-03-10	BMVP	ETF	15.31	15.31	15.1	15.1	11859.0
2011-03-10	BND	ETF	80.15	80.34	80.03	80.32	553100.0
2011-03-10	BNO	ETF	38.135	38.625	37.695	38.17	179600.0
2011-03-10	BRF	ETF	52.35	52.72	52.0	52.05	250903.0
2011-03-10	BSCE	ETF	20.9499	20.98	20.94	20.976	19379.0
2011-03-10	BSV	ETF	80.38	80.53	80.38	80.5	250400.0
2011-03-10	BTF	ETF	84.89999999999999	84.89999999999999	83.3005	83.3005	4870.6
2011-03-10	BWX	ETF	29.515	29.525	29.385	29.46	152946.0

> showing 50 of 833 rows — these rows as CSV

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