PREVIEW / etf_daily / 2010-08-16

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-16.parquet
  size:    33 KB
  rows:    768

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
2010-08-16	SPY	ETF	107.57	108.61	107.18	108.26	147895300.0
2010-08-16	QQQ	ETF	44.48	45.11	44.3	44.8	55472857.0
2010-08-16	IWM	ETF	60.64	61.92	60.38	61.56	51371000.0
2010-08-16	DIA	ETF	102.81	103.59	102.38	103.28	5818900.0
2010-08-16	GLD	ETF	119.7	119.82	119.46	119.73	8948300.0
2010-08-16	TLT	ETF	104.21	104.89	104.07	104.85	7976200.0
2010-08-16	AADR	ETF	25.28	25.28	25.24	25.24	3000.0
2010-08-16	AAXJ	ETF	54.89	55.32	54.89	55.26	208500.0
2010-08-16	ACWI	ETF	40.19	40.59	40.02	40.49	103700.0
2010-08-16	ACWX	ETF	38.08	38.52	38.08	38.4	677685.0
2010-08-16	ADRE	ETF	41.76	42.2999	41.76	42.24	294372.0
2010-08-16	AFK	ETF	30.15	30.27	29.9001	30.19	10051.0
2010-08-16	AGG	ETF	108.33	108.37	108.21	108.35	773200.0
2010-08-16	AGQ	ETF	120.92	121.22	119.92	120.66	119450.0
2010-08-16	AGZ	ETF	111.22	111.22	111.109	111.21	16719.0
2010-08-16	AIA	ETF	39.27	39.61	39.27	39.46	40346.0
2010-08-16	AIQ	ETF	22.55	23.25	22.35	23.25	30258.0
2010-08-16	AIS	ETF	1.62	1.62	1.51	1.55	524037.0
2010-08-16	AIVI	ETF	39.8	40.07	39.73	39.81	4000.0
2010-08-16	AMJ	ETF	32.69	32.88	32.56	32.73	791806.0
2010-08-16	AOA	ETF	29.33	29.55	29.25	29.49	22300.0
2010-08-16	AOK	ETF	27.84	27.84	27.789	27.82	1994.0
2010-08-16	AOM	ETF	28.23	28.32	28.18	28.31	14272.0
2010-08-16	AOR	ETF	28.65	28.758	28.6001	28.7536	1575.0
2010-08-16	ARB	ETF	25.57	25.66	25.05	25.31	227043.0
2010-08-16	BAB	ETF	26.48	26.64	26.48	26.58	455764.0
2010-08-16	BAL	ETF	41.29	41.29	40.9201	40.944	5063.0
2010-08-16	BALT	ETF	10.29	11.13	10.25	11.0	713543.0
2010-08-16	BBH	ETF	30.9833	31.0433	30.7567	30.9267	53400.0
2010-08-16	BIB	ETF	5.7125	5.7125	5.7125	5.7125	1592.0
2010-08-16	BICK	ETF	28.63	28.77	28.58	28.76	16185.0
2010-08-16	BIL	ETF	91.72	91.72	91.7	91.7	59850.0
2010-08-16	BIS	ETF	11425.6	11425.6	11177.6	11177.6	5.0
2010-08-16	BITS	ETF	27.48	27.96	27.4	27.6	894.0
2010-08-16	BIV	ETF	86.19	86.28	86.03	86.22	182800.0
2010-08-16	BJK	ETF	25.34	25.44	25.25	25.32	10100.0
2010-08-16	BKF	ETF	43.7	44.272	43.7	44.22	55058.0
2010-08-16	BLV	ETF	85.58	85.84	85.27	85.81	71900.0
2010-08-16	BMVP	ETF	12.137	12.248	12.137	12.237	14612.0
2010-08-16	BND	ETF	82.52	82.6	82.44	82.55	585500.0
2010-08-16	BNE	ETF	11.11	11.19	11.1	11.16	195303.0
2010-08-16	BNO	ETF	25.385	25.4	25.355	25.4	12400.0
2010-08-16	BRF	ETF	48.93	50.09	48.9	49.98	287676.0
2010-08-16	BSCE	ETF	20.85	20.85	20.83	20.84	1780.0
2010-08-16	BSV	ETF	81.58	81.62	81.51	81.59	535400.0
2010-08-16	BTF	ETF	68.55	69.14999999999999	67.8	68.39999999999999	1830.4
2010-08-16	BWX	ETF	28.475	28.74	28.42	28.545	333230.0
2010-08-16	BWZ	ETF	35.31	35.31	35.198	35.214	7280.0
2010-08-16	BZQ	ETF	3492.8	3512.0	3376.0	3385.6	974.5
2010-08-16	CEF	ETF	14.94	15.02	14.93	14.99	625600.0

> showing 50 of 768 rows — these rows as CSV

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