PREVIEW / etf_daily / 2010-11-24

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-24.parquet
  size:    34 KB
  rows:    801

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-11-24	SPY	ETF	119.2	120.23	119.18	120.2	140046100.0
2010-11-24	QQQ	ETF	52.58	53.25	52.56	53.12	53455536.0
2010-11-24	IWM	ETF	72.76	73.75	72.75	73.73	42138400.0
2010-11-24	DIA	ETF	111.0	111.96	111.0	111.85	4288200.0
2010-11-24	GLD	ETF	134.36	134.7	133.74	134.18	8858100.0
2010-11-24	TLT	ETF	96.81	96.99	95.58	95.74	11467600.0
2010-11-24	AADR	ETF	28.65	28.65	28.65	28.65	800.0
2010-11-24	AAXJ	ETF	61.91	62.21	61.76	62.17	314400.0
2010-11-24	ACWI	ETF	44.55	44.92	44.55	44.86	545200.0
2010-11-24	ACWX	ETF	42.38	42.62	42.3	42.6	88306.0
2010-11-24	ADRE	ETF	45.51	46.0799	45.51	46.07	27429.0
2010-11-24	AFK	ETF	33.61	33.61	33.13	33.28	160387.0
2010-11-24	AGG	ETF	107.5	107.52	107.14	107.15	740700.0
2010-11-24	AGQ	ETF	254.44	259.22	249.98	257.72	362050.0
2010-11-24	AGZ	ETF	110.93	110.93	110.6204	110.7	6616.0
2010-11-24	AIA	ETF	44.32	44.63	44.3	44.54	39849.0
2010-11-24	AIQ	ETF	19.85	19.85	19.45	19.65	22652.0
2010-11-24	AIS	ETF	1.41	1.42	1.39	1.4	198861.0
2010-11-24	AIVI	ETF	43.37	43.46	43.19	43.46	18500.0
2010-11-24	AMJ	ETF	36.14	36.18	35.82	35.88	1313330.0
2010-11-24	AMLP	ETF	80.05	80.05	79.4	79.45	71900.0
2010-11-24	AOA	ETF	32.82	33.02	32.82	33.02	16800.0
2010-11-24	AOK	ETF	28.55	28.63	28.55	28.588	24182.0
2010-11-24	AOM	ETF	29.5	29.5599	29.5	29.5436	5959.0
2010-11-24	AOR	ETF	30.72	30.83	30.72	30.78	10649.0
2010-11-24	ARB	ETF	28.86	29.47	28.34	29.26	328009.0
2010-11-24	BAB	ETF	25.57	25.57	25.35	25.41	246240.0
2010-11-24	BAL	ETF	58.61	59.239	58.05	58.825	64836.0
2010-11-24	BALT	ETF	12.4	12.4	12.16	12.36	73804.0
2010-11-24	BBH	ETF	32.7867	33.08	32.7867	33.0467	35100.0
2010-11-24	BICK	ETF	31.88	32.34	31.88	32.33	17615.0
2010-11-24	BIL	ETF	91.7	91.72	91.7	91.72	86600.0
2010-11-24	BITS	ETF	28.64	28.72	27.96	28.4	2200.0
2010-11-24	BIV	ETF	85.6	85.6	85.1	85.28	380600.0
2010-11-24	BJK	ETF	30.78	31.2	30.78	31.14	8300.0
2010-11-24	BKF	ETF	47.84	48.41	47.77	48.3	167131.0
2010-11-24	BLV	ETF	81.36	81.37	80.53	80.62	62400.0
2010-11-24	BMVP	ETF	14.22	14.32	14.22	14.31	9703.0
2010-11-24	BND	ETF	81.86	81.9	81.6	81.63	539400.0
2010-11-24	BNO	ETF	28.285	28.295	28.285	28.295	6000.0
2010-11-24	BRF	ETF	58.6	59.59	58.5601	59.59	416060.0
2010-11-24	BSCE	ETF	20.93	20.93	20.838	20.838	2898.0
2010-11-24	BSV	ETF	81.46	81.48	81.3	81.35	411800.0
2010-11-24	BTF	ETF	78.05	78.64999999999999	77.89999999999999	78.39999999999999	3198.2000000000003
2010-11-24	BWX	ETF	29.215	29.475	29.0	29.235	461138.0
2010-11-24	BWZ	ETF	36.6778	36.79	36.55	36.55	12767.0
2010-11-24	BZQ	ETF	2763.2	2763.2	2688.0	2707.2	713.0
2010-11-24	CEF	ETF	19.01	19.1	18.88	19.06	902600.0
2010-11-24	CEW	ETF	22.82	22.9	22.82	22.86	126534.0
2010-11-24	CGO	ETF	14.65	14.92	14.55	14.61	34398.0

> showing 50 of 801 rows — these rows as CSV

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