PREVIEW / etf_daily / 2011-12-27

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-27.parquet
  size:    37 KB
  rows:    894

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-27	SPY	ETF	126.17	126.82	126.06	126.49	86075700.0
2011-12-27	QQQ	ETF	56.01	56.42	55.93	56.24	21443438.0
2011-12-27	IWM	ETF	74.26	75.16	74.08	74.77	26922400.0
2011-12-27	DIA	ETF	122.48	123.0	122.4	122.67	3878700.0
2011-12-27	GLD	ETF	155.08	155.55	154.54	154.91	4918600.0
2011-12-27	TLT	ETF	117.94	118.45	117.62	118.45	4270300.0
2011-12-27	AADR	ETF	28.02	28.04	27.96	28.03	5700.0
2011-12-27	AAXJ	ETF	50.09	50.28	49.99	50.0	472400.0
2011-12-27	ACTV	ETF	13.25	13.29	12.995	13.04	106414.0
2011-12-27	ACWI	ETF	42.25	42.41	42.25	42.29	1558400.0
2011-12-27	ACWX	ETF	36.71	36.83	36.64	36.77	503610.0
2011-12-27	ADRE	ETF	38.23	38.37	38.12	38.2	148126.0
2011-12-27	AFK	ETF	25.84	26.074	25.84	25.95	26069.0
2011-12-27	AGEM	ETF	20.69	20.69	20.64	20.66	2640.0
2011-12-27	AGG	ETF	109.7	109.94	109.67	109.94	1090600.0
2011-12-27	AGQ	ETF	184.0	187.88	181.0	181.28	271975.0
2011-12-27	AGZ	ETF	112.52	113.119	112.35	112.52	36018.0
2011-12-27	AIA	ETF	39.13	39.32	39.13	39.19	27550.0
2011-12-27	AIQ	ETF	5.5	5.75	5.1	5.2	17807.0
2011-12-27	AIS	ETF	1.95	1.99	1.87	1.97	912711.0
2011-12-27	AIVI	ETF	39.56	39.56	39.35	39.43	86500.0
2011-12-27	AMJ	ETF	38.48	38.65	38.39	38.6	1472477.0
2011-12-27	AMLP	ETF	82.15	82.45	82.05	82.4	222060.0
2011-12-27	AOA	ETF	33.25	33.29	33.13	33.22	17000.0
2011-12-27	AOK	ETF	29.43	29.432	29.3912	29.43	39217.0
2011-12-27	AOM	ETF	29.83	29.92	29.83	29.9	46839.0
2011-12-27	AOR	ETF	31.17	31.235	31.114	31.19	9526.0
2011-12-27	ARB	ETF	35.53	35.7222	35.17	35.39	85269.0
2011-12-27	ASEA	ETF	14.65	14.85	14.65	14.8	10100.0
2011-12-27	AWAY	ETF	19.77	22.5	19.77	22.12	836848.0
2011-12-27	BAB	ETF	28.52	28.56	28.45	28.49	94131.0
2011-12-27	BAL	ETF	54.07	54.4	54.07	54.4	12457.0
2011-12-27	BALT	ETF	5.0	5.02	4.83	4.92	85191.0
2011-12-27	BBH	ETF	35.8833	36.4133	35.8267	36.3533	21900.0
2011-12-27	BCM	ETF	42.86	43.59	42.86	43.31	2061.0
2011-12-27	BIB	ETF	8.4512	8.6502	8.3788	8.6468	37616.0
2011-12-27	BICK	ETF	23.06	23.0988	22.87	22.9	69733.0
2011-12-27	BIL	ETF	91.66	91.68	91.66	91.66	158500.0
2011-12-27	BIS	ETF	5339.2	5339.2	5246.4	5267.2	21.25
2011-12-27	BITS	ETF	22.72	22.92	22.28	22.68	1574.0
2011-12-27	BIV	ETF	86.31	86.56	86.16	86.28	154300.0
2011-12-27	BJK	ETF	29.82	30.25	29.81	30.11	27700.0
2011-12-27	BKF	ETF	36.9	36.96	36.62	36.7	345291.0
2011-12-27	BKLN	ETF	23.8	23.89	23.75	23.77	173800.0
2011-12-27	BLV	ETF	90.13	90.36	90.02	90.36	32600.0
2011-12-27	BMVP	ETF	13.753	13.824	13.733	13.81	7476.0
2011-12-27	BND	ETF	83.15	83.25	82.88	83.09	1686800.0
2011-12-27	BNO	ETF	37.515	37.945	37.515	37.86	26000.0
2011-12-27	BOIL	ETF	2337000.0	2350000.0	2219000.0	2285000.0	0.2
2011-12-27	BRF	ETF	36.56	36.57	36.25	36.3	314998.0

> showing 50 of 894 rows — these rows as CSV

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