PREVIEW / etf_daily / 2010-05-04

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-04.parquet
  size:    33 KB
  rows:    757

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
2010-05-04	SPY	ETF	119.01	119.03	116.92	117.52	360353400.0
2010-05-04	QQQ	ETF	49.31	49.32	48.08	48.43	141136430.0
2010-05-04	IWM	ETF	72.19	72.2	70.53	70.96	105727600.0
2010-05-04	DIA	ETF	110.51	110.54	108.7	109.36	19911700.0
2010-05-04	GLD	ETF	116.39	116.43	114.17	114.87	21512100.0
2010-05-04	TLT	ETF	92.81	93.47	92.56	93.34	11054800.0
2010-05-04	AAXJ	ETF	56.55	56.55	55.1	55.4	1438400.0
2010-05-04	ACWI	ETF	43.14	43.14	42.23	42.48	431000.0
2010-05-04	ACWX	ETF	40.22	40.22	39.36	39.52	683776.0
2010-05-04	ADRE	ETF	43.09	43.1668	41.88	42.01	275667.0
2010-05-04	AFK	ETF	31.6	31.6	30.78	30.83	11995.0
2010-05-04	AGG	ETF	104.74	104.82	104.56	104.8	690200.0
2010-05-04	AGQ	ETF	129.32	129.46	118.34	120.1	476950.0
2010-05-04	AGZ	ETF	108.21	108.45	108.1501	108.4	119385.0
2010-05-04	AIA	ETF	40.18	40.21	39.3	39.5	41948.0
2010-05-04	AIQ	ETF	27.95	28.45	27.05	27.1	28563.0
2010-05-04	AIS	ETF	1.59	1.59	1.52	1.53	477780.0
2010-05-04	AIVI	ETF	41.13	41.13	40.35	40.54	67700.0
2010-05-04	AMJ	ETF	31.48	31.48	30.8	30.91	775809.0
2010-05-04	AOA	ETF	31.55	31.63	31.21	31.32	17400.0
2010-05-04	AOK	ETF	28.06	28.0625	27.923	27.9727	6592.0
2010-05-04	AOM	ETF	28.92	28.92	28.6401	28.6701	9115.0
2010-05-04	AOR	ETF	30.07	30.07	29.715	29.76	25612.0
2010-05-04	ARB	ETF	32.63	32.73	31.89	32.15	199578.0
2010-05-04	BAB	ETF	25.91	26.0	25.85	25.975	125214.0
2010-05-04	BAL	ETF	39.25	39.25	38.3701	38.52	6123.0
2010-05-04	BALT	ETF	13.5	13.71	13.24	13.4	468304.0
2010-05-04	BBH	ETF	32.3267	32.3267	31.5567	31.8367	104400.0
2010-05-04	BIB	ETF	7.3113	7.3262	7.1875	7.2387	10560.0
2010-05-04	BICK	ETF	29.09	29.63	28.5	28.68	12790.0
2010-05-04	BIL	ETF	91.68	91.7	91.68	91.68	97750.0
2010-05-04	BIS	ETF	9769.6	9929.6	9769.6	9840.0	26.85
2010-05-04	BITS	ETF	31.2004	31.5996	31.0	31.36	364.0
2010-05-04	BIV	ETF	81.04	81.12	80.9	81.05	69300.0
2010-05-04	BJK	ETF	26.96	27.04	26.05	26.2	22000.0
2010-05-04	BKF	ETF	44.78	44.8999	43.4	43.78	253442.0
2010-05-04	BLV	ETF	78.83	79.1	78.56	79.0	18700.0
2010-05-04	BMVP	ETF	13.53	13.53	13.27	13.31	18276.0
2010-05-04	BND	ETF	79.71	79.79	79.62	79.75	468400.0
2010-05-04	BNE	ETF	11.24	11.31	11.18	11.31	1292945.0
2010-05-04	BRF	ETF	46.46	46.67	45.08	45.23	419053.0
2010-05-04	BSV	ETF	80.13	80.13	80.05	80.1	431500.0
2010-05-04	BTF	ETF	73.75	73.75	72.55	72.55	10084.2
2010-05-04	BWX	ETF	27.3	27.345	27.14	27.165	303674.0
2010-05-04	BWZ	ETF	34.91	34.91	34.64	34.779	42394.0
2010-05-04	BZQ	ETF	3830.4	4094.4	3828.8	4091.2	2186.0
2010-05-04	CEF	ETF	15.17	15.17	14.65	14.81	1462600.0
2010-05-04	CEW	ETF	22.21	22.21	22.03	22.05	150929.0
2010-05-04	CGO	ETF	14.82	14.85	14.51	14.64	57336.0
2010-05-04	CGW	ETF	18.36	18.45	18.031	18.1	96912.0

> showing 50 of 757 rows — these rows as CSV

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