PREVIEW / etf_daily / 2006-12-22

all etf daily files

  file:    by_date/etf_daily/2006/2006-12-22.parquet
  size:    19 KB
  rows:    383

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-12-22	SPY	ETF	141.64	141.65	140.67	140.75	62069100.0
2006-12-22	QQQ	ETF	43.39	43.41	42.93	42.93	92884707.0
2006-12-22	IWM	ETF	77.59	77.75	77.05	77.11	31230400.0
2006-12-22	DIA	ETF	124.01	124.24	123.18	123.18	6811000.0
2006-12-22	GLD	ETF	61.45	61.8	61.32	61.65	1367400.0
2006-12-22	TLT	ETF	89.83	89.85	89.21	89.39	1433200.0
2006-12-22	AAA	ETF	62.33	62.33	61.75	61.94	14600.0
2006-12-22	ADRE	ETF	37.72	38.25	37.5	37.7	125215.0
2006-12-22	AGG	ETF	100.52	100.54	100.28	100.51	461300.0
2006-12-22	AIQ	ETF	32.5	33.15	32.0	32.55	45740.0
2006-12-22	AIS	ETF	1.19	1.19	1.15	1.18	133100.0
2006-12-22	ARB	ETF	43.69	43.93	43.25	43.7	65700.0
2006-12-22	BAB	ETF	101.4	101.7899	100.81	100.98	40800.0
2006-12-22	BBC	ETF	4.06	4.24	4.05	4.22	368900.0
2006-12-22	BBH	ETF	61.2	61.49	61.0033	61.0833	627000.0
2006-12-22	BITS	ETF	33.8	34.0	33.1876	33.96	9497.0
2006-12-22	BNE	ETF	15.47	15.66	15.41	15.5	78300.0
2006-12-22	BOSS	ETF	39.13	39.13	39.13	39.13	300.0
2006-12-22	BRF	ETF	14.38	14.38	14.3	14.3	17400.0
2006-12-22	BTF	ETF	107.5505	107.96699999999998	107.14999999999999	107.55	1180.0
2006-12-22	CBON	ETF	30.2	30.2	29.91	29.99	24455.0
2006-12-22	CDL	ETF	9.66	9.67	9.49	9.53	242300.0
2006-12-22	CEF	ETF	9.08	9.29	9.07	9.21	261300.0
2006-12-22	CGO	ETF	16.78	16.8199	16.5	16.55	16600.0
2006-12-22	CHB	ETF	9.28	9.45	9.21	9.32	838400.0
2006-12-22	CHI	ETF	20.24	20.42	20.24	20.35	78900.0
2006-12-22	CHIC	ETF	30.19	31.15	30.16	30.95	336409.0
2006-12-22	CHY	ETF	17.17	17.22	17.06	17.09	85900.0
2006-12-22	CN	ETF	49.75	50.35	49.45	49.95	78000.0
2006-12-22	CNXT	ETF	2.05	2.1	2.02	2.05	8930560.0
2006-12-22	CPST	ETF	1.24	1.27	1.24	1.24	1480615.0
2006-12-22	CSA	ETF	20.55	21.0	20.51	20.99	10800.0
2006-12-22	CSB	ETF	33.4	33.4	33.17	33.26	19900.0
2006-12-22	CSD	ETF	24.86	24.96	24.85	24.95	800.0
2006-12-22	CSQ	ETF	15.54	15.57	15.465	15.56	218300.0
2006-12-22	CTEC	ETF	92.79999999999998	94.25	92.05	93.75	24371.4
2006-12-22	CVY	ETF	26.46	26.5	26.3	26.36	40600.0
2006-12-22	DBC	ETF	24.66	24.9	24.58	24.75	202900.0
2006-12-22	DBV	ETF	25.85	25.85	25.59	25.79	111100.0
2006-12-22	DDM	ETF	6.835	6.835	6.7792	6.7875	675600.0
2006-12-22	DEF	ETF	24.97	24.97	24.81	24.88	20200.0
2006-12-22	DES	ETF	18.9067	18.9333	18.8633	18.9033	137400.0
2006-12-22	DEW	ETF	61.51	61.54	60.99	61.17	8600.0
2006-12-22	DFE	ETF	64.95	64.95	64.5	64.61	20600.0
2006-12-22	DFJ	ETF	50.8	50.8	50.42	50.74	11600.0
2006-12-22	DGT	ETF	75.85	75.85	75.45	75.67	2500.0
2006-12-22	DHS	ETF	57.56	57.56	57.3	57.33	25900.0
2006-12-22	DIM	ETF	63.28	63.28	62.76	63.02	16100.0
2006-12-22	DIV	ETF	13.52	13.53	13.45	13.52	33600.0
2006-12-22	DJP	ETF	48.71	48.89	48.61	48.86	187600.0

> showing 50 of 383 rows — these rows as CSV

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