PREVIEW / etf_daily / 2007-06-18

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-18.parquet
  size:    22 KB
  rows:    484

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-06-18	SPY	ETF	153.38	153.39	152.66	152.89	88537500.0
2007-06-18	QQQ	ETF	47.85	47.87	47.67	47.77	75766515.0
2007-06-18	IWM	ETF	84.58	84.62	83.7	84.17	60117800.0
2007-06-18	DIA	ETF	136.49	136.54	135.93	135.94	10175000.0
2007-06-18	GLD	ETF	65.19	65.25	64.82	64.95	1791000.0
2007-06-18	TLT	ETF	83.63	83.65	82.24	83.52	17704600.0
2007-06-18	ADRE	ETF	46.29	46.4	45.91	46.07	288764.0
2007-06-18	AGG	ETF	97.85	97.98	97.66	97.96	242200.0
2007-06-18	AIQ	ETF	45.4	45.55	43.8	43.95	44660.0
2007-06-18	AIS	ETF	2.05	2.05	2.0	2.02	204600.0
2007-06-18	ARB	ETF	51.1	51.11	50.05	50.23	209300.0
2007-06-18	BBH	ETF	60.3333	60.4067	60.03	60.2333	454500.0
2007-06-18	BIL	ETF	91.82	91.88	91.8	91.86	28000.0
2007-06-18	BITS	ETF	31.88	32.12	31.8	31.92	10066.0
2007-06-18	BIV	ETF	73.27	73.37	73.17	73.37	7100.0
2007-06-18	BLV	ETF	72.11	72.27	71.98	72.27	9100.0
2007-06-18	BMVP	ETF	18.07	18.11	18.03	18.05	35300.0
2007-06-18	BND	ETF	73.83	73.94	73.73	73.76	60300.0
2007-06-18	BNE	ETF	19.76	19.93	19.6	19.84	384000.0
2007-06-18	BRF	ETF	14.47	14.47	14.47	14.47	500.0
2007-06-18	BSV	ETF	74.65	74.65	74.61	74.65	10900.0
2007-06-18	BTF	ETF	109.49999999999999	109.85	108.85	109.8	1220.0
2007-06-18	CBON	ETF	29.92	30.76	29.65	29.91	60170.0
2007-06-18	CDL	ETF	6.15	6.82	6.13	6.6	10216417.0
2007-06-18	CEF	ETF	9.16	9.24	9.1	9.23	281300.0
2007-06-18	CGO	ETF	18.34	18.4	18.21	18.3	32200.0
2007-06-18	CGW	ETF	25.56	25.6	25.31	25.46	159500.0
2007-06-18	CHB	ETF	10.74	10.89	10.66	10.81	1403553.0
2007-06-18	CHI	ETF	20.1	20.1193	20.05	20.08	75300.0
2007-06-18	CHIC	ETF	27.77	27.77	27.45	27.51	353348.0
2007-06-18	CHY	ETF	16.41	16.48	16.26	16.3	148500.0
2007-06-18	CN	ETF	55.32	55.5	54.79	55.28	143200.0
2007-06-18	CNXT	ETF	1.28	1.29	1.25	1.27	6435632.0
2007-06-18	CPI	ETF	23.25	23.25	22.8	22.8	2300.0
2007-06-18	CPST	ETF	1.0	1.02	0.9895	1.01	2116716.0
2007-06-18	CSA	ETF	20.0	20.01	19.57	19.73	48200.0
2007-06-18	CSB	ETF	32.19	32.3	31.98	32.05	13700.0
2007-06-18	CSD	ETF	31.27	31.27	31.06	31.19	48300.0
2007-06-18	CSM	ETF	1.42	1.42	1.42	1.42	400.0
2007-06-18	CSQ	ETF	15.3	15.32	15.21	15.29	372900.0
2007-06-18	CTEC	ETF	111.8	111.85	108.8	109.0	46965.600000000006
2007-06-18	CVY	ETF	28.44	28.46	27.68	28.2	23300.0
2007-06-18	CWI	ETF	27.46	27.5467	27.4333	27.4467	21600.0
2007-06-18	CZA	ETF	27.31	27.31	27.31	27.31	500.0
2007-06-18	DBA	ETF	27.95	28.35	27.61	28.15	548800.0
2007-06-18	DBB	ETF	26.98	27.2	26.5	26.88	34900.0
2007-06-18	DBC	ETF	26.73	26.73	26.5	26.65	259600.0
2007-06-18	DBE	ETF	28.96	29.38	28.96	29.36	129400.0
2007-06-18	DBO	ETF	27.14	27.45	27.03	27.41	127800.0
2007-06-18	DBP	ETF	26.01	26.01	25.85	25.92	10100.0

> showing 50 of 484 rows — these rows as CSV

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