PREVIEW / etf_daily / 2011-01-10

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-10.parquet
  size:    35 KB
  rows:    823

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-10	SPY	ETF	126.58	127.16	126.2	126.98	122401700.0
2011-01-10	QQQ	ETF	55.72	56.18	55.58	56.08	55551757.0
2011-01-10	IWM	ETF	78.24	79.29	77.62	78.97	55020300.0
2011-01-10	DIA	ETF	116.16	116.34	115.56	116.2	6166700.0
2011-01-10	GLD	ETF	133.85	134.2	133.24	134.12	8429900.0
2011-01-10	TLT	ETF	92.58	92.99	92.18	92.85	8295200.0
2011-01-10	AADR	ETF	29.47	29.65	29.37	29.65	33200.0
2011-01-10	AAXJ	ETF	63.0	63.08	62.69	62.92	398400.0
2011-01-10	ACWI	ETF	46.33	46.56	46.14	46.53	158000.0
2011-01-10	ACWX	ETF	43.18	43.31	43.0	43.3	97402.0
2011-01-10	ADRE	ETF	47.25	47.41	47.035	47.39	68107.0
2011-01-10	AFK	ETF	35.17	35.31	34.88	35.28	49257.0
2011-01-10	AGG	ETF	105.59	105.79	105.55	105.79	566000.0
2011-01-10	AGQ	ETF	278.0	280.94	273.74	278.1	338050.0
2011-01-10	AGZ	ETF	109.65	109.7135	109.48	109.64	11718.0
2011-01-10	AIA	ETF	47.16	47.16	46.8252	47.03	37148.0
2011-01-10	AIQ	ETF	21.2	21.75	21.15	21.25	52342.0
2011-01-10	AIS	ETF	1.71	1.75	1.71	1.74	317758.0
2011-01-10	AIVI	ETF	42.5	42.88	42.34	42.85	46200.0
2011-01-10	AMJ	ETF	36.4	36.65	36.37	36.64	286979.0
2011-01-10	AMLP	ETF	80.35	80.6	80.3	80.55	104820.0
2011-01-10	AOA	ETF	34.19	34.41	34.05	34.38	37600.0
2011-01-10	AOK	ETF	28.79	28.82	28.72	28.819	16054.0
2011-01-10	AOM	ETF	29.87	29.93	29.82	29.9028	12475.0
2011-01-10	AOR	ETF	31.37	31.55	31.3518	31.53	73552.0
2011-01-10	ARB	ETF	41.8	42.36	41.54	42.01	223474.0
2011-01-10	BAB	ETF	25.04	25.09	24.99	25.08	257196.0
2011-01-10	BAL	ETF	72.0	73.88	71.8601	72.85	39252.0
2011-01-10	BALT	ETF	10.81	10.9	10.79	10.85	144695.0
2011-01-10	BBH	ETF	34.0267	34.0267	33.8033	33.8367	7800.0
2011-01-10	BIB	ETF	7.7425	7.7575	7.7425	7.7575	4000.0
2011-01-10	BICK	ETF	32.41	32.45	32.18	32.41	20327.0
2011-01-10	BIL	ETF	91.7	91.72	91.7	91.72	150550.0
2011-01-10	BITS	ETF	28.52	28.6	28.44	28.6	325.0
2011-01-10	BIV	ETF	82.73	82.94	82.66	82.88	84100.0
2011-01-10	BJK	ETF	32.55	32.82	32.36	32.81	40800.0
2011-01-10	BKF	ETF	48.8	48.87	48.44	48.76	103914.0
2011-01-10	BLV	ETF	78.46	78.73	78.22	78.65	35700.0
2011-01-10	BMVP	ETF	14.68	14.7	14.6	14.69	13423.0
2011-01-10	BND	ETF	80.29	80.39	80.21	80.39	509800.0
2011-01-10	BNO	ETF	31.815	31.815	31.61	31.61	1600.0
2011-01-10	BOSS	ETF	46.8	46.8	46.0	46.42	900.0
2011-01-10	BRF	ETF	56.37	57.26	56.37	57.23	519463.0
2011-01-10	BSCE	ETF	20.8	20.81	20.776	20.81	11843.0
2011-01-10	BSV	ETF	80.55	80.59	80.51	80.59	273900.0
2011-01-10	BTF	ETF	77.55	77.89999999999999	77.24999999999999	77.89999999999999	2907.4
2011-01-10	BWX	ETF	28.35	28.505	28.335	28.505	155270.0
2011-01-10	BWZ	ETF	36.31	36.39	36.156	36.34	16149.0
2011-01-10	BZQ	ETF	2518.4	2547.2	2510.4	2536.0	379.5
2011-01-10	CEF	ETF	19.21	19.36	19.05	19.27	865700.0

> showing 50 of 823 rows — these rows as CSV

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