PREVIEW / etf_daily / 2007-07-25

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-25.parquet
  size:    23 KB
  rows:    491

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-07-25	SPY	ETF	152.02	152.39	150.25	151.61	265214500.0
2007-07-25	QQQ	ETF	49.57	49.67	49.06	49.4	170909171.0
2007-07-25	IWM	ETF	81.46	81.77	79.83	80.7	164307600.0
2007-07-25	DIA	ETF	137.96	138.1	136.44	137.5	22438800.0
2007-07-25	GLD	ETF	67.19	67.22	66.35	66.9	7530500.0
2007-07-25	TLT	ETF	86.07	86.39	86.0	86.31	881100.0
2007-07-25	ADRE	ETF	48.82	49.25	47.5	48.34	301085.0
2007-07-25	AGG	ETF	98.23	98.65	98.23	98.48	580900.0
2007-07-25	AIQ	ETF	49.25	49.9	48.65	49.1	63820.0
2007-07-25	AIS	ETF	1.78	1.78	1.68	1.7	187600.0
2007-07-25	ARB	ETF	50.2	51.24	50.05	50.89	413200.0
2007-07-25	BBH	ETF	56.4067	57.0933	56.09	56.9267	1810500.0
2007-07-25	BIL	ETF	91.86	91.88	91.86	91.86	9800.0
2007-07-25	BITS	ETF	27.48	27.48	26.6	26.84	12112.0
2007-07-25	BIV	ETF	74.14	74.24	74.08	74.23	16100.0
2007-07-25	BLV	ETF	73.53	73.7	73.52	73.63	21800.0
2007-07-25	BMVP	ETF	17.8433	17.8504	17.5833	17.67	54000.0
2007-07-25	BND	ETF	74.4	74.46	74.37	74.42	24900.0
2007-07-25	BNE	ETF	19.03	19.2	18.65	18.94	229800.0
2007-07-25	BRF	ETF	14.47	14.59	14.47	14.58	11400.0
2007-07-25	BSV	ETF	75.07	75.18	75.06	75.11	35400.0
2007-07-25	BTF	ETF	106.5	106.99999999999999	106.25	106.6	1140.0
2007-07-25	CBON	ETF	24.72	24.72	23.88	24.17	120968.0
2007-07-25	CDL	ETF	5.92	6.02	5.71	5.75	4606805.0
2007-07-25	CEF	ETF	9.47	9.47	9.31	9.42	236000.0
2007-07-25	CGO	ETF	18.0	18.2	17.82	17.91	17700.0
2007-07-25	CGW	ETF	25.9	26.0	25.5356	25.69	99700.0
2007-07-25	CHB	ETF	12.24	12.74	11.75	12.06	2858900.0
2007-07-25	CHI	ETF	16.52	16.71	16.37	16.64	385400.0
2007-07-25	CHIC	ETF	22.85	23.55	22.24	22.32	978978.0
2007-07-25	CHY	ETF	14.81	14.87	14.09	14.56	531300.0
2007-07-25	CN	ETF	52.5	53.0	51.5	52.6	156400.0
2007-07-25	CNXT	ETF	1.39	1.46	1.37	1.41	9524536.0
2007-07-25	CPST	ETF	1.21	1.26	1.2	1.2	3131938.0
2007-07-25	CSA	ETF	17.74	17.83	17.0	17.62	102400.0
2007-07-25	CSD	ETF	30.41	30.48	29.96	30.06	187000.0
2007-07-25	CSQ	ETF	14.4	14.64	14.29	14.51	477600.0
2007-07-25	CTEC	ETF	107.35	108.2	103.49999999999999	105.15	24347.4
2007-07-25	CVY	ETF	27.07	27.19	26.74	26.98	44900.0
2007-07-25	CWI	ETF	28.0	28.0	27.5867	27.88	26700.0
2007-07-25	CZA	ETF	27.13	27.13	26.78	26.84	6000.0
2007-07-25	DBA	ETF	26.25	26.25	25.9	26.03	145700.0
2007-07-25	DBB	ETF	27.78	28.0	27.65	27.84	24400.0
2007-07-25	DBC	ETF	26.14	26.31	25.87	26.31	274200.0
2007-07-25	DBE	ETF	28.91	29.41	28.61	29.41	75100.0
2007-07-25	DBO	ETF	27.27	27.87	27.01	27.87	29000.0
2007-07-25	DBP	ETF	26.49	26.49	26.29	26.39	9600.0
2007-07-25	DBS	ETF	25.86	25.86	25.72	25.73	22800.0
2007-07-25	DBV	ETF	29.87	29.88	29.67	29.78	133200.0
2007-07-25	DDM	ETF	8.24	8.2433	8.0642	8.1992	4596000.0

> showing 50 of 491 rows — these rows as CSV

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