PREVIEW / etf_daily / 2007-09-19

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-19.parquet
  size:    23 KB
  rows:    508

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-19	SPY	ETF	153.41	154.39	152.71	153.36	193779900.0
2007-09-19	QQQ	ETF	50.29	50.59	49.98	50.17	127025724.0
2007-09-19	IWM	ETF	81.27	82.1	77.26	81.6	114738300.0
2007-09-19	DIA	ETF	138.19	139.31	137.89	138.16	13554200.0
2007-09-19	GLD	ETF	71.74	71.8	71.25	71.43	10937800.0
2007-09-19	TLT	ETF	88.71	89.01	88.37	88.83	3854700.0
2007-09-19	ADRE	ETF	50.5	50.906	49.99	50.22	456689.0
2007-09-19	AGG	ETF	100.1	100.19	99.83	100.13	441200.0
2007-09-19	AIQ	ETF	45.95	46.25	44.25	44.75	59540.0
2007-09-19	AIS	ETF	1.46	1.46	1.42	1.4299	125700.0
2007-09-19	ARB	ETF	47.78	47.78	46.35	46.7	384800.0
2007-09-19	BBH	ETF	58.5567	58.7867	58.33	58.6467	362400.0
2007-09-19	BIL	ETF	91.86	91.86	91.74	91.84	66750.0
2007-09-19	BITS	ETF	28.08	28.52	27.12	27.6	6326.0
2007-09-19	BIV	ETF	75.52	75.52	75.25	75.49	20900.0
2007-09-19	BLV	ETF	74.72	74.77	74.43	74.77	24700.0
2007-09-19	BMVP	ETF	17.3	17.4057	17.2153	17.27	92300.0
2007-09-19	BND	ETF	75.8	75.8	75.59	75.7	93600.0
2007-09-19	BNE	ETF	16.75	17.0	16.71	16.83	386600.0
2007-09-19	BRF	ETF	14.57	14.6044	14.57	14.58	7500.0
2007-09-19	BSV	ETF	76.01	76.02	75.92	76.01	41400.0
2007-09-19	BTF	ETF	106.35	110.89999999999999	106.35	107.85	8740.0
2007-09-19	CBON	ETF	25.67	26.71	25.11	26.26	117315.0
2007-09-19	CDL	ETF	4.42	4.53	4.3	4.5	2306400.0
2007-09-19	CEF	ETF	9.54	9.55	9.4	9.46	727800.0
2007-09-19	CGO	ETF	17.72	17.72	17.47	17.5	16700.0
2007-09-19	CGW	ETF	25.32	25.39	25.116	25.19	72100.0
2007-09-19	CHB	ETF	11.4	11.81	10.8	11.01	2565200.0
2007-09-19	CHI	ETF	16.73	17.14	16.72	17.05	178000.0
2007-09-19	CHIC	ETF	17.86	17.92	17.42	17.63	633721.0
2007-09-19	CHW	ETF	13.36	13.6	13.25	13.53	231100.0
2007-09-19	CHY	ETF	14.84	15.16	14.8	15.069	165700.0
2007-09-19	CN	ETF	48.61	49.71	48.24	48.42	266600.0
2007-09-19	CNXT	ETF	1.31	1.32	1.26	1.29	6983367.0
2007-09-19	CPI	ETF	24.6	24.6	23.901	24.08	1400.0
2007-09-19	CPST	ETF	1.25	1.28	1.18	1.23	1976897.0
2007-09-19	CSA	ETF	18.78	19.43	18.6	18.65	124800.0
2007-09-19	CSD	ETF	29.27	29.39	29.2	29.23	38900.0
2007-09-19	CSM	ETF	1.4725	1.475	1.4625	1.4625	8800.0
2007-09-19	CSQ	ETF	14.4	14.62	14.38	14.57	465900.0
2007-09-19	CVY	ETF	26.67	26.84	26.59	26.66	18200.0
2007-09-19	CWI	ETF	27.6533	27.7533	27.4933	27.5267	34200.0
2007-09-19	CZA	ETF	26.29	26.29	26.29	26.29	200.0
2007-09-19	DBA	ETF	27.63	27.98	27.1	27.9	399200.0
2007-09-19	DBB	ETF	26.05	26.2	25.85	26.05	65300.0
2007-09-19	DBC	ETF	26.94	27.08	26.8	27.08	243600.0
2007-09-19	DBE	ETF	30.28	30.38	29.96	30.27	21100.0
2007-09-19	DBO	ETF	28.87	29.0	27.86	28.82	48800.0
2007-09-19	DBP	ETF	27.76	27.81	27.61	27.73	33300.0
2007-09-19	DBS	ETF	25.52	25.56	25.42	25.5099	1700.0

> showing 50 of 508 rows — these rows as CSV

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