PREVIEW / etf_daily / 2007-03-23

all etf daily files

  file:    by_date/etf_daily/2007/2007-03-23.parquet
  size:    21 KB
  rows:    439

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-23	SPY	ETF	143.28	143.81	143.15	143.39	74416800.0
2007-03-23	QQQ	ETF	44.26	44.37	44.07	44.12	68621788.0
2007-03-23	IWM	ETF	80.23	80.42	80.05	80.24	37200500.0
2007-03-23	DIA	ETF	124.5	125.01	124.37	124.69	5276200.0
2007-03-23	GLD	ETF	65.79	65.9	64.9	65.15	5593000.0
2007-03-23	TLT	ETF	89.19	89.2	88.78	88.79	1679700.0
2007-03-23	AAA	ETF	64.29	64.3	64.0	64.24	11400.0
2007-03-23	ADRE	ETF	39.93	39.93	39.49	39.7	102741.0
2007-03-23	AGG	ETF	100.67	100.67	100.31	100.41	226200.0
2007-03-23	AIQ	ETF	41.65	41.8	39.8	39.85	23680.0
2007-03-23	AIS	ETF	1.16	1.2	1.16	1.2	50000.0
2007-03-23	ARB	ETF	47.91	48.03	47.24	47.41	117700.0
2007-03-23	BAB	ETF	102.27	102.64	101.7	102.16	58100.0
2007-03-23	BBH	ETF	59.34	60.2567	58.8167	59.3333	1841700.0
2007-03-23	BITS	ETF	34.0	34.0	33.2	33.56	16036.0
2007-03-23	BNE	ETF	16.1	16.1	15.81	15.89	97600.0
2007-03-23	BRF	ETF	14.54	14.5695	14.51	14.5695	6000.0
2007-03-23	BTF	ETF	108.6	108.9	108.55	108.6	80.0
2007-03-23	CBON	ETF	30.18	31.07	30.18	30.96	55614.0
2007-03-23	CDL	ETF	9.75	9.75	9.66	9.73	131800.0
2007-03-23	CEF	ETF	9.46	9.46	9.36	9.38	201400.0
2007-03-23	CGO	ETF	17.0	17.05	16.9	16.97	13000.0
2007-03-23	CHB	ETF	9.84	10.34	9.67	9.8	2742700.0
2007-03-23	CHI	ETF	20.06	20.23	20.04	20.17	67700.0
2007-03-23	CHIC	ETF	28.27	28.85	28.27	28.79	485772.0
2007-03-23	CHY	ETF	16.69	17.02	16.69	16.98	129500.0
2007-03-23	CN	ETF	47.4	47.6499	47.2	47.32	39500.0
2007-03-23	CNXT	ETF	1.72	1.73	1.67	1.68	9150494.0
2007-03-23	CPST	ETF	0.95	1.03	0.89	1.02	9199714.0
2007-03-23	CSA	ETF	20.96	21.12	20.95	21.0	37600.0
2007-03-23	CSB	ETF	32.71	32.73	32.41	32.55	13800.0
2007-03-23	CSD	ETF	27.13	27.2	27.05	27.16	16300.0
2007-03-23	CSM	ETF	1.34	1.34	1.275	1.335	43600.0
2007-03-23	CSQ	ETF	15.34	15.4	15.05	15.2	481700.0
2007-03-23	CTEC	ETF	86.25	88.69999999999999	84.94999999999999	88.69999999999999	19793.2
2007-03-23	CVY	ETF	27.1	27.12	27.05	27.09	15900.0
2007-03-23	CWI	ETF	25.4067	25.5133	25.4067	25.4933	28800.0
2007-03-23	DBA	ETF	26.39	26.43	26.17	26.28	99700.0
2007-03-23	DBB	ETF	24.7	24.7	24.34	24.56	8500.0
2007-03-23	DBC	ETF	24.85	24.97	24.71	24.85	190000.0
2007-03-23	DBE	ETF	26.3	26.44	26.17	26.27	57200.0
2007-03-23	DBO	ETF	25.85	26.04	25.59	25.64	543900.0
2007-03-23	DBP	ETF	26.23	26.25	25.91	25.95	19500.0
2007-03-23	DBS	ETF	26.24	26.24	25.8	25.9	12100.0
2007-03-23	DBV	ETF	26.82	26.88	26.79	26.87	105200.0
2007-03-23	DDM	ETF	6.83	6.8992	6.83	6.865	680400.0
2007-03-23	DEF	ETF	26.15	26.22	26.14	26.2	7100.0
2007-03-23	DES	ETF	19.44	19.4633	19.4067	19.4367	60000.0
2007-03-23	DEW	ETF	63.35	63.58	63.32	63.49	7700.0
2007-03-23	DFE	ETF	70.0	70.04	69.7	69.86	63000.0

> showing 50 of 439 rows — these rows as CSV

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