PREVIEW / etf_daily / 2010-03-22

all etf daily files

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

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-22	SPY	ETF	115.31	116.8	115.24	116.59	184477800.0
2010-03-22	QQQ	ETF	47.31	48.11	47.25	47.92	71902751.0
2010-03-22	IWM	ETF	66.93	68.51	66.78	68.36	56679400.0
2010-03-22	DIA	ETF	106.95	108.07	106.92	107.79	8835200.0
2010-03-22	GLD	ETF	107.31	108.0	106.95	107.75	11579400.0
2010-03-22	TLT	ETF	91.35	91.49	91.22	91.36	2452300.0
2010-03-22	AAXJ	ETF	55.5	56.03	55.16	55.99	65900.0
2010-03-22	ACWI	ETF	42.62	43.33	42.48	43.22	264400.0
2010-03-22	ACWX	ETF	40.77	41.3	40.53	41.28	122599.0
2010-03-22	ADRE	ETF	42.72	43.2101	42.36	43.13	169015.0
2010-03-22	AFK	ETF	30.36	30.879	30.22	30.65	6851.0
2010-03-22	AGG	ETF	104.87	104.91	104.75	104.83	526700.0
2010-03-22	AGQ	ETF	105.3	109.22	104.8	108.56	259300.0
2010-03-22	AGZ	ETF	108.27	108.3887	108.23	108.23	25551.0
2010-03-22	AIA	ETF	39.57	39.82	39.2	39.79	13391.0
2010-03-22	AIQ	ETF	29.15	29.25	28.55	29.1	40098.0
2010-03-22	AIS	ETF	1.45	1.48	1.43	1.48	182462.0
2010-03-22	AIVI	ETF	41.57	42.36	41.57	42.23	16400.0
2010-03-22	AMJ	ETF	29.8	30.0	29.38	30.0	473770.0
2010-03-22	AOA	ETF	30.94	31.47	30.94	31.47	13300.0
2010-03-22	AOK	ETF	27.71	27.86	27.71	27.86	3152.0
2010-03-22	AOM	ETF	28.64	28.78	28.626	28.7356	9263.0
2010-03-22	AOR	ETF	29.47	29.82	29.47	29.82	16986.0
2010-03-22	ARB	ETF	25.16	25.69	24.93	25.47	124803.0
2010-03-22	BAB	ETF	25.13	25.18	25.1001	25.15	171256.0
2010-03-22	BAL	ETF	39.54	39.731	39.54	39.72	4950.0
2010-03-22	BALT	ETF	13.61	13.61	13.19	13.25	489277.0
2010-03-22	BBH	ETF	35.38	35.8633	35.38	35.6633	316200.0
2010-03-22	BIL	ETF	91.68	91.7	91.68	91.7	204750.0
2010-03-22	BITS	ETF	32.32	33.116	32.08	33.012	556.0
2010-03-22	BIV	ETF	80.89	80.93	80.75	80.84	143300.0
2010-03-22	BJK	ETF	24.71	25.31	24.57	25.25	9800.0
2010-03-22	BKF	ETF	44.82	45.79	44.76	45.7	149281.0
2010-03-22	BLV	ETF	77.91	78.07	77.67	77.75	16000.0
2010-03-22	BMVP	ETF	13.087	13.246	13.07	13.227	29545.0
2010-03-22	BND	ETF	79.57	79.63	79.55	79.62	484000.0
2010-03-22	BNE	ETF	11.22	11.32	11.22	11.29	457282.0
2010-03-22	BRF	ETF	45.0	45.78	44.43	45.69	235328.0
2010-03-22	BSV	ETF	80.13	80.14	80.08	80.14	445900.0
2010-03-22	BTF	ETF	73.0	74.3	73.0	73.961	5007.0
2010-03-22	BWX	ETF	28.25	28.3075	28.005	28.21	162036.0
2010-03-22	BWZ	ETF	35.38	35.8299	35.38	35.748	43422.0
2010-03-22	BZQ	ETF	3945.6	3980.8	3763.2	3782.4	661.0
2010-03-22	CEF	ETF	13.81	13.87	13.65	13.87	730900.0
2010-03-22	CEW	ETF	21.95	22.05	21.901	22.04	104364.0
2010-03-22	CGO	ETF	14.66	14.799	14.34	14.7378	46759.0
2010-03-22	CGW	ETF	18.11	18.28	17.96	18.219	79881.0
2010-03-22	CHI	ETF	12.31	12.53	12.3	12.46	211233.0
2010-03-22	CHIE	ETF	14.05	14.19	14.0	14.19	5244.0
2010-03-22	CHII	ETF	15.03	15.22	15.03	15.202	9252.0

> showing 50 of 734 rows — these rows as CSV

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