PREVIEW / etf_daily / 2007-10-15

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-15.parquet
  size:    24 KB
  rows:    517

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-15	SPY	ETF	156.27	156.36	153.94	155.01	161151900.0
2007-10-15	QQQ	ETF	53.61	53.71	52.7	53.12	121578667.0
2007-10-15	IWM	ETF	83.8	83.87	82.03	82.85	80770400.0
2007-10-15	DIA	ETF	141.08	141.11	139.01	140.02	12383600.0
2007-10-15	GLD	ETF	74.99	75.2	74.49	75.14	6705300.0
2007-10-15	TLT	ETF	87.48	87.72	87.4	87.65	553300.0
2007-10-15	ADRE	ETF	57.59	57.8	56.104	56.74	344521.0
2007-10-15	AGG	ETF	99.43	99.5	99.25	99.48	200800.0
2007-10-15	AIQ	ETF	48.95	49.7	46.5	47.1	23120.0
2007-10-15	AIS	ETF	1.41	1.44	1.3701	1.41	47500.0
2007-10-15	AIVI	ETF	75.65	75.65	74.65	74.84	19300.0
2007-10-15	ARB	ETF	45.08	45.23	43.89	43.94	942900.0
2007-10-15	BBH	ETF	61.6633	61.9267	60.69	60.9	988500.0
2007-10-15	BIL	ETF	91.7	91.72	91.66	91.66	32450.0
2007-10-15	BITS	ETF	26.84	27.0	26.12	26.28	5608.0
2007-10-15	BIV	ETF	75.06	75.25	75.06	75.2	13800.0
2007-10-15	BLV	ETF	74.35	74.61	74.35	74.49	3600.0
2007-10-15	BMVP	ETF	17.73	17.73	17.52	17.59	44600.0
2007-10-15	BND	ETF	75.26	75.5	75.24	75.29	394500.0
2007-10-15	BNE	ETF	18.0	18.0	17.52	17.73	142400.0
2007-10-15	BOSS	ETF	47.17	47.45	47.17	47.44	600.0
2007-10-15	BRF	ETF	14.58	14.58	14.57	14.58	24700.0
2007-10-15	BSV	ETF	75.61	75.75	75.54	75.68	50500.0
2007-10-15	BTF	ETF	111.10049999999998	111.27499999999999	110.99999999999999	110.99999999999999	1620.0
2007-10-15	BWX	ETF	25.965	25.97	25.875	25.875	82600.0
2007-10-15	CBON	ETF	25.41	25.41	24.61	24.86	73970.0
2007-10-15	CDL	ETF	4.54	4.62	4.35	4.41	2191800.0
2007-10-15	CEF	ETF	10.0	10.17	10.0	10.12	401400.0
2007-10-15	CGO	ETF	18.62	18.62	18.38	18.47	32600.0
2007-10-15	CGW	ETF	26.54	26.55	26.02	26.25	130200.0
2007-10-15	CHB	ETF	12.23	12.41	12.04	12.25	1826200.0
2007-10-15	CHI	ETF	17.04	17.15	17.0	17.06	135700.0
2007-10-15	CHIC	ETF	14.74	14.76	14.44	14.6	546371.0
2007-10-15	CHW	ETF	13.38	13.3912	13.18	13.37	122000.0
2007-10-15	CHY	ETF	15.28	15.35	15.15	15.22	173900.0
2007-10-15	CMF	ETF	51.6	51.645	51.55	51.64	8200.0
2007-10-15	CN	ETF	63.3	64.2099	61.89	62.78	306700.0
2007-10-15	CNXT	ETF	1.46	1.47	1.42	1.44	5173332.0
2007-10-15	CPST	ETF	1.13	1.13	1.1	1.11	1003706.0
2007-10-15	CSA	ETF	18.23	18.32	17.27	17.39	61200.0
2007-10-15	CSD	ETF	29.74	29.74	29.35	29.35	16700.0
2007-10-15	CSM	ETF	1.4725	1.4725	1.4725	1.4725	1200.0
2007-10-15	CSQ	ETF	14.8	14.82	14.7	14.77	257300.0
2007-10-15	CVY	ETF	26.49	26.49	26.24	26.29	10800.0
2007-10-15	CWI	ETF	29.4	29.4667	29.1067	29.2	15900.0
2007-10-15	CZA	ETF	27.1899	27.1899	27.04	27.04	1500.0
2007-10-15	DBA	ETF	29.0	29.13	28.85	29.04	288000.0
2007-10-15	DBB	ETF	26.9	26.9	26.55	26.75	17900.0
2007-10-15	DBC	ETF	28.35	28.6	28.25	28.6	156700.0
2007-10-15	DBE	ETF	31.51	32.0	31.36	31.96	25600.0

> showing 50 of 517 rows — these rows as CSV

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