PREVIEW / etf_daily / 2011-07-05

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-05.parquet
  size:    36 KB
  rows:    865

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-07-05	SPY	ETF	133.78	134.08	133.39	133.81	165936000.0
2011-07-05	QQQ	ETF	57.95	58.26	57.83	58.2	43128655.0
2011-07-05	IWM	ETF	83.93	84.14	83.53	84.04	48268900.0
2011-07-05	DIA	ETF	125.54	125.81	125.16	125.49	5324300.0
2011-07-05	GLD	ETF	146.96	147.82	146.85	147.63	11278200.0
2011-07-05	TLT	ETF	94.04	94.17	93.69	93.84	4615600.0
2011-07-05	AADR	ETF	31.71	31.82	31.67	31.82	900.0
2011-07-05	AAXJ	ETF	62.86	62.98	62.54	62.68	773800.0
2011-07-05	ACTV	ETF	18.34	19.25	18.15	18.42	475329.0
2011-07-05	ACWI	ETF	48.85	48.92	48.6	48.75	462000.0
2011-07-05	ACWX	ETF	45.35	45.427	45.1048	45.27	227631.0
2011-07-05	ADRE	ETF	47.07	47.15	46.81	46.96	147837.0
2011-07-05	AFK	ETF	32.48	32.76	32.47	32.52	22699.0
2011-07-05	AGEM	ETF	26.64	26.84	26.64	26.7996	2043.0
2011-07-05	AGG	ETF	106.57	106.82	106.57	106.81	799200.0
2011-07-05	AGQ	ETF	333.5	347.38	331.74	344.46	756350.0
2011-07-05	AGZ	ETF	110.45	110.51	110.4	110.41	4956.0
2011-07-05	AIA	ETF	47.48	47.48	47.2	47.37	23781.0
2011-07-05	AIQ	ETF	18.85	18.85	18.15	18.15	21319.0
2011-07-05	AIS	ETF	2.31	2.31	2.21	2.27	1209624.0
2011-07-05	AIVI	ETF	47.09	47.32	46.92	46.96	31100.0
2011-07-05	AMJ	ETF	37.33	37.6	37.25	37.35	600218.0
2011-07-05	AMLP	ETF	80.6	80.6	80.3	80.5	104400.0
2011-07-05	AOA	ETF	36.29	36.36	36.2	36.3	8500.0
2011-07-05	AOK	ETF	29.43	29.43	29.3507	29.3808	13841.0
2011-07-05	AOM	ETF	30.77	30.7701	30.73	30.77	5408.0
2011-07-05	AOR	ETF	32.88	32.89	32.81	32.86	7999.0
2011-07-05	ARB	ETF	41.32	41.46	40.97	41.3	107521.0
2011-07-05	ARGT	ETF	30.34	30.34	30.28	30.28	550.0
2011-07-05	ASEA	ETF	16.74	16.87	16.72	16.84	8500.0
2011-07-05	AWAY	ETF	38.94	38.95	37.18	37.63	277672.0
2011-07-05	BAB	ETF	26.11	26.16	26.0	26.02	143340.0
2011-07-05	BAL	ETF	73.65	73.78	71.47	71.91	68132.0
2011-07-05	BALT	ETF	5.76	5.79	5.42	5.55	183965.0
2011-07-05	BBH	ETF	35.9133	35.9133	35.71	35.8167	18600.0
2011-07-05	BIB	ETF	10.0	10.1212	9.7749	9.8825	1075088.0
2011-07-05	BICK	ETF	32.37	32.65	32.37	32.58	15689.0
2011-07-05	BIL	ETF	91.72	91.72	91.7	91.7	786700.0
2011-07-05	BIS	ETF	5921.6	5921.6	5827.2	5845.76	47.5
2011-07-05	BITS	ETF	21.3968	21.48	21.3968	21.48	974.0
2011-07-05	BIV	ETF	83.87	84.13	83.77	84.03	571700.0
2011-07-05	BJK	ETF	35.36	35.53	35.28	35.45	32900.0
2011-07-05	BKF	ETF	48.42	48.55	48.1098	48.18	265102.0
2011-07-05	BKLN	ETF	24.93	24.93	24.87	24.92	96700.0
2011-07-05	BLNG	ETF	47.734	47.734	47.734	47.734	240.0
2011-07-05	BLV	ETF	79.78	79.98	79.67	79.8	111100.0
2011-07-05	BMVP	ETF	15.95	16.0	15.92	15.97	5108.0
2011-07-05	BND	ETF	81.1	81.27	81.1	81.25	739900.0
2011-07-05	BNO	ETF	37.54	38.1	37.435	37.825	41600.0
2011-07-05	BOSS	ETF	67.8	70.27	67.8	70.27	100.0

> showing 50 of 865 rows — these rows as CSV

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