PREVIEW / etf_daily / 2010-05-06

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-06.parquet
  size:    32 KB
  rows:    759

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-06	SPY	ETF	116.26	117.0	105.0	112.94	647356600.0
2010-05-06	QQQ	ETF	47.85	48.3201	41.55	46.57	274356791.0
2010-05-06	IWM	ETF	69.42	70.19	63.36	67.3	195388200.0
2010-05-06	DIA	ETF	108.37	109.15	99.16	105.26	34425300.0
2010-05-06	GLD	ETF	115.62	118.62	115.57	118.49	50546300.0
2010-05-06	TLT	ETF	94.16	100.0	93.78	96.79	19578200.0
2010-05-06	AAXJ	ETF	54.17	57.43	22.0	52.43	1067600.0
2010-05-06	ACWI	ETF	41.6	42.76	38.4	40.3	873900.0
2010-05-06	ACWX	ETF	38.42	38.72	30.65	37.2	429470.0
2010-05-06	ADRE	ETF	41.23	41.77	36.1	40.13	831256.0
2010-05-06	AFK	ETF	30.08	30.4	28.31	29.09	26258.0
2010-05-06	AGG	ETF	104.91	105.59	104.72	104.87	1366600.0
2010-05-06	AGQ	ETF	114.36	116.6	110.46	116.4	424550.0
2010-05-06	AGZ	ETF	108.71	109.0	108.47	108.878	14523.0
2010-05-06	AIA	ETF	38.82	38.94	36.5	37.52	68218.0
2010-05-06	AIQ	ETF	26.85	27.05	25.4	25.75	26199.0
2010-05-06	AIS	ETF	1.69	1.69	1.5	1.58	930768.0
2010-05-06	AIVI	ETF	39.1	39.47	31.84	37.07	82000.0
2010-05-06	AMJ	ETF	30.0	30.2	26.45	28.6099	1097530.0
2010-05-06	AOA	ETF	30.75	45.69	18.2	29.92	100500.0
2010-05-06	AOK	ETF	27.82	29.0	27.25	27.43	30441.0
2010-05-06	AOM	ETF	28.5201	29.25	20.0	28.07	114274.0
2010-05-06	AOR	ETF	29.39	29.545	28.13	28.95	45331.0
2010-05-06	ARB	ETF	31.13	31.685	29.01	30.56	177104.0
2010-05-06	BAB	ETF	26.12	26.58	26.01	26.2772	292834.0
2010-05-06	BAL	ETF	38.66	38.66	37.58	37.67	3550.0
2010-05-06	BALT	ETF	13.01	13.1	11.07	12.36	657160.0
2010-05-06	BBH	ETF	31.8967	31.9833	29.86	31.0333	247800.0
2010-05-06	BIB	ETF	6.8125	6.8125	5.5	5.6681	47200.0
2010-05-06	BICK	ETF	27.75	28.15	15.0	26.67	41299.0
2010-05-06	BIL	ETF	91.68	91.72	91.68	91.72	212450.0
2010-05-06	BIS	ETF	10379.2	12360.0	10369.6	11712.0	45.95
2010-05-06	BITS	ETF	31.24	31.68	30.8	30.96	2722.0
2010-05-06	BIV	ETF	81.3	81.91	81.05	81.22	106000.0
2010-05-06	BJK	ETF	25.62	25.62	23.0	24.4	35500.0
2010-05-06	BKF	ETF	42.62	43.08	30.19	40.9	1352716.0
2010-05-06	BLV	ETF	79.25	81.0	78.21	80.15	63900.0
2010-05-06	BMVP	ETF	13.1367	13.2611	9.5367	12.7887	127124.0
2010-05-06	BND	ETF	79.81	81.34	78.87	80.1	1561600.0
2010-05-06	BNE	ETF	11.18	11.24	11.11	11.12	1826020.0
2010-05-06	BRF	ETF	43.67	44.4	37.5	41.86	722563.0
2010-05-06	BSV	ETF	80.25	81.0	80.16	80.42	491100.0
2010-05-06	BTF	ETF	69.19999999999999	70.89999999999999	7.1499999999999995	67.39999999999999	32286.600000000002
2010-05-06	BWX	ETF	26.73	27.49	25.86	26.4825	593070.0
2010-05-06	BWZ	ETF	33.99	34.29	33.81	33.89	81608.0
2010-05-06	BZQ	ETF	4305.6	5008.0	4120.0	4518.4	1846.0
2010-05-06	CEF	ETF	14.72	15.09	14.62	15.08	2302500.0
2010-05-06	CEW	ETF	21.64	21.73	21.01	21.37	298251.0
2010-05-06	CGO	ETF	14.0	14.09	12.75	13.2	103225.0
2010-05-06	CGW	ETF	17.81	17.81	0.105	16.92	276287.0

> showing 50 of 759 rows — these rows as CSV

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