PREVIEW / etf_daily / 2007-03-29

all etf daily files

  file:    by_date/etf_daily/2007/2007-03-29.parquet
  size:    21 KB
  rows:    432

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
2007-03-29	SPY	ETF	142.54	142.61	141.19	141.97	139432700.0
2007-03-29	QQQ	ETF	43.84	43.85	43.1	43.57	124450174.0
2007-03-29	IWM	ETF	79.69	79.76	78.49	79.25	49841400.0
2007-03-29	DIA	ETF	123.67	123.72	122.56	123.3	9107700.0
2007-03-29	GLD	ETF	65.97	66.0	64.93	65.65	5448300.0
2007-03-29	TLT	ETF	88.54	88.67	88.32	88.45	823000.0
2007-03-29	AAA	ETF	64.57	64.61	64.36	64.5	6300.0
2007-03-29	ADRE	ETF	39.89	39.89	39.22	39.75	171248.0
2007-03-29	AGG	ETF	100.36	100.42	100.21	100.26	223000.0
2007-03-29	AIQ	ETF	42.35	42.95	41.75	42.8	26940.0
2007-03-29	AIS	ETF	1.2	1.21	1.18	1.1901	125800.0
2007-03-29	ARB	ETF	46.87	46.87	46.27	46.8	156300.0
2007-03-29	BAB	ETF	98.63	99.15	97.35	97.78	27500.0
2007-03-29	BBH	ETF	58.6667	58.9667	57.95	58.3067	942000.0
2007-03-29	BITS	ETF	32.68	32.68	31.28	31.92	25268.0
2007-03-29	BNE	ETF	15.38	15.62	15.33	15.6	132500.0
2007-03-29	BRF	ETF	14.51	14.51	14.5	14.5	800.0
2007-03-29	BTF	ETF	108.45	108.6	107.69999999999999	108.0	1680.0
2007-03-29	CBON	ETF	30.53	30.8	30.27	30.64	44412.0
2007-03-29	CDL	ETF	9.56	9.56	9.37	9.45	293500.0
2007-03-29	CEF	ETF	9.44	9.48	9.36	9.45	222400.0
2007-03-29	CGO	ETF	17.23	17.28	17.09	17.09	8100.0
2007-03-29	CHB	ETF	9.13	9.33	8.87	8.89	1738900.0
2007-03-29	CHI	ETF	20.19	20.208	20.12	20.13	46800.0
2007-03-29	CHIC	ETF	28.67	28.7	27.59	28.55	692331.0
2007-03-29	CHY	ETF	16.93	17.01	16.9	16.94	138100.0
2007-03-29	CN	ETF	52.5	52.69	51.15	51.89	278300.0
2007-03-29	CNXT	ETF	1.68	1.69	1.6199	1.65	8831085.0
2007-03-29	CPI	ETF	22.36	22.42	22.35	22.42	400.0
2007-03-29	CPST	ETF	1.03	1.08	0.98	1.06	4605263.0
2007-03-29	CSA	ETF	20.82	21.51	20.75	20.91	20700.0
2007-03-29	CSB	ETF	32.93	33.16	32.73	32.98	16700.0
2007-03-29	CSD	ETF	27.31	27.31	27.12	27.31	32700.0
2007-03-29	CSQ	ETF	15.15	15.19	15.03	15.07	210200.0
2007-03-29	CTEC	ETF	87.5	87.55	86.1	86.1	8762.0
2007-03-29	CVY	ETF	26.67	26.67	26.51	26.61	9600.0
2007-03-29	CWI	ETF	25.4	25.4733	25.32	25.4733	34950.0
2007-03-29	DBA	ETF	26.04	26.14	25.76	26.09	214600.0
2007-03-29	DBB	ETF	24.82	24.94	24.69	24.9	37900.0
2007-03-29	DBC	ETF	25.41	25.82	25.26	25.76	348800.0
2007-03-29	DBE	ETF	27.63	27.95	27.45	27.89	111900.0
2007-03-29	DBO	ETF	26.86	27.46	26.67	27.4	34700.0
2007-03-29	DBP	ETF	26.09	26.15	25.93	26.13	10300.0
2007-03-29	DBS	ETF	26.07	26.1604	25.8701	26.16	6300.0
2007-03-29	DBV	ETF	26.99	26.99	26.88	26.94	67800.0
2007-03-29	DDM	ETF	6.7133	6.7133	6.6	6.6917	981600.0
2007-03-29	DEF	ETF	25.95	25.99	25.77	25.865	35700.0
2007-03-29	DES	ETF	19.12	19.16	18.9633	19.0967	46500.0
2007-03-29	DEW	ETF	63.1	63.26	62.92	63.23	11900.0
2007-03-29	DFE	ETF	69.82	70.04	69.56	70.01	13700.0

> showing 50 of 432 rows — these rows as CSV

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