PREVIEW / etf_daily / 2010-11-03

all etf daily files

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

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-03	SPY	ETF	119.68	120.02	118.45	119.95	226702800.0
2010-11-03	QQQ	ETF	52.84	53.04	52.36	53.02	126225796.0
2010-11-03	IWM	ETF	71.36	71.62	70.5	71.55	58044500.0
2010-11-03	DIA	ETF	112.07	112.37	111.06	112.3	10108800.0
2010-11-03	GLD	ETF	132.28	132.52	129.48	131.57	31702100.0
2010-11-03	TLT	ETF	101.73	102.27	98.43	98.92	25541800.0
2010-11-03	AADR	ETF	29.09	29.11	29.09	29.11	400.0
2010-11-03	AAXJ	ETF	63.96	64.15	63.31	64.15	560900.0
2010-11-03	ACWI	ETF	45.37	45.63	44.95	45.57	241300.0
2010-11-03	ACWX	ETF	43.5	43.66	43.0	43.66	37386.0
2010-11-03	ADRE	ETF	47.15	47.15	46.496	47.12	85731.0
2010-11-03	AFK	ETF	33.71	33.74	33.22	33.47	25286.0
2010-11-03	AGG	ETF	108.61	108.82	108.29	108.4	462600.0
2010-11-03	AGQ	ETF	212.54	214.08	197.54	212.22	687700.0
2010-11-03	AGZ	ETF	111.54	111.7299	111.508	111.617	8642.0
2010-11-03	AIA	ETF	45.27	45.53	45.0	45.475	15558.0
2010-11-03	AIQ	ETF	22.25	22.25	21.8	22.0	19437.0
2010-11-03	AIS	ETF	1.41	1.42	1.37	1.39	367504.0
2010-11-03	AIVI	ETF	45.91	46.26	45.59	46.24	165700.0
2010-11-03	AMJ	ETF	35.96	35.96	35.708	35.845	432839.0
2010-11-03	AMLP	ETF	80.45	80.55	80.0	80.2	69560.0
2010-11-03	AOA	ETF	33.05	33.08	32.81	33.03	7600.0
2010-11-03	AOK	ETF	28.85	28.894	28.8	28.825	4053.0
2010-11-03	AOM	ETF	29.84	29.84	29.74	29.84	14974.0
2010-11-03	AOR	ETF	30.99	30.99	30.8	30.933	18033.0
2010-11-03	ARB	ETF	26.31	26.72	26.145	26.71	199278.0
2010-11-03	BAB	ETF	26.31	26.35	25.95	26.01	575550.0
2010-11-03	BAL	ETF	67.82	68.09	64.88	66.8	77199.0
2010-11-03	BALT	ETF	11.72	11.77	11.57	11.7	106606.0
2010-11-03	BBH	ETF	34.2233	34.2233	33.6633	34.01	54600.0
2010-11-03	BIB	ETF	6.815	6.815	6.815	6.815	2400.0
2010-11-03	BICK	ETF	33.45	33.6	33.17	33.6	30546.0
2010-11-03	BIL	ETF	91.7	91.72	91.7	91.7	229500.0
2010-11-03	BIS	ETF	9067.2	9112.0	9054.4	9054.4	8.1
2010-11-03	BITS	ETF	28.2	28.4	27.8	28.12	2786.0
2010-11-03	BIV	ETF	86.92	87.11	86.5	86.92	370300.0
2010-11-03	BJK	ETF	31.92	32.31	31.74	32.29	92100.0
2010-11-03	BKF	ETF	50.55	50.79	50.1045	50.78	154977.0
2010-11-03	BLV	ETF	84.38	84.75	82.47	82.92	255700.0
2010-11-03	BMVP	ETF	13.89	13.9129	13.77	13.89	12230.0
2010-11-03	BND	ETF	82.78	82.92	82.52	82.7	1443800.0
2010-11-03	BNE	ETF	11.34	11.37	11.31	11.31	262158.0
2010-11-03	BRF	ETF	61.68	62.1	61.0	62.03	794883.0
2010-11-03	BSCE	ETF	21.04	21.05	21.0399	21.05	16959.0
2010-11-03	BSV	ETF	81.9	81.98	81.88	81.97	292400.0
2010-11-03	BTF	ETF	77.8	78.64999999999999	77.8	78.15	5547.200000000001
2010-11-03	BWX	ETF	30.75	31.015	30.71	30.92	348256.0
2010-11-03	BWZ	ETF	38.03	38.0675	37.866	38.0675	9784.0
2010-11-03	BZQ	ETF	2534.4	2593.6	2524.8	2531.2	387.5
2010-11-03	CEF	ETF	17.41	17.64	17.15	17.59	2060600.0

> showing 50 of 798 rows — these rows as CSV

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