PREVIEW / etf_daily / 2006-12-26

all etf daily files

  file:    by_date/etf_daily/2006/2006-12-26.parquet
  size:    19 KB
  rows:    384

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-26	SPY	ETF	140.81	141.61	140.78	141.58	32696900.0
2006-12-26	QQQ	ETF	42.93	43.12	42.88	43.11	50874360.0
2006-12-26	IWM	ETF	77.33	78.22	77.3	78.21	21798200.0
2006-12-26	DIA	ETF	123.17	124.01	123.17	123.97	4076200.0
2006-12-26	GLD	ETF	62.24	62.45	61.87	61.98	1975200.0
2006-12-26	TLT	ETF	89.45	89.69	89.36	89.66	496200.0
2006-12-26	AAA	ETF	61.98	62.0	61.92	61.96	1200.0
2006-12-26	ADRE	ETF	37.8	38.35	37.8	38.34	127035.0
2006-12-26	AGG	ETF	100.28	100.5	100.28	100.48	166000.0
2006-12-26	AIQ	ETF	32.75	33.45	32.75	33.25	19760.0
2006-12-26	AIS	ETF	1.16	1.2	1.15	1.2	199600.0
2006-12-26	ARB	ETF	43.63	44.27	43.63	43.97	89400.0
2006-12-26	BAB	ETF	102.05	102.1	101.0	102.05	39400.0
2006-12-26	BBC	ETF	4.22	4.59	4.2	4.55	458200.0
2006-12-26	BBH	ETF	61.0367	61.47	60.8733	61.03	404400.0
2006-12-26	BITS	ETF	33.76	33.76	33.28	33.28	4260.0
2006-12-26	BNE	ETF	15.44	15.82	15.44	15.49	120300.0
2006-12-26	BRF	ETF	14.4	14.4	14.29	14.29	38900.0
2006-12-26	BTF	ETF	108.49999999999999	108.49999999999999	107.55499999999999	107.89999999999999	2320.0
2006-12-26	CBON	ETF	30.0	30.14	29.8	30.04	58841.0
2006-12-26	CDL	ETF	9.52	9.75	9.47	9.71	269000.0
2006-12-26	CEF	ETF	9.28	9.33	9.18	9.23	266100.0
2006-12-26	CEW	ETF	26.0	26.0	25.98	25.98	1400.0
2006-12-26	CGO	ETF	16.54	16.6	16.53	16.59	2300.0
2006-12-26	CHB	ETF	9.32	9.49	9.24	9.41	476600.0
2006-12-26	CHI	ETF	20.22	20.42	20.22	20.42	64400.0
2006-12-26	CHIC	ETF	30.9	30.9	29.78	30.03	502334.0
2006-12-26	CHY	ETF	17.04	17.16	17.04	17.15	72700.0
2006-12-26	CIL	ETF	25.2	25.21	25.18	25.18	1700.0
2006-12-26	CN	ETF	49.75	52.36	49.75	52.0	112300.0
2006-12-26	CNXT	ETF	2.03	2.06	2.01	2.04	3818415.0
2006-12-26	CPI	ETF	23.52	23.52	23.52	23.52	100.0
2006-12-26	CPST	ETF	1.23	1.26	1.22	1.23	1028864.0
2006-12-26	CSA	ETF	21.1	21.45	21.09	21.28	23500.0
2006-12-26	CSB	ETF	34.09	34.09	33.2601	33.37	12300.0
2006-12-26	CSD	ETF	24.98	25.07	24.96	25.07	5600.0
2006-12-26	CSM	ETF	1.3225	1.33	1.3225	1.33	1200.0
2006-12-26	CSQ	ETF	15.56	15.74	15.53	15.74	163400.0
2006-12-26	CTEC	ETF	93.14999999999999	93.14999999999999	91.75	92.05	15779.800000000001
2006-12-26	CVY	ETF	26.35	26.46	26.35	26.46	35800.0
2006-12-26	DBC	ETF	24.83	24.88	24.31	24.37	210500.0
2006-12-26	DBV	ETF	25.84	25.84	25.76	25.82	102500.0
2006-12-26	DDM	ETF	6.7775	6.8433	6.775	6.8433	356400.0
2006-12-26	DEF	ETF	24.88	24.98	24.88	24.9799	4400.0
2006-12-26	DES	ETF	18.8833	19.1367	18.8833	19.1267	23100.0
2006-12-26	DEW	ETF	61.03	61.28	61.0	61.12	17200.0
2006-12-26	DFE	ETF	64.68	64.83	64.55	64.68	16800.0
2006-12-26	DFJ	ETF	50.65	50.73	50.52	50.72	13800.0
2006-12-26	DGT	ETF	75.6	75.9	75.52	75.9	5000.0
2006-12-26	DHS	ETF	57.3	57.73	57.3	57.73	9500.0

> showing 50 of 384 rows — these rows as CSV

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