PREVIEW / etf_daily / 2006-10-12

all etf daily files

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

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-12	SPY	ETF	135.45	136.39	135.4	136.28	59158600.0
2006-10-12	QQQ	ETF	41.76	42.25	41.7	42.23	95335229.0
2006-10-12	IWM	ETF	74.08	75.39	74.08	75.3	40618400.0
2006-10-12	DIA	ETF	118.88	119.58	118.87	119.46	5467800.0
2006-10-12	GLD	ETF	56.74	57.49	56.65	57.49	2777500.0
2006-10-12	TLT	ETF	87.63	87.77	87.48	87.6	586400.0
2006-10-12	AAA	ETF	54.0	54.22	53.95	54.22	5000.0
2006-10-12	ADRE	ETF	33.2	33.82	33.015	33.82	183888.0
2006-10-12	AGG	ETF	99.34	99.5	99.24	99.34	261200.0
2006-10-12	AIQ	ETF	38.75	40.25	38.35	40.0	19440.0
2006-10-12	AIS	ETF	1.15	1.24	1.13	1.23	189100.0
2006-10-12	ARB	ETF	38.4	38.77	38.27	38.75	149000.0
2006-10-12	BAB	ETF	83.07	84.05	82.99	84.0	64700.0
2006-10-12	BBC	ETF	8.49	8.83	8.4475	8.55	275900.0
2006-10-12	BBH	ETF	62.4667	62.6367	62.1733	62.5867	1659000.0
2006-10-12	BITS	ETF	35.8	36.12	34.04	35.24	32816.0
2006-10-12	BNE	ETF	15.06	15.29	14.95	15.2	152600.0
2006-10-12	BRF	ETF	14.19	14.31	14.19	14.3	10400.0
2006-10-12	BTF	ETF	98.55	99.7	98.55	99.7	5680.0
2006-10-12	CBON	ETF	31.99	32.56	31.62	32.55	41269.0
2006-10-12	CDL	ETF	9.5	9.73	9.45	9.73	291100.0
2006-10-12	CEF	ETF	8.1	8.14	8.06	8.12	232300.0
2006-10-12	CFO	ETF	9.7	9.7	9.7	9.7	1500.0
2006-10-12	CGO	ETF	15.7	15.83	15.62	15.69	12000.0
2006-10-12	CHB	ETF	7.6	7.91	7.6	7.9	1646200.0
2006-10-12	CHI	ETF	19.22	19.39	19.22	19.35	103100.0
2006-10-12	CHIC	ETF	27.16	27.77	27.13	27.76	400565.0
2006-10-12	CHY	ETF	16.8	16.96	16.8	16.9199	120200.0
2006-10-12	CIL	ETF	25.73	25.81	25.73	25.81	1100.0
2006-10-12	CIZ	ETF	22.1499	22.5	22.1499	22.47	6100.0
2006-10-12	CN	ETF	35.8	36.29	35.8	36.28	25800.0
2006-10-12	CNXT	ETF	1.85	1.95	1.84	1.94	12377000.0
2006-10-12	COMB	ETF	10.23	10.23	10.1	10.2	8983.0
2006-10-12	CPI	ETF	24.7	24.7	24.5	24.6881	1100.0
2006-10-12	CPST	ETF	1.52	1.69	1.52	1.68	2586530.0
2006-10-12	CSA	ETF	21.75	21.75	21.1	21.35	22400.0
2006-10-12	CSB	ETF	29.8	29.92	29.7	29.77	6300.0
2006-10-12	CSQ	ETF	14.79	14.87	14.78	14.87	374500.0
2006-10-12	CTEC	ETF	62.5	63.449999999999996	62.4	63.449999999999996	23847.2
2006-10-12	CVY	ETF	25.4	25.53	25.36	25.53	17400.0
2006-10-12	CYB	ETF	7.25	7.2952	7.08	7.1	38200.0
2006-10-12	DBC	ETF	23.3	23.86	23.3	23.64	284100.0
2006-10-12	DBV	ETF	25.53	25.56	25.5	25.52	30800.0
2006-10-12	DDM	ETF	6.8375	6.89	6.8192	6.875	1209600.0
2006-10-12	DES	ETF	18.2367	18.43	18.2333	18.43	71400.0
2006-10-12	DEW	ETF	56.58	56.96	56.57	56.79	27700.0
2006-10-12	DFE	ETF	56.83	57.16	56.74	57.16	33500.0
2006-10-12	DFJ	ETF	47.93	48.27	47.93	48.23	22700.0
2006-10-12	DGT	ETF	72.35	72.8	72.09	72.7	43700.0
2006-10-12	DHS	ETF	55.5	55.74	55.48	55.71	46300.0

> showing 50 of 372 rows — these rows as CSV

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