PREVIEW / etf_daily / 2006-11-17

all etf daily files

  file:    by_date/etf_daily/2006/2006-11-17.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-11-17	SPY	ETF	139.93	140.43	139.73	140.42	56353800.0
2006-11-17	QQQ	ETF	44.06	44.3	43.95	44.3	95198351.0
2006-11-17	IWM	ETF	78.35	78.61	77.84	78.59	35969400.0
2006-11-17	DIA	ETF	122.81	123.3	122.67	123.26	6493600.0
2006-11-17	GLD	ETF	61.4	61.78	61.34	61.78	3390900.0
2006-11-17	TLT	ETF	89.56	90.22	89.51	89.95	1752000.0
2006-11-17	AAA	ETF	57.8	58.05	57.71	57.91	10800.0
2006-11-17	ADRE	ETF	35.4	35.5988	35.35	35.5601	149533.0
2006-11-17	AGG	ETF	100.11	100.35	100.08	100.32	534400.0
2006-11-17	AIQ	ETF	34.1	34.65	31.4	31.4	86160.0
2006-11-17	AIS	ETF	1.25	1.27	1.22	1.26	62600.0
2006-11-17	ARB	ETF	44.33	45.41	44.33	45.25	297100.0
2006-11-17	BAB	ETF	90.46	91.59	90.23	91.57	53900.0
2006-11-17	BBC	ETF	4.6	5.15	4.41	5.02	1269800.0
2006-11-17	BBH	ETF	62.7	63.34	62.62	63.3333	955200.0
2006-11-17	BITS	ETF	34.4	34.64	33.6	33.76	27732.0
2006-11-17	BNE	ETF	15.78	15.91	15.7	15.91	130200.0
2006-11-17	BRF	ETF	14.23	14.28	14.23	14.23	11000.0
2006-11-17	BTF	ETF	105.74999999999999	106.1495	105.74999999999999	106.05	4180.0
2006-11-17	CBON	ETF	31.2	31.39	30.71	31.33	55074.0
2006-11-17	CDL	ETF	9.89	9.93	9.82	9.89	391700.0
2006-11-17	CEF	ETF	9.01	9.12	9.0	9.01	421700.0
2006-11-17	CEW	ETF	25.52	25.52	25.52	25.52	200.0
2006-11-17	CFO	ETF	10.65	10.65	10.65	10.65	800.0
2006-11-17	CGO	ETF	15.8	15.9	15.7	15.9	38200.0
2006-11-17	CHB	ETF	9.28	9.39	9.09	9.33	1052200.0
2006-11-17	CHI	ETF	19.6	19.76	19.6	19.73	77700.0
2006-11-17	CHIC	ETF	27.86	28.69	27.86	28.44	515797.0
2006-11-17	CHY	ETF	16.85	16.9	16.782	16.86	167200.0
2006-11-17	CIL	ETF	25.89	25.89	25.89	25.89	100.0
2006-11-17	CN	ETF	39.45	39.81	39.45	39.66	37400.0
2006-11-17	CNXT	ETF	2.21	2.22	2.16	2.17	8231480.0
2006-11-17	CPST	ETF	1.4	1.4	1.33	1.36	1636450.0
2006-11-17	CSA	ETF	20.35	21.2	20.26	20.94	43600.0
2006-11-17	CSB	ETF	31.28	31.4	31.19	31.32	12100.0
2006-11-17	CSM	ETF	1.3025	1.305	1.3025	1.305	8800.0
2006-11-17	CSQ	ETF	14.95	14.98	14.87	14.97	425500.0
2006-11-17	CTEC	ETF	91.69999999999999	92.5	90.64999999999999	91.44999999999999	21100.800000000003
2006-11-17	CVY	ETF	26.24	26.24	26.1	26.22	36200.0
2006-11-17	CYB	ETF	6.76	7.0	6.69	6.95	49800.0
2006-11-17	DBC	ETF	24.11	24.53	24.0	24.52	217200.0
2006-11-17	DBV	ETF	25.36	25.4	25.3	25.38	81300.0
2006-11-17	DDM	ETF	7.2658	7.3367	7.2658	7.3367	705600.0
2006-11-17	DES	ETF	19.0867	19.0933	19.0167	19.0833	26700.0
2006-11-17	DEW	ETF	59.18	59.61	59.18	59.61	5600.0
2006-11-17	DFE	ETF	60.3	60.59	60.3	60.58	3400.0
2006-11-17	DFJ	ETF	48.13	48.16	47.89	48.08	12600.0
2006-11-17	DGT	ETF	74.55	76.67	74.4	74.89	11300.0
2006-11-17	DHS	ETF	56.55	56.77	56.43	56.74	15500.0
2006-11-17	DIM	ETF	59.63	60.01	59.63	60.01	10300.0

> showing 50 of 384 rows — these rows as CSV

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