PREVIEW / etf_daily / 2007-09-18

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-18.parquet
  size:    23 KB
  rows:    506

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-09-18	SPY	ETF	148.83	152.5	148.13	152.46	263759500.0
2007-09-18	QQQ	ETF	49.09	52.08	48.83	50.04	151452083.0
2007-09-18	IWM	ETF	77.81	80.6	77.24	80.52	138693800.0
2007-09-18	DIA	ETF	134.69	137.48	134.41	137.35	18362400.0
2007-09-18	GLD	ETF	71.2	72.0	70.4	71.7	14253100.0
2007-09-18	TLT	ETF	89.8	90.24	89.0	89.66	3132800.0
2007-09-18	ADRE	ETF	47.85	49.836	47.63	49.792	276286.0
2007-09-18	AGG	ETF	99.83	100.35	99.6	100.15	628000.0
2007-09-18	AIQ	ETF	44.5	46.0	44.0	45.6	34860.0
2007-09-18	AIS	ETF	1.41	1.44	1.41	1.44	109500.0
2007-09-18	ARB	ETF	46.03	47.73	45.99	47.3	356200.0
2007-09-18	BBH	ETF	57.25	58.3333	57.0233	58.2867	728700.0
2007-09-18	BIL	ETF	91.82	91.9	91.7	91.8	232950.0
2007-09-18	BITS	ETF	27.592	28.04	27.16	28.04	4199.0
2007-09-18	BIV	ETF	75.44	75.69	75.3	75.64	13300.0
2007-09-18	BLV	ETF	75.2	75.28	74.67	75.21	4400.0
2007-09-18	BMVP	ETF	16.77	17.17	16.74	17.1567	77700.0
2007-09-18	BND	ETF	75.58	75.92	75.45	75.82	74700.0
2007-09-18	BNE	ETF	15.85	16.73	15.79	16.71	273800.0
2007-09-18	BRF	ETF	14.57	14.57	14.56	14.57	12300.0
2007-09-18	BSV	ETF	75.8	75.99	75.69	75.99	63000.0
2007-09-18	BTF	ETF	104.85	106.3	104.85	105.99999999999999	1900.0
2007-09-18	CBON	ETF	23.87	25.51	23.56	25.44	78882.0
2007-09-18	CDL	ETF	4.13	4.4	4.1	4.35	2545200.0
2007-09-18	CEF	ETF	9.4	9.5	9.35	9.48	1080400.0
2007-09-18	CGO	ETF	17.07	17.35	17.05	17.32	26000.0
2007-09-18	CGW	ETF	24.51	25.25	24.5001	25.124	107500.0
2007-09-18	CHB	ETF	10.5	11.43	10.25	11.28	3803000.0
2007-09-18	CHI	ETF	16.24	16.73	16.16	16.7001	287900.0
2007-09-18	CHIC	ETF	17.13	17.84	16.75	17.73	436733.0
2007-09-18	CHW	ETF	13.25	13.4	13.02	13.4	137340.0
2007-09-18	CHY	ETF	14.29	14.78	14.21	14.77	278100.0
2007-09-18	CN	ETF	47.25	49.3	46.86	48.94	463400.0
2007-09-18	CNXT	ETF	1.23	1.29	1.215	1.29	9091011.0
2007-09-18	CPST	ETF	1.24	1.27	1.23	1.24	2542412.0
2007-09-18	CSA	ETF	18.82	19.0	18.57	18.83	138900.0
2007-09-18	CSD	ETF	28.43	29.0	28.35	29.0	16400.0
2007-09-18	CSM	ETF	1.46	1.4725	1.4525	1.4725	54000.0
2007-09-18	CSQ	ETF	14.09	14.37	13.83	14.36	433000.0
2007-09-18	CVY	ETF	25.86	26.54	25.86	26.54	24500.0
2007-09-18	CWI	ETF	26.6467	27.6467	26.6133	27.4267	108600.0
2007-09-18	CZA	ETF	25.96	25.96	25.96	25.96	500.0
2007-09-18	DBA	ETF	27.75	27.8	27.33	27.7	274900.0
2007-09-18	DBB	ETF	24.75	25.17	24.71	25.17	23600.0
2007-09-18	DBC	ETF	26.55	26.9	26.48	26.85	229600.0
2007-09-18	DBE	ETF	29.85	30.38	29.76	30.35	8400.0
2007-09-18	DBO	ETF	28.57	28.88	28.35	28.88	14100.0
2007-09-18	DBP	ETF	27.56	27.85	27.35	27.73	25000.0
2007-09-18	DBS	ETF	25.34	25.62	24.9999	25.62	13300.0
2007-09-18	DBV	ETF	27.57	27.93	27.34	27.93	223000.0

> showing 50 of 506 rows — these rows as CSV

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