PREVIEW / etf_daily / 2006-03-17

all etf daily files

  file:    by_date/etf_daily/2006/2006-03-17.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-17	SPY	ETF	130.68	130.9	130.38	130.62	47286800.0
2006-03-17	QQQ	ETF	41.32	41.59	41.23	41.45	78228437.0
2006-03-17	IWM	ETF	74.13	74.3	73.7	74.07	31551600.0
2006-03-17	DIA	ETF	112.62	112.81	112.45	112.7	5742800.0
2006-03-17	GLD	ETF	55.28	55.33	54.93	55.12	2236000.0
2006-03-17	TLT	ETF	88.85	89.0	88.75	88.85	703500.0
2006-03-17	AAA	ETF	59.54	59.79	59.51	59.6	10100.0
2006-03-17	ADRE	ETF	128.1	129.33	127.75	128.002	17620.0
2006-03-17	AFK	ETF	25.14	25.14	25.08	25.08	7000.0
2006-03-17	AGG	ETF	99.79	99.79	99.5	99.6	253400.0
2006-03-17	AIQ	ETF	30.75	32.5	30.75	31.8	35260.0
2006-03-17	AIS	ETF	1.55	1.8	1.48	1.8	1451000.0
2006-03-17	AOM	ETF	6.8	7.1	6.8	6.93	205000.0
2006-03-17	ARB	ETF	34.7	34.81	34.3	34.4	1034600.0
2006-03-17	BAB	ETF	61.65	62.1	61.59	61.89	79100.0
2006-03-17	BBC	ETF	15.6	15.98	15.6	15.88	228800.0
2006-03-17	BBH	ETF	64.8	66.32	64.5833	66.32	1085400.0
2006-03-17	BCM	ETF	73.25	73.27	72.57	72.59	15900.0
2006-03-17	BITS	ETF	30.28	31.08	29.76	31.08	28270.0
2006-03-17	BKF	ETF	13.01	13.01	12.7	12.75	145100.0
2006-03-17	BNE	ETF	15.25	16.1	15.0	15.98	593700.0
2006-03-17	BRF	ETF	14.25	14.25	14.19	14.21	12400.0
2006-03-17	BTF	ETF	88.24999999999999	88.6	88.24999999999999	88.55	3120.0
2006-03-17	CBON	ETF	31.7	31.98	31.41	31.82	35744.0
2006-03-17	CDL	ETF	11.33	11.6	11.23	11.57	1131100.0
2006-03-17	CEF	ETF	7.9	7.9	7.82	7.88	199200.0
2006-03-17	CEW	ETF	25.55	25.65	25.55	25.65	1100.0
2006-03-17	CFO	ETF	9.8	9.8	9.77	9.8	6700.0
2006-03-17	CGO	ETF	14.4	14.47	14.32	14.46	30800.0
2006-03-17	CHB	ETF	15.43	15.89	15.19	15.81	1342300.0
2006-03-17	CHI	ETF	20.75	20.83	20.68	20.78	77400.0
2006-03-17	CHIC	ETF	18.61	18.8	18.49	18.65	420842.0
2006-03-17	CHIR	ETF	45.6201	46.0101	45.5499	45.7701	2188837.0
2006-03-17	CHY	ETF	16.54	16.54	16.41	16.48	110800.0
2006-03-17	CIL	ETF	25.6	25.6	25.6	25.6	100.0
2006-03-17	CN	ETF	34.6	34.93	34.6	34.85	25200.0
2006-03-17	CNXT	ETF	3.2	3.23	3.12	3.13	13872010.0
2006-03-17	COMB	ETF	8.31	8.31	8.3	8.3	602.0
2006-03-17	CPI	ETF	31.7	31.7	31.25	31.25	1300.0
2006-03-17	CPST	ETF	3.365	3.43	3.25	3.29	1766500.0
2006-03-17	CSA	ETF	21.15	21.43	20.95	21.2	62000.0
2006-03-17	CSB	ETF	31.15	31.46	31.15	31.26	7300.0
2006-03-17	CSM	ETF	2.485	2.485	2.485	2.485	8000.0
2006-03-17	CSQ	ETF	14.01	14.14	14.0	14.14	334600.0
2006-03-17	CTEC	ETF	56.55	57.599999999999994	55.849999999999994	57.15	10741.6
2006-03-17	CYB	ETF	6.24	6.25	6.21	6.22	9700.0
2006-03-17	DBC	ETF	23.47	23.52	23.25	23.32	324200.0
2006-03-17	DGT	ETF	67.98	68.02	67.71	67.75	5700.0
2006-03-17	DIV	ETF	12.43	12.5	12.43	12.47	9900.0
2006-03-17	DRIV	ETF	39.98	41.6	39.98	41.28	1415573.0

> showing 50 of 308 rows — these rows as CSV

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