PREVIEW / etf_daily / 2012-04-05

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-05.parquet
  size:    38 KB
  rows:    931

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-04-05	SPY	ETF	139.38	140.2	139.26	139.79	137439400.0
2012-04-05	QQQ	ETF	67.19	67.78	67.13	67.72	42938457.0
2012-04-05	IWM	ETF	81.6	82.0	81.42	81.58	31978700.0
2012-04-05	DIA	ETF	130.1	130.71	129.93	130.39	4179800.0
2012-04-05	GLD	ETF	157.87	158.68	157.78	158.31	8967700.0
2012-04-05	TLT	ETF	113.0	113.07	112.33	112.91	6364100.0
2012-04-05	AAXJ	ETF	56.09	56.6	56.09	56.45	275000.0
2012-04-05	ACTV	ETF	16.5	16.88	16.42	16.84	110331.0
2012-04-05	ACWI	ETF	46.15	46.49	46.15	46.35	357800.0
2012-04-05	ACWV	ETF	54.18	54.18	54.18	54.18	400.0
2012-04-05	ACWX	ETF	39.72	40.01	39.67	39.81	93054.0
2012-04-05	ADRE	ETF	41.43	41.7301	41.367	41.64	12938.0
2012-04-05	AFK	ETF	28.63	28.93	28.5	28.79	11740.0
2012-04-05	AGG	ETF	109.6	109.63	109.41	109.63	749100.0
2012-04-05	AGQ	ETF	206.2	210.6	205.72	208.44	517200.0
2012-04-05	AGZ	ETF	112.05	112.44	112.05	112.4022	16076.0
2012-04-05	AIA	ETF	44.5801	44.85	44.5801	44.836	20287.0
2012-04-05	AIQ	ETF	7.35	7.6	7.35	7.4	6728.0
2012-04-05	AIS	ETF	3.24	3.26	3.16	3.18	752828.0
2012-04-05	AIVI	ETF	40.2	40.47	40.16	40.26	34600.0
2012-04-05	AMJ	ETF	39.03	39.17	38.86	39.14	610922.0
2012-04-05	AMLP	ETF	82.65	83.05	82.65	83.05	299100.0
2012-04-05	AOA	ETF	35.96	36.1	35.93	36.04	10200.0
2012-04-05	AOK	ETF	29.96	29.99	29.9304	29.99	9287.0
2012-04-05	AOM	ETF	30.96	31.0695	30.96	31.05	9058.0
2012-04-05	AOR	ETF	33.04	33.09	33.016	33.09	6602.0
2012-04-05	ARB	ETF	36.41	37.2	36.41	36.92	122987.0
2012-04-05	ARGT	ETF	20.02	20.14	20.02	20.14	800.0
2012-04-05	ASEA	ETF	16.04	16.17	16.04	16.17	1800.0
2012-04-05	AWAY	ETF	23.2	24.05	23.15	23.92	284014.0
2012-04-05	BAB	ETF	29.19	29.24	29.12	29.24	102896.0
2012-04-05	BAL	ETF	54.2	54.29	53.56	53.93	24061.0
2012-04-05	BALT	ETF	4.33	4.37	4.25	4.3	91490.0
2012-04-05	BBH	ETF	44.02	44.44	44.01	44.37	4300.0
2012-04-05	BCM	ETF	45.15	45.18	45.0188	45.18	1510.0
2012-04-05	BIB	ETF	11.9162	12.0875	11.9162	12.0855	41688.0
2012-04-05	BICK	ETF	26.32	26.52	26.12	26.15	190173.0
2012-04-05	BIL	ETF	91.64	91.66	91.64	91.64	381100.0
2012-04-05	BIS	ETF	3619.2	3641.6	3619.2	3640.0	10.0
2012-04-05	BIV	ETF	86.65	86.69	86.49	86.66	132300.0
2012-04-05	BJK	ETF	35.89	36.05	35.85	36.05	24700.0
2012-04-05	BKF	ETF	40.62	41.04	40.59	41.0	100702.0
2012-04-05	BKLN	ETF	24.58	24.58	24.51	24.53	95000.0
2012-04-05	BLNG	ETF	49.9	49.9	49.9	49.9	802.0
2012-04-05	BLV	ETF	88.92	88.92	88.52	88.83	23000.0
2012-04-05	BMVP	ETF	15.5	15.57	15.5	15.55	3073.0
2012-04-05	BND	ETF	83.1	83.1	82.96	83.08	857200.0
2012-04-05	BNO	ETF	42.795	43.365	42.785	43.36	30200.0
2012-04-05	BOIL	ETF	758000.0	780000.0	724000.0	727000.0	5.2
2012-04-05	BOND	ETF	101.75	101.8	101.67	101.75	211836.0

> showing 50 of 931 rows — these rows as CSV

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