PREVIEW / etf_daily / 2007-02-07

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-07.parquet
  size:    21 KB
  rows:    429

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-02-07	SPY	ETF	145.12	145.36	144.57	145.21	55669700.0
2007-02-07	QQQ	ETF	44.29	44.65	44.12	44.46	118013491.0
2007-02-07	IWM	ETF	80.55	81.21	80.28	81.18	30708600.0
2007-02-07	DIA	ETF	126.76	127.06	126.33	126.79	5930400.0
2007-02-07	GLD	ETF	64.78	65.15	64.48	64.63	3075300.0
2007-02-07	TLT	ETF	87.9	88.12	87.84	88.06	836200.0
2007-02-07	AAA	ETF	61.0	61.27	60.8901	61.19	2300.0
2007-02-07	ADRE	ETF	40.07	40.13	39.78	39.97	118232.0
2007-02-07	AGG	ETF	99.86	99.94	99.72	99.9	289800.0
2007-02-07	AIQ	ETF	35.3	35.6	35.0	35.6	55680.0
2007-02-07	AIS	ETF	1.28	1.28	1.19	1.25	171000.0
2007-02-07	ARB	ETF	47.1	47.39	47.05	47.26	130600.0
2007-02-07	BAB	ETF	112.43	114.67	112.41	114.0	189000.0
2007-02-07	BBC	ETF	4.751	4.76	4.7	4.71	152600.0
2007-02-07	BBH	ETF	63.2167	63.8733	63.2167	63.5833	434400.0
2007-02-07	BITS	ETF	40.64	41.44	39.72	39.96	17948.0
2007-02-07	BNE	ETF	15.38	15.49	15.35	15.4	62500.0
2007-02-07	BRF	ETF	14.52	14.52	14.47	14.51	14000.0
2007-02-07	BTF	ETF	110.25	112.5	110.25	112.5	6460.0
2007-02-07	CBON	ETF	33.2	33.5	33.09	33.5	29583.0
2007-02-07	CDL	ETF	10.9	11.01	10.76	10.96	463400.0
2007-02-07	CEF	ETF	9.58	9.64	9.51	9.52	205000.0
2007-02-07	CGO	ETF	17.11	17.2	17.09	17.2	22300.0
2007-02-07	CHB	ETF	8.29	8.38	8.18	8.38	860600.0
2007-02-07	CHI	ETF	20.3	20.38	20.27	20.27	78900.0
2007-02-07	CHIC	ETF	30.61	30.8	30.14	30.3	509768.0
2007-02-07	CHY	ETF	17.36	17.42	17.3	17.33	172400.0
2007-02-07	CIL	ETF	25.49	25.49	25.49	25.49	300.0
2007-02-07	CN	ETF	50.9	51.41	50.66	51.11	112400.0
2007-02-07	CNXT	ETF	1.97	2.0	1.95	1.98	9118900.0
2007-02-07	CPI	ETF	24.05	24.16	24.05	24.13	800.0
2007-02-07	CPST	ETF	0.89	0.9	0.87	0.8796	1738229.0
2007-02-07	CSA	ETF	22.47	22.49	22.35	22.42	10800.0
2007-02-07	CSB	ETF	33.7	34.06	33.7	33.94	12400.0
2007-02-07	CSD	ETF	26.18	26.27	26.15	26.2	34400.0
2007-02-07	CSM	ETF	1.34	1.34	1.34	1.34	400.0
2007-02-07	CSQ	ETF	15.64	15.66	15.47	15.54	404700.0
2007-02-07	CTEC	ETF	87.6	87.65	86.85	87.5	27721.2
2007-02-07	CVY	ETF	27.21	27.27	27.19	27.25	23600.0
2007-02-07	CWI	ETF	25.02	25.12	25.0067	25.0533	7350.0
2007-02-07	DBA	ETF	25.6	25.73	25.54	25.66	132200.0
2007-02-07	DBB	ETF	22.4	22.53	22.18	22.29	8600.0
2007-02-07	DBC	ETF	23.95	24.1	23.6103	23.72	179500.0
2007-02-07	DBE	ETF	25.4	25.46	24.77	24.81	27700.0
2007-02-07	DBO	ETF	24.82	24.82	24.11	24.26	44400.0
2007-02-07	DBP	ETF	26.13	26.25	26.02	26.02	6000.0
2007-02-07	DBS	ETF	27.03	27.0932	26.9	26.9	7800.0
2007-02-07	DBV	ETF	26.19	26.29	26.1	26.24	127300.0
2007-02-07	DDM	ETF	7.1	7.1367	7.0583	7.0942	672000.0
2007-02-07	DEF	ETF	26.3	26.38	26.26	26.34	19600.0

> showing 50 of 429 rows — these rows as CSV

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