PREVIEW / etf_daily / 2011-01-31

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-31.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-01-31	SPY	ETF	128.07	128.78	127.75	128.68	149249200.0
2011-01-31	QQQ	ETF	55.81	56.16	55.39	56.0	70570591.0
2011-01-31	IWM	ETF	77.87	78.5	77.25	77.95	53265200.0
2011-01-31	DIA	ETF	118.25	118.65	117.88	118.6	8965000.0
2011-01-31	GLD	ETF	129.27	130.51	129.25	129.87	14664100.0
2011-01-31	TLT	ETF	91.66	91.98	91.05	91.22	8647600.0
2011-01-31	AADR	ETF	29.84	29.86	29.84	29.84	700.0
2011-01-31	AAXJ	ETF	61.38	61.71	61.26	61.54	1491400.0
2011-01-31	ACWI	ETF	47.02	47.37	47.02	47.31	471200.0
2011-01-31	ACWX	ETF	44.23	44.47	44.18	44.28	455315.0
2011-01-31	ADRE	ETF	46.01	46.4699	45.8	46.37	619593.0
2011-01-31	AFK	ETF	32.38	32.4999	32.0	32.31	105131.0
2011-01-31	AGG	ETF	105.85	105.94	105.59	105.66	1691500.0
2011-01-31	AGQ	ETF	253.2	264.94	252.98	257.52	528350.0
2011-01-31	AGZ	ETF	109.94	109.959	109.764	109.95	10168.0
2011-01-31	AIA	ETF	47.66	47.69	47.38	47.46	172251.0
2011-01-31	AIQ	ETF	20.9	21.0	20.3	20.95	20420.0
2011-01-31	AIS	ETF	1.66	1.66	1.55	1.55	406255.0
2011-01-31	AIVI	ETF	45.57	45.79	45.57	45.79	12000.0
2011-01-31	AMJ	ETF	37.8	37.8	37.1701	37.39	2181364.0
2011-01-31	AMLP	ETF	81.2	81.5	81.15	81.5	113100.0
2011-01-31	AOA	ETF	34.69	34.78	34.55	34.71	6100.0
2011-01-31	AOK	ETF	28.91	28.9201	28.91	28.9201	5000.0
2011-01-31	AOM	ETF	30.07	30.17	30.07	30.15	14225.0
2011-01-31	AOR	ETF	31.76	31.894	31.72	31.86	30046.0
2011-01-31	ARB	ETF	40.57	41.94	40.08	41.69	203421.0
2011-01-31	BAB	ETF	25.11	25.11	24.86	24.86	259906.0
2011-01-31	BAL	ETF	85.5	86.29	85.25	86.16	61212.0
2011-01-31	BALT	ETF	8.55	8.69	8.25	8.29	382689.0
2011-01-31	BBH	ETF	33.6633	33.9033	33.34	33.8033	130200.0
2011-01-31	BIB	ETF	7.4337	7.5129	7.4337	7.5129	3600.0
2011-01-31	BICK	ETF	31.46	31.69	31.25	31.66	17063.0
2011-01-31	BIL	ETF	91.7	91.72	91.7	91.7	87250.0
2011-01-31	BITS	ETF	28.36	28.36	27.64	28.16	450.0
2011-01-31	BIV	ETF	83.26	83.31	82.95	83.0	97800.0
2011-01-31	BJK	ETF	32.0	32.34	32.0	32.13	19200.0
2011-01-31	BKF	ETF	47.16	47.6099	47.03	47.25	235563.0
2011-01-31	BLV	ETF	78.12	78.34	77.82	78.02	14900.0
2011-01-31	BMVP	ETF	14.92	15.01	14.87	14.97	8356.0
2011-01-31	BND	ETF	80.42	80.46	80.26	80.34	1061200.0
2011-01-31	BNO	ETF	33.05	33.865	32.995	33.505	22600.0
2011-01-31	BRF	ETF	52.27	52.43	51.921	52.16	567481.0
2011-01-31	BSCE	ETF	20.99	20.99	20.8	20.95	41892.0
2011-01-31	BSV	ETF	80.75	80.8	80.71	80.75	397900.0
2011-01-31	BTF	ETF	80.0	80.25	79.55	79.74999999999999	12088.400000000001
2011-01-31	BWX	ETF	29.305	29.495	29.305	29.47	419998.0
2011-01-31	BWZ	ETF	37.94	37.961	37.51	37.7	18331.0
2011-01-31	BZQ	ETF	2678.4	2696.0	2632.0	2664.0	1312.0
2011-01-31	CEF	ETF	18.82	19.08	18.77	18.94	1008800.0
2011-01-31	CEW	ETF	22.19	22.2599	22.19	22.22	180858.0

> showing 50 of 825 rows — these rows as CSV

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