PREVIEW / etf_daily / 2006-03-27

all etf daily files

  file:    by_date/etf_daily/2006/2006-03-27.parquet
  size:    16 KB
  rows:    312

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-27	SPY	ETF	130.03	130.28	129.74	130.02	32523000.0
2006-03-27	QQQ	ETF	41.28	41.51	41.24	41.31	54405618.0
2006-03-27	IWM	ETF	74.81	74.94	74.42	74.91	23334000.0
2006-03-27	DIA	ETF	112.54	112.72	112.2	112.45	3459600.0
2006-03-27	GLD	ETF	56.18	56.55	56.18	56.39	4081900.0
2006-03-27	TLT	ETF	89.05	89.05	88.6	88.76	467100.0
2006-03-27	AAA	ETF	60.8	60.88	60.5	60.7	4000.0
2006-03-27	ADRE	ETF	129.01	129.5	127.564	128.2645	29600.0
2006-03-27	AFK	ETF	25.16	25.17	25.05	25.06	13900.0
2006-03-27	AGG	ETF	99.71	99.75	99.5	99.65	190100.0
2006-03-27	AIQ	ETF	33.9	35.3	33.9	34.5	17480.0
2006-03-27	AIS	ETF	1.7	1.72	1.61	1.7	417700.0
2006-03-27	AOM	ETF	5.95	6.2	5.5	6.19	847200.0
2006-03-27	ARB	ETF	33.89	33.99	33.63	33.77	181200.0
2006-03-27	BAB	ETF	61.88	62.3	61.77	62.0	19900.0
2006-03-27	BBC	ETF	18.13	18.45	17.75	17.8	154700.0
2006-03-27	BBH	ETF	64.5	64.9133	64.4267	64.8667	389400.0
2006-03-27	BCM	ETF	72.4	72.59	71.82	72.46	19100.0
2006-03-27	BITS	ETF	32.64	34.16	31.52	31.96	29407.0
2006-03-27	BKF	ETF	12.9	13.2	12.84	13.16	68200.0
2006-03-27	BNE	ETF	15.95	16.14	15.92	16.0	242000.0
2006-03-27	BRF	ETF	14.45	14.45	14.31	14.31	5300.0
2006-03-27	BTF	ETF	88.64999999999999	88.75	88.45	88.75	18140.0
2006-03-27	CBON	ETF	31.23	31.93	31.19	31.87	20580.0
2006-03-27	CDL	ETF	11.24	11.29	11.14	11.22	244400.0
2006-03-27	CEF	ETF	7.97	7.97	7.75	7.76	834600.0
2006-03-27	CEW	ETF	25.5	25.5	25.48	25.48	1500.0
2006-03-27	CFO	ETF	9.8	9.8	9.76	9.8	21800.0
2006-03-27	CGO	ETF	14.41	14.5	14.4	14.5	29100.0
2006-03-27	CHB	ETF	15.63	15.85	15.08	15.28	575300.0
2006-03-27	CHI	ETF	20.55	20.776	20.53	20.67	107500.0
2006-03-27	CHIC	ETF	18.95	18.95	18.62	18.81	441199.0
2006-03-27	CHIR	ETF	45.7599	45.84	45.5799	45.72	592614.0
2006-03-27	CHY	ETF	16.41	16.41	16.31	16.31	86000.0
2006-03-27	CIL	ETF	25.62	25.63	25.62	25.63	2200.0
2006-03-27	CIZ	ETF	24.0	24.0	24.0	24.0	100.0
2006-03-27	CN	ETF	35.7	35.89	35.65	35.8	22800.0
2006-03-27	CNXT	ETF	3.24	3.351	3.24	3.32	16375284.0
2006-03-27	COMB	ETF	8.49	8.49	8.49	8.49	800.0
2006-03-27	CPST	ETF	3.68	3.71	3.53	3.59	3133805.0
2006-03-27	CSA	ETF	21.48	21.5	21.4	21.4	50100.0
2006-03-27	CSB	ETF	30.47	30.47	30.19	30.37	17400.0
2006-03-27	CSQ	ETF	14.27	14.27	14.08	14.11	375500.0
2006-03-27	CTEC	ETF	61.449999999999996	62.5	61.3	62.497499999999995	6099.200000000001
2006-03-27	CYB	ETF	6.45	6.46	6.35	6.36	22100.0
2006-03-27	DBC	ETF	23.28	23.43	23.2	23.36	147300.0
2006-03-27	DGT	ETF	67.25	67.39	67.21	67.38	1800.0
2006-03-27	DIV	ETF	12.56	12.58	12.51	12.55	35800.0
2006-03-27	DRIV	ETF	43.5	43.63	42.85	43.3	1074325.0
2006-03-27	DSI	ETF	6.345	6.345	6.345	6.345	7600.0

> showing 50 of 312 rows — these rows as CSV

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