PREVIEW / etf_daily / 2011-08-10

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-10.parquet
  size:    37 KB
  rows:    875

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-08-10	SPY	ETF	115.26	116.28	111.95	112.29	662607400.0
2011-08-10	QQQ	ETF	51.82	53.0438	50.8	50.86	205917880.0
2011-08-10	IWM	ETF	67.35	69.57	65.87	66.06	182376400.0
2011-08-10	DIA	ETF	110.22	110.67	106.87	107.17	27711600.0
2011-08-10	GLD	ETF	172.46	175.13	171.62	174.58	44797200.0
2011-08-10	TLT	ETF	107.63	109.07	106.94	109.02	46221000.0
2011-08-10	AADR	ETF	27.41	27.41	27.41	27.41	200.0
2011-08-10	AAXJ	ETF	54.27	54.47	52.9	52.96	660100.0
2011-08-10	ACTV	ETF	15.19	15.19	13.02	13.31	280641.0
2011-08-10	ACWI	ETF	41.46	41.73	40.46	40.51	821100.0
2011-08-10	ACWX	ETF	38.27	38.35	37.26	37.3	729002.0
2011-08-10	ADRE	ETF	39.13	39.81	38.44	38.71	155070.0
2011-08-10	AFK	ETF	27.79	28.1027	27.38	27.574	21464.0
2011-08-10	AGEM	ETF	22.05	22.07	21.29	21.8899	81301.0
2011-08-10	AGG	ETF	109.75	110.17	109.64	110.13	1102400.0
2011-08-10	AGQ	ETF	391.26	414.22	386.66	412.34	779900.0
2011-08-10	AGZ	ETF	112.1	112.63	112.06	112.57	11501.0
2011-08-10	AIA	ETF	39.71	39.71	38.78	38.81	57496.0
2011-08-10	AIQ	ETF	6.45	6.45	5.0	5.5	303010.0
2011-08-10	AIS	ETF	1.95	2.04	1.91	1.91	1014018.0
2011-08-10	AIVI	ETF	40.09	40.09	38.79	38.83	584800.0
2011-08-10	AMJ	ETF	34.95	36.36	34.0	35.31	7114513.0
2011-08-10	AMLP	ETF	75.85	78.5	74.5	77.1	260320.0
2011-08-10	AOA	ETF	31.24	31.53	30.61	30.61	45900.0
2011-08-10	AOK	ETF	28.89	28.895	28.77	28.8	17133.0
2011-08-10	AOM	ETF	29.39	29.43	29.19	29.19	31808.0
2011-08-10	AOR	ETF	29.96	30.235	29.75	29.75	17319.0
2011-08-10	ARB	ETF	34.05	34.35	32.32	32.47	171097.0
2011-08-10	ARGT	ETF	25.0	25.28	25.0	25.28	900.0
2011-08-10	ASEA	ETF	15.77	15.78	15.39	15.5	19100.0
2011-08-10	AWAY	ETF	34.14	37.36	33.38	35.88	278164.0
2011-08-10	BAB	ETF	26.84	27.2	26.83	27.2	366107.0
2011-08-10	BAL	ETF	59.82	61.42	59.21	60.86	92051.0
2011-08-10	BALT	ETF	4.26	4.26	3.93	4.06	287652.0
2011-08-10	BBH	ETF	30.2633	30.4167	29.3367	29.3933	47100.0
2011-08-10	BCM	ETF	45.64	45.64	45.64	45.64	3200.0
2011-08-10	BIB	ETF	6.4188	6.4212	5.9962	6.025	190416.0
2011-08-10	BICK	ETF	26.01	26.36	25.55	25.73	18782.0
2011-08-10	BIL	ETF	91.7	91.72	91.68	91.72	374150.0
2011-08-10	BIS	ETF	8212.8	8694.4	8212.8	8694.4	4.375
2011-08-10	BITS	ETF	20.0	20.4	19.64	20.08	1405.0
2011-08-10	BIV	ETF	87.89	88.27	87.68	88.1	156200.0
2011-08-10	BJK	ETF	30.95	31.57	30.61	30.87	53700.0
2011-08-10	BKF	ETF	39.48	39.85	38.51	38.56	459931.0
2011-08-10	BKLN	ETF	22.53	23.32	22.53	23.18	55700.0
2011-08-10	BLV	ETF	88.24	88.9	87.3	88.67	58300.0
2011-08-10	BMVP	ETF	12.79	12.89	12.51	12.51	18900.0
2011-08-10	BND	ETF	83.76	84.04	83.58	84.01	2467300.0
2011-08-10	BNO	ETF	35.07	35.695	34.6	35.315	329000.0
2011-08-10	BOSS	ETF	63.0	68.4	63.0	64.1	300.0

> showing 50 of 875 rows — these rows as CSV

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