PREVIEW / etf_daily / 2007-04-13

all etf daily files

  file:    by_date/etf_daily/2007/2007-04-13.parquet
  size:    21 KB
  rows:    448

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-04-13	SPY	ETF	144.9	145.32	144.36	145.32	84287000.0
2007-04-13	QQQ	ETF	44.57	44.72	44.29	44.65	94584090.0
2007-04-13	IWM	ETF	80.95	81.4	80.53	81.36	31467000.0
2007-04-13	DIA	ETF	125.76	126.15	125.2	126.15	5935800.0
2007-04-13	GLD	ETF	67.49	67.97	67.19	67.84	5062700.0
2007-04-13	TLT	ETF	87.41	87.47	87.01	87.12	557800.0
2007-04-13	AAA	ETF	67.57	68.18	67.49	68.12	10600.0
2007-04-13	ADRE	ETF	41.45	41.53	41.1	41.53	101100.0
2007-04-13	AGG	ETF	99.79	99.79	99.46	99.59	291600.0
2007-04-13	AIQ	ETF	46.25	46.45	45.7	45.9	23700.0
2007-04-13	AIS	ETF	1.45	1.45	1.38	1.42	400200.0
2007-04-13	ARB	ETF	48.41	48.5	47.9	48.42	263700.0
2007-04-13	BAB	ETF	103.25	103.55	102.5	103.2	24800.0
2007-04-13	BBH	ETF	60.3667	60.3667	59.8767	60.29	435900.0
2007-04-13	BITS	ETF	30.76	31.16	30.48	30.96	7918.0
2007-04-13	BIV	ETF	74.96	75.01	74.86	74.86	9600.0
2007-04-13	BLV	ETF	74.9	74.9	74.73	74.78	16400.0
2007-04-13	BND	ETF	75.04	75.07	74.85	74.91	18000.0
2007-04-13	BNE	ETF	16.55	16.94	16.55	16.94	140200.0
2007-04-13	BOSS	ETF	48.0	49.2	48.0	49.2	100.0
2007-04-13	BRF	ETF	14.49	14.49	14.49	14.49	6200.0
2007-04-13	BSV	ETF	74.99	74.99	74.88	74.91	33800.0
2007-04-13	BTF	ETF	109.7	109.85	109.7	109.85	340.0
2007-04-13	CBON	ETF	29.39	29.75	29.39	29.75	51428.0
2007-04-13	CDL	ETF	9.65	9.67	9.58	9.66	158700.0
2007-04-13	CEF	ETF	9.8	9.95	9.79	9.95	464900.0
2007-04-13	CGO	ETF	17.37	17.42	17.31	17.42	25300.0
2007-04-13	CHB	ETF	10.03	10.24	9.82	10.05	3094600.0
2007-04-13	CHI	ETF	20.31	20.35	20.18	20.27	78700.0
2007-04-13	CHIC	ETF	29.85	30.18	29.66	29.81	433169.0
2007-04-13	CHY	ETF	16.84	17.05	16.8	17.04	108000.0
2007-04-13	CIL	ETF	25.76	25.78	25.72	25.78	2000.0
2007-04-13	CN	ETF	53.45	54.23	53.1	53.95	104600.0
2007-04-13	CNXT	ETF	1.45	1.49	1.43	1.49	9509121.0
2007-04-13	CPI	ETF	21.3	21.32	21.21	21.21	800.0
2007-04-13	CPST	ETF	1.24	1.24	1.1	1.13	6220572.0
2007-04-13	CSA	ETF	21.08	21.15	21.0	21.13	11800.0
2007-04-13	CSB	ETF	33.46	33.8	33.37	33.56	16600.0
2007-04-13	CSD	ETF	28.19	28.2	28.12	28.18	10000.0
2007-04-13	CSQ	ETF	15.19	15.3	15.19	15.3	240600.0
2007-04-13	CTEC	ETF	86.99999999999999	89.39999999999999	86.99999999999999	88.39999999999999	13968.800000000001
2007-04-13	CVY	ETF	26.98	27.07	26.95	27.03	25200.0
2007-04-13	CWI	ETF	26.2733	26.6533	26.22	26.3533	10500.0
2007-04-13	CZA	ETF	25.46	25.46	25.46	25.46	1900.0
2007-04-13	DBA	ETF	25.55	25.97	25.49	25.82	208000.0
2007-04-13	DBB	ETF	26.52	26.59	26.26	26.59	36100.0
2007-04-13	DBC	ETF	25.73	25.8	25.53	25.7	230500.0
2007-04-13	DBE	ETF	28.32	28.32	28.02	28.05	42100.0
2007-04-13	DBO	ETF	26.73	26.75	26.52	26.58	5400.0
2007-04-13	DBP	ETF	27.03	27.6	26.94	27.15	25200.0

> showing 50 of 448 rows — these rows as CSV

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