PREVIEW / etf_daily / 2007-08-27

all etf daily files

  file:    by_date/etf_daily/2007/2007-08-27.parquet
  size:    23 KB
  rows:    496

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-08-27	SPY	ETF	147.85	148.33	146.73	146.95	113024300.0
2007-08-27	QQQ	ETF	48.05	48.2	47.84	47.88	72490363.0
2007-08-27	IWM	ETF	79.36	79.47	78.49	78.53	60380700.0
2007-08-27	DIA	ETF	133.35	133.79	132.98	133.12	8506400.0
2007-08-27	GLD	ETF	66.01	66.05	65.86	65.98	1865700.0
2007-08-27	TLT	ETF	88.28	88.48	88.15	88.31	1585400.0
2007-08-27	ADRE	ETF	45.57	46.162	45.3201	45.8101	191334.0
2007-08-27	AGG	ETF	99.24	99.44	99.17	99.35	301600.0
2007-08-27	AIQ	ETF	44.75	45.2	44.15	44.4	20640.0
2007-08-27	AIS	ETF	1.43	1.45	1.4	1.43	88900.0
2007-08-27	ARB	ETF	50.65	50.91	50.0	50.16	118100.0
2007-08-27	BBH	ETF	54.5567	54.6667	54.1267	54.1333	143400.0
2007-08-27	BIL	ETF	91.88	91.94	91.82	91.82	36050.0
2007-08-27	BITS	ETF	26.6	26.8	26.36	26.48	3115.0
2007-08-27	BIV	ETF	75.1	75.22	75.05	75.22	9200.0
2007-08-27	BLV	ETF	74.22	74.55	74.22	74.55	6700.0
2007-08-27	BMVP	ETF	17.013	17.013	16.87	16.895	37500.0
2007-08-27	BND	ETF	74.93	75.31	74.93	75.31	82200.0
2007-08-27	BNE	ETF	16.86	17.18	16.8	16.94	149800.0
2007-08-27	BRF	ETF	14.57	14.57	14.52	14.52	6900.0
2007-08-27	BSV	ETF	75.55	75.71	75.41	75.71	103500.0
2007-08-27	BTF	ETF	104.74999999999999	105.99999999999999	104.74999999999999	105.99999999999999	1980.0
2007-08-27	CBON	ETF	25.37	25.58	25.2	25.27	24074.0
2007-08-27	CDL	ETF	4.12	4.22	4.04	4.21	3432332.0
2007-08-27	CEF	ETF	9.22	9.22	9.07	9.07	181100.0
2007-08-27	CGO	ETF	17.2	17.3599	16.72	16.89	15200.0
2007-08-27	CGW	ETF	24.5	24.6	24.19	24.55	118200.0
2007-08-27	CHB	ETF	11.2	11.49	10.76	10.9	964812.0
2007-08-27	CHI	ETF	16.62	16.78	16.49	16.64	165500.0
2007-08-27	CHIC	ETF	18.0	18.03	17.6	17.74	177159.0
2007-08-27	CHW	ETF	13.65	14.09	13.21	14.05	123900.0
2007-08-27	CHY	ETF	14.48	14.6	14.4	14.5499	145200.0
2007-08-27	CN	ETF	49.19	51.48	48.81	50.98	298000.0
2007-08-27	CNXT	ETF	1.14	1.145	1.12	1.13	5535515.0
2007-08-27	CPI	ETF	24.7	24.7	24.7	24.7	200.0
2007-08-27	CPST	ETF	0.9899	1.09	0.981	1.09	2303702.0
2007-08-27	CSA	ETF	17.57	17.7	16.51	17.15	57000.0
2007-08-27	CSD	ETF	28.98	28.98	28.8	28.83	12200.0
2007-08-27	CSM	ETF	1.435	1.4375	1.435	1.4375	1600.0
2007-08-27	CSQ	ETF	14.4	14.42	14.18	14.23	284900.0
2007-08-27	CTEC	ETF	99.45	101.89999999999999	99.3	101.89999999999999	25371.4
2007-08-27	CVY	ETF	26.1	26.1	25.92	25.92	33000.0
2007-08-27	CWI	ETF	26.48	26.48	26.3533	26.38	25200.0
2007-08-27	CZA	ETF	25.5	25.57	25.5	25.52	500.0
2007-08-27	DBA	ETF	26.56	26.73	26.34	26.61	140200.0
2007-08-27	DBB	ETF	25.91	26.02	25.73	25.91	12800.0
2007-08-27	DBC	ETF	25.32	25.69	25.25	25.66	102300.0
2007-08-27	DBE	ETF	27.66	28.13	27.43	28.05	124600.0
2007-08-27	DBO	ETF	26.16	26.63	25.71	26.61	4500.0
2007-08-27	DBP	ETF	25.57	25.6	25.52	25.53	14200.0

> showing 50 of 496 rows — these rows as CSV

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