PREVIEW / etf_daily / 2011-01-26

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-26.parquet
  size:    35 KB
  rows:    825

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-01-26	SPY	ETF	129.49	130.05	129.23	129.67	141281500.0
2011-01-26	QQQ	ETF	56.63	56.98	56.45	56.83	60547612.0
2011-01-26	IWM	ETF	78.0	79.38	77.75	79.12	65896200.0
2011-01-26	DIA	ETF	119.55	119.94	119.34	119.61	9154100.0
2011-01-26	GLD	ETF	129.83	131.17	129.28	131.16	20543000.0
2011-01-26	TLT	ETF	92.22	92.26	90.89	91.03	13322900.0
2011-01-26	AADR	ETF	30.3	30.3	30.23	30.23	400.0
2011-01-26	AAXJ	ETF	62.76	63.09	62.69	62.84	482700.0
2011-01-26	ACWI	ETF	47.9	47.98	47.67	47.83	510600.0
2011-01-26	ACWX	ETF	44.91	44.98	44.7488	44.91	41928.0
2011-01-26	ADRE	ETF	47.31	47.4781	47.181	47.39	50081.0
2011-01-26	AFK	ETF	34.67	34.83	34.5	34.7645	45489.0
2011-01-26	AGG	ETF	105.74	105.78	105.51	105.53	568400.0
2011-01-26	AGQ	ETF	235.98	248.76	233.7	248.76	625500.0
2011-01-26	AGZ	ETF	109.74	109.9	109.58	109.6	15701.0
2011-01-26	AIA	ETF	48.21	48.47	48.03	48.37	92887.0
2011-01-26	AIQ	ETF	21.35	21.8	21.15	21.75	15722.0
2011-01-26	AIS	ETF	1.57	1.63	1.57	1.61	323541.0
2011-01-26	AIVI	ETF	46.01	46.04	45.83	46.03	6300.0
2011-01-26	AMJ	ETF	36.81	37.11	36.72	37.07	4891345.0
2011-01-26	AMLP	ETF	80.85	81.4	80.75	81.3	96020.0
2011-01-26	AOA	ETF	35.0	35.18	34.9	35.1	32000.0
2011-01-26	AOK	ETF	28.98	29.01	28.9611	28.98	20509.0
2011-01-26	AOM	ETF	30.23	30.29	30.2099	30.218	8961.0
2011-01-26	AOR	ETF	31.97	32.04	31.93	32.037	34848.0
2011-01-26	ARB	ETF	40.4	41.71	40.32	41.59	155614.0
2011-01-26	BAB	ETF	25.14	25.17	24.95	25.0	289578.0
2011-01-26	BAL	ETF	84.94	85.85	84.37	85.66	56916.0
2011-01-26	BALT	ETF	9.4	9.4	9.11	9.17	188790.0
2011-01-26	BBH	ETF	34.2867	34.5867	34.25	34.5333	11100.0
2011-01-26	BIB	ETF	7.895	7.9076	7.875	7.9076	68400.0
2011-01-26	BICK	ETF	32.43	32.63	32.4296	32.59	22264.0
2011-01-26	BIL	ETF	91.72	91.72	91.7	91.7	87800.0
2011-01-26	BIS	ETF	7616.0	7624.0	7616.0	7624.0	2.5
2011-01-26	BITS	ETF	28.36	28.48	27.84	28.2	10850.0
2011-01-26	BIV	ETF	82.9	82.95	82.61	82.71	122900.0
2011-01-26	BJK	ETF	32.24	32.48	32.11	32.43	15700.0
2011-01-26	BKF	ETF	49.04	49.04	48.47	48.55	143530.0
2011-01-26	BLV	ETF	78.62	78.62	77.68	77.84	10300.0
2011-01-26	BMVP	ETF	15.0	15.09	15.0	15.08	11703.0
2011-01-26	BND	ETF	80.28	80.34	80.12	80.12	1104100.0
2011-01-26	BNO	ETF	32.185	32.615	32.11	32.615	16400.0
2011-01-26	BRF	ETF	56.56	56.56	55.246	55.51	347760.0
2011-01-26	BSCE	ETF	20.88	20.88	20.8378	20.856	2200.0
2011-01-26	BSV	ETF	80.59	80.65	80.5	80.57	614000.0
2011-01-26	BTF	ETF	79.55	81.05	79.5	80.55	11094.800000000001
2011-01-26	BWX	ETF	29.305	29.389	29.015	29.33	161710.0
2011-01-26	BWZ	ETF	37.58	39.9899	37.519	39.2799	27407.0
2011-01-26	BZQ	ETF	2484.8	2542.4	2478.4	2526.4	362.0
2011-01-26	CEF	ETF	18.09	18.58	18.0	18.58	1150400.0

> showing 50 of 825 rows — these rows as CSV

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