PREVIEW / etf_daily / 2007-07-24

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-24.parquet
  size:    23 KB
  rows:    496

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-24	SPY	ETF	153.12	154.28	150.76	151.3	256732400.0
2007-07-24	QQQ	ETF	49.71	50.1	49.05	49.33	175550263.0
2007-07-24	IWM	ETF	82.1	82.2	80.49	81.0	158240800.0
2007-07-24	DIA	ETF	138.5	138.82	136.9	137.27	20848000.0
2007-07-24	GLD	ETF	67.72	68.0	67.3	67.47	3763000.0
2007-07-24	TLT	ETF	86.01	86.16	85.72	86.14	1351600.0
2007-07-24	ADRE	ETF	49.75	49.8	47.96	48.1605	327906.0
2007-07-24	AGG	ETF	98.39	98.56	98.35	98.54	208800.0
2007-07-24	AIQ	ETF	49.2	50.0	48.3	48.85	49480.0
2007-07-24	AIS	ETF	1.73	1.75	1.69	1.7	216600.0
2007-07-24	ARB	ETF	51.17	51.47	49.77	50.0	570500.0
2007-07-24	BBH	ETF	55.9667	56.7667	55.9667	56.1667	1166400.0
2007-07-24	BIL	ETF	91.84	91.86	91.82	91.84	9350.0
2007-07-24	BITS	ETF	27.56	28.16	27.52	27.6396	9070.0
2007-07-24	BIV	ETF	74.08	74.13	74.01	74.03	10200.0
2007-07-24	BLV	ETF	73.55	73.55	73.17	73.48	16600.0
2007-07-24	BMVP	ETF	17.9167	18.008	17.69	17.74	46400.0
2007-07-24	BND	ETF	74.38	74.39	74.25	74.35	31400.0
2007-07-24	BNE	ETF	19.78	19.98	18.85	19.0	262600.0
2007-07-24	BRF	ETF	14.6	14.6	14.46	14.51	5300.0
2007-07-24	BSV	ETF	75.05	75.12	75.02	75.12	132400.0
2007-07-24	BTF	ETF	107.05	107.05	106.89999999999999	106.904	900.0
2007-07-24	CBON	ETF	25.51	25.55	23.77	24.012	215558.0
2007-07-24	CDL	ETF	6.08	6.12	5.88	5.9	2777412.0
2007-07-24	CEF	ETF	9.58	9.66	9.48	9.52	150300.0
2007-07-24	CGO	ETF	18.14	18.29	17.95	17.95	24900.0
2007-07-24	CGW	ETF	26.14	26.15	25.5	25.67	119700.0
2007-07-24	CHB	ETF	12.19	12.54	11.69	12.15	2172000.0
2007-07-24	CHI	ETF	16.8	16.83	16.26	16.69	555100.0
2007-07-24	CHIC	ETF	23.51	23.65	22.63	22.85	1580472.0
2007-07-24	CHY	ETF	15.05	15.1	14.26	14.71	709900.0
2007-07-24	CN	ETF	53.1	53.13	51.82	51.9	148800.0
2007-07-24	CNXT	ETF	1.38	1.42	1.36	1.37	7832627.0
2007-07-24	CPI	ETF	24.4	24.656	24.4	24.656	500.0
2007-07-24	CPST	ETF	1.27	1.27	1.18	1.19	3133930.0
2007-07-24	CSA	ETF	18.6	18.6	17.76	17.8	22800.0
2007-07-24	CSD	ETF	30.92	30.93	30.27	30.38	81000.0
2007-07-24	CSQ	ETF	14.9	14.9	14.23	14.41	631900.0
2007-07-24	CTEC	ETF	108.64999999999999	110.19999999999999	105.5	105.7	19528.4
2007-07-24	CVY	ETF	27.36	27.46	26.88	26.9	26800.0
2007-07-24	CWI	ETF	28.16	28.2	27.8067	27.8333	29250.0
2007-07-24	CZA	ETF	26.97	26.97	26.97	26.97	100.0
2007-07-24	DBA	ETF	26.21	26.21	25.84	25.93	382500.0
2007-07-24	DBB	ETF	28.62	28.62	28.26	28.26	236700.0
2007-07-24	DBC	ETF	26.12	26.28	26.0	26.08	189600.0
2007-07-24	DBE	ETF	28.93	28.98	28.7	28.8	13000.0
2007-07-24	DBO	ETF	27.4	27.4	27.13	27.22	31100.0
2007-07-24	DBP	ETF	26.8	26.88	26.7	26.7	12100.0
2007-07-24	DBS	ETF	26.31	26.3899	26.15	26.18	9300.0
2007-07-24	DBV	ETF	29.52	29.79	29.51	29.55	227700.0

> showing 50 of 496 rows — these rows as CSV

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