PREVIEW / etf_daily / 2012-02-02

all etf daily files

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

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-02	SPY	ETF	132.73	133.02	132.21	132.68	113090400.0
2012-02-02	QQQ	ETF	61.2	61.41	60.97	61.21	46373511.0
2012-02-02	IWM	ETF	81.04	81.53	80.74	81.18	46400100.0
2012-02-02	DIA	ETF	127.02	127.16	126.48	126.84	4531500.0
2012-02-02	GLD	ETF	169.96	171.23	169.68	171.05	11509600.0
2012-02-02	TLT	ETF	118.96	119.48	118.64	119.13	5596900.0
2012-02-02	AADR	ETF	29.8	29.8	29.8	29.8	200.0
2012-02-02	AAXJ	ETF	56.41	56.72	56.29	56.38	340000.0
2012-02-02	ACTV	ETF	14.78	14.9	14.74	14.83	67933.0
2012-02-02	ACWI	ETF	45.16	45.39	45.05	45.26	1000600.0
2012-02-02	ACWV	ETF	52.67	52.72	52.67	52.72	700.0
2012-02-02	ACWX	ETF	39.87	40.06	39.75	39.86	177019.0
2012-02-02	ADRE	ETF	43.38	43.6991	43.3405	43.44	27377.0
2012-02-02	AFK	ETF	28.74	28.784	28.56	28.784	11470.0
2012-02-02	AGEM	ETF	23.77	23.77	23.66	23.6601	2500.0
2012-02-02	AGG	ETF	110.55	110.68	110.47	110.61	1182200.0
2012-02-02	AGQ	ETF	244.0	253.32	242.52	252.16	674550.0
2012-02-02	AGZ	ETF	113.234	113.3	113.0	113.0	6181.0
2012-02-02	AIA	ETF	43.59	43.8562	43.59	43.61	29734.0
2012-02-02	AIQ	ETF	6.0	6.35	5.7	6.3	45460.0
2012-02-02	AIS	ETF	2.7	2.71	2.62	2.63	1530976.0
2012-02-02	AIVI	ETF	41.1	41.16	40.88	41.02	111800.0
2012-02-02	AMJ	ETF	40.24	40.35	40.0108	40.12	2091639.0
2012-02-02	AMLP	ETF	85.15	85.15	84.5	84.75	359960.0
2012-02-02	AOA	ETF	35.1	35.2	35.07	35.1	14500.0
2012-02-02	AOK	ETF	29.916	29.92	29.87	29.9	16092.0
2012-02-02	AOM	ETF	30.72	30.765	30.71	30.71	47894.0
2012-02-02	AOR	ETF	32.44	32.55	32.44	32.44	35494.0
2012-02-02	ARB	ETF	34.31	34.58	34.03	34.3	214830.0
2012-02-02	ARGT	ETF	23.74	23.74	23.72	23.72	450.0
2012-02-02	ASEA	ETF	15.9	15.99	15.86	15.94	31400.0
2012-02-02	AWAY	ETF	26.61	27.06	26.27	26.99	206260.0
2012-02-02	BAB	ETF	29.28	29.34	29.2391	29.3	234333.0
2012-02-02	BAL	ETF	57.84	58.84	57.38	58.84	29966.0
2012-02-02	BALT	ETF	4.19	4.22	4.12	4.15	83546.0
2012-02-02	BBH	ETF	42.8967	43.3167	42.8733	43.19	18600.0
2012-02-02	BCM	ETF	45.29	45.34	45.24	45.28	3121.0
2012-02-02	BIB	ETF	11.1325	11.29	11.1248	11.2675	79600.0
2012-02-02	BICK	ETF	27.34	27.5499	27.311	27.385	21157.0
2012-02-02	BIL	ETF	91.64	91.66	91.64	91.64	119000.0
2012-02-02	BIS	ETF	3988.8	3988.8	3966.4	3984.0	56.5
2012-02-02	BITS	ETF	22.32	22.56	22.08	22.44	375.0
2012-02-02	BIV	ETF	88.08	88.17	87.95	88.16	233500.0
2012-02-02	BJK	ETF	33.79	33.99	33.72	33.99	20100.0
2012-02-02	BKF	ETF	42.34	42.66	42.3	42.46	185669.0
2012-02-02	BKLN	ETF	24.48	24.51	24.45	24.5	97400.0
2012-02-02	BLV	ETF	91.74	91.93	91.5	91.79	48500.0
2012-02-02	BMVP	ETF	14.623	14.701	14.603	14.671	6648.0
2012-02-02	BND	ETF	83.85	84.03	83.79	83.91	2303800.0
2012-02-02	BNO	ETF	38.965	39.125	38.645	39.1	63000.0

> showing 50 of 904 rows — these rows as CSV

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