PREVIEW / etf_daily / 2007-10-19

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-19.parquet
  size:    24 KB
  rows:    516

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-19	SPY	ETF	153.09	156.48	149.66	149.67	297169900.0
2007-10-19	QQQ	ETF	53.77	53.77	52.39	52.44	245111936.0
2007-10-19	IWM	ETF	81.91	82.12	79.0	79.09	128571100.0
2007-10-19	DIA	ETF	137.91	138.75	134.93	134.93	33071200.0
2007-10-19	GLD	ETF	76.09	76.29	74.54	75.7	9507800.0
2007-10-19	TLT	ETF	89.63	90.6	89.61	90.46	2561800.0
2007-10-19	ADRE	ETF	57.8	57.8	54.25	54.67	522119.0
2007-10-19	AGG	ETF	100.5	100.73	100.34	100.73	732700.0
2007-10-19	AIQ	ETF	47.85	47.95	45.35	45.8	75920.0
2007-10-19	AIS	ETF	1.32	1.34	1.3	1.31	231600.0
2007-10-19	AIVI	ETF	74.7	74.7	73.21	73.24	26400.0
2007-10-19	ARB	ETF	46.67	49.78	46.3	47.4	966000.0
2007-10-19	BBH	ETF	59.5267	59.7733	58.9833	59.47	553800.0
2007-10-19	BIL	ETF	91.82	91.84	91.74	91.84	100550.0
2007-10-19	BITS	ETF	26.08	26.16	25.224	25.44	5405.0
2007-10-19	BIV	ETF	76.22	76.51	76.1	76.47	31100.0
2007-10-19	BLV	ETF	75.94	76.41	75.89	76.37	17500.0
2007-10-19	BMVP	ETF	17.3933	17.3933	17.0967	17.1005	48700.0
2007-10-19	BND	ETF	76.06	76.29	76.04	76.29	117300.0
2007-10-19	BNE	ETF	17.48	17.51	16.76	16.76	196500.0
2007-10-19	BOSS	ETF	45.95	47.8	45.95	47.8	100.0
2007-10-19	BRF	ETF	14.57	14.6	14.56	14.6	3200.0
2007-10-19	BSV	ETF	76.27	76.41	76.23	76.37	26900.0
2007-10-19	BTF	ETF	116.4	116.4	113.69999999999999	114.0	7740.0
2007-10-19	BWX	ETF	26.21	26.29	26.17	26.27	449800.0
2007-10-19	CBON	ETF	21.5	21.5	19.56	19.64	111311.0
2007-10-19	CDL	ETF	4.2	4.22	4.1	4.2	3803300.0
2007-10-19	CEF	ETF	10.13	10.15	9.9	10.04	421000.0
2007-10-19	CGO	ETF	18.63	18.79	18.49	18.5899	39900.0
2007-10-19	CGW	ETF	26.33	26.33	25.58	25.75	73500.0
2007-10-19	CHB	ETF	13.32	13.57	12.42	12.61	3686300.0
2007-10-19	CHI	ETF	16.91	16.95	16.84	16.9251	147700.0
2007-10-19	CHIC	ETF	14.44	14.44	13.91	13.91	658801.0
2007-10-19	CHW	ETF	13.24	13.34	13.02	13.29	180300.0
2007-10-19	CHY	ETF	15.02	15.04	14.81	14.99	149900.0
2007-10-19	CMF	ETF	52.03	52.17	52.025	52.1	128000.0
2007-10-19	CN	ETF	66.35	66.47	64.3	64.7	278200.0
2007-10-19	CNXT	ETF	1.46	1.46	1.32	1.33	11082559.0
2007-10-19	CPI	ETF	24.5	24.5	24.0	24.3	1800.0
2007-10-19	CPST	ETF	1.1	1.11	1.05	1.07	2783657.0
2007-10-19	CSA	ETF	18.1	18.21	17.25	17.65	48700.0
2007-10-19	CSD	ETF	29.14	29.14	28.4	28.4	86600.0
2007-10-19	CSQ	ETF	14.8	14.808	14.43	14.69	373300.0
2007-10-19	CVY	ETF	25.78	25.82	25.39	25.43	18900.0
2007-10-19	CWI	ETF	28.9733	29.0	28.4933	28.5133	58500.0
2007-10-19	CZA	ETF	26.77	26.77	26.74	26.74	300.0
2007-10-19	DBA	ETF	29.56	29.6	29.19	29.58	370700.0
2007-10-19	DBB	ETF	26.3	26.32	25.9	26.11	17500.0
2007-10-19	DBC	ETF	28.94	29.01	28.77	28.9078	228600.0
2007-10-19	DBE	ETF	32.06	32.12	31.84	32.0	15700.0

> showing 50 of 516 rows — these rows as CSV

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