PREVIEW / etf_daily / 2007-10-04

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-04.parquet
  size:    23 KB
  rows:    495

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-04	SPY	ETF	154.11	154.26	153.59	154.02	76864400.0
2007-10-04	QQQ	ETF	51.75	51.83	51.34	51.77	84129214.0
2007-10-04	IWM	ETF	82.56	82.72	81.99	82.46	35783300.0
2007-10-04	DIA	ETF	139.9	140.04	139.43	139.51	7234600.0
2007-10-04	GLD	ETF	71.8	73.06	71.24	72.87	9178500.0
2007-10-04	TLT	ETF	89.01	89.32	88.91	89.24	1128700.0
2007-10-04	ADRE	ETF	53.21	53.86	52.59	53.68	290622.0
2007-10-04	AGG	ETF	99.79	99.9	99.51	99.66	445000.0
2007-10-04	AIQ	ETF	46.1	46.25	45.5	45.9	24720.0
2007-10-04	AIS	ETF	1.399	1.41	1.36	1.39	98300.0
2007-10-04	ARB	ETF	45.75	45.85	45.31	45.52	218700.0
2007-10-04	BBH	ETF	58.7633	59.1267	58.5367	58.81	166200.0
2007-10-04	BIL	ETF	91.62	91.64	91.6	91.64	4700.0
2007-10-04	BITS	ETF	25.8	25.96	25.32	25.48	7268.0
2007-10-04	BIV	ETF	75.57	75.68	75.54	75.66	6200.0
2007-10-04	BLV	ETF	75.14	75.26	75.14	75.26	1000.0
2007-10-04	BMVP	ETF	17.4	17.42	17.3734	17.3867	30700.0
2007-10-04	BND	ETF	75.57	75.67	75.5	75.67	70200.0
2007-10-04	BNE	ETF	17.03	17.29	16.99	17.22	241500.0
2007-10-04	BRF	ETF	14.6401	14.78	14.6401	14.78	7100.0
2007-10-04	BSV	ETF	75.89	75.94	75.87	75.91	20300.0
2007-10-04	BTF	ETF	108.2	108.2	108.2	108.2	20.0
2007-10-04	CBON	ETF	25.38	25.49	25.08	25.31	47990.0
2007-10-04	CDL	ETF	4.22	4.25	4.02	4.06	2691800.0
2007-10-04	CEF	ETF	9.61	9.83	9.55	9.82	362600.0
2007-10-04	CGO	ETF	17.9	18.1	17.9	18.1	30300.0
2007-10-04	CGW	ETF	25.92	25.92	25.67	25.85	48100.0
2007-10-04	CHB	ETF	12.01	12.23	11.5	12.18	1130600.0
2007-10-04	CHI	ETF	17.0	17.05	16.9	16.95	92000.0
2007-10-04	CHIC	ETF	15.15	15.15	14.15	14.19	2285823.0
2007-10-04	CHW	ETF	13.55	13.75	13.52	13.63	113900.0
2007-10-04	CHY	ETF	15.55	15.55	15.29	15.32	127200.0
2007-10-04	CN	ETF	56.57	57.9	55.89	57.65	376400.0
2007-10-04	CNXT	ETF	1.31	1.37	1.31	1.37	6566370.0
2007-10-04	CPST	ETF	1.21	1.22	1.16	1.18	1748107.0
2007-10-04	CSA	ETF	18.72	19.15	18.51	18.81	81800.0
2007-10-04	CSD	ETF	29.38	29.53	29.34	29.47	8300.0
2007-10-04	CSM	ETF	1.4625	1.4625	1.4625	1.4625	2400.0
2007-10-04	CSQ	ETF	14.81	14.81	14.62	14.69	243000.0
2007-10-04	CVY	ETF	26.42	26.51	26.42	26.5	8400.0
2007-10-04	CWI	ETF	28.62	28.7933	28.62	28.7533	11550.0
2007-10-04	CZA	ETF	26.7	26.73	26.7	26.73	2200.0
2007-10-04	DBA	ETF	28.53	28.59	28.16	28.31	404300.0
2007-10-04	DBB	ETF	26.37	26.54	26.21	26.54	44500.0
2007-10-04	DBC	ETF	27.27	27.68	27.1	27.67	273800.0
2007-10-04	DBE	ETF	29.85	30.76	29.85	30.76	13500.0
2007-10-04	DBO	ETF	28.64	29.51	28.64	29.44	2500.0
2007-10-04	DBP	ETF	27.77	28.3	27.69	28.3	17200.0
2007-10-04	DBS	ETF	25.9	26.29	25.79	26.24	19200.0
2007-10-04	DBV	ETF	28.64	28.69	28.54	28.67	138400.0

> showing 50 of 495 rows — these rows as CSV

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