PREVIEW / etf_daily / 2007-08-16

all etf daily files

  file:    by_date/etf_daily/2007/2007-08-16.parquet
  size:    23 KB
  rows:    506

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-16	SPY	ETF	139.79	142.94	137.0	142.1	546743700.0
2007-08-16	QQQ	ETF	45.54	45.91	44.39	45.45	362478842.0
2007-08-16	IWM	ETF	74.67	76.93	73.24	76.87	347851600.0
2007-08-16	DIA	ETF	127.84	129.26	125.31	129.15	52563400.0
2007-08-16	GLD	ETF	65.49	65.81	63.47	64.68	18367500.0
2007-08-16	TLT	ETF	86.87	87.6	86.76	87.14	2410200.0
2007-08-16	ADRE	ETF	39.88	40.35	37.9	40.1	871167.0
2007-08-16	AGG	ETF	98.72	98.98	98.43	98.67	541400.0
2007-08-16	AIQ	ETF	41.55	43.7	41.15	42.45	67280.0
2007-08-16	AIS	ETF	1.34	1.34	1.25	1.33	345400.0
2007-08-16	ARB	ETF	51.29	52.68	50.0	50.9	822400.0
2007-08-16	BBH	ETF	54.3333	54.6367	52.8467	53.8667	1505100.0
2007-08-16	BIL	ETF	91.78	92.0	91.78	91.9	122850.0
2007-08-16	BITS	ETF	25.44	25.92	24.6	25.72	8876.0
2007-08-16	BIV	ETF	74.66	75.06	74.64	74.64	9000.0
2007-08-16	BLV	ETF	73.4	73.83	73.27	73.27	8100.0
2007-08-16	BMVP	ETF	15.9433	16.21	15.64	16.21	159300.0
2007-08-16	BND	ETF	74.68	74.95	74.52	74.64	43100.0
2007-08-16	BNE	ETF	15.59	15.84	14.83	15.57	576300.0
2007-08-16	BRF	ETF	14.46	14.46	14.45	14.46	8000.0
2007-08-16	BSV	ETF	75.6	75.84	75.56	75.64	104800.0
2007-08-16	BTF	ETF	97.5	98.0	95.55	98.0	4940.0
2007-08-16	CBON	ETF	22.51	24.74	22.5	24.6	88384.0
2007-08-16	CDL	ETF	4.21	4.5	4.02	4.5	3901531.0
2007-08-16	CEF	ETF	9.15	9.18	8.65	8.95	1300300.0
2007-08-16	CGO	ETF	13.81	14.86	11.9301	14.38	113400.0
2007-08-16	CGW	ETF	23.02	23.1065	22.4101	22.75	213600.0
2007-08-16	CHB	ETF	9.63	10.25	8.8	10.06	4113176.0
2007-08-16	CHI	ETF	13.64	15.15	13.23	15.15	776300.0
2007-08-16	CHIC	ETF	16.63	17.36	16.52	17.36	601562.0
2007-08-16	CHW	ETF	11.75	12.4	11.01	12.4	493000.0
2007-08-16	CHY	ETF	12.5	13.06	10.81	13.04	1454800.0
2007-08-16	CN	ETF	45.01	45.87	42.33	44.51	224700.0
2007-08-16	CNXT	ETF	1.2	1.21	1.13	1.2	11992099.0
2007-08-16	CPI	ETF	27.25	27.25	26.95	26.95	800.0
2007-08-16	CPST	ETF	1.0	1.02	0.91	0.99	2328985.0
2007-08-16	CSA	ETF	16.24	16.63	16.24	16.43	50600.0
2007-08-16	CSD	ETF	27.41	27.44	26.82	27.35	36100.0
2007-08-16	CSM	ETF	1.4025	1.4025	1.3875	1.39	36800.0
2007-08-16	CSQ	ETF	12.99	13.0	11.07	13.0	1305700.0
2007-08-16	CTEC	ETF	99.04999999999998	101.75	97.5	100.95	31387.2
2007-08-16	CVY	ETF	24.25	24.75	23.72	24.75	209300.0
2007-08-16	CWI	ETF	24.8133	24.9333	24.2067	24.9333	79200.0
2007-08-16	DBA	ETF	25.81	25.85	24.58	25.6	782800.0
2007-08-16	DBB	ETF	24.86	25.02	23.95	24.12	109900.0
2007-08-16	DBC	ETF	25.07	25.18	24.63	25.18	455900.0
2007-08-16	DBE	ETF	27.83	28.01	27.46	27.79	27600.0
2007-08-16	DBO	ETF	26.47	27.1	25.56	26.04	35900.0
2007-08-16	DBP	ETF	25.7	25.76	24.59	25.04	43600.0
2007-08-16	DBS	ETF	24.38	24.38	21.95	22.97	60200.0

> showing 50 of 506 rows — these rows as CSV

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