PREVIEW / etf_daily / 2009-07-15

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-15.parquet
  size:    29 KB
  rows:    666

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
2009-07-15	SPY	ETF	91.81	93.51	90.68	93.26	220877900.0
2009-07-15	QQQ	ETF	36.31	36.93	36.14	36.92	160869688.0
2009-07-15	IWM	ETF	50.46	51.62	50.26	51.46	57645800.0
2009-07-15	DIA	ETF	84.59	86.36	84.54	86.2	11620000.0
2009-07-15	GLD	ETF	92.17	92.52	92.03	92.24	9863800.0
2009-07-15	TLT	ETF	92.66	93.0	91.67	91.68	4664200.0
2009-07-15	AAXJ	ETF	45.21	46.02	44.96	46.02	141200.0
2009-07-15	ACWI	ETF	34.63	35.24	34.57	35.15	72100.0
2009-07-15	ACWX	ETF	33.47	34.0	33.37	33.91	21029.0
2009-07-15	ADRE	ETF	34.45	35.37	34.45	35.25	228054.0
2009-07-15	AFK	ETF	26.0	26.65	26.0	26.05	6667.0
2009-07-15	AGG	ETF	102.21	102.39	101.85	101.85	849600.0
2009-07-15	AGQ	ETF	76.9	77.2	75.98	76.7	152750.0
2009-07-15	AGZ	ETF	107.02	107.61	107.0123	107.37	26971.0
2009-07-15	AIA	ETF	33.0	33.849	33.0	33.77	50270.0
2009-07-15	AIQ	ETF	33.7	34.35	33.05	33.5	47209.0
2009-07-15	AIS	ETF	0.82	0.84	0.78	0.79	201698.0
2009-07-15	AIVI	ETF	35.18	35.77	35.14	35.76	13900.0
2009-07-15	AMJ	ETF	22.98	23.3699	22.88	23.3	138318.0
2009-07-15	AOA	ETF	25.1	25.78	25.1	25.44	9200.0
2009-07-15	AOK	ETF	25.6999	26.19	25.43	25.7275	12955.0
2009-07-15	AOM	ETF	25.33	25.9925	25.33	25.75	18285.0
2009-07-15	AOR	ETF	25.5	25.65	25.45	25.65	7495.0
2009-07-15	ARB	ETF	16.42	16.905	16.35	16.64	393114.0
2009-07-15	BAL	ETF	33.11	33.29	32.24	32.35	19260.0
2009-07-15	BBH	ETF	31.8667	31.8667	31.4933	31.82	629100.0
2009-07-15	BIL	ETF	91.76	91.76	91.72	91.72	149050.0
2009-07-15	BITS	ETF	22.0	22.0	21.456	21.9596	672.0
2009-07-15	BIV	ETF	77.41	77.49	76.84	76.84	135700.0
2009-07-15	BJK	ETF	20.58	20.97	20.58	20.84	16200.0
2009-07-15	BKF	ETF	34.27	35.42	34.24	35.36	192809.0
2009-07-15	BLV	ETF	74.06	74.18	73.51	73.51	33500.0
2009-07-15	BMVP	ETF	10.92	11.077	10.92	11.058	13632.0
2009-07-15	BND	ETF	77.52	77.59	77.3	77.34	1087100.0
2009-07-15	BNE	ETF	6.55	7.39	6.5	7.12	374737.0
2009-07-15	BRF	ETF	28.83	29.67	28.82	29.4412	219642.0
2009-07-15	BSV	ETF	79.26	79.27	79.1	79.11	212800.0
2009-07-15	BTF	ETF	48.3	49.5	48.2	49.3	21430.600000000002
2009-07-15	BWX	ETF	27.575	27.58	27.455	27.545	434510.0
2009-07-15	BWZ	ETF	35.43	35.49	35.3	35.3708	6992.0
2009-07-15	BZQ	ETF	9739.2	9739.2	9051.2	9060.8	30.0
2009-07-15	CBON	ETF	0.83	0.87	0.8	0.84	49278.0
2009-07-15	CEF	ETF	11.65	11.77	11.61	11.77	696400.0
2009-07-15	CEW	ETF	20.7	20.87	20.6801	20.86	9411.0
2009-07-15	CGO	ETF	11.62	11.71	11.6	11.64	15717.0
2009-07-15	CGW	ETF	15.41	15.81	15.3417	15.54	62929.0
2009-07-15	CHB	ETF	0.273	0.31	0.273	0.3	273692.0
2009-07-15	CHI	ETF	10.44	10.56	10.27	10.5	142985.0
2009-07-15	CHIC	ETF	12.69	12.94	12.2	12.44	295923.0
2009-07-15	CHW	ETF	6.75	6.75	6.53	6.62	332699.0

> showing 50 of 666 rows — these rows as CSV

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