PREVIEW / etf_daily / 2011-07-27

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-27.parquet
  size:    36 KB
  rows:    868

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-27	SPY	ETF	132.59	132.63	130.43	130.6	249020100.0
2011-07-27	QQQ	ETF	59.25	59.29	57.94	58.09	83969487.0
2011-07-27	IWM	ETF	81.89	81.91	79.85	79.97	97533300.0
2011-07-27	DIA	ETF	124.37	124.39	122.69	122.84	7558600.0
2011-07-27	GLD	ETF	158.47	158.64	156.69	157.19	18296600.0
2011-07-27	TLT	ETF	95.34	95.84	95.1	95.66	11224200.0
2011-07-27	AADR	ETF	31.04	31.3	31.04	31.09	1600.0
2011-07-27	AAXJ	ETF	62.88	62.88	62.02	62.16	359800.0
2011-07-27	ACTV	ETF	18.23	18.415	17.99	18.01	226362.0
2011-07-27	ACWI	ETF	48.3	48.3	47.39	47.49	173400.0
2011-07-27	ACWX	ETF	44.69	44.69	43.8299	43.93	90735.0
2011-07-27	ADRE	ETF	46.16	46.24	45.605	45.74	104899.0
2011-07-27	AFK	ETF	31.94	32.044	31.45	31.53	22241.0
2011-07-27	AGEM	ETF	26.0	26.01	25.687	25.687	3356.0
2011-07-27	AGG	ETF	107.34	107.51	107.25	107.31	662700.0
2011-07-27	AGQ	ETF	458.44	458.8	430.44	432.68	1085700.0
2011-07-27	AGZ	ETF	110.78	110.78	110.61	110.6712	15553.0
2011-07-27	AIA	ETF	47.26	47.26	46.48	46.6	40018.0
2011-07-27	AIQ	ETF	16.8	17.0	16.7	16.7	15763.0
2011-07-27	AIS	ETF	2.42	2.47	2.34	2.35	1132369.0
2011-07-27	AIVI	ETF	46.24	46.24	45.45	45.51	17700.0
2011-07-27	AMJ	ETF	36.9	36.9	36.0	36.12	3896011.0
2011-07-27	AMLP	ETF	79.25	79.65	78.75	79.0	180080.0
2011-07-27	AOA	ETF	35.83	35.83	35.27	35.31	16000.0
2011-07-27	AOK	ETF	29.5	29.5	29.33	29.33	31205.0
2011-07-27	AOM	ETF	30.7002	30.7002	30.54	30.54	11590.0
2011-07-27	AOR	ETF	32.65	32.65	32.29	32.29	22847.0
2011-07-27	ARB	ETF	41.82	41.82	40.71	40.72	196192.0
2011-07-27	ARGT	ETF	29.58	29.74	29.58	29.72	2550.0
2011-07-27	ASEA	ETF	17.44	17.5	17.27	17.33	14100.0
2011-07-27	AWAY	ETF	42.71	43.7	41.92	42.77	159232.0
2011-07-27	BAB	ETF	26.6	26.71	26.56	26.66	80346.0
2011-07-27	BAL	ETF	64.06	64.4	62.36	63.95	166540.0
2011-07-27	BALT	ETF	5.65	5.86	5.51	5.53	563059.0
2011-07-27	BBH	ETF	34.7867	34.88	34.4367	34.5133	28200.0
2011-07-27	BIB	ETF	9.3275	9.4	8.8912	8.96	317008.0
2011-07-27	BICK	ETF	31.59	31.59	31.145	31.1904	11883.0
2011-07-27	BIL	ETF	91.72	91.72	91.7	91.72	906050.0
2011-07-27	BIS	ETF	6080.0	6329.6	6080.0	6329.6	19.15
2011-07-27	BITS	ETF	21.76	21.84	21.2	21.56	1000.0
2011-07-27	BIV	ETF	84.84	85.13	84.69	84.88	184600.0
2011-07-27	BJK	ETF	36.89	37.05	36.34	36.34	10500.0
2011-07-27	BKF	ETF	47.07	47.07	46.32	46.43	329244.0
2011-07-27	BKLN	ETF	24.83	24.86	24.79	24.81	65000.0
2011-07-27	BLV	ETF	81.17	81.45	80.93	81.19	15400.0
2011-07-27	BMVP	ETF	15.28	15.3933	15.1825	15.1825	12363.0
2011-07-27	BND	ETF	81.66	81.79	81.57	81.6	846300.0
2011-07-27	BNO	ETF	39.515	39.515	39.225	39.285	48600.0
2011-07-27	BOSS	ETF	75.85	75.85	75.0	75.0	100.0
2011-07-27	BRF	ETF	53.77	53.97	52.48	52.92	272928.0

> showing 50 of 868 rows — these rows as CSV

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