PREVIEW / etf_daily / 2007-03-20

all etf daily files

  file:    by_date/etf_daily/2007/2007-03-20.parquet
  size:    21 KB
  rows:    442

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
2007-03-20	SPY	ETF	140.08	141.05	139.96	140.97	82147400.0
2007-03-20	QQQ	ETF	43.26	43.59	43.21	43.58	81054392.0
2007-03-20	IWM	ETF	78.19	78.9	77.96	78.85	46527300.0
2007-03-20	DIA	ETF	122.04	122.82	122.01	122.82	7412600.0
2007-03-20	GLD	ETF	64.93	65.54	64.93	65.27	4416300.0
2007-03-20	TLT	ETF	89.91	89.95	89.69	89.71	768400.0
2007-03-20	AAA	ETF	62.35	62.97	62.29	62.88	7900.0
2007-03-20	ADRE	ETF	38.36	38.68	38.27	38.67	124080.0
2007-03-20	AGG	ETF	100.68	100.69	100.5	100.61	446400.0
2007-03-20	AIQ	ETF	39.85	40.85	39.4	40.65	49960.0
2007-03-20	AIS	ETF	1.17	1.2	1.17	1.18	22400.0
2007-03-20	ARB	ETF	46.27	47.0	46.23	46.95	119700.0
2007-03-20	BAB	ETF	98.0	99.13	98.0	98.84	45200.0
2007-03-20	BBH	ETF	59.07	59.5433	59.07	59.4667	450900.0
2007-03-20	BITS	ETF	33.24	33.96	33.0	33.8	18020.0
2007-03-20	BNE	ETF	15.66	15.67	15.46	15.52	92400.0
2007-03-20	BRF	ETF	14.51	14.51	14.45	14.47	23500.0
2007-03-20	BTF	ETF	107.89999999999999	108.2	107.89999999999999	107.94999999999999	1460.0
2007-03-20	CBON	ETF	31.0	31.37	30.6	31.2	74652.0
2007-03-20	CDL	ETF	9.69	9.83	9.63	9.81	142600.0
2007-03-20	CEF	ETF	9.35	9.51	9.32	9.4	215000.0
2007-03-20	CGO	ETF	16.81	16.99	16.75	16.84	25200.0
2007-03-20	CHB	ETF	9.41	9.55	9.24	9.46	1383100.0
2007-03-20	CHI	ETF	20.07	20.07	19.91	20.0	86000.0
2007-03-20	CHIC	ETF	27.38	27.79	27.2	27.79	377670.0
2007-03-20	CHY	ETF	16.5	16.52	16.4	16.48	119400.0
2007-03-20	CIL	ETF	25.58	25.63	25.58	25.63	2600.0
2007-03-20	CN	ETF	44.8	45.1	44.52	45.09	66000.0
2007-03-20	CNXT	ETF	1.7	1.71	1.68	1.7	3955127.0
2007-03-20	CPI	ETF	22.39	22.39	22.38	22.39	600.0
2007-03-20	CPST	ETF	0.84	0.86	0.83	0.85	2052112.0
2007-03-20	CSA	ETF	21.0	21.1	20.85	20.87	698700.0
2007-03-20	CSB	ETF	32.12	32.47	32.02	32.47	11100.0
2007-03-20	CSD	ETF	26.43	26.59	26.38	26.53	9900.0
2007-03-20	CSM	ETF	1.3275	1.3275	1.2375	1.3025	54400.0
2007-03-20	CSQ	ETF	15.07	15.19	15.04	15.19	322900.0
2007-03-20	CTEC	ETF	81.25	86.95	81.25	85.0	14838.2
2007-03-20	CVY	ETF	26.59	26.66	26.46	26.66	15900.0
2007-03-20	CWI	ETF	24.7133	24.9667	24.7133	24.9667	31800.0
2007-03-20	DBA	ETF	25.9	26.2	25.88	26.18	95100.0
2007-03-20	DBB	ETF	24.72	24.83	24.4	24.54	49100.0
2007-03-20	DBC	ETF	24.3	24.44	24.2	24.4	217900.0
2007-03-20	DBE	ETF	25.4	25.6	25.39	25.44	29000.0
2007-03-20	DBO	ETF	24.52	24.87	24.51	24.76	8000.0
2007-03-20	DBP	ETF	26.1	26.15	26.02	26.06	4200.0
2007-03-20	DBS	ETF	26.24	26.29	26.13	26.13	2300.0
2007-03-20	DBV	ETF	26.45	26.63	26.43	26.62	60200.0
2007-03-20	DDM	ETF	6.5992	6.6633	6.5833	6.6625	544800.0
2007-03-20	DEF	ETF	25.61	25.72	25.5899	25.71	5900.0
2007-03-20	DES	ETF	19.0	19.1333	19.0	19.13	53700.0

> showing 50 of 442 rows — these rows as CSV

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