PREVIEW / etf_daily / 2006-09-27

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-27.parquet
  size:    18 KB
  rows:    363

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-09-27	SPY	ETF	133.49	133.97	133.27	133.74	82432200.0
2006-09-27	QQQ	ETF	40.7	40.95	40.5	40.72	113150194.0
2006-09-27	IWM	ETF	72.21	72.99	72.2	72.92	49884200.0
2006-09-27	DIA	ETF	116.54	117.11	116.48	116.98	13105000.0
2006-09-27	GLD	ETF	59.22	59.86	58.73	59.81	4656900.0
2006-09-27	TLT	ETF	90.25	90.28	89.63	89.67	1165400.0
2006-09-27	AAA	ETF	56.05	56.3	56.01	56.29	7900.0
2006-09-27	ADRE	ETF	32.27	32.29	32.02	32.12	221173.0
2006-09-27	AGG	ETF	100.4	100.53	100.21	100.21	430400.0
2006-09-27	AIQ	ETF	39.75	39.75	38.15	38.65	42700.0
2006-09-27	AIS	ETF	1.1	1.1099	1.04	1.06	114900.0
2006-09-27	ARB	ETF	37.3	37.5	37.1	37.41	96700.0
2006-09-27	BAB	ETF	80.91	81.82	80.85	81.29	38800.0
2006-09-27	BBC	ETF	10.82	10.82	10.35	10.39	132700.0
2006-09-27	BBH	ETF	60.1667	61.7667	60.1633	61.7433	1917300.0
2006-09-27	BITS	ETF	34.72	37.88	34.4864	37.88	133825.0
2006-09-27	BNE	ETF	14.89	15.15	14.77	15.15	269600.0
2006-09-27	BRF	ETF	14.21	14.29	14.21	14.22	3200.0
2006-09-27	BTF	ETF	95.1	95.44999999999999	95.1	95.44999999999999	1260.0
2006-09-27	CBON	ETF	31.15	31.21	30.81	31.15	101463.0
2006-09-27	CDL	ETF	9.52	9.552	9.41	9.45	222300.0
2006-09-27	CEF	ETF	8.25	8.42	8.2	8.41	327200.0
2006-09-27	CFO	ETF	9.7	9.85	9.7	9.75	4300.0
2006-09-27	CGO	ETF	15.23	15.32	15.17	15.19	16000.0
2006-09-27	CHB	ETF	7.45	7.6	7.07	7.18	1377200.0
2006-09-27	CHI	ETF	19.55	19.78	19.53	19.71	108400.0
2006-09-27	CHIC	ETF	27.3	27.96	27.29	27.69	948270.0
2006-09-27	CHY	ETF	16.7	16.8	16.6501	16.73	100600.0
2006-09-27	CIL	ETF	25.62	25.62	25.62	25.62	900.0
2006-09-27	CN	ETF	35.7	35.73	35.37	35.54	20000.0
2006-09-27	CNXT	ETF	2.02	2.04	1.96	1.99	19461818.0
2006-09-27	COMB	ETF	10.0	10.0	9.9145	10.0	7800.0
2006-09-27	CPI	ETF	24.34	24.5	24.34	24.5	1200.0
2006-09-27	CPST	ETF	1.3	1.32	1.26	1.27	1796409.0
2006-09-27	CSA	ETF	21.0	21.0	20.3	20.45	22800.0
2006-09-27	CSB	ETF	30.31	30.56	30.16	30.29	8100.0
2006-09-27	CSQ	ETF	14.72	14.73	14.63	14.73	360000.0
2006-09-27	CTEC	ETF	62.5	62.5	61.5	62.4	3947.4
2006-09-27	CVY	ETF	25.08	25.18	25.04	25.18	74700.0
2006-09-27	CYB	ETF	6.45	6.45	6.4	6.4	10400.0
2006-09-27	DBC	ETF	23.4	23.7	23.12	23.7	296900.0
2006-09-27	DBV	ETF	24.95	24.97	24.89	24.95	17600.0
2006-09-27	DDM	ETF	6.5783	6.6292	6.5617	6.6	1276800.0
2006-09-27	DES	ETF	18.04	18.14	18.0	18.1133	30000.0
2006-09-27	DEW	ETF	55.46	55.8	55.46	55.71	2200.0
2006-09-27	DFE	ETF	55.65	55.65	55.53	55.53	1200.0
2006-09-27	DFJ	ETF	49.71	50.14	49.71	50.14	800.0
2006-09-27	DGT	ETF	71.45	71.84	71.29	71.69	45000.0
2006-09-27	DHS	ETF	55.15	55.3	55.05	55.16	82500.0
2006-09-27	DIM	ETF	56.25	56.4	56.06	56.25	5900.0

> showing 50 of 363 rows — these rows as CSV

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