PREVIEW / etf_daily / 2007-09-20

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-20.parquet
  size:    23 KB
  rows:    504

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-09-20	SPY	ETF	153.34	153.43	152.11	152.28	175186800.0
2007-09-20	QQQ	ETF	50.06	50.26	49.92	50.03	109970577.0
2007-09-20	IWM	ETF	81.5	81.54	80.25	80.79	128460700.0
2007-09-20	DIA	ETF	138.29	138.31	137.53	137.7	9651600.0
2007-09-20	GLD	ETF	72.15	73.1	71.95	72.72	11945000.0
2007-09-20	TLT	ETF	88.18	88.29	87.1	87.15	5903200.0
2007-09-20	ADRE	ETF	50.16	50.538	49.7	49.88	266526.0
2007-09-20	AGG	ETF	99.94	99.96	99.35	99.42	282100.0
2007-09-20	AIQ	ETF	44.6	44.85	44.1	44.65	54420.0
2007-09-20	AIS	ETF	1.41	1.45	1.4	1.42	57300.0
2007-09-20	ARB	ETF	46.57	46.92	45.71	46.22	475800.0
2007-09-20	BBH	ETF	58.5933	58.83	58.34	58.34	632400.0
2007-09-20	BIL	ETF	91.88	91.88	91.78	91.78	22250.0
2007-09-20	BITS	ETF	27.52	27.88	26.6	26.64	12503.0
2007-09-20	BIV	ETF	75.23	75.31	74.63	74.7	19200.0
2007-09-20	BLV	ETF	74.35	74.47	73.57	73.7	17700.0
2007-09-20	BMVP	ETF	17.2533	17.29	17.1187	17.14	105100.0
2007-09-20	BND	ETF	75.55	75.58	75.14	75.16	112700.0
2007-09-20	BNE	ETF	16.75	17.0	16.73	16.73	310000.0
2007-09-20	BRF	ETF	14.57	14.57	14.53	14.54	8000.0
2007-09-20	BSV	ETF	75.95	75.97	75.8	75.85	31700.0
2007-09-20	BTF	ETF	107.25049999999999	107.94999999999999	106.6	106.6	900.0
2007-09-20	CBON	ETF	26.1	26.64	25.91	26.26	91193.0
2007-09-20	CDL	ETF	4.48	4.48	4.22	4.28	1476400.0
2007-09-20	CEF	ETF	9.57	9.72	9.55	9.66	1592800.0
2007-09-20	CGO	ETF	17.51	17.51	17.29	17.35	25400.0
2007-09-20	CGW	ETF	25.18	25.32	25.0	25.15	50400.0
2007-09-20	CHB	ETF	11.01	11.01	10.24	10.42	2783600.0
2007-09-20	CHI	ETF	17.06	17.12	16.81	16.86	147300.0
2007-09-20	CHIC	ETF	17.61	17.69	17.12	17.19	326851.0
2007-09-20	CHW	ETF	13.53	13.7	13.41	13.58	103000.0
2007-09-20	CHY	ETF	15.07	15.11	14.7766	14.8	187600.0
2007-09-20	CN	ETF	47.55	47.9099	47.15	47.47	147700.0
2007-09-20	CNXT	ETF	1.28	1.29	1.26	1.26	4900252.0
2007-09-20	CPI	ETF	23.95	23.95	23.95	23.95	2600.0
2007-09-20	CPST	ETF	1.22	1.23	1.18	1.18	725095.0
2007-09-20	CSA	ETF	18.55	18.64	18.42	18.45	39700.0
2007-09-20	CSD	ETF	29.23	29.23	28.93	29.02	56900.0
2007-09-20	CSM	ETF	1.465	1.465	1.465	1.465	2000.0
2007-09-20	CSQ	ETF	14.57	14.58	14.37	14.52	365400.0
2007-09-20	CVY	ETF	26.63	26.63	26.29	26.31	13800.0
2007-09-20	CWI	ETF	27.7533	27.7533	27.56	27.5867	10350.0
2007-09-20	CZA	ETF	26.1	26.12	26.1	26.12	700.0
2007-09-20	DBA	ETF	28.08	29.25	28.07	28.62	968900.0
2007-09-20	DBB	ETF	25.67	25.9	25.61	25.84	29800.0
2007-09-20	DBC	ETF	27.15	27.5	27.07	27.5	519300.0
2007-09-20	DBE	ETF	30.43	30.87	30.27	30.67	27300.0
2007-09-20	DBO	ETF	29.0	29.52	28.78	29.41	8700.0
2007-09-20	DBP	ETF	28.11	28.34	28.11	28.27	57900.0
2007-09-20	DBS	ETF	26.15	26.5	26.0601	26.3	29300.0

> showing 50 of 504 rows — these rows as CSV

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