PREVIEW / etf_daily / 2010-03-16

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-16.parquet
  size:    32 KB
  rows:    728

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-03-16	SPY	ETF	115.81	116.52	115.49	116.41	168673000.0
2010-03-16	QQQ	ETF	47.39	47.61	47.23	47.54	74950596.0
2010-03-16	IWM	ETF	67.83	68.1	67.34	68.07	52874400.0
2010-03-16	DIA	ETF	106.78	107.12	106.41	107.07	6848800.0
2010-03-16	GLD	ETF	110.02	110.57	109.7	110.4	17749300.0
2010-03-16	TLT	ETF	90.56	91.09	90.54	91.08	3932600.0
2010-03-16	AAXJ	ETF	55.55	55.92	55.34	55.83	857700.0
2010-03-16	ACWI	ETF	42.94	43.36	42.94	43.36	168100.0
2010-03-16	ACWX	ETF	41.08	41.58	41.08	41.55	175439.0
2010-03-16	ADRE	ETF	43.68	43.916	43.37	43.91	89403.0
2010-03-16	AFK	ETF	30.58	30.58	30.2	30.45	11278.0
2010-03-16	AGG	ETF	104.64	104.89	104.59	104.84	507700.0
2010-03-16	AGQ	ETF	115.56	116.34	114.06	115.18	242050.0
2010-03-16	AGZ	ETF	112.95	112.95	108.19	108.45	77180.0
2010-03-16	AIA	ETF	39.61	39.8099	39.45	39.8099	24443.0
2010-03-16	AIQ	ETF	26.95	27.75	26.55	27.65	93653.0
2010-03-16	AIS	ETF	1.49	1.5	1.45	1.48	324539.0
2010-03-16	AIVI	ETF	42.43	42.91	42.34	42.91	11100.0
2010-03-16	AMJ	ETF	30.32	30.59	30.32	30.466	470847.0
2010-03-16	AOA	ETF	31.13	31.43	31.13	31.43	10600.0
2010-03-16	AOK	ETF	27.74	27.9	27.74	27.9	7067.0
2010-03-16	AOM	ETF	28.68	28.77	28.63	28.77	47051.0
2010-03-16	AOR	ETF	29.67	29.73	29.609	29.7	12872.0
2010-03-16	ARB	ETF	24.69	24.74	24.48	24.59	148149.0
2010-03-16	BAB	ETF	24.88	25.04	24.88	25.04	144098.0
2010-03-16	BAL	ETF	39.3699	39.449	39.1	39.416	5242.0
2010-03-16	BALT	ETF	13.9	13.96	13.74	13.86	288963.0
2010-03-16	BBH	ETF	34.66	34.9167	34.5633	34.8967	42900.0
2010-03-16	BIL	ETF	91.68	91.7	91.68	91.68	98650.0
2010-03-16	BITS	ETF	32.76	32.84	32.0	32.84	430.0
2010-03-16	BIV	ETF	80.57	80.9	80.57	80.89	125200.0
2010-03-16	BJK	ETF	24.55	24.94	24.55	24.9	3900.0
2010-03-16	BKF	ETF	45.67	46.239	45.6	46.19	306588.0
2010-03-16	BLV	ETF	77.34	77.68	77.32	77.58	15800.0
2010-03-16	BMVP	ETF	13.06	13.15	12.84	13.15	15996.0
2010-03-16	BND	ETF	79.42	79.6	79.39	79.6	523800.0
2010-03-16	BNE	ETF	11.32	11.33	11.27	11.27	632856.0
2010-03-16	BRF	ETF	46.89	47.16	46.45	46.91	534732.0
2010-03-16	BSV	ETF	80.18	80.22	80.07	80.21	514000.0
2010-03-16	BTF	ETF	74.14999999999999	74.4	73.39999999999999	74.35	8309.6
2010-03-16	BWX	ETF	28.315	28.495	28.2525	28.392	212788.0
2010-03-16	BWZ	ETF	36.0299	36.116	35.882	36.1	6397.0
2010-03-16	BZQ	ETF	3648.0	3675.2	3564.8	3566.4	141.0
2010-03-16	CEF	ETF	14.1	14.21	14.1	14.13	1011600.0
2010-03-16	CEW	ETF	22.12	22.19	22.12	22.1681	66636.0
2010-03-16	CGO	ETF	14.34	14.56	14.22	14.56	56871.0
2010-03-16	CGW	ETF	18.06	18.25	18.06	18.25	50046.0
2010-03-16	CHI	ETF	12.61	12.62	12.55	12.57	166431.0
2010-03-16	CHIE	ETF	14.31	14.31	14.31	14.31	2710.0
2010-03-16	CHII	ETF	15.12	15.21	15.068	15.19	15699.0

> showing 50 of 728 rows — these rows as CSV

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