PREVIEW / etf_daily / 2010-07-20

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-20.parquet
  size:    33 KB
  rows:    762

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-07-20	SPY	ETF	105.87	108.56	105.82	108.48	258162400.0
2010-07-20	QQQ	ETF	43.99	45.26	43.86	45.26	89061202.0
2010-07-20	IWM	ETF	60.45	62.47	60.21	62.36	71430700.0
2010-07-20	DIA	ETF	100.1	102.4	100.04	102.33	9200800.0
2010-07-20	GLD	ETF	115.75	116.74	115.48	116.65	9263100.0
2010-07-20	TLT	ETF	100.67	100.9	100.18	100.33	5076600.0
2010-07-20	AAXJ	ETF	53.86	54.91	53.67	54.86	164600.0
2010-07-20	ACWI	ETF	39.15	40.03	39.1	40.03	746300.0
2010-07-20	ACWX	ETF	36.87	37.6905	36.75	37.68	49915.0
2010-07-20	ADRE	ETF	39.81	41.24	39.8	41.19	100641.0
2010-07-20	AFK	ETF	28.7782	29.2299	28.75	29.2299	3871.0
2010-07-20	AGG	ETF	107.4	107.5	107.24	107.25	616900.0
2010-07-20	AGQ	ETF	111.1	113.6	110.64	112.8	83850.0
2010-07-20	AGZ	ETF	110.52	110.53	110.29	110.37	146475.0
2010-07-20	AIA	ETF	37.96	38.7741	37.96	38.7741	34742.0
2010-07-20	AIQ	ETF	18.9	19.3	18.55	19.3	16380.0
2010-07-20	AIS	ETF	1.51	1.55	1.45	1.54	766127.0
2010-07-20	AIVI	ETF	38.51	39.23	38.4	39.22	9200.0
2010-07-20	AMJ	ETF	32.34	33.0	32.315	33.0	589141.0
2010-07-20	AOA	ETF	28.75	29.32	28.7	29.32	4800.0
2010-07-20	AOK	ETF	27.47	27.589	27.47	27.572	16049.0
2010-07-20	AOM	ETF	27.93	28.045	27.8864	28.045	11434.0
2010-07-20	AOR	ETF	28.28	28.49	28.278	28.47	15120.0
2010-07-20	ARB	ETF	25.83	26.69	25.43	26.59	184465.0
2010-07-20	BAB	ETF	25.94	25.95	25.82	25.89	156230.0
2010-07-20	BAL	ETF	35.95	35.981	35.83	35.83	1318.0
2010-07-20	BALT	ETF	10.41	11.1	10.31	11.09	110853.0
2010-07-20	BBH	ETF	29.1033	29.6933	29.1033	29.6933	136200.0
2010-07-20	BIB	ETF	5.1013	5.15	5.1013	5.15	10400.0
2010-07-20	BICK	ETF	27.76	27.76	27.47	27.76	1873.0
2010-07-20	BIL	ETF	91.72	91.72	91.7	91.7	121350.0
2010-07-20	BIS	ETF	12710.4	12716.8	12556.8	12556.8	6.8
2010-07-20	BITS	ETF	27.24	27.24	25.96	26.4	1824.0
2010-07-20	BIV	ETF	84.17	84.29	84.04	84.08	149500.0
2010-07-20	BJK	ETF	23.71	24.06	23.62	24.06	10900.0
2010-07-20	BKF	ETF	42.08	43.4	42.08	43.38	79237.0
2010-07-20	BLV	ETF	82.16	82.52	82.09	82.13	36900.0
2010-07-20	BMVP	ETF	11.94	12.18	11.94	12.18	10533.0
2010-07-20	BND	ETF	81.59	81.63	81.44	81.44	2581000.0
2010-07-20	BNE	ETF	11.28	11.31	11.27	11.31	331216.0
2010-07-20	BNO	ETF	25.43	25.875	25.38	25.77	48600.0
2010-07-20	BRF	ETF	45.69	46.95	45.65	46.75	132482.0
2010-07-20	BSCE	ETF	20.65	20.66	20.65	20.65	6106.0
2010-07-20	BSV	ETF	81.18	81.21	81.15	81.18	380700.0
2010-07-20	BTF	ETF	67.39999999999999	68.39999999999999	67.1545	68.39999999999999	2027.6000000000001
2010-07-20	BWX	ETF	28.005	28.07	27.91	27.9825	207850.0
2010-07-20	BWZ	ETF	34.6	34.9	34.6	34.755	7217.0
2010-07-20	BZQ	ETF	4016.0	4019.2	3696.0	3712.0	1619.0
2010-07-20	CEF	ETF	14.3	14.46	14.25	14.39	840300.0
2010-07-20	CEW	ETF	21.55	21.67	21.51	21.67	62732.0

> showing 50 of 762 rows — these rows as CSV

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