PREVIEW / etf_daily / 2011-05-06

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-06.parquet
  size:    36 KB
  rows:    851

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
2011-05-06	SPY	ETF	134.94	135.63	133.68	134.2	222787200.0
2011-05-06	QQQ	ETF	58.86	59.2	58.31	58.47	72506775.0
2011-05-06	IWM	ETF	83.76	84.34	82.84	83.27	76446200.0
2011-05-06	DIA	ETF	126.73	127.44	125.83	126.27	9866400.0
2011-05-06	GLD	ETF	145.24	146.09	144.4	145.3	24182200.0
2011-05-06	TLT	ETF	94.51	95.49	94.35	95.07	9451500.0
2011-05-06	AAXJ	ETF	63.99	64.16	63.22	63.56	594000.0
2011-05-06	ACWI	ETF	49.71	49.9	49.0	49.25	387800.0
2011-05-06	ACWX	ETF	46.45	46.63	45.726	45.94	433158.0
2011-05-06	ADRE	ETF	46.92	47.2	46.429	46.62	43423.0
2011-05-06	AFK	ETF	33.33	33.47	32.96	33.1399	7875.0
2011-05-06	AGG	ETF	106.56	106.83	106.43	106.66	1020900.0
2011-05-06	AGQ	ETF	363.6	397.96	356.0	373.12	3949950.0
2011-05-06	AGZ	ETF	110.04	110.28	109.93	110.22	10779.0
2011-05-06	AIA	ETF	48.17	48.6	47.99	48.14	54706.0
2011-05-06	AIQ	ETF	20.8	21.0	20.45	20.55	11419.0
2011-05-06	AIS	ETF	1.69	1.74	1.67	1.69	328203.0
2011-05-06	AIVI	ETF	48.86	49.1	47.92	48.08	29500.0
2011-05-06	AMJ	ETF	37.05	37.79	37.05	37.61	942223.0
2011-05-06	AMLP	ETF	80.05	80.65	79.9	80.4	166940.0
2011-05-06	AOA	ETF	36.56	36.68	36.28	36.42	12000.0
2011-05-06	AOK	ETF	29.51	29.5256	29.45	29.45	11259.0
2011-05-06	AOM	ETF	31.0	31.05	30.87	30.93	16986.0
2011-05-06	AOR	ETF	33.12	33.145	32.922	32.94	6762.0
2011-05-06	ARB	ETF	39.59	40.725	39.095	39.75	134675.0
2011-05-06	ARGT	ETF	29.5	29.5	29.46	29.46	150.0
2011-05-06	ASEA	ETF	16.37	16.37	15.98	15.98	2300.0
2011-05-06	BAB	ETF	26.16	26.29	26.1	26.236	102713.0
2011-05-06	BAL	ETF	81.62	82.27	80.5	80.918	62973.0
2011-05-06	BALT	ETF	7.09	7.38	7.09	7.33	162859.0
2011-05-06	BBH	ETF	34.6933	34.9767	34.65	34.71	24900.0
2011-05-06	BCM	ETF	46.6	47.18	46.22	46.22	16100.0
2011-05-06	BIB	ETF	9.7212	10.0312	9.55	9.675	405320.0
2011-05-06	BICK	ETF	33.42	33.65	33.25	33.251	5833.0
2011-05-06	BIL	ETF	91.72	91.74	91.72	91.74	143400.0
2011-05-06	BIS	ETF	6068.8	6092.8	6068.8	6092.8	6.45
2011-05-06	BITS	ETF	23.2	23.844	22.2	23.56	1218.0
2011-05-06	BIV	ETF	83.5	83.87	83.43	83.77	69800.0
2011-05-06	BJK	ETF	34.73	34.81	34.28	34.28	5600.0
2011-05-06	BKF	ETF	48.22	48.59	47.65	48.01	555725.0
2011-05-06	BKLN	ETF	25.24	25.27	25.24	25.27	66300.0
2011-05-06	BLNG	ETF	47.8	47.8	47.8	47.8	115.0
2011-05-06	BLV	ETF	80.54	81.12	80.42	80.78	62800.0
2011-05-06	BMVP	ETF	15.88	15.96	15.77	15.77	8409.0
2011-05-06	BND	ETF	81.05	81.29	80.99	81.19	602600.0
2011-05-06	BNO	ETF	36.58	37.9	36.195	36.45	130800.0
2011-05-06	BRF	ETF	56.35	57.0	56.17	56.89	176553.0
2011-05-06	BSCE	ETF	21.08	21.16	21.08	21.12	12661.0
2011-05-06	BSV	ETF	80.68	80.82	80.68	80.78	506800.0
2011-05-06	BTF	ETF	83.05	83.7495	82.75	82.96499999999999	1990.8000000000002

> showing 50 of 851 rows — these rows as CSV

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