PREVIEW / etf_daily / 2010-10-11

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-11.parquet
  size:    34 KB
  rows:    793

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
2010-10-11	SPY	ETF	116.72	116.97	116.25	116.65	103098300.0
2010-10-11	QQQ	ETF	49.78	50.02	49.62	49.77	46879922.0
2010-10-11	IWM	ETF	69.34	69.86	69.14	69.34	37345900.0
2010-10-11	DIA	ETF	110.29	110.4	109.88	110.26	3527300.0
2010-10-11	GLD	ETF	131.28	132.33	130.98	132.29	10621300.0
2010-10-11	TLT	ETF	104.11	104.43	103.94	104.24	1474200.0
2010-10-11	AADR	ETF	28.69	28.69	28.63	28.63	800.0
2010-10-11	AAXJ	ETF	62.51	62.6	62.39	62.6	240500.0
2010-10-11	ACWI	ETF	44.62	44.68	44.42	44.56	85400.0
2010-10-11	ACWX	ETF	42.76	42.9	42.65	42.65	19646.0
2010-10-11	ADRE	ETF	46.52	46.62	46.36	46.45	65366.0
2010-10-11	AFK	ETF	33.39	33.62	33.37	33.4699	17853.0
2010-10-11	AGG	ETF	108.82	108.85	108.72	108.76	434600.0
2010-10-11	AGQ	ETF	187.0	190.5	185.36	189.14	285150.0
2010-10-11	AGZ	ETF	111.81	111.82	111.52	111.52	7827.0
2010-10-11	AIA	ETF	43.71	43.75	43.5675	43.75	14432.0
2010-10-11	AIQ	ETF	23.8	23.95	23.35	23.5	10416.0
2010-10-11	AIS	ETF	1.5	1.5901	1.5	1.59	520408.0
2010-10-11	AIVI	ETF	44.67	44.82	44.61	44.61	9300.0
2010-10-11	AMJ	ETF	34.84	34.94	34.7	34.91	916978.0
2010-10-11	AMLP	ETF	78.9	79.0	78.6	78.9	82600.0
2010-10-11	AOA	ETF	32.28	32.34	32.25	32.26	4800.0
2010-10-11	AOK	ETF	28.69	28.7099	28.6564	28.7	3337.0
2010-10-11	AOM	ETF	29.52	29.54	29.4755	29.4999	17610.0
2010-10-11	AOR	ETF	30.46	30.54	30.449	30.46	15548.0
2010-10-11	ARB	ETF	29.88	30.41	29.43	29.46	100710.0
2010-10-11	BAB	ETF	26.71	26.74	26.66	26.71	131269.0
2010-10-11	BAL	ETF	54.29	55.73	53.97	54.58	28613.0
2010-10-11	BALT	ETF	11.03	11.12	10.93	11.09	132255.0
2010-10-11	BBH	ETF	32.4833	32.58	32.4	32.4667	42000.0
2010-10-11	BICK	ETF	33.23	33.23	32.6	32.7	29723.0
2010-10-11	BIL	ETF	91.7	91.72	91.7	91.7	64500.0
2010-10-11	BIS	ETF	9408.0	9488.0	9408.0	9488.0	10.0
2010-10-11	BITS	ETF	27.44	27.96	27.36	27.6	386.0
2010-10-11	BIV	ETF	87.47	87.5	87.37	87.43	273600.0
2010-10-11	BJK	ETF	29.78	30.14	29.67	29.98	13300.0
2010-10-11	BKF	ETF	49.68	49.81	49.56	49.66	147844.0
2010-10-11	BLV	ETF	85.35	85.62	85.34	85.54	27300.0
2010-10-11	BMVP	ETF	13.3267	13.3898	13.3267	13.338	9903.0
2010-10-11	BND	ETF	82.95	82.96	82.79	82.8	442300.0
2010-10-11	BNE	ETF	11.31	11.36	11.22	11.32	1011361.0
2010-10-11	BRF	ETF	59.98	60.24	59.781	59.81	344791.0
2010-10-11	BSCE	ETF	21.2	21.22	21.19	21.22	5969.0
2010-10-11	BSV	ETF	81.97	81.99	81.81	81.98	368800.0
2010-10-11	BTF	ETF	77.24999999999999	77.5	77.05	77.24999999999999	2633.8
2010-10-11	BWX	ETF	30.66	30.895	30.505	30.795	667344.0
2010-10-11	BWZ	ETF	37.8	37.8	37.6	37.66	9845.0
2010-10-11	BZQ	ETF	2539.2	2556.8	2510.4	2553.6	311.0
2010-10-11	CEF	ETF	17.13	17.37	17.06	17.32	669800.0
2010-10-11	CEW	ETF	23.25	23.26	23.19	23.21	367228.0

> showing 50 of 793 rows — these rows as CSV

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