PREVIEW / etf_daily / 2006-08-21

all etf daily files

  file:    by_date/etf_daily/2006/2006-08-21.parquet
  size:    18 KB
  rows:    362

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-21	SPY	ETF	130.18	130.28	129.8	130.13	42133600.0
2006-08-21	QQQ	ETF	38.47	38.56	38.26	38.42	66671704.0
2006-08-21	IWM	ETF	70.48	70.49	69.85	70.18	25383500.0
2006-08-21	DIA	ETF	113.43	113.56	113.1	113.5	5056000.0
2006-08-21	GLD	ETF	62.09	62.48	61.8	62.44	3595900.0
2006-08-21	TLT	ETF	86.89	87.08	86.87	87.08	676400.0
2006-08-21	AAA	ETF	57.54	57.68	57.28	57.28	2100.0
2006-08-21	ADRE	ETF	32.49	32.53	32.38	32.52	178894.0
2006-08-21	AFK	ETF	25.29	25.33	25.25	25.25	45900.0
2006-08-21	AGG	ETF	99.19	99.26	99.07	99.25	350600.0
2006-08-21	AIQ	ETF	32.55	32.7	31.8	32.1	9520.0
2006-08-21	AIS	ETF	0.92	0.95	0.88	0.89	155400.0
2006-08-21	AOM	ETF	5.67	5.75	5.58	5.66	19800.0
2006-08-21	ARB	ETF	35.66	35.82	35.35	35.41	88100.0
2006-08-21	BAB	ETF	74.78	75.04	74.2148	74.3	86300.0
2006-08-21	BBC	ETF	12.32	12.32	11.92	12.14	122800.0
2006-08-21	BBH	ETF	59.5	59.7733	59.22	59.64	694800.0
2006-08-21	BITS	ETF	27.6	28.6	26.84	28.2	45006.0
2006-08-21	BKF	ETF	4.01	4.06	3.99	4.06	14400.0
2006-08-21	BNE	ETF	15.3	15.32	15.12	15.26	119000.0
2006-08-21	BOSS	ETF	33.85	34.05	33.85	34.05	100.0
2006-08-21	BRF	ETF	14.1	14.12	14.09	14.1	25900.0
2006-08-21	BTF	ETF	91.19999999999999	91.19999999999999	90.8	90.95	560.0
2006-08-21	CBON	ETF	33.28	33.78	33.16	33.75	17330.0
2006-08-21	CDL	ETF	8.74	8.74	8.63	8.7	317800.0
2006-08-21	CEF	ETF	8.94	9.1	8.94	9.1	235000.0
2006-08-21	CEW	ETF	26.2	26.34	26.2	26.25	1800.0
2006-08-21	CFO	ETF	10.0	10.05	10.0	10.02	4800.0
2006-08-21	CGO	ETF	15.64	15.64	15.38	15.51	33500.0
2006-08-21	CHB	ETF	6.14	6.64	6.14	6.31	2456100.0
2006-08-21	CHI	ETF	20.35	20.44	20.31	20.34	66900.0
2006-08-21	CHIC	ETF	27.19	27.84	27.0	27.64	641730.0
2006-08-21	CHY	ETF	16.51	16.53	16.35	16.45	154400.0
2006-08-21	CN	ETF	36.05	36.35	35.76	36.19	44100.0
2006-08-21	CNXT	ETF	2.14	2.14	2.06	2.07	9688291.0
2006-08-21	COMB	ETF	9.8	9.85	9.8	9.8	88002.0
2006-08-21	CPST	ETF	1.99	2.0118	1.94	1.96	673812.0
2006-08-21	CSA	ETF	18.6	18.6	18.4	18.4	10900.0
2006-08-21	CSB	ETF	28.6	28.78	28.58	28.74	8200.0
2006-08-21	CSQ	ETF	14.45	14.45	14.37	14.44	353400.0
2006-08-21	CTEC	ETF	54.800000000000004	55.05	53.349999999999994	53.349999999999994	6716.0
2006-08-21	CYB	ETF	5.8	5.85	5.76	5.77	14800.0
2006-08-21	DBC	ETF	24.83	25.01	24.76	25.01	259800.0
2006-08-21	DDM	ETF	6.2217	6.2417	6.2108	6.235	547200.0
2006-08-21	DES	ETF	17.4167	17.4167	17.3567	17.4	22500.0
2006-08-21	DEW	ETF	54.59	54.59	54.41	54.43	6000.0
2006-08-21	DFE	ETF	55.36	55.65	55.36	55.65	1400.0
2006-08-21	DFJ	ETF	51.36	51.4	51.36	51.4	5400.0
2006-08-21	DGT	ETF	70.95	71.11	70.9	70.93	26700.0
2006-08-21	DHS	ETF	53.55	53.62	53.51	53.56	14000.0

> showing 50 of 362 rows — these rows as CSV

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