PREVIEW / etf_daily / 2011-10-11

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-11.parquet
  size:    36 KB
  rows:    872

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
2011-10-11	SPY	ETF	118.87	120.04	118.75	119.7	209088000.0
2011-10-11	QQQ	ETF	55.81	56.46	55.7	56.32	66449089.0
2011-10-11	IWM	ETF	67.72	69.12	67.54	68.84	63173300.0
2011-10-11	DIA	ETF	113.62	114.35	113.53	114.01	7836000.0
2011-10-11	GLD	ETF	162.21	162.51	161.21	162.1	8256900.0
2011-10-11	TLT	ETF	117.29	117.36	115.9	116.18	7520200.0
2011-10-11	AADR	ETF	27.29	27.29	27.24	27.24	33200.0
2011-10-11	AAXJ	ETF	49.42	50.41	49.32	50.21	1084500.0
2011-10-11	ACTV	ETF	14.38	14.84	14.25	14.36	172739.0
2011-10-11	ACWI	ETF	41.35	41.7	41.17	41.58	517600.0
2011-10-11	ACWX	ETF	37.01	37.36	36.849	37.32	113398.0
2011-10-11	ADRE	ETF	37.41	38.0	37.35	37.97	53617.0
2011-10-11	AFK	ETF	26.87	27.09	26.87	27.09	4297.0
2011-10-11	AGEM	ETF	21.1	21.1	21.044	21.044	1595.0
2011-10-11	AGG	ETF	109.08	109.29	108.96	109.27	2155000.0
2011-10-11	AGQ	ETF	235.08	241.4	233.0	240.82	461450.0
2011-10-11	AGZ	ETF	112.03	112.13	111.88	111.88	34940.0
2011-10-11	AIA	ETF	38.57	39.1285	38.47	38.928	9236.0
2011-10-11	AIQ	ETF	5.95	6.25	5.9005	6.25	30931.0
2011-10-11	AIS	ETF	2.23	2.28	2.2001	2.28	475558.0
2011-10-11	AIVI	ETF	40.22	40.91	40.22	40.75	50900.0
2011-10-11	AMJ	ETF	34.25	34.96	34.25	34.81	1649484.0
2011-10-11	AMLP	ETF	76.55	77.4	76.25	77.3	196940.0
2011-10-11	AOA	ETF	31.56	31.85	31.56	31.77	8700.0
2011-10-11	AOK	ETF	28.75	28.86	28.75	28.85	17226.0
2011-10-11	AOM	ETF	29.25	29.3936	29.25	29.34	8746.0
2011-10-11	AOR	ETF	30.3	30.32	30.24	30.31	15993.0
2011-10-11	ARB	ETF	36.76	37.3	36.18	37.0	209509.0
2011-10-11	ASEA	ETF	14.55	14.62	14.49	14.59	3300.0
2011-10-11	AWAY	ETF	35.87	37.61	35.87	36.3	73512.0
2011-10-11	BAB	ETF	28.42	28.5	28.3	28.48	145780.0
2011-10-11	BAL	ETF	63.66	64.28	63.6012	63.98	17158.0
2011-10-11	BALT	ETF	5.08	5.5194	5.08	5.37	110827.0
2011-10-11	BBH	ETF	33.92	33.92	33.5	33.5067	28800.0
2011-10-11	BCM	ETF	42.9435	42.9435	42.9435	42.9435	245.0
2011-10-11	BIB	ETF	7.5862	7.5862	7.4225	7.4225	6000.0
2011-10-11	BICK	ETF	23.59	24.0	23.55	23.9	7987.0
2011-10-11	BIL	ETF	91.68	91.7	91.68	91.7	562550.0
2011-10-11	BIS	ETF	6419.2	6480.0	6419.2	6480.0	2.5
2011-10-11	BITS	ETF	23.2	23.2	21.6	22.76	4608.0
2011-10-11	BIV	ETF	86.39	86.47	86.18	86.45	208600.0
2011-10-11	BJK	ETF	30.35	30.74	30.13	30.48	8900.0
2011-10-11	BKF	ETF	36.05	36.75	35.76	36.51	163920.0
2011-10-11	BKLN	ETF	23.19	23.19	23.01	23.12	57200.0
2011-10-11	BLV	ETF	90.08	90.08	89.25	89.5	34900.0
2011-10-11	BMVP	ETF	12.9567	13.1741	12.9567	13.1167	7057.0
2011-10-11	BND	ETF	83.01	83.02	82.9	82.92	976200.0
2011-10-11	BNO	ETF	36.455	37.18	36.31	36.9	96600.0
2011-10-11	BOIL	ETF	3785000.0	3849000.0	3781000.0	3845000.0	0.2
2011-10-11	BRF	ETF	42.13	43.16	42.13	42.74	142451.0

> showing 50 of 872 rows — these rows as CSV

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