PREVIEW / etf_daily / 2011-12-01

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-01.parquet
  size:    37 KB
  rows:    887

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-01	SPY	ETF	124.85	125.64	124.43	124.97	176954800.0
2011-12-01	QQQ	ETF	56.37	56.925	56.35	56.78	45361471.0
2011-12-01	IWM	ETF	73.47	74.14	73.06	73.2	57394700.0
2011-12-01	DIA	ETF	120.01	120.55	119.66	120.13	5437700.0
2011-12-01	GLD	ETF	169.85	170.57	168.59	169.63	11610300.0
2011-12-01	TLT	ETF	116.29	117.24	115.8	117.0	9647200.0
2011-12-01	AADR	ETF	28.7	28.7	28.7	28.7	200.0
2011-12-01	AAXJ	ETF	52.34	52.87	52.34	52.49	522800.0
2011-12-01	ACTV	ETF	12.7	12.78	12.3	12.43	263316.0
2011-12-01	ACWI	ETF	42.95	43.23	42.77	42.91	715700.0
2011-12-01	ACWV	ETF	50.76	50.76	50.71	50.71	500.0
2011-12-01	ACWX	ETF	37.95	38.24	37.83	38.01	391473.0
2011-12-01	ADRE	ETF	39.95	40.47	39.89	40.12	44944.0
2011-12-01	AFK	ETF	27.45	27.51	27.33	27.48	3616.0
2011-12-01	AGEM	ETF	22.21	22.24	22.153	22.2	6670.0
2011-12-01	AGG	ETF	108.8	108.97	108.6	108.84	1831000.0
2011-12-01	AGQ	ETF	244.64	250.52	237.52	240.24	524100.0
2011-12-01	AGZ	ETF	112.063	112.309	112.01	112.13	7776.0
2011-12-01	AIA	ETF	41.51	41.81	41.39	41.47	62270.0
2011-12-01	AIQ	ETF	6.0	6.25	5.65	5.8	29930.0
2011-12-01	AIS	ETF	2.62	2.62	2.56	2.59	1693706.0
2011-12-01	AIVI	ETF	40.79	40.97	40.32	40.5	507500.0
2011-12-01	AMJ	ETF	36.83	37.38	36.83	37.35	1245895.0
2011-12-01	AMLP	ETF	80.0	80.7	79.85	80.7	498680.0
2011-12-01	AOA	ETF	33.22	33.27	33.04	33.07	12300.0
2011-12-01	AOK	ETF	29.24	29.3	29.18	29.22	56189.0
2011-12-01	AOM	ETF	29.97	29.97	29.81	29.88	32633.0
2011-12-01	AOR	ETF	31.16	31.2	31.08	31.13	54584.0
2011-12-01	ARB	ETF	37.53	38.69	37.53	37.81	122465.0
2011-12-01	ARGT	ETF	22.86	22.92	22.84	22.92	1350.0
2011-12-01	ASEA	ETF	15.22	15.22	15.05	15.05	2500.0
2011-12-01	AWAY	ETF	26.75	27.98	25.72	25.98	790435.0
2011-12-01	BAB	ETF	28.3	28.45	28.21	28.42	116387.0
2011-12-01	BAL	ETF	56.99	57.46	56.212	56.4	25776.0
2011-12-01	BALT	ETF	5.09	5.09	4.91	4.97	58948.0
2011-12-01	BBH	ETF	34.9867	35.3933	34.83	35.3933	53100.0
2011-12-01	BCM	ETF	43.9701	44.02	43.97	44.02	427.0
2011-12-01	BIB	ETF	8.3075	8.3537	8.2875	8.35	15072.0
2011-12-01	BICK	ETF	25.0	25.12	24.796	24.89	35508.0
2011-12-01	BIL	ETF	91.66	91.68	91.66	91.66	2137000.0
2011-12-01	BIS	ETF	5515.2	5515.2	5515.2	5515.2	0.94
2011-12-01	BITS	ETF	21.8	21.8	21.4	21.66	3850.0
2011-12-01	BIV	ETF	86.59	86.8	86.37	86.71	192500.0
2011-12-01	BJK	ETF	31.73	31.84	31.48	31.58	25900.0
2011-12-01	BKF	ETF	38.52	38.918	38.436	38.53	128664.0
2011-12-01	BKLN	ETF	23.85	23.93	23.85	23.9	71200.0
2011-12-01	BLV	ETF	89.43	89.7	88.59	89.35	98400.0
2011-12-01	BMVP	ETF	13.55	13.69	13.54	13.64	7406.0
2011-12-01	BND	ETF	83.1	83.21	82.83	83.13	1570600.0
2011-12-01	BNO	ETF	37.92	38.29	37.525	37.755	92400.0

> showing 50 of 887 rows — these rows as CSV

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