PREVIEW / etf_daily / 2007-06-08

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-08.parquet
  size:    22 KB
  rows:    479

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-08	SPY	ETF	149.58	151.19	149.09	151.04	175886000.0
2007-06-08	QQQ	ETF	46.33	46.93	46.16	46.91	177609963.0
2007-06-08	IWM	ETF	81.87	83.14	81.66	82.85	86239400.0
2007-06-08	DIA	ETF	132.81	134.23	132.48	134.1	19097800.0
2007-06-08	GLD	ETF	64.88	65.02	63.74	64.22	7313100.0
2007-06-08	TLT	ETF	83.61	84.12	83.36	83.8	5307600.0
2007-06-08	ADRE	ETF	43.32	44.1625	43.0	44.15	245568.0
2007-06-08	AGG	ETF	97.6	97.86	97.57	97.71	389700.0
2007-06-08	AIQ	ETF	45.0	45.7	44.1	45.6	44580.0
2007-06-08	AIS	ETF	1.98	1.99	1.9	1.95	206600.0
2007-06-08	ARB	ETF	51.13	52.01	51.051	51.92	109800.0
2007-06-08	BBH	ETF	58.7333	59.7333	58.7333	59.6967	1251000.0
2007-06-08	BIL	ETF	91.68	91.68	91.62	91.68	7850.0
2007-06-08	BITS	ETF	32.16	32.36	32.0	32.04	4510.0
2007-06-08	BIV	ETF	73.27	73.41	73.2	73.39	16600.0
2007-06-08	BLV	ETF	72.29	72.47	72.03	72.41	43200.0
2007-06-08	BMVP	ETF	17.75	17.96	17.6959	17.95	56500.0
2007-06-08	BND	ETF	73.75	73.86	73.64	73.84	62700.0
2007-06-08	BNE	ETF	19.15	19.35	19.05	19.25	266000.0
2007-06-08	BRF	ETF	14.48	14.58	14.48	14.51	20400.0
2007-06-08	BSV	ETF	74.44	74.56	74.44	74.54	13200.0
2007-06-08	BTF	ETF	108.94999999999999	110.19999999999999	108.9	110.19999999999999	1300.0
2007-06-08	CBON	ETF	29.2	29.85	29.13	29.61	37830.0
2007-06-08	CDL	ETF	8.39	8.47	8.32	8.39	997500.0
2007-06-08	CEF	ETF	9.05	9.11	8.9	9.03	534500.0
2007-06-08	CGO	ETF	17.76	17.94	17.72	17.88	19800.0
2007-06-08	CGW	ETF	24.81	25.01	24.69	25.01	201100.0
2007-06-08	CHB	ETF	10.33	10.53	10.0	10.4	2198500.0
2007-06-08	CHI	ETF	19.55	19.95	19.5	19.8	168800.0
2007-06-08	CHIC	ETF	28.37	28.54	27.98	28.54	440336.0
2007-06-08	CHY	ETF	16.19	16.64	16.16	16.6	243500.0
2007-06-08	CN	ETF	50.75	52.0	50.75	51.64	99800.0
2007-06-08	CNXT	ETF	1.26	1.3	1.24	1.29	3836282.0
2007-06-08	CPST	ETF	0.98	1.02	0.97	1.01	1067892.0
2007-06-08	CSA	ETF	19.65	20.0	19.65	19.84	24100.0
2007-06-08	CSB	ETF	31.52	31.6	31.3	31.58	10700.0
2007-06-08	CSD	ETF	30.2	30.47	30.05	30.41	41100.0
2007-06-08	CSQ	ETF	14.98	15.2	14.85	15.17	417773.0
2007-06-08	CTEC	ETF	101.85	103.05	100.35	102.14999999999999	72943.6
2007-06-08	CVY	ETF	27.53	27.88	27.53	27.88	27800.0
2007-06-08	CWI	ETF	26.6333	26.9267	26.5667	26.9267	26850.0
2007-06-08	CZA	ETF	26.71	26.71	26.71	26.71	100.0
2007-06-08	DBA	ETF	26.37	26.5	26.03	26.43	84700.0
2007-06-08	DBB	ETF	26.24	26.33	25.9	26.12	35900.0
2007-06-08	DBC	ETF	25.66	25.7399	25.39	25.49	909800.0
2007-06-08	DBE	ETF	28.3	28.37	27.85	27.85	28900.0
2007-06-08	DBO	ETF	26.53	26.53	26.0	26.03	27500.0
2007-06-08	DBP	ETF	25.87	25.95	25.39	25.59	19700.0
2007-06-08	DBS	ETF	26.31	26.31	25.55	25.83	39600.0
2007-06-08	DBV	ETF	28.72	28.85	28.67	28.85	191000.0

> showing 50 of 479 rows — these rows as CSV

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