PREVIEW / etf_daily / 2011-12-13

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-13.parquet
  size:    37 KB
  rows:    892

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-12-13	SPY	ETF	124.86	125.57	122.45	123.05	245159800.0
2011-12-13	QQQ	ETF	56.76	56.98	55.53	55.76	68557659.0
2011-12-13	IWM	ETF	74.23	74.47	71.55	71.94	79040300.0
2011-12-13	DIA	ETF	120.91	121.49	119.05	119.51	7761800.0
2011-12-13	GLD	ETF	161.86	163.19	157.76	158.45	25040400.0
2011-12-13	TLT	ETF	117.28	119.63	117.16	119.11	8901800.0
2011-12-13	AAXJ	ETF	50.29	50.65	49.48	49.74	374800.0
2011-12-13	ACTV	ETF	12.95	13.24	12.88	12.96	226762.0
2011-12-13	ACWI	ETF	42.43	42.62	41.48	41.59	448600.0
2011-12-13	ACWX	ETF	37.2	37.42	36.38	36.46	325349.0
2011-12-13	ADRE	ETF	38.86	39.0841	38.13	38.3	38641.0
2011-12-13	AFK	ETF	26.63	26.71	26.07	26.07	18125.0
2011-12-13	AGEM	ETF	21.14	21.18	20.921	21.0	4254.0
2011-12-13	AGG	ETF	109.43	109.78	109.38	109.64	1468000.0
2011-12-13	AGQ	ETF	218.08	228.36	206.24	209.48	640050.0
2011-12-13	AGZ	ETF	112.44	112.945	112.3	112.72	43584.0
2011-12-13	AIA	ETF	39.7801	40.0	39.14	39.21	37014.0
2011-12-13	AIQ	ETF	5.85	5.9	5.5	5.5	10733.0
2011-12-13	AIS	ETF	2.77	2.78	2.61	2.62	950710.0
2011-12-13	AIVI	ETF	39.63	39.84	38.55	38.73	145000.0
2011-12-13	AMJ	ETF	37.45	37.56	37.14	37.26	656486.0
2011-12-13	AMLP	ETF	81.05	81.15	80.5	80.75	262040.0
2011-12-13	AOA	ETF	33.04	33.15	32.4	32.4	4700.0
2011-12-13	AOK	ETF	29.27	29.2796	29.17	29.2	27909.0
2011-12-13	AOM	ETF	29.85	29.95	29.7	29.7	12592.0
2011-12-13	AOR	ETF	31.15	31.22	30.82	30.82	12852.0
2011-12-13	ARB	ETF	37.26	37.41	36.19	36.49	209378.0
2011-12-13	ARGT	ETF	22.78	22.78	22.56	22.56	650.0
2011-12-13	ASEA	ETF	14.6	14.7	14.41	14.41	7000.0
2011-12-13	AWAY	ETF	24.47	24.47	23.51	23.77	460352.0
2011-12-13	BAB	ETF	28.31	28.582	28.21	28.54	205453.0
2011-12-13	BAL	ETF	53.92	54.52	53.45	53.82	33326.0
2011-12-13	BALT	ETF	5.01	5.12	4.9	4.95	49734.0
2011-12-13	BBH	ETF	34.3233	34.88	33.92	34.3433	81600.0
2011-12-13	BCM	ETF	43.45	43.45	43.266	43.266	510.0
2011-12-13	BIB	ETF	8.08	8.175	7.835	7.835	16200.0
2011-12-13	BICK	ETF	23.73	23.73	23.22	23.22	8938.0
2011-12-13	BIL	ETF	91.66	91.68	91.66	91.66	399150.0
2011-12-13	BIS	ETF	5641.6	5697.6	5641.6	5697.6	3.165
2011-12-13	BITS	ETF	21.16	21.6	21.16	21.2404	13255.0
2011-12-13	BIV	ETF	87.19	87.68	87.04	87.57	267600.0
2011-12-13	BJK	ETF	30.27	30.27	29.44	29.52	10500.0
2011-12-13	BKF	ETF	36.72	36.97	35.99	36.2	157636.0
2011-12-13	BKLN	ETF	23.79	23.88	23.79	23.86	121200.0
2011-12-13	BLV	ETF	89.98	91.23	89.89	91.15	135300.0
2011-12-13	BMVP	ETF	13.58	13.58	13.46	13.49	3300.0
2011-12-13	BND	ETF	83.41	83.77	83.41	83.7	2088000.0
2011-12-13	BNO	ETF	37.435	38.42	37.435	37.78	197400.0
2011-12-13	BOIL	ETF	2470000.0	2540000.0	2456000.0	2519000.0	0.2
2011-12-13	BRF	ETF	42.75	42.81	41.5	41.77	197360.0

> showing 50 of 892 rows — these rows as CSV

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