PREVIEW / etf_daily / 2011-10-05

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-05.parquet
  size:    37 KB
  rows:    874

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-10-05	SPY	ETF	112.62	114.72	111.58	114.42	284108000.0
2011-10-05	QQQ	ETF	52.07	53.6787	51.66	53.53	108825698.0
2011-10-05	IWM	ETF	64.78	66.13	63.92	65.68	100371000.0
2011-10-05	DIA	ETF	107.85	109.41	107.26	109.28	9967000.0
2011-10-05	GLD	ETF	158.01	160.32	156.44	159.46	15132300.0
2011-10-05	TLT	ETF	121.66	121.78	120.66	121.36	14275000.0
2011-10-05	AADR	ETF	25.9	25.9	25.9	25.9	100.0
2011-10-05	AAXJ	ETF	45.94	47.18	45.5	47.02	508000.0
2011-10-05	ACTV	ETF	15.82	16.38	15.49	15.68	83264.0
2011-10-05	ACWI	ETF	38.84	39.58	38.44	39.52	935000.0
2011-10-05	ACWX	ETF	34.44	35.228	34.23	35.2	215894.0
2011-10-05	ADRE	ETF	35.58	36.21	35.291	36.21	74645.0
2011-10-05	AFK	ETF	25.802	26.09	25.73	26.09	41000.0
2011-10-05	AGEM	ETF	19.24	19.8	19.24	19.78	3289.0
2011-10-05	AGG	ETF	109.9	109.93	109.6	109.63	1499100.0
2011-10-05	AGQ	ETF	206.32	219.44	200.84	216.96	695950.0
2011-10-05	AGZ	ETF	112.7682	112.79	112.65	112.78	6221.0
2011-10-05	AIA	ETF	36.02	37.0	35.82	36.97	81121.0
2011-10-05	AIQ	ETF	5.75	6.0	5.6	6.0	55909.0
2011-10-05	AIS	ETF	2.3	2.31	2.23	2.28	582154.0
2011-10-05	AIVI	ETF	37.98	38.74	37.64	38.72	53900.0
2011-10-05	AMJ	ETF	33.65	33.94	32.52	33.62	2329060.0
2011-10-05	AMLP	ETF	74.6	76.35	73.7	76.05	249800.0
2011-10-05	AOA	ETF	30.18	30.59	29.89	30.55	5300.0
2011-10-05	AOK	ETF	28.5	28.63	28.49	28.63	34103.0
2011-10-05	AOM	ETF	28.77	28.934	28.705	28.91	11342.0
2011-10-05	AOR	ETF	29.32	29.5	29.27	29.49	9892.0
2011-10-05	ARB	ETF	36.21	36.61	35.45	36.49	330101.0
2011-10-05	ARGT	ETF	19.82	19.86	19.82	19.86	600.0
2011-10-05	ASEA	ETF	13.45	13.7	13.4	13.7	9200.0
2011-10-05	AWAY	ETF	33.65	35.295	32.08	34.92	180980.0
2011-10-05	BAB	ETF	28.93	29.05	28.8	29.05	158290.0
2011-10-05	BAL	ETF	63.1219	63.7	62.74	63.5	28404.0
2011-10-05	BALT	ETF	4.9	4.93	4.7	4.85	106026.0
2011-10-05	BBH	ETF	32.0267	33.1567	31.9133	33.13	39000.0
2011-10-05	BCM	ETF	41.0065	41.19	41.0065	41.19	630.0
2011-10-05	BIB	ETF	6.6437	7.0775	6.6437	7.0775	32488.0
2011-10-05	BICK	ETF	21.38	21.611	21.3241	21.5792	4991.0
2011-10-05	BIL	ETF	91.7	91.7	91.68	91.7	689300.0
2011-10-05	BIS	ETF	6985.6	7006.4	6793.6	6857.6	14.4
2011-10-05	BITS	ETF	22.32	22.32	21.68	21.792	319.0
2011-10-05	BIV	ETF	87.3	87.32	87.05	87.24	288600.0
2011-10-05	BJK	ETF	27.1	27.53	26.76	27.45	9700.0
2011-10-05	BKF	ETF	33.07	33.9393	32.78	33.9	137346.0
2011-10-05	BKLN	ETF	22.55	22.79	22.55	22.79	63800.0
2011-10-05	BLV	ETF	91.94	91.94	91.26	91.67	76700.0
2011-10-05	BMVP	ETF	12.06	12.38	11.99	12.38	46230.0
2011-10-05	BND	ETF	83.58	83.6	83.27	83.31	3989600.0
2011-10-05	BNO	ETF	34.225	34.695	34.0	34.665	212200.0
2011-10-05	BRF	ETF	38.66	39.5	38.1544	39.45	274617.0

> showing 50 of 874 rows — these rows as CSV

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