PREVIEW / etf_daily / 2006-10-13

all etf daily files

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

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-13	SPY	ETF	136.16	136.71	136.04	136.63	53944000.0
2006-10-13	QQQ	ETF	42.22	42.52	42.14	42.43	80478787.0
2006-10-13	IWM	ETF	75.3	75.91	75.13	75.9	45517000.0
2006-10-13	DIA	ETF	119.37	119.68	119.07	119.64	5290000.0
2006-10-13	GLD	ETF	58.25	58.6	57.94	58.57	3078400.0
2006-10-13	TLT	ETF	87.29	87.36	87.11	87.16	1414100.0
2006-10-13	AAA	ETF	53.97	54.01	53.75	53.98	3800.0
2006-10-13	ADRE	ETF	33.83	34.18	33.82	34.05	161234.0
2006-10-13	AGG	ETF	99.2	99.22	99.06	99.09	257400.0
2006-10-13	AIQ	ETF	40.15	40.9	39.6	40.3	37960.0
2006-10-13	AIS	ETF	1.23	1.31	1.22	1.29	328200.0
2006-10-13	ARB	ETF	38.75	38.92	38.5	38.73	95600.0
2006-10-13	BAB	ETF	82.59	83.39	82.42	83.32	68800.0
2006-10-13	BBC	ETF	8.65	8.75	8.61	8.7	157200.0
2006-10-13	BBH	ETF	62.4867	62.5	61.9467	62.19	595200.0
2006-10-13	BITS	ETF	36.0	39.56	35.64	37.84	149901.0
2006-10-13	BNE	ETF	15.26	15.34	15.0	15.19	120300.0
2006-10-13	BRF	ETF	14.22	14.28	14.22	14.28	8600.0
2006-10-13	BTF	ETF	99.8	100.05	99.60000000000001	99.94999999999999	1440.0
2006-10-13	CBON	ETF	32.47	32.75	32.32	32.61	31047.0
2006-10-13	CDL	ETF	9.79	9.82	9.66	9.74	283400.0
2006-10-13	CEF	ETF	8.17	8.37	8.17	8.35	282100.0
2006-10-13	CEW	ETF	25.39	25.39	25.38	25.3808	1900.0
2006-10-13	CFO	ETF	9.74	9.9	9.74	9.9	7000.0
2006-10-13	CGO	ETF	15.8	15.86	15.5	15.85	15600.0
2006-10-13	CHB	ETF	7.95	8.02	7.8	7.99	1983500.0
2006-10-13	CHI	ETF	19.32	19.39	19.21	19.29	108500.0
2006-10-13	CHIC	ETF	27.81	28.85	27.63	28.76	1105659.0
2006-10-13	CHY	ETF	16.96	17.0	16.88	16.93	97600.0
2006-10-13	CN	ETF	36.25	36.63	36.25	36.5	41300.0
2006-10-13	CNXT	ETF	1.92	1.95	1.89	1.93	9261613.0
2006-10-13	COMB	ETF	10.2	10.38	10.2	10.38	14170.0
2006-10-13	CPI	ETF	24.4	24.4	24.16	24.4	2200.0
2006-10-13	CPST	ETF	1.68	1.75	1.65	1.68	1664508.0
2006-10-13	CSA	ETF	21.6	21.6	21.51	21.59	16800.0
2006-10-13	CSB	ETF	29.74	30.26	29.68	29.96	13600.0
2006-10-13	CSQ	ETF	14.87	14.9	14.83	14.9	363900.0
2006-10-13	CTEC	ETF	63.25	63.449999999999996	62.099999999999994	62.55	5114.200000000001
2006-10-13	CVY	ETF	25.55	25.68	25.51	25.66	24800.0
2006-10-13	CYB	ETF	7.1	7.25	7.1	7.15	62100.0
2006-10-13	DBC	ETF	23.88	24.4	23.82	24.15	285200.0
2006-10-13	DBV	ETF	25.59	25.62	25.54	25.58	31600.0
2006-10-13	DDM	ETF	6.8692	6.8983	6.8333	6.8983	444000.0
2006-10-13	DES	ETF	18.43	18.5633	18.43	18.5633	36900.0
2006-10-13	DEW	ETF	56.8	56.96	56.76	56.96	24700.0
2006-10-13	DFE	ETF	56.96	57.14	56.92	57.06	5700.0
2006-10-13	DFJ	ETF	48.34	48.59	48.34	48.45	5300.0
2006-10-13	DGT	ETF	72.7	72.85	72.44	72.75	20700.0
2006-10-13	DHS	ETF	55.75	55.87	55.54	55.87	38100.0
2006-10-13	DIM	ETF	57.37	57.52	57.22	57.39	9100.0

> showing 50 of 374 rows — these rows as CSV

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