PREVIEW / etf_daily / 2007-10-30

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-30.parquet
  size:    24 KB
  rows:    528

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-30	SPY	ETF	153.45	153.75	152.87	153.06	132981600.0
2007-10-30	QQQ	ETF	53.94	54.56	53.9	54.26	114616598.0
2007-10-30	IWM	ETF	81.51	81.96	80.96	81.27	59967000.0
2007-10-30	DIA	ETF	138.19	138.55	137.66	137.82	8531000.0
2007-10-30	GLD	ETF	77.66	77.66	77.01	77.35	5608600.0
2007-10-30	TLT	ETF	90.73	91.01	90.42	90.8	1439600.0
2007-10-30	ADRE	ETF	59.12	59.97	58.45	58.65	364552.0
2007-10-30	AGG	ETF	100.85	100.89	100.7	100.89	252400.0
2007-10-30	AIQ	ETF	45.95	47.7	45.75	47.15	35660.0
2007-10-30	AIS	ETF	1.2	1.25	1.2	1.24	142300.0
2007-10-30	AIVI	ETF	76.45	76.79	76.28	76.55	23500.0
2007-10-30	ARB	ETF	49.91	50.26	49.67	50.0	185300.0
2007-10-30	BBH	ETF	59.63	59.9533	59.54	59.79	399000.0
2007-10-30	BIL	ETF	91.88	91.88	91.82	91.82	5250.0
2007-10-30	BITS	ETF	26.52	26.52	25.84	25.92	5379.0
2007-10-30	BIV	ETF	76.46	76.54	76.38	76.5	12000.0
2007-10-30	BLV	ETF	76.57	76.68	76.39	76.58	3000.0
2007-10-30	BMVP	ETF	17.5867	17.6333	17.4967	17.5	49900.0
2007-10-30	BND	ETF	76.33	76.38	76.28	76.38	86800.0
2007-10-30	BNE	ETF	17.38	17.5	16.95	17.04	117700.0
2007-10-30	BRF	ETF	14.69	14.7	14.62	14.68	12800.0
2007-10-30	BSV	ETF	76.41	76.44	76.37	76.41	59200.0
2007-10-30	BTF	ETF	116.5	119.45	116.25	116.35	17300.0
2007-10-30	BWX	ETF	26.55	26.575	26.5375	26.55	91600.0
2007-10-30	CBON	ETF	20.02	20.4	19.53	20.01	89587.0
2007-10-30	CDL	ETF	4.4	4.42	4.31	4.35	1212800.0
2007-10-30	CEF	ETF	10.35	10.42	10.17	10.28	378600.0
2007-10-30	CGO	ETF	19.5	19.58	19.25	19.3	18500.0
2007-10-30	CGW	ETF	26.54	26.59	26.29	26.39	106100.0
2007-10-30	CHB	ETF	11.4	11.67	11.13	11.65	8981900.0
2007-10-30	CHI	ETF	16.95	17.0	16.88	16.9	133500.0
2007-10-30	CHIC	ETF	15.0	15.0	14.67	14.72	298377.0
2007-10-30	CHW	ETF	13.14	13.18	12.95	13.07	226900.0
2007-10-30	CHY	ETF	14.83	14.86	14.69	14.76	142700.0
2007-10-30	CMF	ETF	52.055	52.055	51.985	52.05	16200.0
2007-10-30	CN	ETF	62.95	62.95	60.62	60.8	167700.0
2007-10-30	CNXT	ETF	1.27	1.28	1.23	1.25	4336426.0
2007-10-30	CPST	ETF	1.16	1.17	1.09	1.13	2012595.0
2007-10-30	CSA	ETF	17.03	17.25	16.98	17.05	38500.0
2007-10-30	CSD	ETF	28.78	28.82	28.7	28.72	44700.0
2007-10-30	CSQ	ETF	14.67	14.72	14.6	14.64	222000.0
2007-10-30	CVY	ETF	25.78	25.88	25.77	25.78	13200.0
2007-10-30	CWI	ETF	29.72	29.8133	29.6333	29.7	42450.0
2007-10-30	CZA	ETF	26.88	26.9499	26.88	26.94	900.0
2007-10-30	DBA	ETF	29.49	29.56	29.1	29.27	407500.0
2007-10-30	DBB	ETF	25.52	25.75	25.42	25.7	32400.0
2007-10-30	DBC	ETF	30.0	30.0399	29.57	29.66	283000.0
2007-10-30	DBE	ETF	33.97	33.99	33.12	33.14	10900.0
2007-10-30	DBO	ETF	33.48	33.48	32.52	32.7	13700.0
2007-10-30	DBP	ETF	29.87	29.97	29.82	29.87	24200.0

> showing 50 of 528 rows — these rows as CSV

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