PREVIEW / etf_daily / 2006-01-12

all etf daily files

  file:    by_date/etf_daily/2006/2006-01-12.parquet
  size:    16 KB
  rows:    299

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-12	SPY	ETF	129.08	129.28	128.44	128.8	40509200.0
2006-01-12	QQQ	ETF	43.16	43.29	42.85	43.0	82429110.0
2006-01-12	IWM	ETF	70.45	70.74	70.05	70.33	24564000.0
2006-01-12	DIA	ETF	110.22	110.23	109.51	109.77	6331700.0
2006-01-12	GLD	ETF	54.21	54.64	54.01	54.43	3603000.0
2006-01-12	TLT	ETF	91.13	91.52	91.0	91.5	626600.0
2006-01-12	AAA	ETF	54.85	55.2	54.79	54.84	4000.0
2006-01-12	ADRE	ETF	123.11	124.14	122.52	122.77	64932.0
2006-01-12	AFK	ETF	25.3	25.3	25.22	25.25	35800.0
2006-01-12	AGG	ETF	100.52	100.81	100.35	100.75	188200.0
2006-01-12	AIQ	ETF	28.35	28.55	27.25	27.75	23400.0
2006-01-12	AIS	ETF	1.42	1.45	1.4	1.42	143800.0
2006-01-12	AOM	ETF	4.67	5.25	4.67	5.2	136400.0
2006-01-12	ARB	ETF	39.19	39.6	39.01	39.26	84400.0
2006-01-12	BAB	ETF	59.31	59.71	58.88	58.88	35100.0
2006-01-12	BBC	ETF	16.3	17.439	16.16	17.28	343300.0
2006-01-12	BBH	ETF	66.6633	66.6633	65.37	65.77	2489400.0
2006-01-12	BCM	ETF	69.1	69.59	68.45	68.6	53900.0
2006-01-12	BITS	ETF	13.84	15.0	13.84	14.2	2274.0
2006-01-12	BKF	ETF	18.55	18.63	18.3	18.47	24300.0
2006-01-12	BNE	ETF	15.17	15.17	14.52	14.52	171400.0
2006-01-12	BRF	ETF	15.25	15.41	15.22	15.25	9700.0
2006-01-12	BTF	ETF	86.14999999999999	86.3	85.8	85.8	1040.0
2006-01-12	CBON	ETF	32.58	32.69	32.55	32.57	12848.0
2006-01-12	CDL	ETF	13.14	13.25	13.03	13.16	296400.0
2006-01-12	CEF	ETF	7.11	7.19	7.09	7.14	394100.0
2006-01-12	CEW	ETF	26.2	26.23	26.2	26.23	1700.0
2006-01-12	CFO	ETF	9.9	9.9	9.9	9.9	5600.0
2006-01-12	CGO	ETF	14.5	14.5	14.2	14.45	48700.0
2006-01-12	CHB	ETF	14.02	14.05	13.27	13.38	730100.0
2006-01-12	CHI	ETF	20.02	20.17	19.9901	20.13	77700.0
2006-01-12	CHIC	ETF	19.89	20.66	19.88	20.44	812110.0
2006-01-12	CHIR	ETF	44.6499	44.7501	44.6301	44.6901	588639.0
2006-01-12	CHY	ETF	16.0	16.1	15.92	16.1	94600.0
2006-01-12	CIL	ETF	25.33	25.33	25.33	25.33	400.0
2006-01-12	CN	ETF	34.9	34.91	34.47	34.48	29700.0
2006-01-12	CNXT	ETF	3.35	3.47	3.24	3.29	35489988.0
2006-01-12	COMB	ETF	8.2	8.35	8.2	8.35	10499.0
2006-01-12	CPI	ETF	28.05	28.3	28.05	28.3	1000.0
2006-01-12	CPST	ETF	3.44	3.62	3.41	3.46	6293350.0
2006-01-12	CSA	ETF	17.6	17.89	17.55	17.8	26900.0
2006-01-12	CSB	ETF	32.35	32.35	32.0	32.01	6400.0
2006-01-12	CSM	ETF	2.4625	2.4625	2.4625	2.4625	20000.0
2006-01-12	CSQ	ETF	14.04	14.11	13.9	13.97	438400.0
2006-01-12	CTEC	ETF	48.349999999999994	48.75	47.75	47.949999999999996	21650.600000000002
2006-01-12	CURE	ETF	0.03	0.0312	0.0275	0.0288	2075392.0
2006-01-12	CYB	ETF	3.9	3.95	3.84	3.85	11200.0
2006-01-12	DGT	ETF	67.28	67.42	67.07	67.09	25500.0
2006-01-12	DIG	ETF	17.05	17.05	17.05	17.05	1600.0
2006-01-12	DIV	ETF	12.46	12.47	12.42	12.45	30400.0

> showing 50 of 299 rows — these rows as CSV

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