PREVIEW / etf_daily / 2010-12-01

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-01.parquet
  size:    34 KB
  rows:    806

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-01	SPY	ETF	120.2	121.24	120.19	121.01	221037200.0
2010-12-01	QQQ	ETF	52.87	53.46	52.84	53.19	81758047.0
2010-12-01	IWM	ETF	74.12	74.57	72.81	74.38	59974000.0
2010-12-01	DIA	ETF	111.68	112.9	111.59	112.67	7312300.0
2010-12-01	GLD	ETF	135.71	136.14	134.96	135.38	16831100.0
2010-12-01	TLT	ETF	96.65	97.11	95.89	95.89	15441200.0
2010-12-01	AADR	ETF	28.57	28.78	28.57	28.78	1700.0
2010-12-01	AAXJ	ETF	62.29	62.76	62.24	62.57	683900.0
2010-12-01	ACWI	ETF	44.58	45.05	44.58	44.98	243000.0
2010-12-01	ACWX	ETF	42.1	42.47	42.07	42.43	85534.0
2010-12-01	ADRE	ETF	45.88	46.212	45.7801	46.08	64126.0
2010-12-01	AFK	ETF	33.06	33.2	32.66	33.1775	51413.0
2010-12-01	AGG	ETF	106.56	106.56	106.25	106.26	950600.0
2010-12-01	AGQ	ETF	272.86	277.42	266.96	273.68	573300.0
2010-12-01	AGZ	ETF	110.53	110.6	110.41	110.41	6234.0
2010-12-01	AIA	ETF	45.29	45.29	44.9104	45.14	42559.0
2010-12-01	AIQ	ETF	19.15	19.3	18.75	18.85	53047.0
2010-12-01	AIS	ETF	1.45	1.4539	1.42	1.44	194175.0
2010-12-01	AIVI	ETF	41.89	42.33	41.82	42.33	30800.0
2010-12-01	AMJ	ETF	35.97	35.97	35.61	35.64	793754.0
2010-12-01	AMLP	ETF	80.05	80.05	79.15	79.25	193380.0
2010-12-01	AOA	ETF	32.97	33.14	32.96	33.11	9000.0
2010-12-01	AOK	ETF	28.56	28.64	28.56	28.57	13547.0
2010-12-01	AOM	ETF	29.5	29.57	29.488	29.56	36457.0
2010-12-01	AOR	ETF	30.75	30.85	30.7101	30.839	29232.0
2010-12-01	ARB	ETF	29.65	30.0	29.49	29.89	179692.0
2010-12-01	BAB	ETF	25.35	25.43	25.2907	25.31	184187.0
2010-12-01	BAL	ETF	60.33	62.51	60.2	62.28	59259.0
2010-12-01	BALT	ETF	11.97	12.37	11.81	11.86	168651.0
2010-12-01	BBH	ETF	32.6633	32.8933	32.57	32.76	103500.0
2010-12-01	BICK	ETF	32.33	32.44	32.12	32.44	15653.0
2010-12-01	BIL	ETF	91.72	91.72	91.7	91.7	75350.0
2010-12-01	BITS	ETF	28.6	28.6	27.68	28.4	10824.0
2010-12-01	BIV	ETF	84.78	84.86	84.37	84.57	644800.0
2010-12-01	BJK	ETF	31.58	31.68	31.42	31.54	20800.0
2010-12-01	BKF	ETF	48.54	49.05	48.45	48.82	83106.0
2010-12-01	BLV	ETF	80.64	81.13	80.35	80.53	56600.0
2010-12-01	BMVP	ETF	14.32	14.3967	14.3133	14.39	26077.0
2010-12-01	BND	ETF	81.36	81.47	81.16	81.19	1170600.0
2010-12-01	BNO	ETF	29.295	29.545	29.295	29.545	800.0
2010-12-01	BOSS	ETF	38.9	41.95	38.9	41.95	400.0
2010-12-01	BRF	ETF	59.68	60.15	59.41	60.04	434532.0
2010-12-01	BSCE	ETF	20.76	20.86	20.7501	20.7501	66177.0
2010-12-01	BSV	ETF	81.18	81.23	81.08	81.08	516600.0
2010-12-01	BTF	ETF	77.85	78.39999999999999	77.85	78.25	3689.6000000000004
2010-12-01	BWX	ETF	28.605	28.745	28.4125	28.575	535142.0
2010-12-01	BWZ	ETF	37.79	37.79	36.036	36.35	18239.0
2010-12-01	BZQ	ETF	2692.8	2721.6	2649.6	2668.8	518.0
2010-12-01	CEF	ETF	19.45	19.5	19.28	19.49	1360600.0
2010-12-01	CEW	ETF	22.78	22.85	22.73	22.84	123042.0

> showing 50 of 806 rows — these rows as CSV

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