PREVIEW / etf_daily / 2006-08-23

all etf daily files

  file:    by_date/etf_daily/2006/2006-08-23.parquet
  size:    18 KB
  rows:    359

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-08-23	SPY	ETF	130.18	130.44	129.19	129.76	66592100.0
2006-08-23	QQQ	ETF	38.47	38.67	37.92	38.14	96067499.0
2006-08-23	IWM	ETF	70.5	70.8	69.2	69.6	37109000.0
2006-08-23	DIA	ETF	113.28	113.62	112.58	113.11	7033800.0
2006-08-23	GLD	ETF	62.56	62.68	61.75	61.83	3573700.0
2006-08-23	TLT	ETF	87.06	87.24	86.86	87.15	801700.0
2006-08-23	AAA	ETF	57.73	58.0	57.42	57.64	8800.0
2006-08-23	ADRE	ETF	32.52	32.61	31.9	31.97	40515.0
2006-08-23	AFK	ETF	25.27	25.31	25.27	25.31	3700.0
2006-08-23	AGG	ETF	99.2	99.3	99.06	99.23	157200.0
2006-08-23	AIQ	ETF	32.4	32.65	32.0	32.25	14360.0
2006-08-23	AIS	ETF	1.02	1.11	1.02	1.07	562400.0
2006-08-23	AOM	ETF	5.55	5.67	5.55	5.6	67600.0
2006-08-23	ARB	ETF	35.3	35.55	35.18	35.41	227700.0
2006-08-23	BAB	ETF	74.86	75.0	74.18	74.31	47900.0
2006-08-23	BBC	ETF	12.4	12.47	12.14	12.24	197400.0
2006-08-23	BBH	ETF	58.8167	59.2367	58.5033	59.1833	924600.0
2006-08-23	BITS	ETF	29.84	30.76	29.0	29.16	54508.0
2006-08-23	BKF	ETF	4.17	4.23	4.0	4.0	20300.0
2006-08-23	BNE	ETF	15.23	15.45	14.9	15.0	121600.0
2006-08-23	BRF	ETF	14.09	14.1	14.09	14.1	2700.0
2006-08-23	BTF	ETF	91.14999999999999	91.14999999999999	90.39999999999999	90.74999999999999	8660.0
2006-08-23	CBON	ETF	34.0	34.14	33.76	34.09	25649.0
2006-08-23	CDL	ETF	8.72	8.77	8.61	8.62	363600.0
2006-08-23	CEF	ETF	9.0	9.14	9.0	9.07	222900.0
2006-08-23	CEW	ETF	26.25	26.25	26.25	26.25	300.0
2006-08-23	CFO	ETF	10.12	10.12	10.1	10.1	8300.0
2006-08-23	CGO	ETF	15.38	15.38	15.09	15.28	43700.0
2006-08-23	CHB	ETF	6.26	6.31	5.85	5.97	851800.0
2006-08-23	CHI	ETF	20.29	20.32	20.23	20.32	88300.0
2006-08-23	CHIC	ETF	27.64	27.84	27.47	27.62	212291.0
2006-08-23	CHY	ETF	16.4	16.43	16.31	16.31	114400.0
2006-08-23	CIL	ETF	25.41	25.41	25.41	25.41	400.0
2006-08-23	CN	ETF	35.78	35.93	34.75	34.93	70000.0
2006-08-23	CNXT	ETF	2.18	2.2601	2.12	2.16	15058415.0
2006-08-23	COMB	ETF	10.0	10.04	9.9	9.9	50905.0
2006-08-23	CPST	ETF	1.9	1.92	1.86	1.87	690485.0
2006-08-23	CSA	ETF	18.65	18.65	18.5	18.55	8600.0
2006-08-23	CSB	ETF	29.42	29.42	29.05	29.13	9000.0
2006-08-23	CSQ	ETF	14.45	14.46	14.35	14.4	310300.0
2006-08-23	CTEC	ETF	53.65	56.449999999999996	53.6	54.699999999999996	27343.0
2006-08-23	CYB	ETF	5.58	5.63	5.55	5.55	32700.0
2006-08-23	DBC	ETF	24.92	24.92	24.63	24.71	322600.0
2006-08-23	DDM	ETF	6.23	6.2558	6.1417	6.1667	794400.0
2006-08-23	DES	ETF	17.5	17.5067	17.2133	17.25	33900.0
2006-08-23	DEW	ETF	55.7	55.87	53.82	54.48	19700.0
2006-08-23	DFE	ETF	55.2	55.2	54.4	54.53	109200.0
2006-08-23	DFJ	ETF	53.0	53.0	51.21	51.67	1600.0
2006-08-23	DGT	ETF	71.0	71.12	70.7	70.72	7200.0
2006-08-23	DHS	ETF	53.7	53.73	53.4	53.48	11400.0

> showing 50 of 359 rows — these rows as CSV

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