PREVIEW / etf_daily / 2006-09-18

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-18.parquet
  size:    18 KB
  rows:    359

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
2006-09-18	SPY	ETF	131.79	132.39	131.65	132.14	64154100.0
2006-09-18	QQQ	ETF	40.12	40.4	39.94	40.1101	117821649.0
2006-09-18	IWM	ETF	72.35	73.07	72.14	72.64	37907200.0
2006-09-18	DIA	ETF	115.39	115.79	115.13	115.52	7036500.0
2006-09-18	GLD	ETF	57.47	58.39	57.42	58.23	4438700.0
2006-09-18	TLT	ETF	86.97	87.38	86.97	87.32	871400.0
2006-09-18	AAA	ETF	57.08	57.32	57.08	57.3	12900.0
2006-09-18	ADRE	ETF	32.1	32.41	32.0	32.32	123212.0
2006-09-18	AFK	ETF	25.05	25.08	25.0	25.02	4800.0
2006-09-18	AGG	ETF	98.86	99.25	98.86	99.23	237400.0
2006-09-18	AIQ	ETF	39.75	41.5	39.75	41.3	25620.0
2006-09-18	AIS	ETF	1.05	1.15	1.05	1.12	182300.0
2006-09-18	ARB	ETF	38.14	38.36	37.78	37.9	69500.0
2006-09-18	BAB	ETF	80.47	80.79	79.92	80.54	35600.0
2006-09-18	BBC	ETF	10.86	11.04	10.61	10.73	124100.0
2006-09-18	BBH	ETF	59.5	59.7333	59.3533	59.62	715200.0
2006-09-18	BITS	ETF	28.2	28.2	27.4	28.16	11137.0
2006-09-18	BNE	ETF	14.8	14.84	14.24	14.41	150200.0
2006-09-18	BRF	ETF	14.2	14.2	14.17	14.17	300.0
2006-09-18	BTF	ETF	93.94999999999999	94.45	93.94999999999999	94.25	4120.0
2006-09-18	CBON	ETF	32.65	32.8	32.4	32.62	77286.0
2006-09-18	CDL	ETF	9.28	9.41	9.2	9.38	259800.0
2006-09-18	CEF	ETF	8.17	8.31	8.12	8.22	350500.0
2006-09-18	CEW	ETF	25.29	25.37	25.29	25.37	2000.0
2006-09-18	CFO	ETF	9.9	9.9	9.82	9.85	4300.0
2006-09-18	CGO	ETF	15.56	15.56	15.18	15.51	39900.0
2006-09-18	CHB	ETF	6.78	7.09	6.65	7.04	1613700.0
2006-09-18	CHI	ETF	19.43	19.5184	19.43	19.45	131000.0
2006-09-18	CHIC	ETF	25.99	27.05	25.8	26.79	1480008.0
2006-09-18	CHY	ETF	16.7	16.76	16.62	16.68	138500.0
2006-09-18	CIL	ETF	25.6	25.6194	25.6	25.6194	500.0
2006-09-18	CN	ETF	35.3	35.85	35.3	35.76	41300.0
2006-09-18	CNXT	ETF	1.85	1.91	1.85	1.87	8146507.0
2006-09-18	COMB	ETF	10.01	10.01	10.01	10.01	302.0
2006-09-18	CPI	ETF	24.5	24.5	24.5	24.5	400.0
2006-09-18	CPST	ETF	1.52	1.55	1.47	1.52	1482817.0
2006-09-18	CSA	ETF	20.65	20.8	20.65	20.77	4400.0
2006-09-18	CSB	ETF	28.34	28.56	28.3	28.55	13000.0
2006-09-18	CSQ	ETF	14.5	14.57	14.42	14.57	435900.0
2006-09-18	CTEC	ETF	64.1	64.64949999999999	62.35	62.8	7828.0
2006-09-18	CYB	ETF	6.35	6.49	6.2756	6.46	50700.0
2006-09-18	DBC	ETF	23.45	23.7	23.32	23.56	345600.0
2006-09-18	DBV	ETF	25.01	25.1	25.01	25.1	3600.0
2006-09-18	DDM	ETF	6.45	6.495	6.4325	6.4633	462000.0
2006-09-18	DES	ETF	17.9233	18.0167	17.91	17.93	81300.0
2006-09-18	DEW	ETF	54.32	54.64	54.3	54.64	35500.0
2006-09-18	DFE	ETF	54.88	55.04	54.88	54.89	13300.0
2006-09-18	DFJ	ETF	49.07	49.52	49.07	49.45	24100.0
2006-09-18	DGT	ETF	70.3	70.72	70.3	70.52	7100.0
2006-09-18	DHS	ETF	54.5	54.6	54.41	54.49	16400.0

> showing 50 of 359 rows — these rows as CSV

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