PREVIEW / etf_daily / 2012-02-27

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-27.parquet
  size:    38 KB
  rows:    928

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-02-27	SPY	ETF	136.02	137.53	135.8	137.16	145728900.0
2012-02-27	QQQ	ETF	63.6	64.26	63.33	64.05	42678420.0
2012-02-27	IWM	ETF	81.84	82.95	81.25	82.5	51807700.0
2012-02-27	DIA	ETF	128.93	130.04	128.57	129.66	5778600.0
2012-02-27	GLD	ETF	172.14	172.92	171.58	171.7	7340900.0
2012-02-27	TLT	ETF	118.5	118.85	118.12	118.54	8180700.0
2012-02-27	AADR	ETF	30.39	30.45	30.39	30.45	800.0
2012-02-27	AAXJ	ETF	56.85	57.22	56.63	57.0	348800.0
2012-02-27	ACTV	ETF	15.92	16.03	15.52	15.86	621216.0
2012-02-27	ACWI	ETF	46.27	46.65	46.09	46.52	725800.0
2012-02-27	ACWV	ETF	53.36	53.36	53.36	53.36	100.0
2012-02-27	ACWX	ETF	40.77	41.12	40.59	41.03	172653.0
2012-02-27	ADRE	ETF	43.22	43.57	43.16	43.44	111096.0
2012-02-27	AFK	ETF	30.05	30.2	29.95	30.16	38539.0
2012-02-27	AGEM	ETF	23.74	23.74	23.74	23.74	112.0
2012-02-27	AGG	ETF	110.83	110.95	110.76	110.95	712000.0
2012-02-27	AGQ	ETF	265.68	270.08	263.2	266.16	587250.0
2012-02-27	AGZ	ETF	112.98	112.99	112.5903	112.79	305265.0
2012-02-27	AIA	ETF	44.35	44.68	44.34	44.66	11535.0
2012-02-27	AIQ	ETF	7.35	7.403	7.25	7.3	6310.0
2012-02-27	AIS	ETF	2.72	2.72	2.62	2.63	505939.0
2012-02-27	AIVI	ETF	42.06	42.48	41.97	42.41	41700.0
2012-02-27	AMJ	ETF	41.3	41.33	40.99	41.17	951768.0
2012-02-27	AMLP	ETF	85.75	85.95	85.65	85.8	489400.0
2012-02-27	AOA	ETF	35.83	36.13	35.73	36.07	12300.0
2012-02-27	AOK	ETF	30.13	30.19	30.077	30.1719	36831.0
2012-02-27	AOM	ETF	31.09	31.21	31.0799	31.2	22454.0
2012-02-27	AOR	ETF	32.95	33.15	32.95	33.09	8089.0
2012-02-27	ARB	ETF	34.72	34.72	33.9	34.06	457091.0
2012-02-27	ARGT	ETF	23.12	23.12	23.02	23.02	1750.0
2012-02-27	ASEA	ETF	15.77	15.86	15.72	15.85	4000.0
2012-02-27	AWAY	ETF	23.98	25.57	23.84	25.5	1310498.0
2012-02-27	BAB	ETF	29.55	29.55	29.42	29.52	160399.0
2012-02-27	BAL	ETF	55.0199	55.61	54.66	55.53	12829.0
2012-02-27	BALT	ETF	4.48	4.68	4.41	4.67	246221.0
2012-02-27	BBH	ETF	42.2	42.55	41.93	42.34	88000.0
2012-02-27	BCM	ETF	47.154	47.17	47.028	47.028	1753.0
2012-02-27	BIB	ETF	11.055	11.3262	11.0062	11.2725	51696.0
2012-02-27	BICK	ETF	27.37	27.42	27.11	27.33	20967.0
2012-02-27	BIL	ETF	91.66	91.66	91.64	91.64	956000.0
2012-02-27	BIS	ETF	3950.4	3964.8	3932.8	3932.8	12.1
2012-02-27	BITS	ETF	21.0	21.2	20.64	20.96	786.0
2012-02-27	BIV	ETF	88.06	88.19	88.02	88.13	224500.0
2012-02-27	BJK	ETF	33.94	34.07	33.87	34.02	9900.0
2012-02-27	BKF	ETF	43.27	43.56	43.09	43.49	98568.0
2012-02-27	BKLN	ETF	24.45	24.51	24.42	24.48	170300.0
2012-02-27	BLV	ETF	92.09	92.4	91.94	92.29	35800.0
2012-02-27	BMVP	ETF	15.23	15.35	15.16	15.32	10790.0
2012-02-27	BND	ETF	84.02	84.02	83.94	83.99	970300.0
2012-02-27	BNO	ETF	43.34	43.465	42.94	43.055	165200.0

> showing 50 of 928 rows — these rows as CSV

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