PREVIEW / etf_daily / 2011-06-23

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-23.parquet
  size:    36 KB
  rows:    857

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-06-23	SPY	ETF	127.16	128.64	126.19	128.3	334286500.0
2011-06-23	QQQ	ETF	54.28	55.37	54.06	55.34	80743295.0
2011-06-23	IWM	ETF	79.13	80.51	78.3	80.35	92521100.0
2011-06-23	DIA	ETF	119.62	120.34	118.49	120.32	9033500.0
2011-06-23	GLD	ETF	148.67	148.84	147.26	148.34	24869600.0
2011-06-23	TLT	ETF	97.24	97.74	97.15	97.39	8586800.0
2011-06-23	AADR	ETF	30.08	30.21	30.08	30.21	400.0
2011-06-23	AAXJ	ETF	59.25	59.77	58.87	59.77	844700.0
2011-06-23	ACTV	ETF	17.86	17.99	16.63	16.9	381271.0
2011-06-23	ACWI	ETF	46.16	46.54	45.8	46.5	205100.0
2011-06-23	ACWX	ETF	42.8	43.21	42.465	43.19	83261.0
2011-06-23	ADRE	ETF	44.02	44.52	43.7916	44.47	139906.0
2011-06-23	AFK	ETF	31.56	31.896	31.151	31.896	10145.0
2011-06-23	AGEM	ETF	24.74	25.35	24.74	25.3	1803.0
2011-06-23	AGG	ETF	107.55	107.8	107.53	107.73	2735300.0
2011-06-23	AGQ	ETF	349.1	349.3	330.0	341.78	1246250.0
2011-06-23	AGZ	ETF	110.88	111.15	110.88	110.9758	7498.0
2011-06-23	AIA	ETF	44.9	45.15	44.55	45.15	22442.0
2011-06-23	AIQ	ETF	18.45	18.7	18.2	18.7	28563.0
2011-06-23	AIS	ETF	1.95	1.98	1.92	1.97	348907.0
2011-06-23	AIVI	ETF	44.86	45.38	44.6	45.38	23700.0
2011-06-23	AMJ	ETF	35.96	36.24	35.54	36.22	1010005.0
2011-06-23	AMLP	ETF	78.85	79.05	78.0	79.05	260620.0
2011-06-23	AOA	ETF	34.77	35.03	34.64	35.03	47500.0
2011-06-23	AOK	ETF	29.16	29.24	29.1	29.24	16409.0
2011-06-23	AOM	ETF	30.37	30.5	30.33	30.5	10153.0
2011-06-23	AOR	ETF	32.01	32.25	31.94	32.24	33448.0
2011-06-23	ARB	ETF	38.04	38.76	37.9	38.59	169050.0
2011-06-23	ARGT	ETF	28.5	28.88	28.5	28.88	150.0
2011-06-23	ASEA	ETF	15.93	16.02	15.92	15.94	1900.0
2011-06-23	BAB	ETF	26.61	26.704	26.59	26.6	278447.0
2011-06-23	BAL	ETF	75.32	75.32	73.97	75.05	42076.0
2011-06-23	BALT	ETF	5.84	5.99	5.69	5.98	123118.0
2011-06-23	BBH	ETF	34.3833	34.7533	34.1233	34.7533	15900.0
2011-06-23	BIB	ETF	8.8863	9.1275	8.735	9.1275	34048.0
2011-06-23	BICK	ETF	30.06	30.2012	29.9072	30.185	2923.0
2011-06-23	BIL	ETF	91.72	91.72	91.7	91.72	523750.0
2011-06-23	BIS	ETF	6456.0	6569.6	6456.0	6569.6	7.5
2011-06-23	BITS	ETF	21.2	21.28	20.88	21.28	250.0
2011-06-23	BIV	ETF	84.95	85.13	84.93	85.02	104700.0
2011-06-23	BJK	ETF	32.14	32.61	32.07	32.61	4300.0
2011-06-23	BKF	ETF	45.22	45.71	44.95	45.71	129647.0
2011-06-23	BKLN	ETF	24.72	24.73	24.61	24.62	427300.0
2011-06-23	BLV	ETF	81.89	82.25	81.78	82.0	14400.0
2011-06-23	BMVP	ETF	15.04	15.1058	14.9267	15.0633	4281.0
2011-06-23	BND	ETF	81.91	82.04	81.9	81.97	925200.0
2011-06-23	BNO	ETF	36.29	36.29	35.31	36.015	551200.0
2011-06-23	BRF	ETF	55.0	55.43	54.391	55.4	299534.0
2011-06-23	BSCE	ETF	21.24	21.24	21.2	21.2	25050.0
2011-06-23	BSV	ETF	81.3	81.37	81.27	81.32	375200.0

> showing 50 of 857 rows — these rows as CSV

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