PREVIEW / etf_daily / 2006-09-21

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-21.parquet
  size:    18 KB
  rows:    366

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-21	SPY	ETF	132.61	132.75	131.42	131.87	88932500.0
2006-09-21	QQQ	ETF	40.52	40.67	40.08	40.18	126900236.0
2006-09-21	IWM	ETF	73.35	73.57	72.09	72.5	68561500.0
2006-09-21	DIA	ETF	116.09	116.22	114.95	115.37	8600800.0
2006-09-21	GLD	ETF	57.35	58.09	57.22	57.95	3870800.0
2006-09-21	TLT	ETF	88.35	89.28	88.35	89.24	1698600.0
2006-09-21	AAA	ETF	57.18	58.52	57.12	58.31	57000.0
2006-09-21	ADRE	ETF	32.28	32.28	31.54	31.63	395392.0
2006-09-21	AFK	ETF	25.06	25.09	25.06	25.09	2400.0
2006-09-21	AGG	ETF	99.69	100.03	99.5	100.0	259600.0
2006-09-21	AIQ	ETF	41.85	43.0	41.2	41.6	19120.0
2006-09-21	AIS	ETF	1.2	1.2	1.12	1.19	278400.0
2006-09-21	ARB	ETF	38.0	38.179	37.29	37.57	83100.0
2006-09-21	BAB	ETF	82.73	82.73	81.29	81.48	50300.0
2006-09-21	BBC	ETF	10.41	10.5	10.31	10.42	74500.0
2006-09-21	BBH	ETF	59.8367	60.3333	59.5167	59.5167	898500.0
2006-09-21	BITS	ETF	28.12	31.6	28.04	30.8	96648.0
2006-09-21	BNE	ETF	14.66	14.78	14.48	14.59	173400.0
2006-09-21	BRF	ETF	14.17	14.25	14.17	14.25	7800.0
2006-09-21	BTF	ETF	94.74999999999999	94.74999999999999	94.64999999999999	94.7	900.0
2006-09-21	CBON	ETF	32.4	32.5	32.25	32.38	54503.0
2006-09-21	CDL	ETF	9.73	9.73	9.51	9.59	208000.0
2006-09-21	CEF	ETF	7.9	8.08	7.86	8.07	711900.0
2006-09-21	CEW	ETF	25.32	25.32	25.32	25.32	300.0
2006-09-21	CFO	ETF	9.75	9.77	9.67	9.77	4600.0
2006-09-21	CGO	ETF	15.1	15.18	15.04	15.14	23200.0
2006-09-21	CHB	ETF	7.09	7.2	6.85	6.98	1560200.0
2006-09-21	CHI	ETF	19.52	19.71	19.52	19.71	102100.0
2006-09-21	CHIC	ETF	26.27	26.4	25.8	25.89	687835.0
2006-09-21	CHY	ETF	16.78	16.78	16.66	16.67	111900.0
2006-09-21	CIL	ETF	25.66	25.66	25.66	25.66	100.0
2006-09-21	CN	ETF	35.28	35.35	34.83	34.94	37600.0
2006-09-21	CNXT	ETF	1.9	1.9	1.8099	1.82	16784198.0
2006-09-21	CPI	ETF	24.0	24.0	24.0	24.0	200.0
2006-09-21	CPST	ETF	1.4	1.4	1.24	1.26	4516224.0
2006-09-21	CSA	ETF	20.7	21.72	20.7	21.29	22000.0
2006-09-21	CSB	ETF	29.68	29.86	29.25	29.46	15100.0
2006-09-21	CSQ	ETF	14.7	14.7	14.55	14.64	456500.0
2006-09-21	CTEC	ETF	61.1	62.24999999999999	60.55	62.24999999999999	4645.400000000001
2006-09-21	CVY	ETF	25.0	25.05	24.88	24.91	26900.0
2006-09-21	CYB	ETF	6.6	6.6	6.1	6.3	22700.0
2006-09-21	DBC	ETF	23.02	23.5	23.02	23.47	422000.0
2006-09-21	DBV	ETF	24.94	25.05	24.89	24.9	21200.0
2006-09-21	DDM	ETF	6.5458	6.5458	6.4058	6.4375	639600.0
2006-09-21	DES	ETF	18.1233	18.1367	17.8967	17.92	66900.0
2006-09-21	DEW	ETF	55.45	55.45	55.26	55.26	1800.0
2006-09-21	DFE	ETF	55.76	55.76	55.49	55.49	32300.0
2006-09-21	DFJ	ETF	49.78	49.88	49.6	49.72	1700.0
2006-09-21	DGT	ETF	70.9	71.07	70.54	70.54	9700.0
2006-09-21	DHS	ETF	54.9	54.92	54.46	54.61	28200.0

> showing 50 of 366 rows — these rows as CSV

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