PREVIEW / etf_daily / 2010-02-05

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-05.parquet
  size:    31 KB
  rows:    720

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-02-05	SPY	ETF	106.56	106.88	104.58	106.66	493585800.0
2010-02-05	QQQ	ETF	42.75	43.02	42.12	42.98	213618504.0
2010-02-05	IWM	ETF	59.17	59.33	58.0	59.27	106752200.0
2010-02-05	DIA	ETF	100.15	100.34	98.36	100.16	28939700.0
2010-02-05	GLD	ETF	103.76	104.68	102.28	104.68	32656700.0
2010-02-05	TLT	ETF	91.37	92.42	91.21	91.98	6875800.0
2010-02-05	AAXJ	ETF	50.91	50.91	49.25	50.29	552500.0
2010-02-05	ACWI	ETF	39.67	39.85	38.69	39.49	181300.0
2010-02-05	ACWX	ETF	37.67	37.79	36.58	37.45	535268.0
2010-02-05	ADRE	ETF	38.63	38.7558	37.44	38.67	461009.0
2010-02-05	AFK	ETF	27.83	28.2	27.0	27.52	28145.0
2010-02-05	AGG	ETF	104.43	104.74	104.28	104.4	777600.0
2010-02-05	AGQ	ETF	88.76	89.76	83.1	89.56	794200.0
2010-02-05	AGZ	ETF	108.38	108.79	108.33	108.67	31026.0
2010-02-05	AIA	ETF	36.6	36.64	35.83	36.59	65312.0
2010-02-05	AIQ	ETF	24.5	24.5	23.805	23.95	15236.0
2010-02-05	AIS	ETF	1.1	1.13	1.1	1.12	215173.0
2010-02-05	AIVI	ETF	39.79	39.84	38.69	39.56	83200.0
2010-02-05	AMJ	ETF	28.62	28.62	27.24	28.07	585404.0
2010-02-05	AOA	ETF	28.64	28.64	28.0	28.57	26500.0
2010-02-05	AOK	ETF	27.15	27.15	26.976	27.0975	9558.0
2010-02-05	AOM	ETF	27.6	27.61	27.37	27.59	47765.0
2010-02-05	AOR	ETF	27.97	28.15	27.7401	27.99	31011.0
2010-02-05	ARB	ETF	24.66	24.7	23.91	24.39	123811.0
2010-02-05	BAB	ETF	24.97	25.1	24.86	25.04	212739.0
2010-02-05	BAL	ETF	33.49	33.57	32.283	32.55	4162.0
2010-02-05	BBH	ETF	33.2733	33.5367	32.81	33.4567	260400.0
2010-02-05	BIL	ETF	91.7	91.74	91.7	91.74	685400.0
2010-02-05	BITS	ETF	31.48	31.88	31.44	31.784	1105.0
2010-02-05	BIV	ETF	80.44	80.75	80.34	80.59	281300.0
2010-02-05	BJK	ETF	22.83	22.85	22.23	22.83	47100.0
2010-02-05	BKF	ETF	40.33	40.7	39.07	40.35	632851.0
2010-02-05	BLV	ETF	77.04	77.69	76.96	77.13	55100.0
2010-02-05	BMVP	ETF	12.09	12.09	11.83	12.06	49100.0
2010-02-05	BND	ETF	79.58	79.71	79.44	79.58	903800.0
2010-02-05	BNE	ETF	5.88	6.23	5.8	6.2	343075.0
2010-02-05	BRF	ETF	41.6	41.97	40.23	41.91	1128792.0
2010-02-05	BSV	ETF	80.26	80.39	80.21	80.35	842600.0
2010-02-05	BTF	ETF	63.699999999999996	64.2995	62.75	64.09949999999999	14482.400000000001
2010-02-05	BWX	ETF	27.71	27.825	27.51	27.625	752450.0
2010-02-05	BWZ	ETF	35.56	35.57	35.27	35.3781	48421.0
2010-02-05	BZQ	ETF	4974.4	5352.0	4886.4	4896.0	1994.5
2010-02-05	CEF	ETF	12.49	12.82	12.2	12.81	3281900.0
2010-02-05	CEW	ETF	21.5	21.5496	21.1201	21.47	1924874.0
2010-02-05	CGO	ETF	13.25	13.31	12.45	12.8	61396.0
2010-02-05	CGW	ETF	17.25	17.25	16.85	17.17	138821.0
2010-02-05	CHI	ETF	12.38	12.38	11.14	11.77	1213600.0
2010-02-05	CHIE	ETF	13.13	13.14	12.96	13.14	7100.0
2010-02-05	CHII	ETF	13.92	13.92	13.57	13.92	38242.0
2010-02-05	CHIM	ETF	23.8	24.28	22.92	23.58	1365.0

> showing 50 of 720 rows — these rows as CSV

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