PREVIEW / etf_daily / 2007-07-27

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-27.parquet
  size:    23 KB
  rows:    500

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-27	SPY	ETF	148.21	148.87	145.05	145.11	422987600.0
2007-07-27	QQQ	ETF	48.89	49.12	47.99	47.99	246387520.0
2007-07-27	IWM	ETF	78.35	79.2	76.43	76.63	202037300.0
2007-07-27	DIA	ETF	134.62	135.1	132.11	132.11	31428100.0
2007-07-27	GLD	ETF	65.28	65.61	64.97	65.41	5341900.0
2007-07-27	TLT	ETF	87.05	87.56	86.85	87.28	5367800.0
2007-07-27	ADRE	ETF	45.5	46.5	45.194	45.61	516327.0
2007-07-27	AGG	ETF	98.71	98.89	98.58	98.73	329000.0
2007-07-27	AIQ	ETF	46.6	47.05	44.8	44.9	98380.0
2007-07-27	AIS	ETF	1.63	1.67	1.57	1.6	273500.0
2007-07-27	ARB	ETF	49.6	50.31	48.76	48.84	375700.0
2007-07-27	BBH	ETF	56.53	56.7	55.6667	55.6667	676200.0
2007-07-27	BIL	ETF	91.86	92.0	91.62	91.92	153800.0
2007-07-27	BITS	ETF	26.0	26.32	25.8	26.2	16454.0
2007-07-27	BIV	ETF	74.49	74.5	74.15	74.5	21900.0
2007-07-27	BLV	ETF	73.86	74.0	72.95	73.5	39400.0
2007-07-27	BMVP	ETF	17.17	17.3353	16.87	16.88	91700.0
2007-07-27	BND	ETF	74.6	74.7	74.51	74.65	45700.0
2007-07-27	BNE	ETF	18.09	18.14	17.44	17.46	302700.0
2007-07-27	BRF	ETF	14.54	14.57	14.52	14.53	2400.0
2007-07-27	BSV	ETF	75.32	75.43	75.02	75.41	43200.0
2007-07-27	BTF	ETF	103.64999999999999	103.85	103.64999999999999	103.64999999999999	1480.0
2007-07-27	CBON	ETF	23.81	24.13	23.68	23.68	125167.0
2007-07-27	CDL	ETF	5.31	5.45	5.2	5.35	3100727.0
2007-07-27	CEF	ETF	9.26	9.31	9.1	9.1	408000.0
2007-07-27	CGO	ETF	17.66	17.71	16.88	17.11	50800.0
2007-07-27	CGW	ETF	24.55	25.41	24.51	24.63	158700.0
2007-07-27	CHB	ETF	11.75	12.1	11.51	11.56	2090300.0
2007-07-27	CHI	ETF	17.0	17.58	16.89	17.39	218700.0
2007-07-27	CHIC	ETF	19.14	19.54	18.15	18.3	1217078.0
2007-07-27	CHW	ETF	15.0	15.01	15.0	15.0	714000.0
2007-07-27	CHY	ETF	14.47	15.17	14.47	15.07	207000.0
2007-07-27	CN	ETF	51.0	51.8	50.23	50.73	232500.0
2007-07-27	CNXT	ETF	1.28	1.41	1.26	1.4	17970867.0
2007-07-27	CPST	ETF	1.15	1.17	1.11	1.14	1474860.0
2007-07-27	CSA	ETF	17.42	17.59	17.03	17.25	39800.0
2007-07-27	CSD	ETF	29.37	29.64	29.07	29.07	89500.0
2007-07-27	CSQ	ETF	14.51	14.51	14.05	14.09	391500.0
2007-07-27	CTEC	ETF	101.44999999999999	104.8	100.85000000000001	102.75	8037.200000000001
2007-07-27	CVY	ETF	26.32	26.6	26.1	26.1	13800.0
2007-07-27	CWI	ETF	26.6667	26.8467	26.46	26.56	56100.0
2007-07-27	CZA	ETF	26.15	26.15	25.78	25.78	1700.0
2007-07-27	DBA	ETF	26.35	26.35	25.91	26.0	167600.0
2007-07-27	DBB	ETF	27.69	27.69	27.4	27.47	72000.0
2007-07-27	DBC	ETF	26.03	26.29	25.94	26.28	283200.0
2007-07-27	DBE	ETF	29.06	29.37	28.96	29.2	22800.0
2007-07-27	DBO	ETF	27.55	27.89	27.32	27.66	22200.0
2007-07-27	DBP	ETF	25.76	25.82	25.63	25.75	13600.0
2007-07-27	DBS	ETF	24.96	24.96	24.82	24.91	2900.0
2007-07-27	DBV	ETF	29.01	29.17	28.54	28.55	513300.0

> showing 50 of 500 rows — these rows as CSV

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