PREVIEW / etf_daily / 2007-03-13

all etf daily files

  file:    by_date/etf_daily/2007/2007-03-13.parquet
  size:    21 KB
  rows:    436

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-13	SPY	ETF	140.18	140.77	138.04	138.25	190605200.0
2007-03-13	QQQ	ETF	43.0	43.24	42.36	42.37	171232751.0
2007-03-13	IWM	ETF	77.84	78.06	76.26	76.39	96417200.0
2007-03-13	DIA	ETF	122.52	122.99	120.86	121.02	13714600.0
2007-03-13	GLD	ETF	64.29	64.69	63.57	63.72	4332100.0
2007-03-13	TLT	ETF	90.23	90.34	89.98	90.29	553800.0
2007-03-13	AAA	ETF	62.27	62.5	61.63	61.67	141800.0
2007-03-13	ADRE	ETF	38.21	38.37	37.12	37.21	311914.0
2007-03-13	AGG	ETF	100.67	100.8	100.55	100.8	344300.0
2007-03-13	AIQ	ETF	37.5	38.8	36.7	36.9	29900.0
2007-03-13	AIS	ETF	1.23	1.25	1.2	1.23	26400.0
2007-03-13	ARB	ETF	45.51	45.65	44.9	45.01	190800.0
2007-03-13	BAB	ETF	100.19	100.19	98.02	98.06	55400.0
2007-03-13	BBC	ETF	3.85	3.85	3.72	3.75	100000.0
2007-03-13	BBH	ETF	58.5433	58.9367	58.0933	58.14	779700.0
2007-03-13	BITS	ETF	28.88	29.6	28.64	29.12	21392.0
2007-03-13	BNE	ETF	14.92	15.2	14.35	14.39	147400.0
2007-03-13	BRF	ETF	14.53	14.55	14.5	14.5	4500.0
2007-03-13	BTF	ETF	108.0	108.0	106.75	106.89	2000.0
2007-03-13	CBON	ETF	31.34	31.35	29.44	29.54	62734.0
2007-03-13	CDL	ETF	9.71	9.79	9.6	9.61	201400.0
2007-03-13	CEF	ETF	9.22	9.23	9.03	9.1	173000.0
2007-03-13	CGO	ETF	16.64	16.68	16.37	16.37	47400.0
2007-03-13	CHB	ETF	8.4	8.44	8.11	8.25	2648700.0
2007-03-13	CHI	ETF	20.01	20.01	19.8	19.86	100300.0
2007-03-13	CHIC	ETF	28.28	28.37	26.33	26.48	1083840.0
2007-03-13	CHY	ETF	16.58	16.62	16.3	16.34	126600.0
2007-03-13	CIL	ETF	25.62	25.62	25.58	25.58	1800.0
2007-03-13	CN	ETF	44.75	45.42	43.62	43.8	190500.0
2007-03-13	CNXT	ETF	1.74	1.76	1.68	1.7	8185315.0
2007-03-13	CPI	ETF	22.8	22.8	22.8	22.8	100.0
2007-03-13	CPST	ETF	0.9	0.9	0.8402	0.86	2846875.0
2007-03-13	CSA	ETF	21.66	21.66	21.37	21.37	7500.0
2007-03-13	CSB	ETF	31.81	32.0	31.54	31.54	20700.0
2007-03-13	CSD	ETF	26.2	26.38	25.9	25.9	26300.0
2007-03-13	CSM	ETF	1.3275	1.3275	1.3	1.3	5600.0
2007-03-13	CSQ	ETF	14.78	14.84	14.55	14.64	389300.0
2007-03-13	CTEC	ETF	80.0	80.5	79.4	79.85	8120.6
2007-03-13	CVY	ETF	26.4	26.42	25.9	25.98	21700.0
2007-03-13	CWI	ETF	24.7067	24.82	24.34	24.34	49650.0
2007-03-13	DBA	ETF	26.18	26.25	25.87	25.89	111900.0
2007-03-13	DBB	ETF	24.24	24.32	23.77	23.81	12200.0
2007-03-13	DBC	ETF	24.57	24.7	24.18	24.29	248600.0
2007-03-13	DBE	ETF	25.69	25.99	25.54	25.59	8900.0
2007-03-13	DBO	ETF	25.1	25.45	24.9	24.92	5600.0
2007-03-13	DBP	ETF	25.72	25.72	25.31	25.34	6900.0
2007-03-13	DBS	ETF	25.56	25.56	25.06	25.12	6700.0
2007-03-13	DBV	ETF	26.18	26.3	26.05	26.06	53800.0
2007-03-13	DDM	ETF	6.62	6.6633	6.4425	6.4542	2436000.0
2007-03-13	DEF	ETF	25.56	25.56	25.2	25.2	11500.0

> showing 50 of 436 rows — these rows as CSV

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