PREVIEW / etf_daily / 2011-01-24

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-24.parquet
  size:    35 KB
  rows:    817

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-24	SPY	ETF	128.29	129.25	128.26	129.1	113715500.0
2011-01-24	QQQ	ETF	55.79	56.46	55.68	56.45	64103246.0
2011-01-24	IWM	ETF	77.2	78.07	77.09	77.76	48142600.0
2011-01-24	DIA	ETF	118.36	119.58	118.34	119.56	12299400.0
2011-01-24	GLD	ETF	131.01	131.63	130.14	130.36	15127200.0
2011-01-24	TLT	ETF	91.87	91.9	91.38	91.56	7700200.0
2011-01-24	AAXJ	ETF	62.2	62.47	62.08	62.38	1070000.0
2011-01-24	ACWI	ETF	47.3	47.68	47.24	47.64	558900.0
2011-01-24	ACWX	ETF	44.32	44.72	44.28	44.72	323608.0
2011-01-24	ADRE	ETF	47.02	47.59	47.02	47.57	74379.0
2011-01-24	AFK	ETF	35.2	35.57	35.15	35.5294	70306.0
2011-01-24	AGG	ETF	105.49	105.69	105.49	105.55	535300.0
2011-01-24	AGQ	ETF	243.48	249.44	237.0	238.98	449900.0
2011-01-24	AGZ	ETF	110.05	110.05	109.66	109.72	16033.0
2011-01-24	AIA	ETF	47.7	47.86	47.629	47.83	21343.0
2011-01-24	AIQ	ETF	20.5	21.05	20.05	21.05	16683.0
2011-01-24	AIS	ETF	1.59	1.6299	1.58	1.61	241499.0
2011-01-24	AIVI	ETF	45.48	46.02	45.48	46.01	12500.0
2011-01-24	AMJ	ETF	36.57	36.8899	36.44	36.83	1161066.0
2011-01-24	AMLP	ETF	80.35	80.9	80.3	80.8	131380.0
2011-01-24	AOA	ETF	34.62	34.9	34.62	34.77	16100.0
2011-01-24	AOK	ETF	28.87	28.92	28.84	28.9199	4793.0
2011-01-24	AOM	ETF	30.06	30.17	30.06	30.1373	26635.0
2011-01-24	AOR	ETF	31.72	31.89	31.72	31.87	27174.0
2011-01-24	ARB	ETF	40.66	41.39	40.37	41.23	145831.0
2011-01-24	BAB	ETF	25.16	25.16	25.0	25.04	206626.0
2011-01-24	BAL	ETF	83.02	83.9799	83.0	83.94	141690.0
2011-01-24	BALT	ETF	9.87	9.89	9.14	9.55	628815.0
2011-01-24	BBH	ETF	34.1033	34.54	34.1033	34.2967	30000.0
2011-01-24	BIB	ETF	7.645	7.72	7.6375	7.72	69072.0
2011-01-24	BICK	ETF	32.36	32.472	32.2	32.369	25119.0
2011-01-24	BIL	ETF	91.7	91.72	91.7	91.7	312100.0
2011-01-24	BITS	ETF	28.12	28.4	27.84	28.0	4525.0
2011-01-24	BIV	ETF	82.75	82.76	82.55	82.63	130500.0
2011-01-24	BJK	ETF	32.35	32.5	32.13	32.42	15000.0
2011-01-24	BKF	ETF	48.53	48.93	48.3	48.93	135036.0
2011-01-24	BLV	ETF	78.37	78.37	78.02	78.05	13400.0
2011-01-24	BMVP	ETF	14.7133	14.8934	14.7133	14.8867	19499.0
2011-01-24	BND	ETF	80.18	80.31	80.17	80.19	582000.0
2011-01-24	BNO	ETF	32.42	32.53	32.155	32.155	4000.0
2011-01-24	BOSS	ETF	44.01	44.01	44.01	44.01	100.0
2011-01-24	BRF	ETF	56.11	56.98	56.0	56.65	215387.0
2011-01-24	BSCE	ETF	20.81	20.84	20.7501	20.83	14383.0
2011-01-24	BSV	ETF	80.5	80.55	80.46	80.49	478100.0
2011-01-24	BTF	ETF	78.64999999999999	79.95	78.64999999999999	79.4	11656.800000000001
2011-01-24	BWX	ETF	29.25	29.42	29.23	29.41	505096.0
2011-01-24	BWZ	ETF	37.22	37.489	37.22	37.41	17285.0
2011-01-24	BZQ	ETF	2539.2	2553.6	2486.4	2486.4	307.5
2011-01-24	CEF	ETF	18.28	18.45	18.17	18.22	1088300.0
2011-01-24	CEW	ETF	22.37	22.44	22.37	22.44	57516.0

> showing 50 of 817 rows — these rows as CSV

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