PREVIEW / etf_daily / 2007-06-13

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-13.parquet
  size:    22 KB
  rows:    490

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-06-13	SPY	ETF	150.5	152.07	149.72	151.89	193208200.0
2007-06-13	QQQ	ETF	46.74	47.09	46.54	47.05	148025252.0
2007-06-13	IWM	ETF	81.89	82.97	81.74	82.59	118706700.0
2007-06-13	DIA	ETF	133.58	134.89	133.24	134.8	17254900.0
2007-06-13	GLD	ETF	63.95	64.65	63.9	64.53	2803300.0
2007-06-13	TLT	ETF	82.7	83.76	82.65	83.33	8751200.0
2007-06-13	ADRE	ETF	44.49	44.7	22.29	25.55	189735.0
2007-06-13	AGG	ETF	97.11	97.5	97.1	97.35	407100.0
2007-06-13	AIQ	ETF	44.4	45.15	44.05	44.9	22760.0
2007-06-13	AIS	ETF	1.9	1.93	1.85	1.9099	389000.0
2007-06-13	ARB	ETF	50.71	51.15	50.28	50.98	190700.0
2007-06-13	BBH	ETF	59.4833	59.9533	59.45	59.9433	242700.0
2007-06-13	BIL	ETF	91.64	91.72	91.64	91.72	3750.0
2007-06-13	BITS	ETF	31.8	32.24	31.8	32.1996	9666.0
2007-06-13	BIV	ETF	72.92	73.05	72.9	73.03	5200.0
2007-06-13	BLV	ETF	71.49	71.83	71.48	71.73	26700.0
2007-06-13	BMVP	ETF	17.89	18.01	17.84	18.0	37700.0
2007-06-13	BND	ETF	73.42	73.6	73.34	73.57	93800.0
2007-06-13	BNE	ETF	19.19	19.29	19.13	19.25	368100.0
2007-06-13	BRF	ETF	14.47	14.4899	14.47	14.48	1100.0
2007-06-13	BSV	ETF	74.46	74.55	74.46	74.52	21900.0
2007-06-13	BTF	ETF	109.35	110.19999999999999	109.35	110.19999999999999	1720.0
2007-06-13	CBON	ETF	29.12	29.69	29.05	29.19	57930.0
2007-06-13	CDL	ETF	5.9	6.26	5.82	6.14	15451500.0
2007-06-13	CEF	ETF	8.94	9.08	8.93	9.02	184300.0
2007-06-13	CGO	ETF	17.38	17.72	17.38	17.66	35800.0
2007-06-13	CGW	ETF	24.69	24.9	24.65	24.85	149000.0
2007-06-13	CHB	ETF	9.87	10.31	9.65	10.22	2049400.0
2007-06-13	CHI	ETF	19.95	20.31	19.95	20.15	86400.0
2007-06-13	CHIC	ETF	27.65	28.06	27.51	27.85	317424.0
2007-06-13	CHY	ETF	16.5	16.75	16.48	16.65	159400.0
2007-06-13	CN	ETF	52.46	53.24	52.46	53.05	77500.0
2007-06-13	CNXT	ETF	1.26	1.28	1.24	1.25	7708603.0
2007-06-13	CPI	ETF	23.48	23.48	22.7	22.7	1000.0
2007-06-13	CPST	ETF	1.07	1.16	1.0301	1.11	5518115.0
2007-06-13	CSA	ETF	19.43	19.74	19.42	19.69	34200.0
2007-06-13	CSB	ETF	31.15	31.4	31.05	31.38	15700.0
2007-06-13	CSD	ETF	30.23	30.77	30.23	30.77	40000.0
2007-06-13	CSQ	ETF	15.08	15.2	15.0	15.14	485300.0
2007-06-13	CTEC	ETF	104.3	108.0	104.3	107.05	102266.0
2007-06-13	CVY	ETF	27.6	27.9	27.56	27.9	16200.0
2007-06-13	CWI	ETF	26.6333	26.88	26.6333	26.8267	22800.0
2007-06-13	CZA	ETF	26.81	26.85	26.81	26.85	1900.0
2007-06-13	DBA	ETF	26.73	27.3	26.61	27.28	394200.0
2007-06-13	DBB	ETF	26.33	26.53	26.23	26.51	19100.0
2007-06-13	DBC	ETF	25.71	26.29	25.69	26.24	395000.0
2007-06-13	DBE	ETF	28.17	28.69	28.06	28.56	18400.0
2007-06-13	DBO	ETF	26.46	26.74	26.26	26.73	21000.0
2007-06-13	DBP	ETF	25.53	25.73	25.53	25.6	10800.0
2007-06-13	DBS	ETF	25.87	25.87	25.83	25.83	500.0

> showing 50 of 490 rows — these rows as CSV

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