PREVIEW / etf_daily / 2006-08-07

all etf daily files

  file:    by_date/etf_daily/2006/2006-08-07.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-07	SPY	ETF	127.9	128.08	127.4	127.9	45377300.0
2006-08-07	QQQ	ETF	36.92	36.94	36.53	36.71	69670953.0
2006-08-07	IWM	ETF	69.37	69.48	68.74	69.35	45882400.0
2006-08-07	DIA	ETF	112.14	112.42	111.85	112.34	3623200.0
2006-08-07	GLD	ETF	64.47	64.81	64.25	64.5	2493800.0
2006-08-07	TLT	ETF	86.33	86.39	86.18	86.37	1127600.0
2006-08-07	AAA	ETF	58.02	58.25	57.8	58.0	2300.0
2006-08-07	ADRE	ETF	32.07	32.17	31.7	31.98	130364.0
2006-08-07	AFK	ETF	25.21	25.2299	25.15	25.15	5000.0
2006-08-07	AGG	ETF	98.62	98.67	98.51	98.61	209400.0
2006-08-07	AIQ	ETF	32.25	32.7	31.3	32.25	10820.0
2006-08-07	AIS	ETF	1.09	1.09	1.03	1.06	166100.0
2006-08-07	AOM	ETF	6.1	6.18	6.1	6.18	3000.0
2006-08-07	ARB	ETF	36.28	36.33	35.5	35.79	125800.0
2006-08-07	BAB	ETF	72.16	72.65	71.59	71.99	71900.0
2006-08-07	BBC	ETF	13.0	13.39	13.0	13.27	79300.0
2006-08-07	BBH	ETF	59.14	59.14	58.3833	58.7	587100.0
2006-08-07	BITS	ETF	17.32	17.92	16.6	17.16	75870.0
2006-08-07	BKF	ETF	3.91	4.08	3.91	3.97	18100.0
2006-08-07	BNE	ETF	13.94	14.0	13.67	13.91	40700.0
2006-08-07	BRF	ETF	14.05	14.06	14.04	14.04	10100.0
2006-08-07	BTF	ETF	88.0	88.0	87.70049999999999	88.0	2600.0
2006-08-07	CBON	ETF	33.81	33.81	33.29	33.7	22500.0
2006-08-07	CDL	ETF	8.82	8.8344	8.0	8.23	872900.0
2006-08-07	CEF	ETF	9.22	9.24	9.11	9.19	244700.0
2006-08-07	CEW	ETF	25.97	25.97	25.97	25.97	500.0
2006-08-07	CFO	ETF	10.0	10.01	10.0	10.01	4500.0
2006-08-07	CGO	ETF	15.11	15.29	14.99	15.05	34300.0
2006-08-07	CHB	ETF	6.24	6.4	6.2	6.21	1160300.0
2006-08-07	CHI	ETF	20.08	20.32	20.07	20.26	83600.0
2006-08-07	CHIC	ETF	25.36	25.9	25.03	25.79	240146.0
2006-08-07	CHY	ETF	16.38	16.38	16.25	16.29	197800.0
2006-08-07	CIL	ETF	25.32	25.32	25.32	25.32	300.0
2006-08-07	CN	ETF	34.59	34.87	34.4	34.6	45600.0
2006-08-07	CNXT	ETF	1.65	1.67	1.6	1.61	11341503.0
2006-08-07	COMB	ETF	9.8	9.8	9.74	9.79	30012.0
2006-08-07	CPI	ETF	28.75	28.75	28.75	28.75	200.0
2006-08-07	CPST	ETF	2.03	2.03	1.9	1.9	831104.0
2006-08-07	CSA	ETF	18.4	18.46	18.2	18.2	154000.0
2006-08-07	CSB	ETF	26.34	26.39	26.17	26.2	6100.0
2006-08-07	CSQ	ETF	14.25	14.25	14.15	14.19	270300.0
2006-08-07	CTEC	ETF	55.99999999999999	56.15	54.5	55.14999999999999	10646.400000000001
2006-08-07	CYB	ETF	5.7	5.7	5.53	5.61	45100.0
2006-08-07	DBC	ETF	26.14	26.46	26.14	26.46	293200.0
2006-08-07	DDM	ETF	6.0992	6.1025	6.0583	6.0892	139200.0
2006-08-07	DES	ETF	17.3067	17.3133	17.2167	17.2167	11400.0
2006-08-07	DEW	ETF	53.75	53.75	53.5	53.54	2200.0
2006-08-07	DFE	ETF	54.14	54.45	54.14	54.45	400.0
2006-08-07	DFJ	ETF	49.15	49.15	49.08	49.08	300.0
2006-08-07	DGT	ETF	69.5	69.53	69.15	69.4	16800.0

> showing 50 of 359 rows — these rows as CSV

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