PREVIEW / etf_daily / 2010-03-08

all etf daily files

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

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-08	SPY	ETF	114.26	114.52	114.07	114.27	114631200.0
2010-03-08	QQQ	ETF	46.46	46.64	46.44	46.53	58712350.0
2010-03-08	IWM	ETF	66.64	66.93	66.52	66.74	46046400.0
2010-03-08	DIA	ETF	105.72	105.96	105.5	105.59	5728100.0
2010-03-08	GLD	ETF	111.22	111.3	109.52	109.88	12753800.0
2010-03-08	TLT	ETF	89.9	89.97	89.7	89.8	2850400.0
2010-03-08	AAXJ	ETF	55.4	55.5	55.24	55.31	93900.0
2010-03-08	ACWI	ETF	42.56	42.73	42.43	42.57	372900.0
2010-03-08	ACWX	ETF	40.96	40.96	40.73	40.85	118128.0
2010-03-08	ADRE	ETF	43.36	43.36	42.98	43.17	141879.0
2010-03-08	AFK	ETF	30.11	30.12	30.0	30.0	15066.0
2010-03-08	AGG	ETF	104.39	104.47	104.3	104.46	1827100.0
2010-03-08	AGQ	ETF	117.06	117.16	111.88	113.32	182950.0
2010-03-08	AGZ	ETF	108.17	108.4199	108.17	108.386	14439.0
2010-03-08	AIA	ETF	39.66	39.83	39.6199	39.7	29972.0
2010-03-08	AIQ	ETF	24.55	24.75	24.1	24.65	57592.0
2010-03-08	AIS	ETF	1.3	1.4	1.3	1.39	615287.0
2010-03-08	AIVI	ETF	42.05	42.07	41.79	41.85	17000.0
2010-03-08	AMJ	ETF	29.93	30.008	29.84	29.99	507700.0
2010-03-08	AOA	ETF	30.92	30.92	30.77	30.79	9000.0
2010-03-08	AOK	ETF	27.68	27.68	27.6548	27.6548	8125.0
2010-03-08	AOM	ETF	28.5	28.51	28.433	28.5	25743.0
2010-03-08	AOR	ETF	29.4	29.42	29.31	29.34	14570.0
2010-03-08	ARB	ETF	22.94	23.2	22.75	23.04	197134.0
2010-03-08	BAB	ETF	24.82	24.84	24.78	24.8	195223.0
2010-03-08	BAL	ETF	39.34	39.52	39.34	39.44	2801.0
2010-03-08	BBH	ETF	34.56	34.7133	34.51	34.5167	121500.0
2010-03-08	BIL	ETF	91.7	91.7	91.68	91.68	200650.0
2010-03-08	BITS	ETF	32.36	33.64	32.36	33.64	827.0
2010-03-08	BIV	ETF	80.39	80.48	80.35	80.48	70500.0
2010-03-08	BJK	ETF	24.39	24.66	24.39	24.51	10700.0
2010-03-08	BKF	ETF	45.47	45.47	45.046	45.1	204287.0
2010-03-08	BLV	ETF	76.72	76.87	76.54	76.57	16400.0
2010-03-08	BMVP	ETF	12.96	12.99	12.93	12.93	22485.0
2010-03-08	BND	ETF	79.34	79.37	79.3	79.34	720200.0
2010-03-08	BNE	ETF	11.22	11.23	11.2	11.22	1231565.0
2010-03-08	BRF	ETF	47.03	47.33	46.54	46.73	296413.0
2010-03-08	BSV	ETF	80.14	80.24	80.12	80.22	721200.0
2010-03-08	BTF	ETF	71.39999999999999	72.89999999999999	71.39999999999999	72.45	7618.400000000001
2010-03-08	BWX	ETF	27.985	28.11	27.93	27.995	256874.0
2010-03-08	BWZ	ETF	35.5	35.81	35.5	35.726	23837.0
2010-03-08	BZQ	ETF	3740.8	3851.2	3721.6	3806.4	155.0
2010-03-08	CEF	ETF	14.09	14.12	13.92	14.02	641700.0
2010-03-08	CEW	ETF	22.16	22.17	22.06	22.07	112328.0
2010-03-08	CGO	ETF	14.59	14.98	14.5003	14.74	55116.0
2010-03-08	CGW	ETF	18.06	18.19	17.9907	18.01	36108.0
2010-03-08	CHI	ETF	12.94	13.05	12.92	13.05	149288.0
2010-03-08	CHIE	ETF	14.57	14.57	14.5	14.5	1800.0
2010-03-08	CHII	ETF	15.37	15.5	15.37	15.45	10989.0
2010-03-08	CHIM	ETF	27.1	27.1	26.96	27.06	2455.0

> showing 50 of 730 rows — these rows as CSV

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