PREVIEW / etf_daily / 2007-07-06

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-06.parquet
  size:    22 KB
  rows:    485

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-06	SPY	ETF	152.38	153.17	151.93	152.98	81109000.0
2007-07-06	QQQ	ETF	48.71	48.91	48.5	48.86	65812537.0
2007-07-06	IWM	ETF	84.56	84.93	84.06	84.8	40975100.0
2007-07-06	DIA	ETF	135.63	136.31	135.36	136.13	8218700.0
2007-07-06	GLD	ETF	64.18	64.97	63.88	64.96	8080700.0
2007-07-06	TLT	ETF	83.54	83.55	83.28	83.48	1437800.0
2007-07-06	ADRE	ETF	47.1	47.61	47.01	47.58	92215.0
2007-07-06	AGG	ETF	97.41	97.6	97.32	97.51	281300.0
2007-07-06	AIQ	ETF	49.95	50.65	49.15	50.3	23820.0
2007-07-06	AIS	ETF	1.64	1.67	1.63	1.64	428400.0
2007-07-06	ARB	ETF	53.72	54.26	53.3	54.01	447700.0
2007-07-06	BBH	ETF	56.2833	56.2833	55.63	55.8867	1067700.0
2007-07-06	BIL	ETF	91.64	91.66	91.64	91.66	3800.0
2007-07-06	BITS	ETF	27.206	27.48	26.96	27.2	14140.0
2007-07-06	BIV	ETF	73.16	73.18	73.0	73.12	8200.0
2007-07-06	BLV	ETF	72.0	72.02	71.84	71.94	14200.0
2007-07-06	BMVP	ETF	18.15	18.25	18.09	18.22	76900.0
2007-07-06	BND	ETF	73.68	73.69	73.59	73.63	55400.0
2007-07-06	BNE	ETF	19.42	19.9	19.31	19.9	155800.0
2007-07-06	BRF	ETF	14.48	14.5	14.48	14.49	15900.0
2007-07-06	BSV	ETF	74.65	74.65	74.54	74.54	70700.0
2007-07-06	BTF	ETF	107.75	109.04999999999998	107.75	109.04999999999998	1280.0
2007-07-06	CBON	ETF	27.5	27.72	27.42	27.5	55849.0
2007-07-06	CDL	ETF	6.31	6.37	6.26	6.36	1835815.0
2007-07-06	CEF	ETF	9.08	9.21	9.04	9.2	167600.0
2007-07-06	CGO	ETF	18.19	18.29	18.166	18.214	22200.0
2007-07-06	CGW	ETF	25.9	25.9	25.75	25.75	194300.0
2007-07-06	CHB	ETF	9.66	10.13	9.66	10.02	1532400.0
2007-07-06	CHI	ETF	19.35	19.5	19.35	19.46	68100.0
2007-07-06	CHIC	ETF	25.54	26.3	25.49	25.95	409177.0
2007-07-06	CHY	ETF	16.45	16.5	16.45	16.46	77800.0
2007-07-06	CN	ETF	56.0	56.66	55.51	56.6	60400.0
2007-07-06	CNXT	ETF	1.41	1.48	1.41	1.47	9537200.0
2007-07-06	CPST	ETF	1.06	1.13	1.05	1.13	2902555.0
2007-07-06	CSA	ETF	20.14	20.14	19.8	20.09	14800.0
2007-07-06	CSB	ETF	31.99	32.39	31.94	32.1	239400.0
2007-07-06	CSD	ETF	31.19	31.34	31.17	31.32	28200.0
2007-07-06	CSQ	ETF	15.46	15.5	15.31	15.48	225500.0
2007-07-06	CTEC	ETF	111.64999999999999	113.05	110.64999999999999	112.39999999999999	16736.2
2007-07-06	CVY	ETF	27.9	28.03	27.87	27.99	18800.0
2007-07-06	CWI	ETF	27.8733	28.0133	27.86	27.9867	30450.0
2007-07-06	CZA	ETF	27.45	27.51	27.45	27.51	2400.0
2007-07-06	DBA	ETF	26.46	26.73	26.34	26.71	343700.0
2007-07-06	DBB	ETF	27.49	27.7	27.38	27.67	64800.0
2007-07-06	DBC	ETF	26.29	26.35	26.11	26.35	332500.0
2007-07-06	DBE	ETF	29.38	29.46	29.29	29.42	45100.0
2007-07-06	DBO	ETF	27.51	27.76	27.41	27.63	19600.0
2007-07-06	DBP	ETF	25.57	25.66	25.57	25.62	15300.0
2007-07-06	DBS	ETF	24.68	25.12	24.65	25.0376	51300.0
2007-07-06	DBV	ETF	29.25	29.26	29.09	29.21	188100.0

> showing 50 of 485 rows — these rows as CSV

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