PREVIEW / etf_daily / 2007-04-04

all etf daily files

  file:    by_date/etf_daily/2007/2007-04-04.parquet
  size:    21 KB
  rows:    437

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-04-04	SPY	ETF	143.69	143.95	143.16	143.85	63995200.0
2007-04-04	QQQ	ETF	44.2	44.38	44.13	44.34	85195268.0
2007-04-04	IWM	ETF	80.48	80.59	80.0	80.49	35754200.0
2007-04-04	DIA	ETF	125.08	125.34	124.87	125.18	4879800.0
2007-04-04	GLD	ETF	66.09	66.98	66.0	66.81	7126100.0
2007-04-04	TLT	ETF	88.17	88.34	87.9	88.08	576900.0
2007-04-04	AAA	ETF	66.12	66.43	66.0	66.39	14500.0
2007-04-04	ADRE	ETF	40.55	40.6	40.2915	40.58	199122.0
2007-04-04	AGG	ETF	100.01	100.11	99.91	100.01	181400.0
2007-04-04	AIQ	ETF	41.7	45.0	41.7	44.15	124980.0
2007-04-04	AIS	ETF	1.51	1.59	1.5	1.59	542500.0
2007-04-04	ARB	ETF	47.94	47.99	47.39	47.72	101400.0
2007-04-04	BAB	ETF	100.47	100.86	100.21	100.7	44200.0
2007-04-04	BBH	ETF	58.9167	59.5167	58.9167	59.4233	445200.0
2007-04-04	BITS	ETF	31.12	32.28	30.8	31.88	14379.0
2007-04-04	BNE	ETF	15.86	15.95	15.68	15.9	110300.0
2007-04-04	BRF	ETF	14.5	14.52	14.5	14.52	1400.0
2007-04-04	BTF	ETF	109.55	110.29999999999998	109.55	110.29999999999998	1380.0
2007-04-04	CBON	ETF	31.16	31.25	30.372	30.53	33060.0
2007-04-04	CDL	ETF	9.58	9.64	9.48	9.57	199500.0
2007-04-04	CEF	ETF	9.45	9.5	9.42	9.5	253300.0
2007-04-04	CGO	ETF	17.17	17.23	17.09	17.18	11700.0
2007-04-04	CHB	ETF	8.89	8.93	8.73	8.89	779900.0
2007-04-04	CHI	ETF	20.27	20.39	20.24	20.38	46800.0
2007-04-04	CHIC	ETF	29.93	30.26	29.7	29.95	281708.0
2007-04-04	CHY	ETF	16.95	17.06	16.95	16.98	82900.0
2007-04-04	CN	ETF	51.18	51.45	50.93	51.28	35500.0
2007-04-04	CNXT	ETF	1.62	1.65	1.62	1.64	5818167.0
2007-04-04	CPI	ETF	21.9	21.9	21.8	21.8	400.0
2007-04-04	CPST	ETF	1.02	1.02	0.93	0.99	2188921.0
2007-04-04	CSA	ETF	20.94	21.43	20.94	21.0	31800.0
2007-04-04	CSB	ETF	33.21	33.34	33.09	33.21	8600.0
2007-04-04	CSD	ETF	27.7	27.8	27.7	27.8	21300.0
2007-04-04	CSM	ETF	1.3575	1.3575	1.3575	1.3575	4000.0
2007-04-04	CSQ	ETF	15.16	15.26	15.16	15.24	244500.0
2007-04-04	CTEC	ETF	86.95	87.75	84.8	85.85000000000001	12750.800000000001
2007-04-04	CVY	ETF	26.83	26.83	26.7	26.77	18100.0
2007-04-04	CWI	ETF	27.0667	27.0667	25.8133	25.94	82500.0
2007-04-04	CZA	ETF	25.41	25.43	25.41	25.43	900.0
2007-04-04	DBA	ETF	25.05	25.3	24.87	25.18	270800.0
2007-04-04	DBB	ETF	25.66	26.41	25.66	26.21	38600.0
2007-04-04	DBC	ETF	24.99	25.36	24.91	25.31	122000.0
2007-04-04	DBE	ETF	27.11	27.83	27.11	27.8	54600.0
2007-04-04	DBO	ETF	26.67	26.72	26.21	26.52	6500.0
2007-04-04	DBP	ETF	26.45	26.66	26.45	26.66	12900.0
2007-04-04	DBS	ETF	26.56	26.82	26.56	26.82	11600.0
2007-04-04	DBV	ETF	27.19	27.3	27.12	27.28	66000.0
2007-04-04	DDM	ETF	6.8667	6.8808	6.8375	6.8683	512400.0
2007-04-04	DEF	ETF	26.25	26.35	26.25	26.35	12700.0
2007-04-04	DES	ETF	19.35	19.35	19.24	19.2867	83700.0

> showing 50 of 437 rows — these rows as CSV

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