PREVIEW / etf_daily / 2006-12-13

all etf daily files

  file:    by_date/etf_daily/2006/2006-12-13.parquet
  size:    19 KB
  rows:    382

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-13	SPY	ETF	142.23	142.34	141.56	141.87	55520200.0
2006-12-13	QQQ	ETF	44.105	44.11	43.62	43.88	79065830.0
2006-12-13	IWM	ETF	78.91	79.0	78.15	78.65	47296600.0
2006-12-13	DIA	ETF	123.65	123.74	123.06	123.35	4444800.0
2006-12-13	GLD	ETF	62.1	62.57	61.88	62.48	3595400.0
2006-12-13	TLT	ETF	90.31	90.35	89.82	90.01	1217900.0
2006-12-13	AAA	ETF	61.13	61.15	61.01	61.15	1400.0
2006-12-13	ADRE	ETF	37.23	37.23	37.04	37.15	80007.0
2006-12-13	AGG	ETF	100.59	100.62	100.4	100.47	215700.0
2006-12-13	AIQ	ETF	31.85	32.25	31.4	31.9	51320.0
2006-12-13	AIS	ETF	1.22	1.22	1.14	1.17	84400.0
2006-12-13	ARB	ETF	44.64	44.71	44.3	44.36	91100.0
2006-12-13	BAB	ETF	100.23	100.75	99.98	100.599	51200.0
2006-12-13	BBC	ETF	4.37	4.37	4.07	4.09	603000.0
2006-12-13	BBH	ETF	62.3	62.3967	61.6367	61.7933	921300.0
2006-12-13	BITS	ETF	34.2	34.44	33.88	34.28	18244.0
2006-12-13	BNE	ETF	15.79	15.85	15.34	15.52	122800.0
2006-12-13	BRF	ETF	14.24	14.32	14.23	14.25	29200.0
2006-12-13	BTF	ETF	111.95	112.3	111.95	112.24999999999999	1220.0
2006-12-13	CBON	ETF	30.38	30.6	30.27	30.44	27112.0
2006-12-13	CDL	ETF	9.6	9.67	9.45	9.63	2232400.0
2006-12-13	CEF	ETF	9.54	9.54	9.43	9.47	265400.0
2006-12-13	CEW	ETF	25.74	25.74	25.63	25.63	200.0
2006-12-13	CFO	ETF	11.12	11.12	11.09	11.11	48500.0
2006-12-13	CGO	ETF	16.6	16.69	16.4	16.47	26300.0
2006-12-13	CHB	ETF	9.62	9.85	9.48	9.6	986400.0
2006-12-13	CHI	ETF	20.15	20.19	20.11	20.19	64200.0
2006-12-13	CHIC	ETF	30.72	31.3	30.72	31.13	316180.0
2006-12-13	CHY	ETF	17.0	17.18	17.0	17.07	109800.0
2006-12-13	CIL	ETF	25.29	25.29	25.28	25.29	1900.0
2006-12-13	CN	ETF	46.25	46.48	46.05	46.3	66200.0
2006-12-13	CNXT	ETF	2.2	2.21	2.12	2.12	9087695.0
2006-12-13	CPI	ETF	23.64	23.64	23.64	23.64	100.0
2006-12-13	CPST	ETF	1.3	1.32	1.29	1.3	713959.0
2006-12-13	CSA	ETF	22.01	22.05	21.79	22.0	15000.0
2006-12-13	CSB	ETF	33.1	33.45	33.09	33.39	18300.0
2006-12-13	CSM	ETF	1.3175	1.3175	1.31	1.31	98800.0
2006-12-13	CSQ	ETF	15.5	15.57	15.47	15.57	315700.0
2006-12-13	CTEC	ETF	92.75	93.64999999999999	91.5	93.64999999999999	16834.600000000002
2006-12-13	CVY	ETF	26.84	26.88	26.71	26.76	20900.0
2006-12-13	DBC	ETF	25.0	25.13	24.95	25.11	126400.0
2006-12-13	DBV	ETF	25.34	25.46	25.34	25.44	13000.0
2006-12-13	DDM	ETF	7.3592	7.3592	7.2842	7.305	478800.0
2006-12-13	DES	ETF	19.3	19.32	19.1967	19.2567	33600.0
2006-12-13	DEW	ETF	61.6	61.82	61.58	61.72	8600.0
2006-12-13	DFE	ETF	64.37	64.57	64.32	64.57	13400.0
2006-12-13	DFJ	ETF	50.84	50.97	50.77	50.79	6300.0
2006-12-13	DGT	ETF	75.51	75.81	75.5	75.6	12300.0
2006-12-13	DHS	ETF	57.4	57.65	57.32	57.48	20300.0
2006-12-13	DIM	ETF	63.02	63.19	62.99	63.14	13200.0

> showing 50 of 382 rows — these rows as CSV

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