PREVIEW / etf_daily / 2009-09-02

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-02.parquet
  size:    29 KB
  rows:    669

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-09-02	SPY	ETF	99.78	100.44	99.57	99.82	171805000.0
2009-09-02	QQQ	ETF	39.09	39.47	39.04	39.25	92757103.0
2009-09-02	IWM	ETF	55.65	56.06	55.47	55.64	43436100.0
2009-09-02	DIA	ETF	92.94	93.42	92.71	92.83	10922400.0
2009-09-02	GLD	ETF	94.7	96.26	94.57	96.19	27673700.0
2009-09-02	TLT	ETF	96.48	97.66	96.24	97.46	4345000.0
2009-09-02	AAXJ	ETF	47.58	48.33	47.58	48.03	117300.0
2009-09-02	ACWI	ETF	37.8	38.23	37.68	38.07	87600.0
2009-09-02	ACWX	ETF	36.93	37.18	36.8	37.0	12275.0
2009-09-02	ADRE	ETF	36.74	37.48	36.74	37.25	136522.0
2009-09-02	AFK	ETF	27.66	27.75	27.112	27.71	9386.0
2009-09-02	AGG	ETF	103.66	104.18	103.51	104.06	843200.0
2009-09-02	AGQ	ETF	95.48	100.96	93.18	100.9	169900.0
2009-09-02	AGZ	ETF	108.35	108.5	108.08	108.5	8546.0
2009-09-02	AIA	ETF	35.32	35.6286	35.23	35.23	81101.0
2009-09-02	AIQ	ETF	26.25	26.5	25.6	25.85	154365.0
2009-09-02	AIS	ETF	0.91	0.93	0.89	0.92	386750.0
2009-09-02	AIVI	ETF	39.04	39.59	39.04	39.43	11700.0
2009-09-02	AMJ	ETF	23.58	23.58	23.3201	23.36	343271.0
2009-09-02	AOA	ETF	27.36	27.42	27.27	27.42	10500.0
2009-09-02	AOK	ETF	26.61	26.61	26.2001	26.5	3371.0
2009-09-02	AOM	ETF	27.17	27.22	27.0	27.0	5399.0
2009-09-02	AOR	ETF	27.16	27.1861	26.61	27.174	19856.0
2009-09-02	ARB	ETF	17.58	17.89	17.5	17.76	236491.0
2009-09-02	BAL	ETF	30.47	30.59	30.41	30.54	600.0
2009-09-02	BBH	ETF	32.73	33.4267	32.73	33.1167	261300.0
2009-09-02	BIL	ETF	91.74	91.76	91.68	91.76	334750.0
2009-09-02	BITS	ETF	20.0	20.0	19.0	19.72	2786.0
2009-09-02	BIV	ETF	79.65	80.09	79.48	79.94	137300.0
2009-09-02	BJK	ETF	22.8	23.52	22.8	23.18	30700.0
2009-09-02	BKF	ETF	36.5	36.8294	36.29	36.61	510435.0
2009-09-02	BLV	ETF	77.98	78.63	77.71	78.57	29100.0
2009-09-02	BMVP	ETF	11.5	11.525	11.46	11.46	20860.0
2009-09-02	BND	ETF	78.78	79.06	78.69	78.97	390700.0
2009-09-02	BNE	ETF	6.62	6.8	6.48	6.67	253101.0
2009-09-02	BOSS	ETF	18.26	18.26	18.16	18.21	200.0
2009-09-02	BRF	ETF	34.28	35.172	34.11	34.84	169828.0
2009-09-02	BSV	ETF	79.96	80.0	79.76	79.93	368700.0
2009-09-02	BTF	ETF	55.99999999999999	56.49949999999999	55.8	56.39999999999999	5578.0
2009-09-02	BWX	ETF	28.22	28.39	28.12	28.235	524048.0
2009-09-02	BWZ	ETF	36.02	36.2	36.02	36.1999	15545.0
2009-09-02	BZQ	ETF	7712.0	7750.4	7428.8	7539.2	49.5
2009-09-02	CEF	ETF	12.23	12.74	12.23	12.68	1714500.0
2009-09-02	CEW	ETF	21.05	21.2708	21.05	21.14	8153.0
2009-09-02	CGO	ETF	13.0	13.08	12.9	12.96	22349.0
2009-09-02	CGW	ETF	16.61	16.6899	16.5	16.63	35943.0
2009-09-02	CHB	ETF	0.55	0.62	0.522	0.55	1528984.0
2009-09-02	CHI	ETF	10.92	11.08	10.81	11.0	141230.0
2009-09-02	CHIC	ETF	17.39	17.41	17.39	17.39	685885.0
2009-09-02	CHW	ETF	7.15	7.32	7.08	7.22	241823.0

> showing 50 of 669 rows — these rows as CSV

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