PREVIEW / etf_daily / 2006-10-19

all etf daily files

  file:    by_date/etf_daily/2006/2006-10-19.parquet
  size:    19 KB
  rows:    373

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-10-19	SPY	ETF	136.39	136.88	136.23	136.81	64063200.0
2006-10-19	QQQ	ETF	41.69	42.1101	41.59	41.9	108239420.0
2006-10-19	IWM	ETF	75.73	76.4	75.58	76.35	43889000.0
2006-10-19	DIA	ETF	119.82	120.31	119.67	120.15	6592000.0
2006-10-19	GLD	ETF	59.04	59.65	59.02	59.41	2952900.0
2006-10-19	TLT	ETF	87.59	87.76	87.36	87.64	797300.0
2006-10-19	AAA	ETF	54.0	54.56	53.93	54.1	17700.0
2006-10-19	ADRE	ETF	34.0	34.085	33.5	34.02	271082.0
2006-10-19	AGG	ETF	99.39	99.48	99.29	99.47	174200.0
2006-10-19	AIQ	ETF	40.7	41.5	40.65	40.95	15240.0
2006-10-19	AIS	ETF	1.17	1.38	1.17	1.37	558600.0
2006-10-19	ARB	ETF	37.93	39.15	37.9	38.79	246800.0
2006-10-19	BAB	ETF	84.76	85.34	84.65	84.99	94000.0
2006-10-19	BBC	ETF	10.45	10.7999	9.8	9.82	503600.0
2006-10-19	BBH	ETF	62.9767	63.1033	62.6867	62.8433	538200.0
2006-10-19	BITS	ETF	38.84	41.08	38.2	39.48	69705.0
2006-10-19	BNE	ETF	15.6	15.99	15.44	15.71	140300.0
2006-10-19	BRF	ETF	14.25	14.36	14.22	14.26	27300.0
2006-10-19	BTF	ETF	100.44999999999999	100.85000000000001	100.2505	100.39999999999999	1800.0
2006-10-19	CBON	ETF	31.04	31.04	30.18	30.33	81160.0
2006-10-19	CDL	ETF	9.71	9.79	9.63	9.67	165700.0
2006-10-19	CEF	ETF	8.42	8.56	8.42	8.56	231800.0
2006-10-19	CFO	ETF	10.0	10.1	10.0	10.1	8000.0
2006-10-19	CGO	ETF	15.65	15.8	15.5	15.77	32800.0
2006-10-19	CHB	ETF	7.71	7.94	7.6203	7.91	1095500.0
2006-10-19	CHI	ETF	19.26	19.28	19.22	19.26	93600.0
2006-10-19	CHIC	ETF	28.23	28.9	27.94	28.1	289253.0
2006-10-19	CHY	ETF	16.84	16.92	16.82	16.92	102500.0
2006-10-19	CIL	ETF	25.76	25.76	25.76	25.76	500.0
2006-10-19	CIZ	ETF	22.7	22.7	22.7	22.7	100.0
2006-10-19	CN	ETF	35.85	35.85	35.54	35.69	42300.0
2006-10-19	CNXT	ETF	2.02	2.03	1.98	2.0	16731083.0
2006-10-19	COMB	ETF	10.5	10.59	10.0	10.59	1820.0
2006-10-19	CPI	ETF	23.65	23.82	23.65	23.82	600.0
2006-10-19	CPST	ETF	1.56	1.63	1.54	1.56	1096717.0
2006-10-19	CSA	ETF	21.73	21.77	21.41	21.43	27800.0
2006-10-19	CSB	ETF	29.79	30.14	29.62	30.02	9400.0
2006-10-19	CSQ	ETF	14.9	15.0	14.88	15.0	462300.0
2006-10-19	CTEC	ETF	62.5	62.949999999999996	62.24999999999999	62.24999999999999	4000.0
2006-10-19	CVY	ETF	25.75	25.79	25.7	25.78	21600.0
2006-10-19	CYB	ETF	7.25	7.39	7.25	7.34	88600.0
2006-10-19	DBC	ETF	24.16	24.47	24.028	24.39	187300.0
2006-10-19	DBV	ETF	25.56	25.57	25.4988	25.52	26100.0
2006-10-19	DDM	ETF	6.9008	6.9608	6.9	6.9492	351600.0
2006-10-19	DES	ETF	18.54	18.65	18.54	18.6133	29400.0
2006-10-19	DEW	ETF	56.92	57.25	56.92	57.23	4800.0
2006-10-19	DFE	ETF	57.34	57.69	57.34	57.66	600.0
2006-10-19	DFJ	ETF	49.96	50.1	49.91	50.08	8300.0
2006-10-19	DGT	ETF	73.0	73.3	72.98	73.12	7000.0
2006-10-19	DHS	ETF	55.9	55.9	55.74	55.89	26400.0

> showing 50 of 373 rows — these rows as CSV

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