PREVIEW / etf_daily / 2012-07-06

all etf daily files

  file:    by_date/etf_daily/2012/2012-07-06.parquet
  size:    38 KB
  rows:    924

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-07-06	SPY	ETF	135.47	135.77	134.85	135.49	151192100.0
2012-07-06	QQQ	ETF	64.65	64.69	63.65	64.12	40684059.0
2012-07-06	IWM	ETF	80.77	80.83	80.15	80.53	38530600.0
2012-07-06	DIA	ETF	127.79	127.81	126.87	127.57	4341400.0
2012-07-06	GLD	ETF	154.23	154.49	152.95	153.71	7045700.0
2012-07-06	TLT	ETF	126.67	127.21	126.61	127.06	5818300.0
2012-07-06	AADR	ETF	28.57	28.57	28.51	28.51	600.0
2012-07-06	AAXJ	ETF	52.54	52.7	52.25	52.46	169600.0
2012-07-06	ACTV	ETF	15.24	15.27	14.78	14.97	166116.0
2012-07-06	ACWI	ETF	43.74	43.79	43.44	43.66	230800.0
2012-07-06	ACWV	ETF	54.6	54.72	54.29	54.6	60900.0
2012-07-06	ACWX	ETF	36.96	37.02	36.67	36.85	106283.0
2012-07-06	ADRE	ETF	37.52	37.57	37.3701	37.53	54325.0
2012-07-06	AFK	ETF	28.24	28.3999	27.69	28.03	162759.0
2012-07-06	AGEM	ETF	20.86	20.8725	20.86	20.8725	675.0
2012-07-06	AGG	ETF	111.51	111.68	111.5	111.58	1520200.0
2012-07-06	AGQ	ETF	149.48	150.2	146.32	148.16	363475.0
2012-07-06	AGZ	ETF	113.66	113.7	113.5035	113.67	9812.0
2012-07-06	AIA	ETF	41.15	41.15	40.7752	40.93	10019.0
2012-07-06	AIQ	ETF	5.0	5.05	4.65	4.65	22901.0
2012-07-06	AIVI	ETF	37.28	37.28	37.0	37.1	15900.0
2012-07-06	AMJ	ETF	39.25	39.52	38.65	38.9	825574.0
2012-07-06	AMLP	ETF	80.4	80.75	80.05	80.6	296880.0
2012-07-06	ANGL	ETF	25.5	25.5	25.5	25.5	1200.0
2012-07-06	AOA	ETF	35.01	35.01	34.78	34.94	5400.0
2012-07-06	AOK	ETF	29.86	29.877	29.85	29.8601	6062.0
2012-07-06	AOM	ETF	30.72	30.72	30.63	30.71	9684.0
2012-07-06	AOR	ETF	32.48	32.5	32.36	32.48	27097.0
2012-07-06	ARB	ETF	36.07	36.18	35.235	35.55	78032.0
2012-07-06	ASEA	ETF	15.75	15.75	15.52	15.65	17200.0
2012-07-06	AWAY	ETF	21.68	21.8171	20.94	21.1	102963.0
2012-07-06	BAB	ETF	29.95	30.0282	29.8701	30.01	110320.0
2012-07-06	BAL	ETF	46.4875	46.77	46.4875	46.71	7500.0
2012-07-06	BALT	ETF	3.65	3.7099	3.54	3.6	42501.0
2012-07-06	BBH	ETF	48.31	48.31	47.63	47.82	9100.0
2012-07-06	BCM	ETF	42.18	42.18	42.18	42.18	1200.0
2012-07-06	BIB	ETF	13.69	13.7125	13.5375	13.61	47856.0
2012-07-06	BICK	ETF	22.5	22.511	22.37	22.45	7346.0
2012-07-06	BIL	ETF	91.64	91.64	91.62	91.62	134750.0
2012-07-06	BIS	ETF	3040.0	3059.2	3028.8	3028.8	49.6
2012-07-06	BIV	ETF	89.19	89.3	89.17	89.27	257000.0
2012-07-06	BJK	ETF	31.57	31.58	31.38	31.53	11200.0
2012-07-06	BKF	ETF	35.88	35.88	35.54	35.75	95905.0
2012-07-06	BKLN	ETF	24.47	24.48	24.42	24.44	110600.0
2012-07-06	BLV	ETF	95.53	96.15	95.53	95.96	76800.0
2012-07-06	BMVP	ETF	15.3967	15.4167	15.3734	15.3834	2885.0
2012-07-06	BND	ETF	84.53	84.63	84.51	84.57	861200.0
2012-07-06	BNO	ETF	34.94	35.01	34.645	34.675	47200.0
2012-07-06	BOIL	ETF	986200.0	1040000.0	864600.0	882000.0	25.2
2012-07-06	BOND	ETF	106.26	106.299	106.1001	106.28	561551.0

> showing 50 of 924 rows — these rows as CSV

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