PREVIEW / etf_daily / 2012-02-10

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-10.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-10	SPY	ETF	134.16	134.47	133.84	134.36	167907500.0
2012-02-10	QQQ	ETF	62.47	62.64	62.25	62.475	58093569.0
2012-02-10	IWM	ETF	81.5	81.67	81.08	81.27	42503000.0
2012-02-10	DIA	ETF	127.76	127.92	127.3	127.85	6380600.0
2012-02-10	GLD	ETF	166.49	167.64	166.33	167.14	10326800.0
2012-02-10	TLT	ETF	116.8	117.33	116.52	116.99	7193100.0
2012-02-10	AADR	ETF	29.79	29.79	29.73	29.73	400.0
2012-02-10	AAXJ	ETF	56.3	56.3	55.96	56.28	1256800.0
2012-02-10	ACTV	ETF	15.13	15.42	15.13	15.38	92923.0
2012-02-10	ACWI	ETF	45.5	45.5	45.25	45.44	546400.0
2012-02-10	ACWV	ETF	52.25	52.25	52.25	52.25	600.0
2012-02-10	ACWX	ETF	39.88	39.96	39.77	39.84	195590.0
2012-02-10	ADRE	ETF	43.07	43.07	42.76	42.93	41771.0
2012-02-10	AFK	ETF	28.69	29.152	28.5	28.55	10294.0
2012-02-10	AGEM	ETF	23.27	23.301	23.27	23.301	2500.0
2012-02-10	AGG	ETF	110.35	110.53	110.34	110.41	714900.0
2012-02-10	AGQ	ETF	239.36	244.72	237.08	238.92	382050.0
2012-02-10	AGZ	ETF	112.74	112.93	112.64	112.93	13792.0
2012-02-10	AIA	ETF	43.32	43.32	43.1225	43.29	26462.0
2012-02-10	AIQ	ETF	6.5	7.6	6.5	6.85	36756.0
2012-02-10	AIS	ETF	2.66	2.66	2.58	2.59	1263460.0
2012-02-10	AIVI	ETF	41.12	41.21	40.95	41.07	152300.0
2012-02-10	AMJ	ETF	40.19	40.26	39.9354	40.26	1472408.0
2012-02-10	AMLP	ETF	83.8	83.95	83.35	83.95	382880.0
2012-02-10	AOA	ETF	35.33	35.43	35.26	35.33	28600.0
2012-02-10	AOK	ETF	29.93	29.93	29.86	29.93	27967.0
2012-02-10	AOM	ETF	30.7902	30.85	30.74	30.83	16016.0
2012-02-10	AOR	ETF	32.55	32.65	32.55	32.63	22461.0
2012-02-10	ARB	ETF	34.42	35.139	34.3	35.12	160919.0
2012-02-10	ARGT	ETF	23.04	23.04	22.76	22.76	750.0
2012-02-10	ASEA	ETF	15.72	15.85	15.57	15.73	48300.0
2012-02-10	AWAY	ETF	26.07	26.43	25.25	26.3	182275.0
2012-02-10	BAB	ETF	29.26	29.3	29.17	29.25	164748.0
2012-02-10	BAL	ETF	55.84	56.41	55.75	55.95	14767.0
2012-02-10	BALT	ETF	4.34	4.34	4.18	4.18	130278.0
2012-02-10	BBH	ETF	42.9733	43.1733	42.8467	43.1233	13200.0
2012-02-10	BCM	ETF	45.42	45.51	45.4148	45.47	4140.0
2012-02-10	BIB	ETF	11.2275	11.2275	11.0538	11.1662	69184.0
2012-02-10	BICK	ETF	27.44	27.44	27.2301	27.24	15353.0
2012-02-10	BIL	ETF	91.66	91.66	91.64	91.66	521300.0
2012-02-10	BIS	ETF	4025.6	4051.04	3996.96	4008.96	38.65
2012-02-10	BITS	ETF	21.8	22.12	21.8	22.12	75.0
2012-02-10	BIV	ETF	87.76	87.86	87.6	87.78	189000.0
2012-02-10	BJK	ETF	33.48	33.56	33.3	33.42	24700.0
2012-02-10	BKF	ETF	42.36	42.36	41.89	42.14	249795.0
2012-02-10	BKLN	ETF	24.52	24.55	24.46	24.53	111700.0
2012-02-10	BLV	ETF	90.68	91.0	90.42	90.79	110900.0
2012-02-10	BMVP	ETF	14.9733	14.9931	14.8967	14.9767	6575.0
2012-02-10	BND	ETF	83.72	83.79	83.65	83.7	1003600.0
2012-02-10	BNO	ETF	40.585	40.85	40.5	40.85	124600.0

> showing 50 of 919 rows — these rows as CSV

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