PREVIEW / etf_daily / 2011-01-25

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-25.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-25	SPY	ETF	128.76	129.28	128.11	129.17	167552200.0
2011-01-25	QQQ	ETF	56.18	56.55	56.05	56.5325	55305024.0
2011-01-25	IWM	ETF	77.31	77.9	76.95	77.88	47013400.0
2011-01-25	DIA	ETF	119.3	119.59	118.71	119.49	10474000.0
2011-01-25	GLD	ETF	129.65	130.27	129.07	130.1	22219700.0
2011-01-25	TLT	ETF	91.94	92.9	91.32	92.43	13438100.0
2011-01-25	AAXJ	ETF	62.35	62.37	61.88	62.31	451900.0
2011-01-25	ACWI	ETF	47.47	47.62	47.24	47.62	161500.0
2011-01-25	ACWX	ETF	44.49	44.67	44.23	44.67	204401.0
2011-01-25	ADRE	ETF	47.27	47.33	46.8007	47.09	88665.0
2011-01-25	AFK	ETF	35.02	35.2	34.74	34.85	32271.0
2011-01-25	AGG	ETF	105.57	105.93	105.48	105.88	483400.0
2011-01-25	AGQ	ETF	237.18	239.1	233.54	236.72	529200.0
2011-01-25	AGZ	ETF	109.67	110.05	109.6286	110.05	12594.0
2011-01-25	AIA	ETF	47.81	47.81	47.38	47.77	20253.0
2011-01-25	AIQ	ETF	20.85	21.4	20.8	21.35	17810.0
2011-01-25	AIS	ETF	1.61	1.64	1.57	1.57	171664.0
2011-01-25	AIVI	ETF	45.48	45.93	45.38	45.93	12500.0
2011-01-25	AMJ	ETF	36.86	36.899	36.57	36.82	994953.0
2011-01-25	AMLP	ETF	80.85	80.95	80.6	80.75	95560.0
2011-01-25	AOA	ETF	34.73	34.85	34.6	34.84	27000.0
2011-01-25	AOK	ETF	28.91	28.95	28.85	28.9387	8700.0
2011-01-25	AOM	ETF	30.06	30.18	30.06	30.18	17839.0
2011-01-25	AOR	ETF	31.77	31.86	31.7198	31.85	64900.0
2011-01-25	ARB	ETF	40.94	41.01	39.72	40.32	236151.0
2011-01-25	BAB	ETF	25.09	25.24	24.98	25.16	307410.0
2011-01-25	BAL	ETF	84.28	84.69	81.64	82.476	196383.0
2011-01-25	BALT	ETF	9.43	9.45	9.01	9.24	386086.0
2011-01-25	BBH	ETF	34.1133	34.3467	34.03	34.2333	24600.0
2011-01-25	BIB	ETF	7.6875	7.7188	7.665	7.7188	52936.0
2011-01-25	BICK	ETF	32.51	32.51	32.02	32.2	37627.0
2011-01-25	BIL	ETF	91.72	91.72	91.7	91.72	443100.0
2011-01-25	BIS	ETF	7910.4	7910.4	7910.4	7910.4	0.625
2011-01-25	BITS	ETF	28.8	28.8	28.0	28.4	494.0
2011-01-25	BIV	ETF	82.65	83.14	82.55	83.03	95100.0
2011-01-25	BJK	ETF	32.13	32.19	31.8	32.07	21100.0
2011-01-25	BKF	ETF	48.76	48.76	48.09	48.57	162939.0
2011-01-25	BLV	ETF	78.14	78.86	77.85	78.6	24200.0
2011-01-25	BMVP	ETF	14.86	14.92	14.82	14.92	7555.0
2011-01-25	BND	ETF	80.27	80.48	80.15	80.4	1380800.0
2011-01-25	BNO	ETF	31.7	31.74	31.685	31.74	18200.0
2011-01-25	BOSS	ETF	44.25	44.25	43.2	43.2	100.0
2011-01-25	BRF	ETF	56.4	56.55	55.2719	55.7	801471.0
2011-01-25	BSCE	ETF	20.78	20.85	20.78	20.85	2398.0
2011-01-25	BSV	ETF	80.5	80.61	80.47	80.54	349900.0
2011-01-25	BTF	ETF	78.64999999999999	79.6	78.64999999999999	79.55	6499.6
2011-01-25	BWX	ETF	29.295	29.41	29.245	29.37	1196648.0
2011-01-25	BWZ	ETF	37.374	37.55	37.25	37.545	40017.0
2011-01-25	BZQ	ETF	2504.0	2566.4	2504.0	2531.2	568.0
2011-01-25	CEF	ETF	18.1	18.19	18.0	18.1	1942400.0

> showing 50 of 825 rows — these rows as CSV

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