PREVIEW / etf_daily / 2010-12-08

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-08.parquet
  size:    35 KB
  rows:    818

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-12-08	SPY	ETF	122.98	123.38	122.41	123.28	138019200.0
2010-12-08	QQQ	ETF	54.02	54.15	53.6899	54.08	48066845.0
2010-12-08	IWM	ETF	76.75	77.01	76.37	76.53	40388800.0
2010-12-08	DIA	ETF	113.7	114.08	113.45	113.89	6518700.0
2010-12-08	GLD	ETF	135.91	136.29	133.88	134.79	23483300.0
2010-12-08	TLT	ETF	93.72	93.8	92.11	93.26	19275900.0
2010-12-08	AADR	ETF	29.34	29.34	29.1	29.19	2200.0
2010-12-08	AAXJ	ETF	63.11	63.35	62.73	62.94	345700.0
2010-12-08	ACWI	ETF	45.86	46.02	45.62	45.89	139600.0
2010-12-08	ACWX	ETF	43.35	43.53	43.07	43.4199	93267.0
2010-12-08	ADRE	ETF	46.7	46.73	46.131	46.32	50024.0
2010-12-08	AFK	ETF	34.0	34.181	33.6102	33.88	29563.0
2010-12-08	AGG	ETF	105.55	105.55	104.93	105.31	1856200.0
2010-12-08	AGQ	ETF	282.02	284.64	262.28	269.82	1163700.0
2010-12-08	AGZ	ETF	109.9	110.28	109.548	109.9	134268.0
2010-12-08	AIA	ETF	45.71	45.77	45.37	45.56	38429.0
2010-12-08	AIQ	ETF	18.85	19.1	18.75	19.1	18094.0
2010-12-08	AIS	ETF	1.51	1.55	1.49	1.54	176289.0
2010-12-08	AIVI	ETF	43.14	43.36	42.89	43.2	25500.0
2010-12-08	AMJ	ETF	35.79	35.88	35.5198	35.57	940398.0
2010-12-08	AMLP	ETF	79.5	79.55	79.0	79.1	161080.0
2010-12-08	AOA	ETF	33.84	33.84	33.57	33.74	10500.0
2010-12-08	AOK	ETF	28.5901	28.6	28.5101	28.57	8551.0
2010-12-08	AOM	ETF	29.71	29.71	29.628	29.71	59816.0
2010-12-08	AOR	ETF	31.18	31.18	31.04	31.14	15912.0
2010-12-08	ARB	ETF	31.27	31.9	31.06	31.3	243225.0
2010-12-08	BAB	ETF	24.95	25.13	24.92	25.089	558815.0
2010-12-08	BAL	ETF	65.12	67.58	64.16	67.22	47011.0
2010-12-08	BALT	ETF	11.63	11.71	11.22	11.34	146062.0
2010-12-08	BBH	ETF	32.76	33.0133	32.76	32.9433	20400.0
2010-12-08	BICK	ETF	32.52	32.52	32.0	32.268	63565.0
2010-12-08	BIL	ETF	91.7	91.72	91.7	91.7	82450.0
2010-12-08	BITS	ETF	28.8	28.84	28.6	28.6	1025.0
2010-12-08	BIV	ETF	83.33	83.33	82.57	83.09	630600.0
2010-12-08	BJK	ETF	31.94	32.04	31.63	31.78	16300.0
2010-12-08	BKF	ETF	49.1	49.26	48.56	48.86	139839.0
2010-12-08	BLV	ETF	79.46	79.46	78.06	78.88	72600.0
2010-12-08	BMVP	ETF	14.617	14.627	14.551	14.607	20152.0
2010-12-08	BND	ETF	80.63	80.66	80.25	80.51	966500.0
2010-12-08	BNO	ETF	30.115	30.115	30.115	30.115	400.0
2010-12-08	BRF	ETF	59.76	60.21	58.71	58.93	346131.0
2010-12-08	BSCE	ETF	20.62	20.68	20.62	20.643	22006.0
2010-12-08	BSV	ETF	80.86	80.86	80.65	80.75	736600.0
2010-12-08	BTF	ETF	78.05	78.2	77.55	77.94999999999999	2808.8
2010-12-08	BWX	ETF	28.76	28.795	28.39	28.645	278130.0
2010-12-08	BWZ	ETF	36.38	36.7198	36.31	36.331	18808.0
2010-12-08	BZQ	ETF	2640.0	2729.6	2619.2	2707.2	1108.0
2010-12-08	CEF	ETF	19.97	20.02	19.38	19.54	1710200.0
2010-12-08	CEW	ETF	22.94	22.96	22.88	22.96	56672.0
2010-12-08	CGO	ETF	14.52	14.53	14.37	14.37	23770.0

> showing 50 of 818 rows — these rows as CSV

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