PREVIEW / etf_daily / 2007-10-25

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-25.parquet
  size:    24 KB
  rows:    529

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-25	SPY	ETF	151.65	152.29	149.88	151.84	237374500.0
2007-10-25	QQQ	ETF	53.88	53.98	52.75	53.05	233835345.0
2007-10-25	IWM	ETF	81.08	81.5	79.59	80.66	116690000.0
2007-10-25	DIA	ETF	136.71	137.29	135.35	136.9	16618800.0
2007-10-25	GLD	ETF	75.94	76.17	75.66	76.03	6487800.0
2007-10-25	TLT	ETF	91.06	91.18	90.7	90.71	3062200.0
2007-10-25	ADRE	ETF	56.79	56.79	55.73	56.42	198960.0
2007-10-25	AGG	ETF	101.13	101.14	100.83	100.85	236200.0
2007-10-25	AIQ	ETF	45.55	46.0	44.45	45.55	32560.0
2007-10-25	AIS	ETF	1.22	1.25	1.21	1.23	121700.0
2007-10-25	AIVI	ETF	74.79	74.88	74.4	74.79	13400.0
2007-10-25	ARB	ETF	50.42	50.58	49.37	49.65	305100.0
2007-10-25	BBH	ETF	60.4167	60.55	59.6633	60.1467	250200.0
2007-10-25	BIL	ETF	91.84	91.84	91.78	91.82	12100.0
2007-10-25	BITS	ETF	25.0	25.96	25.0	25.76	6941.0
2007-10-25	BIV	ETF	76.69	76.75	76.55	76.6	12000.0
2007-10-25	BLV	ETF	76.8	76.82	76.64	76.64	3800.0
2007-10-25	BMVP	ETF	17.5033	17.5033	17.1433	17.3	125000.0
2007-10-25	BND	ETF	76.5	76.55	76.4	76.46	88600.0
2007-10-25	BNE	ETF	17.26	17.4	17.01	17.21	165700.0
2007-10-25	BOSS	ETF	45.57	46.84	45.57	46.84	300.0
2007-10-25	BRF	ETF	14.61	14.64	14.6	14.61	10800.0
2007-10-25	BSV	ETF	76.53	76.57	76.46	76.46	35900.0
2007-10-25	BTF	ETF	115.99999999999999	115.99999999999999	113.69999999999999	115.7	3840.0
2007-10-25	BWX	ETF	26.485	26.485	26.425	26.445	60000.0
2007-10-25	CBON	ETF	19.95	20.26	19.95	20.1	96351.0
2007-10-25	CDL	ETF	4.31	4.41	4.21	4.32	2537200.0
2007-10-25	CEF	ETF	9.99	10.15	9.99	10.05	388200.0
2007-10-25	CGO	ETF	18.8399	18.89	18.75	18.88	19600.0
2007-10-25	CGW	ETF	26.35	26.35	25.8	25.95	48200.0
2007-10-25	CHB	ETF	13.19	13.22	12.37	12.77	1566200.0
2007-10-25	CHI	ETF	16.76	16.93	16.76	16.9	144000.0
2007-10-25	CHIC	ETF	14.49	14.85	14.16	14.54	426257.0
2007-10-25	CHW	ETF	13.16	13.25	12.85	12.99	256600.0
2007-10-25	CHY	ETF	14.85	14.85	14.78	14.83	116600.0
2007-10-25	CMF	ETF	52.15	52.15	52.12	52.12	3000.0
2007-10-25	CN	ETF	58.39	60.36	58.18	59.89	312500.0
2007-10-25	CNXT	ETF	1.31	1.32	1.17	1.18	12429341.0
2007-10-25	COW	ETF	49.51	49.55	49.45	49.45	700.0
2007-10-25	CPST	ETF	1.07	1.08	1.05	1.06	1189286.0
2007-10-25	CSA	ETF	17.27	17.57	17.1	17.22	36400.0
2007-10-25	CSD	ETF	28.74	28.85	28.45	28.64	44700.0
2007-10-25	CSQ	ETF	14.75	14.75	14.5	14.64	241900.0
2007-10-25	CVY	ETF	25.56	25.67	25.37	25.5	83400.0
2007-10-25	CWI	ETF	28.9467	29.0333	28.7867	29.0267	20100.0
2007-10-25	CZA	ETF	26.58	26.59	26.58	26.59	5600.0
2007-10-25	DBA	ETF	28.81	29.15	28.64	29.1	428100.0
2007-10-25	DBB	ETF	25.87	25.87	25.6	25.73	24400.0
2007-10-25	DBC	ETF	28.95	29.4	28.88	29.4	332500.0
2007-10-25	DBE	ETF	32.61	33.31	32.61	33.28	66400.0

> showing 50 of 529 rows — these rows as CSV

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