PREVIEW / etf_daily / 2006-01-06

all etf daily files

  file:    by_date/etf_daily/2006/2006-01-06.parquet
  size:    16 KB
  rows:    296

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-01-06	SPY	ETF	128.02	128.58	127.36	128.44	62885900.0
2006-01-06	QQQ	ETF	42.26	42.7	42.06	42.68	110120922.0
2006-01-06	IWM	ETF	69.12	69.65	68.68	69.61	26874100.0
2006-01-06	DIA	ETF	109.33	109.7	108.76	109.52	9017800.0
2006-01-06	GLD	ETF	53.14	53.87	53.04	53.72	4629800.0
2006-01-06	TLT	ETF	91.77	91.9	91.49	91.72	1193700.0
2006-01-06	AAA	ETF	56.19	56.35	56.131	56.27	1100.0
2006-01-06	ADRE	ETF	122.19	123.017	121.42	122.91	38368.0
2006-01-06	AFK	ETF	25.24	25.29	25.22	25.29	7900.0
2006-01-06	AGG	ETF	100.88	100.89	100.6	100.65	201100.0
2006-01-06	AIQ	ETF	28.65	29.25	27.55	28.6	41120.0
2006-01-06	AIS	ETF	1.55	1.6	1.47	1.5	212000.0
2006-01-06	AOM	ETF	4.32	4.36	4.3	4.34	30300.0
2006-01-06	ARB	ETF	38.58	38.8	38.24	38.62	64900.0
2006-01-06	BAB	ETF	58.98	59.47	58.98	59.26	6700.0
2006-01-06	BBC	ETF	15.55	15.55	15.1	15.43	145900.0
2006-01-06	BBH	ETF	68.3733	68.5833	67.1967	67.2467	2131500.0
2006-01-06	BCM	ETF	67.57	67.8	67.34	67.74	36300.0
2006-01-06	BITS	ETF	14.48	15.4	14.32	14.7604	4012.0
2006-01-06	BKF	ETF	19.0	19.15	18.66	18.7	16900.0
2006-01-06	BNE	ETF	15.27	15.27	14.6	14.85	100600.0
2006-01-06	BRF	ETF	15.38	15.42	15.36	15.42	7000.0
2006-01-06	BTF	ETF	84.14999999999999	84.89999999999999	83.8	84.89999999999999	5640.0
2006-01-06	CBON	ETF	32.15	32.24	31.75	31.79	10128.0
2006-01-06	CDL	ETF	13.5	13.63	13.5	13.56	837200.0
2006-01-06	CEF	ETF	6.94	7.13	6.94	7.1	797400.0
2006-01-06	CEW	ETF	26.2	26.2	26.2	26.2	100.0
2006-01-06	CFO	ETF	9.88	9.89	9.85	9.89	3300.0
2006-01-06	CGO	ETF	14.25	14.33	14.14	14.33	22900.0
2006-01-06	CHB	ETF	13.48	13.51	12.9703	13.0	1175200.0
2006-01-06	CHI	ETF	20.16	20.37	20.16	20.3	65600.0
2006-01-06	CHIC	ETF	21.6	21.95	21.35	21.87	619674.0
2006-01-06	CHIR	ETF	44.85	44.85	44.6301	44.7699	598022.0
2006-01-06	CHY	ETF	16.05	16.07	15.9	15.97	113400.0
2006-01-06	CIL	ETF	25.32	25.32	25.32	25.32	400.0
2006-01-06	CN	ETF	33.5	34.41	33.5	34.1	64500.0
2006-01-06	CNXT	ETF	2.68	2.68	2.56	2.59	12695184.0
2006-01-06	COMB	ETF	8.2	8.2	8.0	8.0	700.0
2006-01-06	CPST	ETF	3.185	3.2	3.09	3.18	1759268.0
2006-01-06	CSA	ETF	17.25	17.41	17.25	17.38	32500.0
2006-01-06	CSB	ETF	32.06	32.29	31.96	32.23	21000.0
2006-01-06	CSM	ETF	2.46	2.46	2.46	2.46	400.0
2006-01-06	CSQ	ETF	13.66	13.79	13.64	13.76	371900.0
2006-01-06	CTEC	ETF	51.349999999999994	51.449999999999996	50.75	51.050000000000004	9045.6
2006-01-06	CURE	ETF	0.03	0.0312	0.0288	0.03	2439368.0
2006-01-06	CYB	ETF	3.5	3.61	3.5	3.61	4500.0
2006-01-06	DGT	ETF	66.92	67.4	66.92	67.28	4100.0
2006-01-06	DIG	ETF	16.8125	16.825	16.8125	16.8125	2480.0
2006-01-06	DIV	ETF	12.43	12.47	12.38	12.44	17600.0
2006-01-06	DRIV	ETF	31.04	33.38	31.02	32.83	1606336.0

> showing 50 of 296 rows — these rows as CSV

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