PREVIEW / etf_daily / 2007-11-14

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-14.parquet
  size:    24 KB
  rows:    530

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-11-14	SPY	ETF	149.22	149.4	146.78	147.67	230558800.0
2007-11-14	QQQ	ETF	51.39	51.44	49.9	50.09	263285341.0
2007-11-14	IWM	ETF	79.17	79.23	77.6	78.05	76347400.0
2007-11-14	DIA	ETF	133.96	133.99	132.24	132.71	13708200.0
2007-11-14	GLD	ETF	80.21	80.68	79.91	80.28	5703700.0
2007-11-14	TLT	ETF	90.95	91.51	90.92	91.42	684400.0
2007-11-14	ADRE	ETF	56.72	57.02	55.2101	55.46	355169.0
2007-11-14	AGG	ETF	100.54	100.65	100.4	100.63	336000.0
2007-11-14	AIQ	ETF	45.0	45.85	44.55	45.4	45480.0
2007-11-14	AIS	ETF	1.1	1.15	1.08	1.14	224500.0
2007-11-14	AIVI	ETF	74.7	74.7	73.25	73.45	32000.0
2007-11-14	ARB	ETF	51.55	52.0	50.92	50.99	400200.0
2007-11-14	BBH	ETF	58.11	58.5533	57.9367	58.01	183000.0
2007-11-14	BIL	ETF	91.72	91.78	91.68	91.72	100950.0
2007-11-14	BITS	ETF	22.96	23.0	22.0	22.84	16411.0
2007-11-14	BIV	ETF	76.24	76.48	76.24	76.45	9500.0
2007-11-14	BLV	ETF	76.11	76.38	76.11	76.38	17000.0
2007-11-14	BMVP	ETF	17.1867	17.25	17.05	17.0633	39800.0
2007-11-14	BND	ETF	76.17	76.24	76.08	76.24	66100.0
2007-11-14	BNE	ETF	16.99	17.27	16.84	16.96	121700.0
2007-11-14	BRF	ETF	14.68	14.69	14.64	14.64	8700.0
2007-11-14	BSV	ETF	76.43	76.57	76.43	76.53	24500.0
2007-11-14	BTF	ETF	113.6	114.64999999999999	113.35000000000001	113.35000000000001	1440.0
2007-11-14	BWX	ETF	27.825	27.825	26.9851	27.1	166540.0
2007-11-14	CBON	ETF	20.93	21.04	20.16	20.25	41837.0
2007-11-14	CDL	ETF	3.0	3.0	2.595	2.65	4956644.0
2007-11-14	CEF	ETF	10.6	10.85	10.53	10.83	451600.0
2007-11-14	CGO	ETF	18.79	18.93	18.61	18.81	22800.0
2007-11-14	CGW	ETF	25.79	25.79	25.49	25.57	43400.0
2007-11-14	CHB	ETF	10.81	11.02	10.45	10.58	1598400.0
2007-11-14	CHI	ETF	15.08	15.46	15.08	15.29	236701.0
2007-11-14	CHIC	ETF	14.58	14.61	14.04	14.29	1003057.0
2007-11-14	CHW	ETF	12.59	12.72	12.26	12.39	204499.0
2007-11-14	CHY	ETF	13.6	13.72	13.4	13.55	216080.0
2007-11-14	CN	ETF	54.97	55.08	53.14	53.4	264900.0
2007-11-14	CNXT	ETF	1.22	1.25	1.2	1.24	5976438.0
2007-11-14	COW	ETF	48.53	48.53	48.53	48.53	1000.0
2007-11-14	CPST	ETF	1.24	1.27	1.2	1.2	2143754.0
2007-11-14	CSA	ETF	16.77	18.06	16.77	17.4	61900.0
2007-11-14	CSD	ETF	27.64	27.65	27.33	27.33	12200.0
2007-11-14	CSM	ETF	1.475	1.475	1.475	1.475	800.0
2007-11-14	CSQ	ETF	13.94	14.04	13.87	13.91	345600.0
2007-11-14	CUT	ETF	25.17	25.2	24.9	24.9	25000.0
2007-11-14	CVY	ETF	25.2	25.29	24.79	24.81	7700.0
2007-11-14	CWI	ETF	28.2133	29.0133	28.2133	28.62	57300.0
2007-11-14	CZA	ETF	26.04	26.04	26.04	26.04	2000.0
2007-11-14	DBA	ETF	29.39	29.91	29.39	29.91	218600.0
2007-11-14	DBB	ETF	24.64	25.26	24.64	25.16	85900.0
2007-11-14	DBC	ETF	29.94	30.59	29.94	30.52	260500.0
2007-11-14	DBE	ETF	33.86	35.0	33.84	34.29	18400.0

> showing 50 of 530 rows — these rows as CSV

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