PREVIEW / etf_daily / 2010-10-14

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-14.parquet
  size:    34 KB
  rows:    792

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-14	SPY	ETF	117.81	118.01	116.72	117.46	217764300.0
2010-10-14	QQQ	ETF	50.54	50.64	50.17	50.42	68463772.0
2010-10-14	IWM	ETF	70.63	70.95	69.89	70.53	70382100.0
2010-10-14	DIA	ETF	111.05	111.23	110.31	111.07	8971700.0
2010-10-14	GLD	ETF	134.06	134.85	133.9	134.75	26890500.0
2010-10-14	TLT	ETF	103.29	103.65	101.47	101.51	10945000.0
2010-10-14	AADR	ETF	29.13	29.13	28.77	28.96	3800.0
2010-10-14	AAXJ	ETF	63.36	63.37	62.87	63.19	592700.0
2010-10-14	ACWI	ETF	44.98	45.23	44.84	45.13	165000.0
2010-10-14	ACWX	ETF	43.48	43.55	43.2	43.41	32810.0
2010-10-14	ADRE	ETF	47.15	47.19	46.73	46.95	127457.0
2010-10-14	AFK	ETF	34.0	34.0	33.46	33.61	53667.0
2010-10-14	AGG	ETF	108.62	108.67	108.2	108.24	1091800.0
2010-10-14	AGQ	ETF	202.3	210.4	201.98	210.0	410400.0
2010-10-14	AGZ	ETF	111.73	111.73	111.46	111.51	13668.0
2010-10-14	AIA	ETF	44.0	44.215	43.9581	44.14	60658.0
2010-10-14	AIQ	ETF	23.0	23.25	22.4	22.45	18897.0
2010-10-14	AIS	ETF	1.64	1.64	1.57	1.61	190174.0
2010-10-14	AIVI	ETF	45.44	45.63	45.31	45.53	26500.0
2010-10-14	AMJ	ETF	35.18	35.18	34.82	34.82	690915.0
2010-10-14	AMLP	ETF	79.25	79.3	78.8	79.0	156520.0
2010-10-14	AOA	ETF	32.6	32.68	32.55	32.55	5800.0
2010-10-14	AOK	ETF	28.8	28.82	28.74	28.74	4347.0
2010-10-14	AOM	ETF	29.65	29.71	29.5999	29.61	7096.0
2010-10-14	AOR	ETF	30.76	30.7692	30.6188	30.64	15657.0
2010-10-14	ARB	ETF	30.8	31.01	29.44	29.78	157280.0
2010-10-14	BAB	ETF	26.56	26.6288	26.33	26.38	236212.0
2010-10-14	BAL	ETF	56.25	58.58	56.2	58.44	45476.0
2010-10-14	BALT	ETF	11.37	11.37	11.07	11.17	122454.0
2010-10-14	BBH	ETF	32.3633	32.5467	32.16	32.2533	68100.0
2010-10-14	BIB	ETF	6.755	6.755	6.6738	6.6738	6400.0
2010-10-14	BICK	ETF	33.64	33.64	33.07	33.3	52564.0
2010-10-14	BIL	ETF	91.7	91.72	91.7	91.72	170300.0
2010-10-14	BIS	ETF	9318.4	9340.8	9308.8	9334.4	34.4
2010-10-14	BITS	ETF	27.76	27.76	26.48	27.4	2099.0
2010-10-14	BIV	ETF	87.17	87.37	86.91	86.91	115500.0
2010-10-14	BJK	ETF	30.1	30.1	29.69	29.83	30900.0
2010-10-14	BKF	ETF	50.6	50.61	50.09	50.39	243025.0
2010-10-14	BLV	ETF	85.26	85.43	83.96	83.96	95200.0
2010-10-14	BMVP	ETF	13.48	13.54	13.45	13.49	10335.0
2010-10-14	BND	ETF	82.74	82.84	82.52	82.53	926900.0
2010-10-14	BNE	ETF	11.39	11.42	11.37	11.41	909780.0
2010-10-14	BNO	ETF	28.165	28.165	28.165	28.165	2000.0
2010-10-14	BRF	ETF	61.89	61.96	61.06	61.35	461645.0
2010-10-14	BSV	ETF	81.79	81.86	81.79	81.81	338900.0
2010-10-14	BTF	ETF	78.05	78.05	77.0	77.1525	3640.2000000000003
2010-10-14	BWX	ETF	30.9	31.09	30.88	31.02	149672.0
2010-10-14	BWZ	ETF	37.75	37.92	37.66	37.67	50429.0
2010-10-14	BZQ	ETF	2468.8	2494.4	2433.6	2472.0	454.5
2010-10-14	CEF	ETF	17.66	18.02	17.64	17.98	1256800.0

> showing 50 of 792 rows — these rows as CSV

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