PREVIEW / etf_daily / 2010-11-05

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-05.parquet
  size:    35 KB
  rows:    809

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-05	SPY	ETF	122.34	122.92	122.18	122.72	180654100.0
2010-11-05	QQQ	ETF	53.7	53.81	53.51	53.67	77937076.0
2010-11-05	IWM	ETF	73.45	74.0	73.3	73.77	45659100.0
2010-11-05	DIA	ETF	114.45	114.63	114.05	114.54	6347900.0
2010-11-05	GLD	ETF	135.14	136.61	134.95	136.38	20342500.0
2010-11-05	TLT	ETF	98.35	98.8	97.98	97.98	12435000.0
2010-11-05	AADR	ETF	29.44	29.44	29.2	29.23	600.0
2010-11-05	AAXJ	ETF	65.4	65.71	65.28	65.56	390400.0
2010-11-05	ACWI	ETF	46.53	46.7	46.32	46.51	286300.0
2010-11-05	ACWX	ETF	44.49	44.6601	44.356	44.6	55565.0
2010-11-05	ADRE	ETF	48.4	48.42	48.15	48.3788	60327.0
2010-11-05	AFK	ETF	34.36	34.55	34.36	34.5	25207.0
2010-11-05	AGG	ETF	108.62	108.75	108.52	108.62	1150200.0
2010-11-05	AGQ	ETF	235.42	249.88	234.86	247.28	524750.0
2010-11-05	AGZ	ETF	111.69	111.69	111.5608	111.5608	8558.0
2010-11-05	AIA	ETF	46.41	46.65	46.29	46.64	65079.0
2010-11-05	AIQ	ETF	21.85	21.902	21.55	21.7	37448.0
2010-11-05	AIS	ETF	1.42	1.56	1.42	1.48	1062222.0
2010-11-05	AIVI	ETF	46.43	46.62	46.18	46.37	113900.0
2010-11-05	AMJ	ETF	36.27	36.51	36.19	36.49	1871119.0
2010-11-05	AMLP	ETF	80.05	80.35	79.3	80.0	151580.0
2010-11-05	AOA	ETF	33.72	33.84	33.72	33.82	5800.0
2010-11-05	AOK	ETF	29.09	29.1	29.02	29.04	7377.0
2010-11-05	AOM	ETF	30.1	30.17	30.1	30.14	32702.0
2010-11-05	AOR	ETF	31.4	31.45	31.4	31.4372	10231.0
2010-11-05	ARB	ETF	27.31	27.31	26.76	27.03	285204.0
2010-11-05	BAB	ETF	25.97	26.1	25.9	26.04	721539.0
2010-11-05	BAL	ETF	68.79	70.64	68.66	69.84	73142.0
2010-11-05	BALT	ETF	11.85	12.25	11.78	12.03	188304.0
2010-11-05	BBH	ETF	33.6867	33.6867	33.1767	33.3967	324300.0
2010-11-05	BIB	ETF	6.8187	6.8187	6.6908	6.7637	19200.0
2010-11-05	BICK	ETF	34.46	34.46	34.195	34.31	42988.0
2010-11-05	BIL	ETF	91.7	91.72	91.7	91.7	327150.0
2010-11-05	BIS	ETF	9096.0	9192.0	9096.0	9192.0	17.65
2010-11-05	BITS	ETF	28.4	28.88	28.04	28.4	3192.0
2010-11-05	BIV	ETF	87.35	87.5	87.13	87.24	151700.0
2010-11-05	BJK	ETF	32.71	33.11	32.7	32.7	9700.0
2010-11-05	BKF	ETF	51.79	52.08	51.76	52.02	153159.0
2010-11-05	BLV	ETF	82.84	83.22	82.62	82.62	69200.0
2010-11-05	BMVP	ETF	14.25	14.33	14.24	14.32	12025.0
2010-11-05	BND	ETF	82.76	82.86	82.61	82.61	1200000.0
2010-11-05	BNE	ETF	11.36	11.36	11.31	11.33	156079.0
2010-11-05	BNO	ETF	29.33	29.435	29.32	29.42	4200.0
2010-11-05	BRF	ETF	63.34	63.5	62.6	63.48	582343.0
2010-11-05	BSCE	ETF	21.17	21.17	21.0899	21.1	22733.0
2010-11-05	BSV	ETF	81.97	82.02	81.91	81.94	454800.0
2010-11-05	BTF	ETF	78.1	80.89999999999999	78.1	80.44999999999999	5407.0
2010-11-05	BWX	ETF	30.985	31.0145	30.84	30.84	537698.0
2010-11-05	BWZ	ETF	38.17	38.26	38.1	38.12	33512.0
2010-11-05	BZQ	ETF	2390.4	2436.8	2388.8	2406.4	349.0

> showing 50 of 809 rows — these rows as CSV

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