PREVIEW / etf_daily / 2007-06-27

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-27.parquet
  size:    22 KB
  rows:    484

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-06-27	SPY	ETF	148.13	150.57	148.06	150.4	213638000.0
2007-06-27	QQQ	ETF	46.74	47.56	46.7	47.54	141238628.0
2007-06-27	IWM	ETF	81.63	83.65	81.5	83.59	127640800.0
2007-06-27	DIA	ETF	132.71	134.22	132.53	134.12	20981000.0
2007-06-27	GLD	ETF	63.54	63.89	63.43	63.67	4689400.0
2007-06-27	TLT	ETF	84.61	84.74	84.2	84.32	6109300.0
2007-06-27	ADRE	ETF	44.4	45.28	44.298	45.21	287193.0
2007-06-27	AGG	ETF	98.36	98.46	98.13	98.24	214500.0
2007-06-27	AIQ	ETF	44.6	45.65	44.0	45.55	43160.0
2007-06-27	AIS	ETF	1.74	1.79	1.69	1.75	378700.0
2007-06-27	ARB	ETF	52.35	52.66	52.09	52.5	489800.0
2007-06-27	BBH	ETF	55.1767	56.0333	54.8733	55.98	1277100.0
2007-06-27	BIL	ETF	91.96	91.96	91.92	91.92	8200.0
2007-06-27	BITS	ETF	28.26	28.8796	27.48	27.96	28496.0
2007-06-27	BIV	ETF	73.85	73.85	73.61	73.61	12900.0
2007-06-27	BLV	ETF	72.85	72.92	72.63	72.63	11100.0
2007-06-27	BMVP	ETF	17.59	17.85	17.55	17.85	45500.0
2007-06-27	BND	ETF	74.27	74.27	74.1	74.13	212000.0
2007-06-27	BNE	ETF	19.12	19.77	19.1	19.75	264900.0
2007-06-27	BRF	ETF	14.6	14.6	14.48	14.49	12400.0
2007-06-27	BSV	ETF	74.99	75.02	74.88	74.92	37900.0
2007-06-27	BTF	ETF	106.3005	107.44999999999999	106.3005	107.44999999999999	1340.0
2007-06-27	CBON	ETF	27.64	28.166	27.6	27.99	96367.0
2007-06-27	CDL	ETF	5.95	6.19	5.91	6.1	5440795.0
2007-06-27	CEF	ETF	8.81	9.03	8.78	9.0	393400.0
2007-06-27	CGO	ETF	17.6	17.74	17.48	17.74	34800.0
2007-06-27	CGW	ETF	25.1	25.25	25.05	25.25	187900.0
2007-06-27	CHB	ETF	9.8	10.28	9.69	10.16	1890600.0
2007-06-27	CHI	ETF	19.0	19.43	18.84	19.34	231400.0
2007-06-27	CHIC	ETF	25.25	26.8	25.16	26.64	1140163.0
2007-06-27	CHY	ETF	15.6	16.0	15.6	16.0	215400.0
2007-06-27	CN	ETF	55.66	56.0	55.41	56.0	68500.0
2007-06-27	CNXT	ETF	1.4	1.45	1.38	1.43	4418552.0
2007-06-27	CPST	ETF	1.15	1.16	1.07	1.14	4861819.0
2007-06-27	CSA	ETF	19.44	19.72	19.14	19.72	135700.0
2007-06-27	CSB	ETF	31.86	32.19	31.8	32.19	12300.0
2007-06-27	CSD	ETF	30.5	30.78	30.26	30.78	14200.0
2007-06-27	CSQ	ETF	14.89	15.12	14.78	15.12	373200.0
2007-06-27	CTEC	ETF	109.1	112.69999999999999	108.6	112.39999999999999	52067.4
2007-06-27	CVY	ETF	27.25	27.48	27.03	27.48	20300.0
2007-06-27	CWI	ETF	26.8067	27.1133	26.7667	27.1133	146700.0
2007-06-27	CZA	ETF	26.9	26.9	26.9	26.9	1700.0
2007-06-27	DBA	ETF	26.65	26.71	25.97	26.24	303400.0
2007-06-27	DBB	ETF	25.98	26.22	25.77	26.22	29000.0
2007-06-27	DBC	ETF	25.81	25.94	25.59	25.8	219300.0
2007-06-27	DBE	ETF	28.3	28.77	28.2	28.6	7400.0
2007-06-27	DBO	ETF	26.51	26.92	26.41	26.73	17900.0
2007-06-27	DBP	ETF	25.12	25.14	25.04	25.12	3800.0
2007-06-27	DBS	ETF	24.15	24.29	24.04	24.17	6900.0
2007-06-27	DBV	ETF	28.97	28.98	28.74	28.85	186200.0

> showing 50 of 484 rows — these rows as CSV

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