PREVIEW / etf_daily / 2010-10-06

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-06.parquet
  size:    34 KB
  rows:    790

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-06	SPY	ETF	116.02	116.33	115.56	116.03	148626600.0
2010-10-06	QQQ	ETF	49.59	49.71	48.91	49.23	81831120.0
2010-10-06	IWM	ETF	68.78	69.06	68.22	68.61	43163400.0
2010-10-06	DIA	ETF	109.44	109.83	109.27	109.77	7215600.0
2010-10-06	GLD	ETF	131.45	131.86	131.34	131.81	16142200.0
2010-10-06	TLT	ETF	104.9	106.1	104.86	105.56	6476100.0
2010-10-06	AADR	ETF	28.75	28.75	28.51	28.57	4900.0
2010-10-06	AAXJ	ETF	62.47	62.72	62.41	62.65	388000.0
2010-10-06	ACWI	ETF	44.24	44.42	44.15	44.39	670500.0
2010-10-06	ACWX	ETF	42.54	42.692	42.5	42.68	66096.0
2010-10-06	ADRE	ETF	46.35	46.6	46.25	46.34	122963.0
2010-10-06	AFK	ETF	33.55	33.55	33.2001	33.415	13991.0
2010-10-06	AGG	ETF	108.67	108.77	108.54	108.55	1041900.0
2010-10-06	AGQ	ETF	183.7	188.4	183.02	188.4	267400.0
2010-10-06	AGZ	ETF	111.5	111.52	111.42	111.45	17929.0
2010-10-06	AIA	ETF	43.5	43.7081	43.47	43.7081	23004.0
2010-10-06	AIQ	ETF	24.2	24.95	24.05	24.45	12962.0
2010-10-06	AIS	ETF	1.48	1.5	1.47	1.48	231758.0
2010-10-06	AIVI	ETF	44.38	44.53	44.22	44.49	28800.0
2010-10-06	AMJ	ETF	34.24	34.41	34.199	34.37	519633.0
2010-10-06	AMLP	ETF	77.95	78.15	77.85	78.1	100700.0
2010-10-06	AOA	ETF	32.14	32.18	32.0	32.03	2700.0
2010-10-06	AOK	ETF	28.63	28.66	28.58	28.6	9586.0
2010-10-06	AOM	ETF	29.38	29.46	29.35	29.41	8124.0
2010-10-06	AOR	ETF	30.39	30.42	30.2888	30.34	15547.0
2010-10-06	ARB	ETF	28.34	29.26	28.34	28.76	111336.0
2010-10-06	BAB	ETF	26.84	26.94	26.77	26.82	142593.0
2010-10-06	BAL	ETF	48.39	49.1699	48.33	48.9	6610.0
2010-10-06	BALT	ETF	11.0	11.02	10.92	10.97	118342.0
2010-10-06	BBH	ETF	32.3933	32.3967	32.0	32.1667	33900.0
2010-10-06	BIB	ETF	6.6175	6.6175	6.4735	6.4735	6344.0
2010-10-06	BICK	ETF	32.74	32.78	32.5	32.599	27844.0
2010-10-06	BIL	ETF	91.7	91.72	91.7	91.7	744600.0
2010-10-06	BIS	ETF	9444.8	9539.2	9428.8	9537.6	2.625
2010-10-06	BITS	ETF	28.0	28.0	27.2	27.76	340.0
2010-10-06	BIV	ETF	87.18	87.41	87.15	87.25	359500.0
2010-10-06	BJK	ETF	29.11	29.11	28.75	28.76	16100.0
2010-10-06	BKF	ETF	49.43	49.5	49.05	49.2	141594.0
2010-10-06	BLV	ETF	85.96	86.48	85.84	86.18	118500.0
2010-10-06	BMVP	ETF	13.29	13.3	13.19	13.22	8350.0
2010-10-06	BND	ETF	82.85	82.89	82.76	82.79	454000.0
2010-10-06	BNE	ETF	11.35	11.37	11.34	11.36	637364.0
2010-10-06	BNO	ETF	28.415	28.77	28.415	28.535	9000.0
2010-10-06	BRF	ETF	58.86	59.03	58.3	58.46	808810.0
2010-10-06	BSCE	ETF	21.0005	21.02	21.0005	21.02	350.0
2010-10-06	BSV	ETF	81.77	81.84	81.76	81.81	307700.0
2010-10-06	BTF	ETF	76.8	76.9	76.05	76.6	7451.6
2010-10-06	BWX	ETF	30.48	30.75	30.3752	30.72	196652.0
2010-10-06	BWZ	ETF	37.3	37.6099	37.3	37.405	9652.0
2010-10-06	BZQ	ETF	2553.6	2619.2	2539.2	2604.8	1337.5

> showing 50 of 790 rows — these rows as CSV

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