PREVIEW / etf_daily / 2011-08-23

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-23.parquet
  size:    36 KB
  rows:    868

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-08-23	SPY	ETF	113.15	116.57	112.58	116.44	331136600.0
2011-08-23	QQQ	ETF	50.56	52.28	50.34	52.28	75688388.0
2011-08-23	IWM	ETF	65.46	68.3	64.86	68.19	93274300.0
2011-08-23	DIA	ETF	108.85	111.47	108.43	111.37	12374800.0
2011-08-23	GLD	ETF	182.24	183.82	177.5	177.67	55265400.0
2011-08-23	TLT	ETF	109.76	111.17	109.35	109.39	16017800.0
2011-08-23	AAXJ	ETF	53.6	54.77	53.19	54.77	307500.0
2011-08-23	ACTV	ETF	16.61	17.027	16.35	16.95	107328.0
2011-08-23	ACWI	ETF	41.17	42.18	40.93	42.15	667200.0
2011-08-23	ACWX	ETF	38.05	38.92	37.9	38.92	320815.0
2011-08-23	ADRE	ETF	39.85	40.67	39.47	40.67	73308.0
2011-08-23	AFK	ETF	28.2	28.64	28.04	28.6	36944.0
2011-08-23	AGEM	ETF	22.22	22.4483	22.188	22.4483	2122.0
2011-08-23	AGG	ETF	109.72	109.72	109.5	109.63	757100.0
2011-08-23	AGQ	ETF	486.92	496.82	453.42	458.98	1014250.0
2011-08-23	AGZ	ETF	112.24	112.49	112.19	112.24	33757.0
2011-08-23	AIA	ETF	39.94	40.72	39.64	40.72	54732.0
2011-08-23	AIQ	ETF	6.95	7.5	6.8	7.5	55810.0
2011-08-23	AIS	ETF	2.23	2.35	2.2	2.35	1115864.0
2011-08-23	AIVI	ETF	40.93	41.86	40.76	41.86	480100.0
2011-08-23	AMJ	ETF	33.44	34.33	33.3	34.33	1187180.0
2011-08-23	AMLP	ETF	73.7	75.3	72.75	75.3	162380.0
2011-08-23	AOA	ETF	30.8	31.55	30.75	31.51	9400.0
2011-08-23	AOK	ETF	28.75	28.88	28.6701	28.88	13513.0
2011-08-23	AOM	ETF	29.25	29.5	29.18	29.5	66235.0
2011-08-23	AOR	ETF	29.82	30.25	29.71	30.24	13159.0
2011-08-23	ARB	ETF	31.9	33.78	31.42	33.73	142072.0
2011-08-23	ARGT	ETF	24.7	24.78	24.7	24.78	25150.0
2011-08-23	ASEA	ETF	15.87	16.03	15.87	16.03	2100.0
2011-08-23	AWAY	ETF	34.0	35.99	33.41	35.49	74863.0
2011-08-23	BAB	ETF	27.79	27.82	27.6289	27.64	107488.0
2011-08-23	BAL	ETF	65.9	66.4628	64.631	65.84	49497.0
2011-08-23	BALT	ETF	4.25	4.48	4.17	4.48	112267.0
2011-08-23	BBH	ETF	31.3433	32.1267	31.3333	32.1267	33900.0
2011-08-23	BCM	ETF	47.71	47.71	47.66	47.66	681.0
2011-08-23	BIB	ETF	6.36	6.8197	6.3371	6.8087	55800.0
2011-08-23	BICK	ETF	25.37	26.025	25.37	26.0	9045.0
2011-08-23	BIL	ETF	91.7	91.72	91.7	91.72	709250.0
2011-08-23	BIS	ETF	7484.8	7516.8	7457.6	7457.6	3.125
2011-08-23	BITS	ETF	21.8	22.0	21.52	21.6	1288.0
2011-08-23	BIV	ETF	87.84	88.0	87.63	87.65	83300.0
2011-08-23	BJK	ETF	30.91	31.73	30.91	31.66	33000.0
2011-08-23	BKF	ETF	39.34	40.29	38.92	40.28	112608.0
2011-08-23	BKLN	ETF	23.13	23.23	22.97	23.2	150400.0
2011-08-23	BLNG	ETF	59.26	59.26	57.74	57.74	1000.0
2011-08-23	BLV	ETF	87.91	88.38	87.49	87.58	72000.0
2011-08-23	BMVP	ETF	12.71	13.04	12.7	13.04	10815.0
2011-08-23	BND	ETF	83.68	83.8	83.51	83.55	1660600.0
2011-08-23	BNO	ETF	36.19	36.83	35.99	36.83	451000.0
2011-08-23	BRF	ETF	47.51	48.35	46.86	48.3	143138.0

> showing 50 of 868 rows — these rows as CSV

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