PREVIEW / etf_daily / 2006-02-02

all etf daily files

  file:    by_date/etf_daily/2006/2006-02-02.parquet
  size:    16 KB
  rows:    301

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-02-02	SPY	ETF	128.1	128.14	126.8	126.9	83626900.0
2006-02-02	QQQ	ETF	42.01	42.08	41.41	41.43	94051510.0
2006-02-02	IWM	ETF	73.0	73.09	71.66	72.0	46751000.0
2006-02-02	DIA	ETF	109.3	109.39	108.19	108.3	7334800.0
2006-02-02	GLD	ETF	57.04	57.3	56.67	56.98	5114300.0
2006-02-02	TLT	ETF	90.04	90.41	89.86	90.21	658500.0
2006-02-02	AAA	ETF	54.9	55.1	54.86	54.89	1500.0
2006-02-02	ADRE	ETF	131.7	131.7	128.1	128.5001	34056.0
2006-02-02	AFK	ETF	25.4	25.43	25.3	25.3	33800.0
2006-02-02	AGG	ETF	99.99	100.11	99.81	99.95	150400.0
2006-02-02	AIQ	ETF	22.05	23.0	21.6	22.3	30240.0
2006-02-02	AIS	ETF	1.41	1.45	1.37	1.39	274800.0
2006-02-02	AOM	ETF	5.6	5.64	5.54	5.58	13100.0
2006-02-02	ARB	ETF	39.38	39.42	38.44	38.98	258400.0
2006-02-02	BAB	ETF	57.74	58.91	57.57	58.65	34800.0
2006-02-02	BBC	ETF	18.8	18.8	17.0	17.0	1006400.0
2006-02-02	BBH	ETF	66.0	66.0	65.1633	65.4967	919800.0
2006-02-02	BCM	ETF	69.86	69.86	69.35	69.43	25300.0
2006-02-02	BITS	ETF	17.08	17.52	16.68	17.4	9850.0
2006-02-02	BKF	ETF	12.7	12.7	12.22	12.55	190200.0
2006-02-02	BNE	ETF	15.01	15.11	14.8	14.81	225200.0
2006-02-02	BOSS	ETF	35.8	35.8	34.79	34.79	100.0
2006-02-02	BRF	ETF	15.31	15.38	15.31	15.38	3800.0
2006-02-02	BTF	ETF	85.99999999999999	85.99999999999999	85.1	85.8	5840.0
2006-02-02	CBON	ETF	31.59	31.76	31.05	31.32	19821.0
2006-02-02	CDL	ETF	12.4	12.4	12.04	12.09	434500.0
2006-02-02	CEF	ETF	7.67	7.85	7.66	7.78	673700.0
2006-02-02	CEW	ETF	26.3	26.4	26.3	26.35	2600.0
2006-02-02	CFO	ETF	10.07	10.1	10.07	10.1	16700.0
2006-02-02	CGO	ETF	14.32	14.35	14.05	14.19	45600.0
2006-02-02	CHB	ETF	14.15	14.16	13.0	13.3	1551700.0
2006-02-02	CHI	ETF	20.37	20.58	20.35	20.58	89100.0
2006-02-02	CHIC	ETF	17.34	17.6	16.48	16.75	635016.0
2006-02-02	CHIR	ETF	45.5001	45.78	45.5001	45.5601	755453.0
2006-02-02	CHY	ETF	16.1	16.22	16.07	16.17	111400.0
2006-02-02	CIL	ETF	25.44	25.45	25.44	25.45	700.0
2006-02-02	CN	ETF	34.9	34.9	34.42	34.46	22300.0
2006-02-02	CNXT	ETF	3.29	3.3701	3.27	3.29	12949491.0
2006-02-02	COMB	ETF	8.41	8.42	8.4	8.42	3696.0
2006-02-02	CPI	ETF	30.05	30.05	30.05	30.05	900.0
2006-02-02	CPST	ETF	3.56	3.68	3.54	3.63	2429761.0
2006-02-02	CSA	ETF	18.85	18.9	18.76	18.77	27200.0
2006-02-02	CSB	ETF	31.15	31.19	30.95	31.01	28200.0
2006-02-02	CSQ	ETF	14.0	14.06	13.9	13.97	313000.0
2006-02-02	CTEC	ETF	54.1	54.74999999999999	53.49999999999999	54.059999999999995	6243.6
2006-02-02	CURE	ETF	0.0288	0.0306	0.0288	0.03	1954688.0
2006-02-02	CYB	ETF	4.4399	4.4399	4.4	4.4	1700.0
2006-02-02	DGT	ETF	66.57	66.57	66.05	66.05	900.0
2006-02-02	DIG	ETF	17.25	17.275	17.2375	17.2375	2800.0
2006-02-02	DIV	ETF	12.49	12.53	12.45	12.52	15000.0

> showing 50 of 301 rows — these rows as CSV

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