PREVIEW / etf_daily / 2011-03-01

all etf daily files

  file:    by_date/etf_daily/2011/2011-03-01.parquet
  size:    35 KB
  rows:    825

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-03-01	SPY	ETF	133.57	133.69	130.89	130.93	258565500.0
2011-03-01	QQQ	ETF	57.99	58.02	56.695	56.84	91992504.0
2011-03-01	IWM	ETF	82.58	82.64	80.35	80.62	70865100.0
2011-03-01	DIA	ETF	122.4	122.48	120.37	120.37	9666700.0
2011-03-01	GLD	ETF	138.57	140.03	138.49	140.03	17438100.0
2011-03-01	TLT	ETF	91.52	92.4	91.47	92.37	8048700.0
2011-03-01	AADR	ETF	30.44	30.44	30.3	30.3	7500.0
2011-03-01	AAXJ	ETF	60.69	60.91	59.94	60.06	442000.0
2011-03-01	ACWI	ETF	49.03	49.08	48.1	48.11	287100.0
2011-03-01	ACWX	ETF	45.95	45.95	45.07	45.1	193154.0
2011-03-01	ADRE	ETF	47.0	47.14	46.4001	46.44	73167.0
2011-03-01	AFK	ETF	32.81	33.05	32.4415	32.48	42907.0
2011-03-01	AGG	ETF	105.1	105.38	105.05	105.28	735700.0
2011-03-01	AGQ	ETF	383.18	390.3	380.24	389.6	576800.0
2011-03-01	AGZ	ETF	109.07	109.38	108.84	109.36	41589.0
2011-03-01	AIA	ETF	46.11	46.15	45.43	45.49	47139.0
2011-03-01	AIQ	ETF	20.75	21.0	20.3	20.45	18273.0
2011-03-01	AIS	ETF	1.56	1.58	1.51	1.52	551622.0
2011-03-01	AIVI	ETF	46.72	46.78	45.93	46.01	27300.0
2011-03-01	AMJ	ETF	38.25	38.34	37.88	37.93	435461.0
2011-03-01	AMLP	ETF	82.95	83.05	82.2	82.3	124360.0
2011-03-01	AOA	ETF	35.99	36.0	35.35	35.38	29100.0
2011-03-01	AOK	ETF	29.2	29.2	29.09	29.11	12787.0
2011-03-01	AOM	ETF	30.55	30.5899	30.4099	30.417	12395.0
2011-03-01	AOR	ETF	32.63	32.63	32.23	32.266	12937.0
2011-03-01	ARB	ETF	39.86	40.12	38.56	38.79	179777.0
2011-03-01	ASEA	ETF	15.39	15.39	15.03	15.03	5500.0
2011-03-01	BAB	ETF	25.23	25.31	25.13	25.31	155530.0
2011-03-01	BAL	ETF	106.25	106.459	98.93	100.49	191267.0
2011-03-01	BALT	ETF	9.53	9.59	9.15	9.16	147526.0
2011-03-01	BBH	ETF	33.7867	34.0033	33.73	33.75	183900.0
2011-03-01	BICK	ETF	31.2	31.2	30.73	30.77	25249.0
2011-03-01	BIL	ETF	91.72	91.72	91.7	91.7	138400.0
2011-03-01	BITS	ETF	26.6	27.16	25.6	26.0	3476.0
2011-03-01	BIV	ETF	82.27	82.59	82.16	82.55	69400.0
2011-03-01	BJK	ETF	32.17	32.17	31.47	31.54	24500.0
2011-03-01	BKF	ETF	48.3	48.34	47.6702	47.87	168874.0
2011-03-01	BLV	ETF	78.17	78.66	77.84	78.55	21200.0
2011-03-01	BMVP	ETF	15.68	15.68	15.3767	15.3928	4621.0
2011-03-01	BND	ETF	79.92	80.13	79.87	80.1	558500.0
2011-03-01	BNO	ETF	37.58	38.62	37.58	38.62	202600.0
2011-03-01	BRF	ETF	52.63	52.73	51.68	51.76	241194.0
2011-03-01	BSCE	ETF	20.85	20.91	20.85	20.8501	15829.0
2011-03-01	BSV	ETF	80.3	80.4	80.27	80.36	510300.0
2011-03-01	BTF	ETF	87.2	87.24999999999999	85.2505	85.5	5719.8
2011-03-01	BWX	ETF	29.57	29.7075	29.57	29.625	195268.0
2011-03-01	BWZ	ETF	38.27	38.27	37.51	37.53	50041.0
2011-03-01	BZQ	ETF	2532.8	2633.6	2524.8	2633.6	242.0
2011-03-01	CEF	ETF	21.73	22.05	21.73	22.05	1783000.0
2011-03-01	CEW	ETF	22.46	22.47	22.39	22.41	186298.0

> showing 50 of 825 rows — these rows as CSV

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