PREVIEW / etf_daily / 2011-06-17

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-17.parquet
  size:    36 KB
  rows:    864

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-06-17	SPY	ETF	127.93	127.94	126.62	127.05	233284900.0
2011-06-17	QQQ	ETF	54.45	54.598	53.631	53.79	70353112.0
2011-06-17	IWM	ETF	78.99	79.13	77.83	78.23	77862900.0
2011-06-17	DIA	ETF	120.23	120.47	119.43	119.74	7742000.0
2011-06-17	GLD	ETF	148.87	150.29	148.83	149.94	19205100.0
2011-06-17	TLT	ETF	96.86	97.15	96.64	96.9	9622900.0
2011-06-17	AADR	ETF	30.1	30.1	30.0	30.0	600.0
2011-06-17	AAXJ	ETF	60.41	60.48	59.89	59.98	637200.0
2011-06-17	ACTV	ETF	18.73	18.9	17.875	18.21	237441.0
2011-06-17	ACWI	ETF	47.21	47.21	46.65	46.76	595100.0
2011-06-17	ACWX	ETF	43.89	43.94	43.63	43.75	84469.0
2011-06-17	ADRE	ETF	44.27	44.32	43.85	44.08	67876.0
2011-06-17	AFK	ETF	31.69	31.8991	31.61	31.65	7890.0
2011-06-17	AGG	ETF	107.44	107.51	107.34	107.49	871300.0
2011-06-17	AGQ	ETF	344.08	354.78	344.08	353.4	516150.0
2011-06-17	AGZ	ETF	110.92	110.93	110.7944	110.82	7249.0
2011-06-17	AIA	ETF	46.0	46.0	45.608	45.67	10792.0
2011-06-17	AIQ	ETF	19.7	19.7	19.4	19.45	44109.0
2011-06-17	AIS	ETF	1.99	2.0	1.92	1.95	1598467.0
2011-06-17	AIVI	ETF	46.59	46.72	46.4	46.57	22800.0
2011-06-17	AMJ	ETF	35.62	35.79	35.26	35.35	907514.0
2011-06-17	AMLP	ETF	78.2	78.45	77.5	77.7	150840.0
2011-06-17	AOA	ETF	34.87	34.88	34.65	34.79	1900.0
2011-06-17	AOK	ETF	29.17	29.17	29.1	29.1599	51139.0
2011-06-17	AOM	ETF	30.3901	30.4	30.34	30.36	37730.0
2011-06-17	AOR	ETF	32.09	32.11	31.98	32.0135	10648.0
2011-06-17	ARB	ETF	38.67	39.11	37.85	37.9	205305.0
2011-06-17	ARGT	ETF	28.36	28.44	28.36	28.44	450.0
2011-06-17	ASEA	ETF	15.99	15.99	15.88	15.95	2500.0
2011-06-17	BAB	ETF	26.63	26.645	26.54	26.58	105433.0
2011-06-17	BAL	ETF	75.59	77.52	75.42	76.76	55633.0
2011-06-17	BALT	ETF	6.0	6.09	5.8621	5.97	170269.0
2011-06-17	BBH	ETF	34.22	34.32	33.9533	34.0167	40500.0
2011-06-17	BIB	ETF	8.89	8.935	8.6937	8.7538	130488.0
2011-06-17	BICK	ETF	30.74	30.79	30.555	30.58	21787.0
2011-06-17	BIL	ETF	91.72	91.72	91.7	91.72	96750.0
2011-06-17	BIS	ETF	6422.4	6582.4	6422.4	6582.4	66.0
2011-06-17	BITS	ETF	21.76	21.84	20.68	20.68	7084.0
2011-06-17	BIV	ETF	84.96	85.03	84.76	85.01	79200.0
2011-06-17	BJK	ETF	32.39	32.46	32.14	32.18	9500.0
2011-06-17	BKF	ETF	46.21	46.36	45.97	46.12	102576.0
2011-06-17	BKLN	ETF	24.72	24.79	24.67	24.72	128200.0
2011-06-17	BLNG	ETF	48.77	48.84	48.67	48.73	6100.0
2011-06-17	BLV	ETF	81.81	81.89	81.53	81.81	16900.0
2011-06-17	BMVP	ETF	14.96	14.981	14.817	14.817	6855.0
2011-06-17	BND	ETF	81.71	81.85	81.69	81.83	1254100.0
2011-06-17	BNO	ETF	37.625	37.85	37.36	37.785	252000.0
2011-06-17	BRF	ETF	55.91	55.96	55.19	55.65	219604.0
2011-06-17	BSCE	ETF	21.2	21.21	21.16	21.21	7799.0
2011-06-17	BSV	ETF	81.24	81.3	81.2	81.26	498200.0

> showing 50 of 864 rows — these rows as CSV

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