PREVIEW / etf_daily / 2010-11-11

all etf daily files

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

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-11-11	SPY	ETF	121.05	121.82	120.68	121.64	158017600.0
2010-11-11	QQQ	ETF	52.9	53.48	52.66	53.385	85163524.0
2010-11-11	IWM	ETF	72.73	73.54	72.46	73.25	42989400.0
2010-11-11	DIA	ETF	112.9	113.26	112.53	113.08	5517900.0
2010-11-11	GLD	ETF	137.62	137.75	136.45	137.66	15447500.0
2010-11-11	TLT	ETF	96.45	96.63	96.14	96.33	3368100.0
2010-11-11	AADR	ETF	28.92	28.99	28.92	28.99	400.0
2010-11-11	AAXJ	ETF	64.61	64.83	64.48	64.69	325500.0
2010-11-11	ACWI	ETF	45.77	45.96	45.57	45.85	190700.0
2010-11-11	ACWX	ETF	43.78	43.84	43.592	43.83	35793.0
2010-11-11	ADRE	ETF	47.39	47.6399	47.35	47.58	103514.0
2010-11-11	AFK	ETF	34.73	34.73	34.351	34.69	71365.0
2010-11-11	AGG	ETF	107.95	108.0	107.81	107.94	425100.0
2010-11-11	AGQ	ETF	258.16	263.7	247.72	262.9	647600.0
2010-11-11	AGZ	ETF	111.43	111.43	110.87	111.0	16539.0
2010-11-11	AIA	ETF	46.08	46.22	45.97	46.22	53944.0
2010-11-11	AIQ	ETF	21.0	21.35	20.85	20.9	18743.0
2010-11-11	AIS	ETF	1.56	1.57	1.48	1.52	364160.0
2010-11-11	AIVI	ETF	45.18	45.18	44.84	45.02	37000.0
2010-11-11	AMJ	ETF	36.7	36.815	36.5708	36.73	324672.0
2010-11-11	AMLP	ETF	79.95	80.15	79.9	80.1	54600.0
2010-11-11	AOA	ETF	33.32	33.46	33.25	33.44	7200.0
2010-11-11	AOK	ETF	28.83	28.8583	28.83	28.8583	3965.0
2010-11-11	AOM	ETF	29.85	29.889	29.82	29.87	8637.0
2010-11-11	AOR	ETF	31.1	31.16	31.06	31.09	3561.0
2010-11-11	ARB	ETF	25.93	26.11	25.6	26.01	256288.0
2010-11-11	BAB	ETF	25.72	25.81	25.7	25.75	125549.0
2010-11-11	BAL	ETF	71.75	72.355	70.06	70.06	99166.0
2010-11-11	BALT	ETF	12.3	12.69	12.03	12.48	418365.0
2010-11-11	BBH	ETF	33.09	33.3733	33.0833	33.37	18300.0
2010-11-11	BIB	ETF	6.6537	6.655	6.6138	6.6138	16800.0
2010-11-11	BICK	ETF	33.68	33.85	33.55	33.85	55617.0
2010-11-11	BIL	ETF	91.7	91.72	91.68	91.68	49600.0
2010-11-11	BITS	ETF	28.8	28.8	28.36	28.72	345.0
2010-11-11	BIV	ETF	86.95	87.01	86.53	86.79	84800.0
2010-11-11	BJK	ETF	31.91	32.0	31.55	31.99	16400.0
2010-11-11	BKF	ETF	50.84	50.86	50.47	50.8	176761.0
2010-11-11	BLV	ETF	81.49	81.62	81.27	81.48	23700.0
2010-11-11	BMVP	ETF	14.14	14.28	14.13	14.25	11485.0
2010-11-11	BND	ETF	82.25	82.26	82.06	82.21	252900.0
2010-11-11	BNE	ETF	11.43	11.46	11.42	11.44	710203.0
2010-11-11	BNO	ETF	29.695	29.78	29.665	29.78	60600.0
2010-11-11	BRF	ETF	60.0	60.38	59.59	60.26	349605.0
2010-11-11	BSCE	ETF	21.0	21.0	21.0	21.0	460.0
2010-11-11	BSV	ETF	81.77	81.78	81.56	81.66	378700.0
2010-11-11	BTF	ETF	79.35	80.0	79.19999999999999	79.95	3188.2000000000003
2010-11-11	BWX	ETF	30.21	30.21	29.985	30.12	191324.0
2010-11-11	BWZ	ETF	37.46	37.46	37.23	37.37	10588.0
2010-11-11	BZQ	ETF	2609.6	2622.4	2584.0	2604.8	424.0
2010-11-11	CEF	ETF	18.87	19.09	18.75	19.06	1372900.0

> showing 50 of 803 rows — these rows as CSV

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