PREVIEW / etf_daily / 2007-02-06

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-06.parquet
  size:    20 KB
  rows:    427

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-06	SPY	ETF	144.97	145.03	144.33	144.89	57081300.0
2007-02-06	QQQ	ETF	44.2	44.23	43.64	44.05	121184806.0
2007-02-06	IWM	ETF	80.26	80.46	79.79	80.44	31445600.0
2007-02-06	DIA	ETF	126.62	126.79	126.3	126.65	7254800.0
2007-02-06	GLD	ETF	65.05	65.1	64.53	64.79	2928800.0
2007-02-06	TLT	ETF	87.2	87.83	87.16	87.8	770500.0
2007-02-06	AAA	ETF	60.76	60.92	60.76	60.92	1100.0
2007-02-06	ADRE	ETF	39.86	40.06	39.732	40.03	185223.0
2007-02-06	AGG	ETF	99.7	99.8	99.37	99.78	236400.0
2007-02-06	AIQ	ETF	35.25	35.45	34.85	35.3	68920.0
2007-02-06	AIS	ETF	1.26	1.28	1.2	1.23	99500.0
2007-02-06	ARB	ETF	47.31	47.36	46.74	46.99	96000.0
2007-02-06	BAB	ETF	108.3	109.13	107.68	109.06	76000.0
2007-02-06	BBC	ETF	4.87	4.87	4.67	4.75	204000.0
2007-02-06	BBH	ETF	63.3	63.53	62.9767	63.4267	392700.0
2007-02-06	BITS	ETF	41.6	41.72	39.36	40.6	29459.0
2007-02-06	BNE	ETF	15.28	15.45	15.28	15.38	77100.0
2007-02-06	BOSS	ETF	43.03	43.65	43.03	43.65	100.0
2007-02-06	BRF	ETF	14.51	14.56	14.51	14.52	600.0
2007-02-06	BTF	ETF	108.9	110.05	108.05	110.0	5320.0
2007-02-06	CBON	ETF	33.35	33.35	33.0	33.2	36483.0
2007-02-06	CDL	ETF	10.64	10.95	10.63	10.9	349000.0
2007-02-06	CEF	ETF	9.56	9.69	9.56	9.61	243600.0
2007-02-06	CGO	ETF	17.35	17.35	17.15	17.24	12700.0
2007-02-06	CHB	ETF	8.28	8.42	8.15	8.27	687300.0
2007-02-06	CHI	ETF	20.35	20.42	20.32	20.34	79300.0
2007-02-06	CHIC	ETF	29.75	31.0599	29.58	30.58	701397.0
2007-02-06	CHY	ETF	17.43	17.51	17.35	17.39	137800.0
2007-02-06	CIL	ETF	25.48	25.49	25.48	25.49	400.0
2007-02-06	CN	ETF	50.76	51.94	50.76	51.6	72500.0
2007-02-06	CNXT	ETF	1.95	1.98	1.88	1.95	9995661.0
2007-02-06	CPST	ETF	0.91	0.91	0.8606	0.876	1473324.0
2007-02-06	CSA	ETF	22.5	22.51	22.4	22.48	5500.0
2007-02-06	CSB	ETF	33.5	33.69	33.4	33.68	9100.0
2007-02-06	CSD	ETF	26.1	26.23	26.04	26.23	12100.0
2007-02-06	CSM	ETF	1.33	1.335	1.33	1.335	34400.0
2007-02-06	CSQ	ETF	15.5	15.71	15.34	15.63	398000.0
2007-02-06	CTEC	ETF	87.10000000000001	87.69999999999999	86.8	87.55	24300.2
2007-02-06	CVY	ETF	27.17	27.2	27.1	27.2	27200.0
2007-02-06	CWI	ETF	24.9867	25.02	24.9133	25.0133	9150.0
2007-02-06	DBA	ETF	26.04	26.04	25.59	25.7	281200.0
2007-02-06	DBB	ETF	22.55	22.79	22.49	22.73	35800.0
2007-02-06	DBC	ETF	24.24	24.25	23.87	24.0101	473500.0
2007-02-06	DBE	ETF	25.51	25.54	25.14	25.32	9000.0
2007-02-06	DBO	ETF	25.0	25.13	24.55	24.59	8800.0
2007-02-06	DBP	ETF	26.23	26.23	26.06	26.1	9200.0
2007-02-06	DBS	ETF	27.06	27.07	26.85	26.8832	7900.0
2007-02-06	DBV	ETF	26.2	26.2	26.07	26.09	355300.0
2007-02-06	DDM	ETF	7.0892	7.1025	7.0558	7.0875	896400.0
2007-02-06	DEF	ETF	26.19	26.28	26.1501	26.28	28600.0

> showing 50 of 427 rows — these rows as CSV

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