PREVIEW / etf_daily / 2010-10-25

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-25.parquet
  size:    34 KB
  rows:    795

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-25	SPY	ETF	119.14	119.76	118.61	118.7	151145700.0
2010-10-25	QQQ	ETF	51.85	52.23	51.85	51.89	51413627.0
2010-10-25	IWM	ETF	70.84	71.56	70.36	70.74	36095900.0
2010-10-25	DIA	ETF	111.9	112.55	111.66	111.71	6126500.0
2010-10-25	GLD	ETF	131.16	131.38	130.21	130.85	12154900.0
2010-10-25	TLT	ETF	102.12	102.29	101.55	101.67	5632300.0
2010-10-25	AADR	ETF	29.69	29.69	29.17	29.18	3900.0
2010-10-25	AAXJ	ETF	63.39	63.57	63.17	63.22	654100.0
2010-10-25	ACWI	ETF	45.37	45.42	45.0	45.06	159400.0
2010-10-25	ACWX	ETF	43.42	43.49	43.09	43.09	145484.0
2010-10-25	ADRE	ETF	46.3	46.51	46.18	46.24	72683.0
2010-10-25	AFK	ETF	33.79	33.969	33.63	33.65	48265.0
2010-10-25	AGG	ETF	108.8	108.8	108.49	108.51	723500.0
2010-10-25	AGQ	ETF	195.34	196.5	189.84	192.86	367200.0
2010-10-25	AGZ	ETF	111.74	111.74	111.4906	111.58	16306.0
2010-10-25	AIA	ETF	44.46	44.66	44.39	44.39	34480.0
2010-10-25	AIQ	ETF	21.55	21.8	21.0	21.05	17968.0
2010-10-25	AIS	ETF	1.43	1.47	1.4	1.42	171494.0
2010-10-25	AIVI	ETF	45.77	45.77	45.31	45.41	12300.0
2010-10-25	AMJ	ETF	35.15	35.21	34.97	35.02	1510687.0
2010-10-25	AMLP	ETF	79.25	79.45	78.9	79.0	58440.0
2010-10-25	AOA	ETF	32.86	32.96	32.75	32.76	6700.0
2010-10-25	AOK	ETF	28.89	28.91	28.85	28.87	9237.0
2010-10-25	AOM	ETF	29.79	29.8	29.71	29.72	36149.0
2010-10-25	AOR	ETF	30.91	31.0	30.838	30.838	30191.0
2010-10-25	ARB	ETF	30.64	31.21	30.38	30.85	188939.0
2010-10-25	BAB	ETF	26.46	26.46	26.32	26.36	160503.0
2010-10-25	BAL	ETF	61.3	63.49	61.1301	62.89	99934.0
2010-10-25	BALT	ETF	11.16	11.5	11.16	11.43	142118.0
2010-10-25	BBH	ETF	33.5967	33.8467	33.5967	33.7367	75000.0
2010-10-25	BIB	ETF	6.8513	6.8513	6.8463	6.8475	12000.0
2010-10-25	BICK	ETF	32.85	33.12	32.85	33.01	44720.0
2010-10-25	BIL	ETF	91.7	91.72	91.7	91.7	135600.0
2010-10-25	BIS	ETF	9078.4	9136.0	9065.6	9136.0	60.0
2010-10-25	BITS	ETF	27.16	28.4	26.644	27.0	10731.0
2010-10-25	BIV	ETF	87.25	87.28	86.92	86.96	142900.0
2010-10-25	BJK	ETF	30.36	30.63	30.36	30.44	11500.0
2010-10-25	BKF	ETF	49.71	50.0096	49.54	49.595	126135.0
2010-10-25	BLV	ETF	84.51	84.75	84.33	84.45	54800.0
2010-10-25	BMVP	ETF	13.6767	13.7708	13.6667	13.6733	12491.0
2010-10-25	BND	ETF	82.79	82.83	82.62	82.67	1413900.0
2010-10-25	BNE	ETF	11.29	11.33	11.28	11.3	457522.0
2010-10-25	BNO	ETF	27.9	27.9	27.9	27.9	4000.0
2010-10-25	BRF	ETF	59.36	59.46	58.75	59.21	404321.0
2010-10-25	BSCE	ETF	21.0001	21.06	21.0	21.06	2196.0
2010-10-25	BSV	ETF	81.99	81.99	81.87	81.93	329100.0
2010-10-25	BTF	ETF	78.49999999999999	78.75	78.49999999999999	78.55	2794.6000000000004
2010-10-25	BWX	ETF	30.8	30.919	30.6775	30.7	161536.0
2010-10-25	BWZ	ETF	37.79	37.91	37.6401	37.77	23489.0
2010-10-25	BZQ	ETF	2689.6	2720.0	2659.2	2705.6	424.5

> showing 50 of 795 rows — these rows as CSV

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