PREVIEW / etf_daily / 2012-02-07

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-07.parquet
  size:    38 KB
  rows:    919

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-07	SPY	ETF	134.17	135.02	133.64	134.79	135528100.0
2012-02-07	QQQ	ETF	61.95	62.25	61.67	62.13	37935695.0
2012-02-07	IWM	ETF	82.61	82.99	82.08	82.63	41623400.0
2012-02-07	DIA	ETF	127.95	128.76	127.55	128.51	5739300.0
2012-02-07	GLD	ETF	167.38	170.09	167.15	169.7	11614300.0
2012-02-07	TLT	ETF	116.62	116.88	115.77	116.27	8794800.0
2012-02-07	AADR	ETF	29.95	29.95	29.95	29.95	300.0
2012-02-07	AAXJ	ETF	56.39	56.65	56.06	56.54	288800.0
2012-02-07	ACTV	ETF	15.15	15.21	15.1	15.2	66346.0
2012-02-07	ACWI	ETF	45.51	45.95	45.48	45.88	1040500.0
2012-02-07	ACWX	ETF	40.25	40.49	40.064	40.49	90777.0
2012-02-07	ADRE	ETF	43.65	43.805	43.28	43.79	47352.0
2012-02-07	AFK	ETF	28.9	28.9	28.65	28.87	24270.0
2012-02-07	AGEM	ETF	23.88	23.88	23.76	23.76	459.0
2012-02-07	AGG	ETF	110.46	110.57	110.34	110.53	966600.0
2012-02-07	AGQ	ETF	239.4	252.32	237.28	250.4	586825.0
2012-02-07	AGZ	ETF	112.85	112.93	112.58	112.85	85605.0
2012-02-07	AIA	ETF	43.47	43.7852	43.45	43.68	62004.0
2012-02-07	AIQ	ETF	6.7	6.8	6.45	6.65	28096.0
2012-02-07	AIS	ETF	2.78	2.8	2.71	2.74	1165133.0
2012-02-07	AIVI	ETF	41.49	41.83	41.3	41.76	110200.0
2012-02-07	AMJ	ETF	40.22	40.29	40.0	40.26	1115891.0
2012-02-07	AMLP	ETF	83.85	84.2	83.35	83.8	474380.0
2012-02-07	AOA	ETF	35.47	35.6	35.47	35.6	14400.0
2012-02-07	AOK	ETF	29.99	30.02	29.9599	29.96	19431.0
2012-02-07	AOM	ETF	30.89	30.949	30.83	30.94	16090.0
2012-02-07	AOR	ETF	32.7	32.79	32.598	32.79	25769.0
2012-02-07	ARB	ETF	34.05	34.25	33.84	33.93	196279.0
2012-02-07	ARGT	ETF	23.48	23.48	23.18	23.18	3400.0
2012-02-07	ASEA	ETF	15.91	15.99	15.87	15.99	27800.0
2012-02-07	AWAY	ETF	26.96	27.21	26.54	27.05	172071.0
2012-02-07	BAB	ETF	29.13	29.13	29.02	29.09	166598.0
2012-02-07	BAL	ETF	59.0	59.02	58.25	58.25	19038.0
2012-02-07	BALT	ETF	4.31	4.337	4.2	4.21	154899.0
2012-02-07	BBH	ETF	44.0	44.0	43.6833	43.8533	34500.0
2012-02-07	BCM	ETF	45.93	45.93	45.85	45.85	540.0
2012-02-07	BIB	ETF	11.875	11.875	11.5325	11.59	91864.0
2012-02-07	BICK	ETF	27.44	27.5182	27.2	27.438	13147.0
2012-02-07	BIL	ETF	91.64	91.66	91.64	91.64	189500.0
2012-02-07	BIS	ETF	3844.8	3888.0	3844.8	3885.12	14.65
2012-02-07	BITS	ETF	22.36	22.36	21.84	22.36	2099.0
2012-02-07	BIV	ETF	87.74	87.74	87.52	87.64	207200.0
2012-02-07	BJK	ETF	33.66	33.88	33.57	33.79	9600.0
2012-02-07	BKF	ETF	42.65	42.946	42.42	42.75	211190.0
2012-02-07	BKLN	ETF	24.44	24.55	24.44	24.49	64500.0
2012-02-07	BLV	ETF	90.91	90.91	90.18	90.46	72400.0
2012-02-07	BMVP	ETF	14.87	15.0	14.85	15.0	60487.0
2012-02-07	BND	ETF	83.78	83.8	83.61	83.73	1496300.0
2012-02-07	BNO	ETF	40.605	40.86	40.225	40.45	285800.0
2012-02-07	BOIL	ETF	1436000.0	1440000.0	1285000.0	1319000.0	6.8

> showing 50 of 919 rows — these rows as CSV

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