PREVIEW / etf_daily / 2007-10-12

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-12.parquet
  size:    23 KB
  rows:    502

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-10-12	SPY	ETF	155.46	156.35	155.27	156.33	124546700.0
2007-10-12	QQQ	ETF	52.9	53.54	52.8	53.53	131675908.0
2007-10-12	IWM	ETF	83.28	84.08	83.21	83.82	60997500.0
2007-10-12	DIA	ETF	140.37	141.12	140.09	141.12	7714600.0
2007-10-12	GLD	ETF	73.93	74.59	73.75	74.59	3604200.0
2007-10-12	TLT	ETF	87.52	88.18	87.48	87.63	1133900.0
2007-10-12	ADRE	ETF	55.0	56.8	55.0	56.7	174703.0
2007-10-12	AGG	ETF	99.55	99.65	99.32	99.45	470400.0
2007-10-12	AIQ	ETF	46.2	49.4	46.0	49.25	37420.0
2007-10-12	AIS	ETF	1.4	1.41	1.38	1.4	98900.0
2007-10-12	AIVI	ETF	75.43	75.75	75.21	75.54	16800.0
2007-10-12	ARB	ETF	45.95	46.15	44.95	45.08	844900.0
2007-10-12	BBH	ETF	59.33	60.0633	59.1767	59.9833	804000.0
2007-10-12	BIL	ETF	91.74	91.74	91.66	91.7	14250.0
2007-10-12	BITS	ETF	26.6	27.36	26.6	26.88	7701.0
2007-10-12	BIV	ETF	75.09	75.32	75.09	75.12	8600.0
2007-10-12	BLV	ETF	74.27	74.68	74.27	74.39	1700.0
2007-10-12	BMVP	ETF	17.6	17.7676	17.6	17.7133	38700.0
2007-10-12	BND	ETF	75.32	75.48	75.29	75.35	61200.0
2007-10-12	BNE	ETF	17.65	18.09	17.65	18.05	115200.0
2007-10-12	BOSS	ETF	48.08	48.25	48.08	48.25	300.0
2007-10-12	BRF	ETF	14.61	14.61	14.57	14.58	15700.0
2007-10-12	BSV	ETF	75.68	75.75	75.64	75.69	26000.0
2007-10-12	BTF	ETF	110.6	111.25	110.6	111.25	540.0
2007-10-12	BWX	ETF	26.01	26.02	25.925	25.94	64600.0
2007-10-12	CBON	ETF	25.43	25.63	25.2	25.5	33592.0
2007-10-12	CDL	ETF	4.75	4.8	4.54	4.56	2436411.0
2007-10-12	CEF	ETF	10.0	10.04	9.89	10.01	390500.0
2007-10-12	CGO	ETF	18.37	18.45	18.27	18.38	14500.0
2007-10-12	CGW	ETF	26.38	26.44	26.12	26.38	102800.0
2007-10-12	CHB	ETF	11.91	12.35	11.9	12.23	1008800.0
2007-10-12	CHI	ETF	17.09	17.17	17.0	17.07	97100.0
2007-10-12	CHIC	ETF	14.7	14.92	14.36	14.76	800744.0
2007-10-12	CHW	ETF	13.34	13.45	13.26	13.38	104300.0
2007-10-12	CHY	ETF	15.46	15.48	15.24	15.27	116800.0
2007-10-12	CMF	ETF	51.65	51.7	51.61	51.61	4200.0
2007-10-12	CN	ETF	59.63	60.87	59.41	60.7	208500.0
2007-10-12	CNXT	ETF	1.38	1.44	1.38	1.44	6698362.0
2007-10-12	CPI	ETF	24.4999	24.78	24.4999	24.78	800.0
2007-10-12	CPST	ETF	1.13	1.15	1.1	1.13	2359519.0
2007-10-12	CSA	ETF	18.65	18.65	18.0	18.15	29600.0
2007-10-12	CSD	ETF	29.75	29.92	29.75	29.83	38500.0
2007-10-12	CSQ	ETF	14.89	14.89	14.74	14.78	192800.0
2007-10-12	CVY	ETF	26.74	26.74	26.59	26.61	15400.0
2007-10-12	CWI	ETF	29.2667	29.46	29.2667	29.3933	17850.0
2007-10-12	CZA	ETF	27.28	27.28	27.28	27.28	1100.0
2007-10-12	DBA	ETF	28.89	28.94	28.56	28.78	445900.0
2007-10-12	DBB	ETF	26.59	26.72	26.41	26.49	38200.0
2007-10-12	DBC	ETF	28.0	28.17	27.8901	28.12	164900.0
2007-10-12	DBE	ETF	30.83	31.16	30.83	31.16	68800.0

> showing 50 of 502 rows — these rows as CSV

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