PREVIEW / etf_daily / 2012-01-09

all etf daily files

  file:    by_date/etf_daily/2012/2012-01-09.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-09	SPY	ETF	128.0	128.18	127.41	128.02	99530200.0
2012-01-09	QQQ	ETF	57.95	57.98	57.431	57.62	39195455.0
2012-01-09	IWM	ETF	75.14	75.3	74.41	75.17	52042400.0
2012-01-09	DIA	ETF	123.69	123.91	123.14	123.66	5881800.0
2012-01-09	GLD	ETF	157.36	157.59	156.19	156.5	8771900.0
2012-01-09	TLT	ETF	118.47	119.54	118.3	118.52	5582400.0
2012-01-09	AADR	ETF	28.06	28.06	28.04	28.04	700.0
2012-01-09	AAXJ	ETF	50.56	50.82	50.51	50.62	240900.0
2012-01-09	ACTV	ETF	13.33	13.52	13.3	13.35	327861.0
2012-01-09	ACWI	ETF	42.58	42.64	42.37	42.62	858800.0
2012-01-09	ACWX	ETF	36.76	36.91	36.54	36.9	633060.0
2012-01-09	ADRE	ETF	39.28	39.482	39.202	39.46	18211.0
2012-01-09	AFK	ETF	25.87	25.99	25.84	25.87	5208.0
2012-01-09	AGEM	ETF	21.27	21.27	21.27	21.27	1583.0
2012-01-09	AGG	ETF	110.13	110.32	110.0	110.03	976200.0
2012-01-09	AGQ	ETF	184.16	185.32	179.76	181.72	292750.0
2012-01-09	AGZ	ETF	112.65	112.85	112.65	112.85	14802.0
2012-01-09	AIA	ETF	39.65	39.73	39.49	39.72	42767.0
2012-01-09	AIQ	ETF	5.7	5.7	5.6	5.7	6670.0
2012-01-09	AIS	ETF	2.05	2.15	2.05	2.14	724366.0
2012-01-09	AIVI	ETF	39.28	39.28	38.9	39.21	36500.0
2012-01-09	AMJ	ETF	39.54	39.67	38.87	39.06	1613141.0
2012-01-09	AMLP	ETF	83.55	83.75	82.75	83.1	505640.0
2012-01-09	AOA	ETF	33.49	33.5	33.29	33.5	17500.0
2012-01-09	AOK	ETF	29.45	29.45	29.39	29.4	32905.0
2012-01-09	AOM	ETF	30.02	30.0296	29.9681	29.99	10888.0
2012-01-09	AOR	ETF	31.41	31.41	31.315	31.37	28077.0
2012-01-09	ARB	ETF	35.78	35.87	35.0	35.11	165042.0
2012-01-09	ARGT	ETF	21.98	22.16	21.98	22.16	350.0
2012-01-09	ASEA	ETF	14.63	14.63	14.5	14.5	12700.0
2012-01-09	AWAY	ETF	24.3	24.5	22.73	23.48	316529.0
2012-01-09	BAB	ETF	28.5	28.72	28.5	28.6	172329.0
2012-01-09	BAL	ETF	59.47	59.99	57.77	59.77	65309.0
2012-01-09	BALT	ETF	4.37	4.42	4.31	4.33	56599.0
2012-01-09	BBH	ETF	38.36	38.41	38.1367	38.2767	71400.0
2012-01-09	BCM	ETF	44.02	44.16	44.01	44.0299	13125.0
2012-01-09	BIB	ETF	9.4738	9.4738	9.3001	9.395	107112.0
2012-01-09	BICK	ETF	23.4	23.461	23.28	23.461	2742.0
2012-01-09	BIL	ETF	91.66	91.66	91.64	91.66	490300.0
2012-01-09	BIS	ETF	4897.6	4897.6	4833.6	4846.4	19.15
2012-01-09	BITS	ETF	22.76	22.8	22.36	22.72	1457.0
2012-01-09	BIV	ETF	87.0	87.14	86.91	87.03	340600.0
2012-01-09	BJK	ETF	30.15	30.15	29.92	30.12	12500.0
2012-01-09	BKF	ETF	37.39	37.5	37.234	37.45	257895.0
2012-01-09	BKLN	ETF	24.09	24.16	24.05	24.13	251700.0
2012-01-09	BLV	ETF	91.05	91.57	90.85	90.97	64600.0
2012-01-09	BMVP	ETF	13.85	13.85	13.77	13.81	4297.0
2012-01-09	BND	ETF	83.34	83.55	83.34	83.41	833800.0
2012-01-09	BNO	ETF	39.395	39.41	38.915	39.045	74800.0
2012-01-09	BRF	ETF	37.14	37.82	37.14	37.69	749263.0

> showing 50 of 894 rows — these rows as CSV

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