PREVIEW / etf_daily / 2010-10-21

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-21.parquet
  size:    34 KB
  rows:    797

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-10-21	SPY	ETF	118.4	119.09	117.21	118.13	221585500.0
2010-10-21	QQQ	ETF	51.51	51.7101	50.79	51.29	85885334.0
2010-10-21	IWM	ETF	70.56	71.09	68.96	69.87	62505300.0
2010-10-21	DIA	ETF	111.58	112.21	110.7	111.54	6992000.0
2010-10-21	GLD	ETF	131.08	131.59	128.72	129.47	21804200.0
2010-10-21	TLT	ETF	101.69	101.91	100.69	100.7	6836100.0
2010-10-21	AADR	ETF	28.9	29.04	28.9	29.04	500.0
2010-10-21	AAXJ	ETF	62.83	62.95	62.03	62.44	869300.0
2010-10-21	ACWI	ETF	45.06	45.18	44.44	44.8	81500.0
2010-10-21	ACWX	ETF	43.24	43.3178	42.57	42.8	39662.0
2010-10-21	ADRE	ETF	46.54	46.55	45.42	45.83	135045.0
2010-10-21	AFK	ETF	33.4	33.53	32.81	33.26	36205.0
2010-10-21	AGG	ETF	108.58	108.66	108.45	108.45	507100.0
2010-10-21	AGQ	ETF	197.24	200.22	184.0	185.42	656350.0
2010-10-21	AGZ	ETF	111.76	111.77	111.6	111.62	16654.0
2010-10-21	AIA	ETF	43.88	43.9881	43.38	43.73	12943.0
2010-10-21	AIQ	ETF	21.9	21.9	21.0	21.2	12203.0
2010-10-21	AIS	ETF	1.47	1.49	1.43	1.44	264171.0
2010-10-21	AIVI	ETF	45.43	45.7	44.91	45.07	23600.0
2010-10-21	AMJ	ETF	35.03	35.19	34.8	34.915	736450.0
2010-10-21	AMLP	ETF	79.1	79.4	78.75	78.95	75800.0
2010-10-21	AOA	ETF	32.79	32.79	32.47	32.5	3700.0
2010-10-21	AOK	ETF	28.82	28.87	28.7	28.7645	8384.0
2010-10-21	AOM	ETF	29.64	29.7101	29.546	29.62	12928.0
2010-10-21	AOR	ETF	30.71	30.87	30.58	30.67	11637.0
2010-10-21	ARB	ETF	29.6	29.95	29.47	29.89	173541.0
2010-10-21	BAB	ETF	26.36	26.36	26.19	26.2	127512.0
2010-10-21	BAL	ETF	57.03	57.26	55.959	56.8	38715.0
2010-10-21	BALT	ETF	11.24	11.34	11.06	11.26	248387.0
2010-10-21	BBH	ETF	33.3367	33.4767	33.0733	33.3533	59400.0
2010-10-21	BIB	ETF	6.7687	6.7687	6.7613	6.7613	23200.0
2010-10-21	BICK	ETF	32.88	32.91	32.38	32.649	35303.0
2010-10-21	BIL	ETF	91.7	91.72	91.7	91.7	625600.0
2010-10-21	BIS	ETF	9414.4	9414.4	9304.0	9304.0	9.4
2010-10-21	BITS	ETF	27.16	27.4	26.76	26.76	3088.0
2010-10-21	BIV	ETF	87.17	87.19	86.92	86.95	111200.0
2010-10-21	BJK	ETF	29.78	30.17	29.68	29.73	7200.0
2010-10-21	BKF	ETF	49.97	50.07	49.01	49.52	167798.0
2010-10-21	BLV	ETF	84.51	84.51	83.64	83.75	34100.0
2010-10-21	BMVP	ETF	13.6033	13.6365	13.44	13.53	11368.0
2010-10-21	BND	ETF	82.75	82.79	82.65	82.67	673900.0
2010-10-21	BNE	ETF	11.37	11.38	11.34	11.37	480327.0
2010-10-21	BNO	ETF	27.285	27.35	27.285	27.35	5000.0
2010-10-21	BRF	ETF	59.34	59.8	58.07	58.89	625804.0
2010-10-21	BSCE	ETF	21.01	21.01	21.01	21.01	100.0
2010-10-21	BSV	ETF	81.95	81.97	81.91	81.94	292100.0
2010-10-21	BTF	ETF	77.85	78.44999999999999	77.24999999999999	77.64999999999999	3831.0
2010-10-21	BWX	ETF	30.64	30.72	30.49	30.505	236300.0
2010-10-21	BWZ	ETF	37.68	37.762	37.51	37.51	38754.0
2010-10-21	BZQ	ETF	2611.2	2764.8	2576.0	2720.0	779.5

> showing 50 of 797 rows — these rows as CSV

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