PREVIEW / etf_daily / 2007-03-12

all etf daily files

  file:    by_date/etf_daily/2007/2007-03-12.parquet
  size:    21 KB
  rows:    433

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-12	SPY	ETF	140.42	141.34	140.16	140.99	80366900.0
2007-03-12	QQQ	ETF	42.88	43.28	42.83	43.21	81371756.0
2007-03-12	IWM	ETF	78.01	78.51	77.75	78.4	35945400.0
2007-03-12	DIA	ETF	122.69	123.53	122.52	123.15	6396100.0
2007-03-12	GLD	ETF	64.54	64.74	63.96	64.37	4558800.0
2007-03-12	TLT	ETF	89.73	89.98	89.68	89.75	594400.0
2007-03-12	AAA	ETF	60.3	60.87	60.3	60.77	2600.0
2007-03-12	ADRE	ETF	38.1	38.69	38.09	38.57	121537.0
2007-03-12	AGG	ETF	100.47	100.55	100.32	100.54	224200.0
2007-03-12	AIQ	ETF	38.0	38.35	37.5	37.9	18880.0
2007-03-12	AIS	ETF	1.24	1.25	1.2	1.25	56300.0
2007-03-12	ARB	ETF	45.9	46.14	45.32	45.81	138300.0
2007-03-12	BAB	ETF	100.61	101.48	100.2	101.4	53900.0
2007-03-12	BBC	ETF	3.76	3.85	3.75	3.8399	111900.0
2007-03-12	BBH	ETF	58.3833	58.7367	58.1667	58.7367	503400.0
2007-03-12	BITS	ETF	29.16	29.2	28.3592	28.88	24708.0
2007-03-12	BNE	ETF	15.06	15.07	14.93	14.99	78400.0
2007-03-12	BRF	ETF	14.52	14.55	14.48	14.55	10100.0
2007-03-12	BTF	ETF	107.24999999999999	108.6	107.24999999999999	108.55	880.0
2007-03-12	CBON	ETF	31.74	31.93	31.13	31.5	47976.0
2007-03-12	CDL	ETF	9.76	9.82	9.7	9.76	181000.0
2007-03-12	CEF	ETF	9.19	9.27	9.12	9.2	205500.0
2007-03-12	CGO	ETF	16.51	16.72	16.51	16.72	5900.0
2007-03-12	CHB	ETF	8.39	8.62	8.17	8.44	3109400.0
2007-03-12	CHI	ETF	20.1	20.14	20.01	20.03	70600.0
2007-03-12	CHIC	ETF	29.01	29.35	28.45	28.49	364305.0
2007-03-12	CHY	ETF	16.63	16.67	16.57	16.63	108700.0
2007-03-12	CN	ETF	44.6	45.65	44.6	45.56	119500.0
2007-03-12	CNXT	ETF	1.75	1.78	1.72	1.73	8382209.0
2007-03-12	CPI	ETF	22.91	22.91	22.91	22.91	200.0
2007-03-12	CPST	ETF	0.9	0.9	0.8677	0.9	1698212.0
2007-03-12	CSA	ETF	22.7501	22.7501	21.52	21.71	11800.0
2007-03-12	CSB	ETF	31.5	31.99	31.49	31.99	10400.0
2007-03-12	CSD	ETF	26.19	26.36	26.19	26.32	27100.0
2007-03-12	CSM	ETF	1.32	1.32	1.32	1.32	3200.0
2007-03-12	CSQ	ETF	14.77	14.83	14.73	14.82	319600.0
2007-03-12	CTEC	ETF	80.19999999999999	80.95	80.05	80.74999999999999	10024.6
2007-03-12	CVY	ETF	26.33	26.5	26.29	26.47	14800.0
2007-03-12	CWI	ETF	24.7	24.8333	24.62	24.8333	11250.0
2007-03-12	DBA	ETF	26.34	26.34	26.0	26.13	91700.0
2007-03-12	DBB	ETF	24.15	24.46	23.89	24.46	800.0
2007-03-12	DBC	ETF	24.59	24.6	24.34	24.48	143700.0
2007-03-12	DBE	ETF	25.75	25.75	25.39	25.56	141800.0
2007-03-12	DBO	ETF	25.06	25.29	24.9	25.0	20500.0
2007-03-12	DBP	ETF	25.52	25.8	25.51	25.7	5800.0
2007-03-12	DBS	ETF	25.27	25.5	25.15	25.5	6200.0
2007-03-12	DBV	ETF	26.29	26.37	26.17	26.35	71800.0
2007-03-12	DDM	ETF	6.6383	6.7267	6.6225	6.6917	1368000.0
2007-03-12	DEF	ETF	25.59	25.7	25.5101	25.7	8800.0
2007-03-12	DES	ETF	18.9667	19.0467	18.9	19.01	41700.0

> showing 50 of 433 rows — these rows as CSV

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