PREVIEW / etf_daily / 2006-03-28

all etf daily files

  file:    by_date/etf_daily/2006/2006-03-28.parquet
  size:    16 KB
  rows:    308

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-03-28	SPY	ETF	129.93	130.53	129.05	129.22	82079900.0
2006-03-28	QQQ	ETF	41.37	41.67	40.99	41.14	100534374.0
2006-03-28	IWM	ETF	74.81	75.3	74.33	74.52	27179200.0
2006-03-28	DIA	ETF	112.34	112.72	111.32	111.43	8467700.0
2006-03-28	GLD	ETF	56.56	56.63	55.92	56.06	3419700.0
2006-03-28	TLT	ETF	88.4	88.43	87.84	87.93	1094900.0
2006-03-28	AAA	ETF	60.74	60.9	60.5	60.5	2500.0
2006-03-28	ADRE	ETF	127.5	127.5	125.25	125.64	42904.0
2006-03-28	AFK	ETF	25.09	25.1	25.06	25.1	16300.0
2006-03-28	AGG	ETF	99.6	99.64	99.3	99.4	181600.0
2006-03-28	AIQ	ETF	34.4	35.85	34.4	34.4	16780.0
2006-03-28	AIS	ETF	1.68	1.75	1.64	1.64	227900.0
2006-03-28	AOM	ETF	6.14	6.23	6.04	6.23	27700.0
2006-03-28	ARB	ETF	33.66	33.8	33.44	33.47	291100.0
2006-03-28	BAB	ETF	61.81	62.03	61.2	61.2	47100.0
2006-03-28	BBC	ETF	17.5	17.59	15.1	15.38	1065600.0
2006-03-28	BBH	ETF	64.7	64.8067	63.64	63.8733	942900.0
2006-03-28	BCM	ETF	72.27	73.07	72.23	73.01	39000.0
2006-03-28	BITS	ETF	31.88	33.0	31.76	31.76	14284.0
2006-03-28	BKF	ETF	13.18	13.2	12.96	13.1	97000.0
2006-03-28	BNE	ETF	16.01	16.2	15.82	16.01	85300.0
2006-03-28	BRF	ETF	14.29	14.42	14.29	14.29	15900.0
2006-03-28	BTF	ETF	88.6	88.85	88.49999999999999	88.49999999999999	6040.0
2006-03-28	CBON	ETF	31.39	31.83	31.39	31.69	10897.0
2006-03-28	CDL	ETF	11.14	11.14	10.9	10.9	590300.0
2006-03-28	CEF	ETF	7.68	7.76	7.66	7.68	615400.0
2006-03-28	CEW	ETF	25.47	25.56	25.47	25.56	1100.0
2006-03-28	CFO	ETF	9.85	9.99	9.85	9.9	10500.0
2006-03-28	CGO	ETF	14.49	14.52	14.4	14.5	41400.0
2006-03-28	CHB	ETF	15.16	15.65	15.1	15.3	476000.0
2006-03-28	CHI	ETF	20.75	20.88	20.5901	20.73	101100.0
2006-03-28	CHIC	ETF	18.8	18.86	18.6	18.75	142437.0
2006-03-28	CHIR	ETF	45.8199	45.9501	45.6699	45.84	742117.0
2006-03-28	CHY	ETF	16.34	16.42	16.3	16.4	96700.0
2006-03-28	CIL	ETF	25.63	25.63	25.63	25.63	1200.0
2006-03-28	CN	ETF	35.1	35.1399	34.47	34.58	31000.0
2006-03-28	CNXT	ETF	3.32	3.47	3.29	3.37	26353299.0
2006-03-28	COMB	ETF	8.649	8.649	8.649	8.649	150.0
2006-03-28	CPST	ETF	3.59	3.81	3.57	3.72	4087846.0
2006-03-28	CSA	ETF	21.49	21.5	21.42	21.47	48400.0
2006-03-28	CSB	ETF	30.35	30.45	30.12	30.12	11300.0
2006-03-28	CSQ	ETF	14.06	14.16	14.02	14.03	402100.0
2006-03-28	CTEC	ETF	62.300000000000004	63.2	62.0	62.99999999999999	7696.6
2006-03-28	CYB	ETF	6.46	6.46	6.31	6.4	23700.0
2006-03-28	DBC	ETF	23.39	23.68	23.39	23.66	355200.0
2006-03-28	DGT	ETF	67.22	67.22	66.66	66.7	1400.0
2006-03-28	DIG	ETF	17.4	17.4875	17.4	17.4	10000.0
2006-03-28	DIV	ETF	12.57	12.59	12.52	12.52	21300.0
2006-03-28	DRIV	ETF	43.33	43.4	42.66	42.91	928402.0
2006-03-28	DSI	ETF	6.3	6.315	6.28	6.315	9200.0

> showing 50 of 308 rows — these rows as CSV

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