PREVIEW / etf_daily / 2007-06-14

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-14.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-14	SPY	ETF	152.06	153.12	152.03	152.86	146396500.0
2007-06-14	QQQ	ETF	47.1	47.49	47.09	47.36	101551500.0
2007-06-14	IWM	ETF	82.88	83.67	82.88	83.34	79451800.0
2007-06-14	DIA	ETF	134.96	135.87	134.85	135.7	12749000.0
2007-06-14	GLD	ETF	64.16	64.8	63.95	64.6	2765400.0
2007-06-14	TLT	ETF	83.14	83.71	83.05	83.12	3384700.0
2007-06-14	ADRE	ETF	44.701	45.44	44.701	45.38	176488.0
2007-06-14	AGG	ETF	97.47	97.68	97.39	97.54	230700.0
2007-06-14	AIQ	ETF	44.9	44.9	43.45	43.95	27420.0
2007-06-14	AIS	ETF	1.93	1.96	1.92	1.93	317200.0
2007-06-14	ARB	ETF	50.89	51.03	50.17	50.59	189000.0
2007-06-14	BBH	ETF	59.97	60.3633	59.94	59.9967	138900.0
2007-06-14	BIL	ETF	91.76	91.76	91.76	91.76	13400.0
2007-06-14	BITS	ETF	32.08	32.48	31.48	32.4	7315.0
2007-06-14	BIV	ETF	73.07	73.08	72.86	72.87	9000.0
2007-06-14	BLV	ETF	72.03	72.03	71.71	71.71	13000.0
2007-06-14	BMVP	ETF	18.0333	18.1396	18.0293	18.06	23800.0
2007-06-14	BND	ETF	73.55	73.64	73.47	73.47	109800.0
2007-06-14	BNE	ETF	19.31	19.5	19.3	19.44	314200.0
2007-06-14	BRF	ETF	14.48	14.51	14.46	14.47	7100.0
2007-06-14	BSV	ETF	74.53	74.53	74.44	74.52	82000.0
2007-06-14	BTF	ETF	110.19949999999999	110.44999999999999	109.7	110.00049999999999	4640.0
2007-06-14	CBON	ETF	29.23	30.21	29.15	29.51	48988.0
2007-06-14	CDL	ETF	6.15	6.15	6.0	6.05	13242985.0
2007-06-14	CEF	ETF	9.1	9.1	9.01	9.02	166100.0
2007-06-14	CGO	ETF	17.7	18.33	17.7	18.16	57400.0
2007-06-14	CGW	ETF	24.94	25.24	24.94	25.24	209200.0
2007-06-14	CHB	ETF	10.21	10.35	10.12	10.24	1248600.0
2007-06-14	CHI	ETF	19.93	20.18	19.93	20.03	66600.0
2007-06-14	CHIC	ETF	27.8	28.21	27.8	27.91	306981.0
2007-06-14	CHY	ETF	16.65	16.69	16.45	16.52	137400.0
2007-06-14	CN	ETF	53.43	53.88	53.26	53.76	101100.0
2007-06-14	CNXT	ETF	1.26	1.27	1.24	1.25	3844596.0
2007-06-14	CPI	ETF	22.8	22.8	22.8	22.8	200.0
2007-06-14	CPST	ETF	1.0	1.04	0.98	1.01	5208393.0
2007-06-14	CSA	ETF	19.58	19.63	19.5	19.62	32500.0
2007-06-14	CSB	ETF	31.49	31.67	31.37	31.5	16100.0
2007-06-14	CSD	ETF	30.9	31.07	30.9	31.07	47600.0
2007-06-14	CSQ	ETF	15.21	15.23	15.11	15.23	486100.0
2007-06-14	CTEC	ETF	107.3	110.0	107.3	109.0	142876.6
2007-06-14	CVY	ETF	27.89	27.99	27.89	27.91	34100.0
2007-06-14	CWI	ETF	27.0467	27.1467	27.0467	27.1267	17250.0
2007-06-14	CZA	ETF	27.18	27.18	27.18	27.18	1500.0
2007-06-14	DBA	ETF	27.3	27.62	27.15	27.5	446300.0
2007-06-14	DBB	ETF	26.81	27.04	26.68	26.82	22500.0
2007-06-14	DBC	ETF	26.41	26.59	26.29	26.49	2681200.0
2007-06-14	DBE	ETF	28.9	28.96	28.8	28.96	8100.0
2007-06-14	DBO	ETF	26.88	27.05	26.88	26.96	13700.0
2007-06-14	DBP	ETF	25.68	25.8	25.68	25.76	5800.0
2007-06-14	DBS	ETF	25.95	25.98	25.91	25.98	12900.0

> showing 50 of 479 rows — these rows as CSV

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