PREVIEW / etf_daily / 2010-03-03

all etf daily files

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

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-03	SPY	ETF	112.49	112.97	112.02	112.3	150785000.0
2010-03-03	QQQ	ETF	45.67	45.82	45.43	45.6	65744912.0
2010-03-03	IWM	ETF	65.07	65.49	64.78	65.12	56207500.0
2010-03-03	DIA	ETF	104.35	104.77	103.83	104.09	5891900.0
2010-03-03	GLD	ETF	111.46	112.18	111.18	111.63	16222100.0
2010-03-03	TLT	ETF	91.01	91.08	90.7	90.99	2156100.0
2010-03-03	AAXJ	ETF	54.4	54.49	53.91	54.1	154200.0
2010-03-03	ACWI	ETF	41.95	42.16	41.81	41.9	93500.0
2010-03-03	ACWX	ETF	40.16	40.416	40.07	40.18	80981.0
2010-03-03	ADRE	ETF	42.5	42.8	42.0808	42.27	111589.0
2010-03-03	AFK	ETF	29.61	29.96	29.44	29.9	15672.0
2010-03-03	AGG	ETF	104.3	104.45	104.29	104.4	492600.0
2010-03-03	AGQ	ETF	113.2	115.36	112.54	112.9	464100.0
2010-03-03	AGZ	ETF	108.53	108.73	108.47	108.655	57159.0
2010-03-03	AIA	ETF	38.81	39.08	38.68	38.75	31618.0
2010-03-03	AIQ	ETF	24.65	24.85	24.3	24.55	35208.0
2010-03-03	AIS	ETF	1.3	1.34	1.28	1.34	316371.0
2010-03-03	AIVI	ETF	41.13	41.57	41.13	41.24	17700.0
2010-03-03	AMJ	ETF	29.99	30.04	29.6	29.615	573571.0
2010-03-03	AOA	ETF	30.34	30.52	30.31	30.35	8900.0
2010-03-03	AOK	ETF	27.45	27.5363	27.45	27.5199	7322.0
2010-03-03	AOM	ETF	28.19	28.33	28.19	28.27	47953.0
2010-03-03	AOR	ETF	29.08	29.18	29.05	29.08	25814.0
2010-03-03	ARB	ETF	22.07	22.5	22.0	22.21	272235.0
2010-03-03	BAB	ETF	25.0	25.0	24.91	24.99	227701.0
2010-03-03	BAL	ETF	39.8101	39.97	39.64	39.886	2410.0
2010-03-03	BBH	ETF	34.4367	34.51	34.36	34.4033	180600.0
2010-03-03	BIL	ETF	91.72	91.72	91.68	91.68	278900.0
2010-03-03	BITS	ETF	34.08	34.08	30.48	32.64	3216.0
2010-03-03	BIV	ETF	80.58	80.68	80.46	80.63	114400.0
2010-03-03	BJK	ETF	23.7	24.13	23.67	23.93	35800.0
2010-03-03	BKF	ETF	44.46	44.96	44.285	44.34	333967.0
2010-03-03	BLV	ETF	77.13	77.18	76.87	77.03	17100.0
2010-03-03	BMVP	ETF	12.8167	12.8703	12.77	12.7767	22453.0
2010-03-03	BND	ETF	79.5	79.54	79.41	79.53	731900.0
2010-03-03	BNE	ETF	11.2	11.24	11.2	11.21	1072742.0
2010-03-03	BRF	ETF	47.25	47.71	46.5	46.84	588089.0
2010-03-03	BSV	ETF	80.31	80.32	80.22	80.27	470800.0
2010-03-03	BTF	ETF	69.6	70.0	69.6	70.0	8040.0
2010-03-03	BWX	ETF	27.945	28.23	27.945	28.1	319098.0
2010-03-03	BWZ	ETF	35.4	35.98	35.4	35.9599	19734.0
2010-03-03	BZQ	ETF	3865.6	3972.8	3744.0	3942.4	654.5
2010-03-03	CEF	ETF	13.9	14.05	13.89	13.97	1123300.0
2010-03-03	CEW	ETF	21.99	22.01	21.91	21.99	170328.0
2010-03-03	CGO	ETF	14.22	14.32	14.16	14.2	15582.0
2010-03-03	CGW	ETF	17.92	18.13	17.92	18.01	72641.0
2010-03-03	CHI	ETF	12.76	12.76	12.59	12.68	127160.0
2010-03-03	CHIE	ETF	14.3	14.3679	14.3	14.3	1950.0
2010-03-03	CHII	ETF	15.23	15.36	15.13	15.16	46015.0
2010-03-03	CHIM	ETF	26.32	26.6776	26.32	26.42	5287.0

> showing 50 of 727 rows — these rows as CSV

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