PREVIEW / etf_daily / 2009-04-29

all etf daily files

  file:    by_date/etf_daily/2009/2009-04-29.parquet
  size:    28 KB
  rows:    642

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-04-29	SPY	ETF	86.52	88.36	86.3	87.39	311505700.0
2009-04-29	QQQ	ETF	33.75	34.4	33.64	33.94	141413571.0
2009-04-29	IWM	ETF	47.81	49.57	47.63	48.97	79875900.0
2009-04-29	DIA	ETF	80.82	82.55	80.69	81.77	18084100.0
2009-04-29	GLD	ETF	88.31	88.78	87.67	88.33	8098300.0
2009-04-29	TLT	ETF	99.67	100.08	98.15	98.47	3752600.0
2009-04-29	AAXJ	ETF	37.08	38.38	36.84	38.11	139300.0
2009-04-29	ACWI	ETF	31.41	32.09	31.33	31.7	71800.0
2009-04-29	ACWX	ETF	29.61	30.19	29.61	29.92	22434.0
2009-04-29	ADRE	ETF	30.17	31.17	30.17	30.8	238782.0
2009-04-29	AFK	ETF	21.74	21.89	21.55	21.89	1800.0
2009-04-29	AGG	ETF	101.69	101.69	101.1	101.15	488000.0
2009-04-29	AGQ	ETF	72.84	75.14	72.36	74.1	98050.0
2009-04-29	AGZ	ETF	108.314	108.59	107.746	108.25	23018.0
2009-04-29	AIA	ETF	27.98	28.97	27.98	28.3	25016.0
2009-04-29	AIQ	ETF	41.0	43.65	40.85	43.65	82585.0
2009-04-29	AIS	ETF	0.42	0.42	0.39	0.41	104857.0
2009-04-29	AIVI	ETF	31.44	32.25	31.44	31.91	11800.0
2009-04-29	AMJ	ETF	21.4	21.53	21.4	21.53	16787.0
2009-04-29	AOA	ETF	23.8	24.03	23.8	23.86	21200.0
2009-04-29	AOM	ETF	24.89	24.9945	24.87	24.9945	1444.0
2009-04-29	AOR	ETF	24.3572	24.61	24.35	24.432	6426.0
2009-04-29	ARB	ETF	20.85	21.8	20.49	21.35	729672.0
2009-04-29	BAL	ETF	30.22	30.39	29.94	29.94	3672.0
2009-04-29	BBH	ETF	30.4067	30.6733	30.1833	30.31	469200.0
2009-04-29	BIL	ETF	91.76	91.78	91.74	91.76	143450.0
2009-04-29	BITS	ETF	17.4	17.6004	17.4	17.6	3630.0
2009-04-29	BIV	ETF	76.72	77.5	76.3	76.45	73700.0
2009-04-29	BJK	ETF	19.23	19.86	19.21	19.35	1335700.0
2009-04-29	BKF	ETF	28.92	29.69	28.74	29.35	66969.0
2009-04-29	BLV	ETF	72.83	73.29	72.0	72.46	9700.0
2009-04-29	BMVP	ETF	10.4	10.7	10.4	10.5	24796.0
2009-04-29	BND	ETF	77.24	77.33	76.9	77.01	374800.0
2009-04-29	BNE	ETF	5.29	5.49	5.29	5.46	108542.0
2009-04-29	BSV	ETF	79.0	79.46	78.8	78.92	168100.0
2009-04-29	BTF	ETF	45.599999999999994	47.15	45.599999999999994	46.9	21762.4
2009-04-29	BWX	ETF	25.905	26.6	25.905	25.915	162270.0
2009-04-29	BWZ	ETF	33.36	33.45	33.31	33.31	4649.0
2009-04-29	CBON	ETF	2.41	2.736	2.39	2.47	16697.0
2009-04-29	CEF	ETF	11.27	11.45	11.14	11.33	888100.0
2009-04-29	CGO	ETF	9.74	9.84	9.52	9.73	29074.0
2009-04-29	CGW	ETF	13.51	13.95	13.51	13.8	53542.0
2009-04-29	CHB	ETF	0.61	0.61	0.58	0.6	427742.0
2009-04-29	CHI	ETF	9.46	9.49	9.2082	9.35	184226.0
2009-04-29	CHIC	ETF	12.35	12.69	12.04	12.37	324862.0
2009-04-29	CHW	ETF	6.45	6.5134	6.33	6.37	258681.0
2009-04-29	CHY	ETF	9.16	9.19	8.9	9.04	218751.0
2009-04-29	CMF	ETF	52.455	52.535	52.43	52.43	32794.0
2009-04-29	CNXT	ETF	1.24	1.39	1.24	1.3	532545.0
2009-04-29	COW	ETF	29.8	30.2679	29.7766	30.21	19621.0

> showing 50 of 642 rows — these rows as CSV

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