PREVIEW / etf_daily / 2012-01-05

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-05.parquet
  size:    37 KB
  rows:    894

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
2012-01-05	SPY	ETF	127.01	128.23	126.43	128.04	173895000.0
2012-01-05	QQQ	ETF	57.02	57.66	56.8	57.61	41260529.0
2012-01-05	IWM	ETF	74.03	75.34	73.37	74.98	57274600.0
2012-01-05	DIA	ETF	123.46	124.11	122.59	123.95	8678900.0
2012-01-05	GLD	ETF	155.37	158.03	155.25	157.78	11621600.0
2012-01-05	TLT	ETF	118.17	119.1	117.57	117.8	6465800.0
2012-01-05	AADR	ETF	27.91	28.24	27.91	28.2	19000.0
2012-01-05	AAXJ	ETF	50.53	50.97	50.4	50.87	341700.0
2012-01-05	ACTV	ETF	13.01	13.42	13.0	13.25	166685.0
2012-01-05	ACWI	ETF	42.54	42.89	42.33	42.8	267200.0
2012-01-05	ACWV	ETF	51.34	51.34	51.34	51.34	200.0
2012-01-05	ACWX	ETF	37.0	37.1948	36.81	37.06	296672.0
2012-01-05	ADRE	ETF	39.27	39.5	39.07	39.37	15556.0
2012-01-05	AFK	ETF	26.12	26.22	25.7	26.13	30120.0
2012-01-05	AGEM	ETF	21.05	21.267	21.05	21.154	2755.0
2012-01-05	AGG	ETF	109.91	110.05	109.85	110.03	856500.0
2012-01-05	AGQ	ETF	180.0	188.48	179.24	186.4	319475.0
2012-01-05	AGZ	ETF	112.94	112.97	112.52	112.53	12972.0
2012-01-05	AIA	ETF	39.8113	40.09	39.62	39.961	11135.0
2012-01-05	AIQ	ETF	5.7	5.7	5.6	5.65	8431.0
2012-01-05	AIS	ETF	2.03	2.13	2.0	2.13	594718.0
2012-01-05	AIVI	ETF	39.56	39.66	39.34	39.6	77800.0
2012-01-05	AMJ	ETF	39.32	39.7	39.2576	39.68	581516.0
2012-01-05	AMLP	ETF	83.8	84.0	83.65	84.0	415340.0
2012-01-05	AOA	ETF	33.27	33.53	33.1	33.45	3700.0
2012-01-05	AOK	ETF	29.37	29.43	29.34	29.37	32259.0
2012-01-05	AOM	ETF	29.97	30.04	29.905	30.0	14229.0
2012-01-05	AOR	ETF	31.21	31.4196	31.191	31.41	8422.0
2012-01-05	ARB	ETF	36.01	36.63	35.35	36.52	226946.0
2012-01-05	ASEA	ETF	14.69	14.79	14.58	14.65	2700.0
2012-01-05	AWAY	ETF	23.85	24.32	23.78	23.99	195953.0
2012-01-05	BAB	ETF	28.41	28.45	28.33	28.41	136212.0
2012-01-05	BAL	ETF	58.88	59.06	58.5	58.53	12685.0
2012-01-05	BALT	ETF	4.52	4.52	4.45	4.47	86662.0
2012-01-05	BBH	ETF	36.8767	37.6767	36.8467	37.5167	21300.0
2012-01-05	BCM	ETF	43.97	44.09	43.85	43.85	15435.0
2012-01-05	BIB	ETF	9.0	9.07	9.0	9.0218	8920.0
2012-01-05	BICK	ETF	23.17	23.469	23.1449	23.46	6480.0
2012-01-05	BIL	ETF	91.64	91.66	91.64	91.64	489350.0
2012-01-05	BITS	ETF	23.0	23.0	22.76	22.8	4610.0
2012-01-05	BIV	ETF	86.73	86.88	86.65	86.75	214200.0
2012-01-05	BJK	ETF	30.4	30.51	30.23	30.41	6700.0
2012-01-05	BKF	ETF	37.27	37.49	37.0	37.37	96270.0
2012-01-05	BKLN	ETF	23.99	24.06	23.98	24.06	90500.0
2012-01-05	BLV	ETF	90.69	91.13	90.46	90.51	34600.0
2012-01-05	BMVP	ETF	13.6833	13.8565	13.6367	13.8533	5427.0
2012-01-05	BND	ETF	83.3	83.41	83.22	83.29	1194800.0
2012-01-05	BNO	ETF	39.3	39.705	39.075	39.125	790400.0
2012-01-05	BOIL	ETF	2095000.0	2118000.0	1990000.0	2023000.0	0.4
2012-01-05	BRF	ETF	37.39	37.51	36.94	37.13	167882.0

> showing 50 of 894 rows — these rows as CSV

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