PREVIEW / etf_daily / 2011-04-11

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-11.parquet
  size:    36 KB
  rows:    838

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-04-11	SPY	ETF	133.0	133.45	132.14	132.46	121385400.0
2011-04-11	QQQ	ETF	57.16	57.29	56.56	56.76	42451617.0
2011-04-11	IWM	ETF	84.02	84.28	82.9	83.23	41784100.0
2011-04-11	DIA	ETF	123.79	124.28	123.36	123.64	5467500.0
2011-04-11	GLD	ETF	143.28	143.49	142.28	142.64	10105600.0
2011-04-11	TLT	ETF	89.83	90.22	89.65	89.96	5734000.0
2011-04-11	AADR	ETF	31.05	31.05	31.05	31.05	500.0
2011-04-11	AAXJ	ETF	64.46	64.5	63.69	63.85	514000.0
2011-04-11	ACWI	ETF	49.06	49.27	48.73	48.83	444800.0
2011-04-11	ACWX	ETF	46.49	46.53	46.0	46.15	59325.0
2011-04-11	ADRE	ETF	49.26	49.434	48.8048	48.99	21740.0
2011-04-11	AFK	ETF	34.29	34.37	33.75	33.77	15396.0
2011-04-11	AGG	ETF	104.6	104.75	104.55	104.66	387000.0
2011-04-11	AGQ	ETF	536.18	538.8	497.46	508.6	1399950.0
2011-04-11	AGZ	ETF	109.19	109.19	108.96	109.1	9301.0
2011-04-11	AIA	ETF	48.66	48.81	48.28	48.37	62749.0
2011-04-11	AIQ	ETF	21.35	21.55	21.1	21.25	13868.0
2011-04-11	AIS	ETF	1.67	1.67	1.58	1.58	551362.0
2011-04-11	AIVI	ETF	48.58	48.68	48.35	48.43	31300.0
2011-04-11	AMJ	ETF	37.94	38.28	37.84	37.905	308029.0
2011-04-11	AMLP	ETF	82.35	82.35	81.75	82.0	70860.0
2011-04-11	AOA	ETF	36.21	36.21	35.9	35.97	26500.0
2011-04-11	AOK	ETF	29.23	29.23	29.14	29.14	9533.0
2011-04-11	AOM	ETF	30.65	30.66	30.54	30.58	14081.0
2011-04-11	AOR	ETF	32.65	32.7	32.55	32.5601	19467.0
2011-04-11	ARB	ETF	37.87	37.99	37.48	37.79	69785.0
2011-04-11	ARGT	ETF	31.48	31.58	31.0	31.0	9400.0
2011-04-11	ASEA	ETF	16.18	16.2	16.14	16.14	4900.0
2011-04-11	BAB	ETF	25.17	25.23	25.1	25.2	148711.0
2011-04-11	BAL	ETF	104.15	106.84	103.21	105.67	105786.0
2011-04-11	BALT	ETF	9.03	9.1	8.82	8.85	85100.0
2011-04-11	BBH	ETF	35.5467	35.99	35.5467	35.9733	279300.0
2011-04-11	BIB	ETF	9.1312	9.1312	8.7988	8.89	75312.0
2011-04-11	BICK	ETF	34.28	34.537	33.97	33.99	57458.0
2011-04-11	BIL	ETF	91.7	91.72	91.7	91.7	230850.0
2011-04-11	BIS	ETF	6660.8	6660.8	6660.8	6660.8	2.81
2011-04-11	BITS	ETF	25.08	25.36	25.0	25.24	1156.0
2011-04-11	BIV	ETF	81.45	81.61	81.38	81.52	92300.0
2011-04-11	BJK	ETF	32.92	32.93	32.59	32.65	8200.0
2011-04-11	BKF	ETF	51.9	52.05	51.091	51.17	136710.0
2011-04-11	BKLN	ETF	25.3	25.33	25.27	25.31	213300.0
2011-04-11	BLV	ETF	77.03	77.39	77.0	77.16	16800.0
2011-04-11	BMVP	ETF	15.73	15.757	15.606	15.633	9284.0
2011-04-11	BND	ETF	79.62	79.71	79.57	79.63	444000.0
2011-04-11	BNO	ETF	41.725	41.85	40.905	40.93	184400.0
2011-04-11	BRF	ETF	58.96	59.2	58.35	58.35	191112.0
2011-04-11	BSCE	ETF	20.86	20.906	20.86	20.906	2298.0
2011-04-11	BSV	ETF	80.0	80.04	79.96	79.98	298500.0
2011-04-11	BTF	ETF	82.75	82.75999999999999	81.4	81.54999999999998	2289.2000000000003
2011-04-11	BWX	ETF	30.045	30.075	29.98	30.025	116138.0

> showing 50 of 838 rows — these rows as CSV

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