PREVIEW / etf_daily / 2011-09-19

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-19.parquet
  size:    36 KB
  rows:    867

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-09-19	SPY	ETF	119.53	120.93	118.72	120.31	241517000.0
2011-09-19	QQQ	ETF	55.9	56.91	55.43	56.61	73042834.0
2011-09-19	IWM	ETF	70.1	71.01	69.45	70.24	69216200.0
2011-09-19	DIA	ETF	113.1	114.22	112.29	113.72	9727400.0
2011-09-19	GLD	ETF	176.83	176.86	172.2	173.31	18301100.0
2011-09-19	TLT	ETF	114.2	115.19	114.12	114.38	13033500.0
2011-09-19	AADR	ETF	27.68	27.83	27.47	27.83	2000.0
2011-09-19	AAXJ	ETF	51.91	52.28	51.51	52.07	167300.0
2011-09-19	ACTV	ETF	15.72	15.91	15.4	15.76	71169.0
2011-09-19	ACWI	ETF	41.38	42.0	41.21	41.8	362900.0
2011-09-19	ACWX	ETF	36.93	37.1792	36.652	36.98	141570.0
2011-09-19	ADRE	ETF	39.21	39.5929	39.04	39.47	43449.0
2011-09-19	AFK	ETF	28.29	28.49	28.1774	28.481	5496.0
2011-09-19	AGEM	ETF	21.81	21.86	21.67	21.86	3719.0
2011-09-19	AGG	ETF	110.18	110.25	110.05	110.08	786500.0
2011-09-19	AGQ	ETF	419.46	421.86	392.68	409.0	500600.0
2011-09-19	AGZ	ETF	112.9	113.07	112.48	112.88	4466.0
2011-09-19	AIA	ETF	40.0	40.0	39.45	39.8271	24195.0
2011-09-19	AIQ	ETF	6.55	6.8	6.4	6.4	12137.0
2011-09-19	AIS	ETF	2.31	2.4	2.28	2.35	524601.0
2011-09-19	AIVI	ETF	39.31	39.72	39.0	39.55	78800.0
2011-09-19	AMJ	ETF	34.46	35.68	34.44	35.66	4353278.0
2011-09-19	AMLP	ETF	76.65	78.05	76.35	78.05	110040.0
2011-09-19	AOA	ETF	31.98	32.29	31.88	32.29	30700.0
2011-09-19	AOK	ETF	29.0	29.09	28.99	29.08	52762.0
2011-09-19	AOM	ETF	29.58	29.72	29.5401	29.66	47833.0
2011-09-19	AOR	ETF	30.45	30.6805	30.37	30.65	27888.0
2011-09-19	ARB	ETF	35.31	36.33	34.88	35.91	246251.0
2011-09-19	ASEA	ETF	14.72	14.87	14.62	14.86	17700.0
2011-09-19	AWAY	ETF	41.44	42.94	41.0	41.315	64718.0
2011-09-19	BAB	ETF	28.33	28.489	28.24	28.41	118682.0
2011-09-19	BAL	ETF	66.34	66.59	64.881	65.21	101259.0
2011-09-19	BALT	ETF	5.17	5.25	4.81	5.03	106670.0
2011-09-19	BBH	ETF	33.81	33.9033	33.1667	33.69	43200.0
2011-09-19	BCM	ETF	46.3	46.33	45.85	45.86	8360.0
2011-09-19	BIB	ETF	7.5375	7.7713	7.4813	7.7462	35840.0
2011-09-19	BICK	ETF	25.06	25.06	24.7473	25.0165	5111.0
2011-09-19	BIL	ETF	91.7	91.7	91.68	91.7	517100.0
2011-09-19	BIS	ETF	6644.8	6644.8	6344.32	6412.8	13.1
2011-09-19	BITS	ETF	19.92	22.52	19.92	20.88	4706.0
2011-09-19	BIV	ETF	88.26	88.38	88.02	88.04	99500.0
2011-09-19	BJK	ETF	31.39	32.41	31.37	32.3	107300.0
2011-09-19	BKF	ETF	38.22	38.52	37.9	38.36	200600.0
2011-09-19	BKLN	ETF	23.25	23.45	23.25	23.4	31100.0
2011-09-19	BLNG	ETF	56.78	56.78	55.66	55.76	5900.0
2011-09-19	BLV	ETF	89.71	90.14	89.59	89.71	27000.0
2011-09-19	BMVP	ETF	13.17	13.46	13.17	13.39	3147.0
2011-09-19	BND	ETF	83.86	83.97	83.78	83.79	1104100.0
2011-09-19	BNO	ETF	36.975	37.06	36.65	36.815	226600.0
2011-09-19	BRF	ETF	45.47	45.52	44.54	45.32	129814.0

> showing 50 of 867 rows — these rows as CSV

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