PREVIEW / etf_daily / 2007-03-14

all etf daily files

  file:    by_date/etf_daily/2007/2007-03-14.parquet
  size:    21 KB
  rows:    441

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-14	SPY	ETF	138.43	139.36	136.75	139.28	231853800.0
2007-03-14	QQQ	ETF	42.43	43.0	42.1	42.99	192587565.0
2007-03-14	IWM	ETF	76.41	77.28	75.53	77.2	129087500.0
2007-03-14	DIA	ETF	121.03	121.69	119.5	121.66	22827500.0
2007-03-14	GLD	ETF	63.34	64.06	63.09	63.94	7417000.0
2007-03-14	TLT	ETF	90.15	90.54	89.84	89.88	1698100.0
2007-03-14	AAA	ETF	61.92	62.61	61.82	62.61	33000.0
2007-03-14	ADRE	ETF	36.87	37.63	36.48	37.63	320755.0
2007-03-14	AGG	ETF	100.72	100.87	100.61	100.68	468700.0
2007-03-14	AIQ	ETF	36.75	37.0	34.95	35.45	42360.0
2007-03-14	AIS	ETF	1.2	1.23	1.18	1.2	133100.0
2007-03-14	ARB	ETF	45.04	46.77	45.04	46.53	388100.0
2007-03-14	BAB	ETF	96.29	96.98	94.85	96.75	112400.0
2007-03-14	BBC	ETF	3.79	3.79	3.65	3.7321	93000.0
2007-03-14	BBH	ETF	58.0533	58.3067	57.5567	58.2767	2430900.0
2007-03-14	BITS	ETF	29.36	29.76	28.72	29.72	18646.0
2007-03-14	BNE	ETF	14.39	14.93	14.39	14.82	116900.0
2007-03-14	BRF	ETF	14.51	14.55	14.51	14.55	1500.0
2007-03-14	BTF	ETF	106.75	106.75	104.89999999999999	105.99999999999999	7640.0
2007-03-14	CBON	ETF	29.54	30.49	29.54	30.49	60257.0
2007-03-14	CDL	ETF	9.59	9.66	9.53	9.62	181700.0
2007-03-14	CEF	ETF	9.0	9.14	8.88	9.11	403400.0
2007-03-14	CGO	ETF	16.37	16.45	16.21	16.31	47100.0
2007-03-14	CHB	ETF	8.23	9.56	8.18	9.4	5323600.0
2007-03-14	CHI	ETF	19.85	19.91	19.76	19.84	66900.0
2007-03-14	CHIC	ETF	26.62	27.13	26.21	26.94	755136.0
2007-03-14	CHY	ETF	16.34	16.43	16.3	16.33	93500.0
2007-03-14	CIL	ETF	25.66	25.67	25.57	25.57	900.0
2007-03-14	CN	ETF	43.05	43.8	42.51	43.74	123700.0
2007-03-14	CNXT	ETF	1.69	1.71	1.64	1.67	10397484.0
2007-03-14	CPST	ETF	0.85	0.86	0.8308	0.85	1845727.0
2007-03-14	CSA	ETF	21.74	21.74	21.51	21.51	2000.0
2007-03-14	CSB	ETF	31.22	31.28	30.96	31.28	12500.0
2007-03-14	CSD	ETF	25.92	25.96	25.67	25.94	9900.0
2007-03-14	CSQ	ETF	14.65	14.69	14.45	14.69	254100.0
2007-03-14	CTEC	ETF	79.64999999999999	81.1	79.64999999999999	80.39999999999999	8075.400000000001
2007-03-14	CVY	ETF	26.05	26.22	25.65	26.08	19600.0
2007-03-14	CWI	ETF	24.1867	24.3533	23.9067	24.3533	25050.0
2007-03-14	DBA	ETF	25.7	25.98	25.53	25.98	172900.0
2007-03-14	DBB	ETF	23.84	24.08	23.8	23.97	700.0
2007-03-14	DBC	ETF	24.22	24.34	24.04	24.34	179100.0
2007-03-14	DBE	ETF	25.62	25.76	25.55	25.69	29600.0
2007-03-14	DBO	ETF	24.78	25.03	24.62	25.03	6100.0
2007-03-14	DBP	ETF	25.42	25.42	25.17	25.32	2300.0
2007-03-14	DBS	ETF	25.15	25.24	24.8	25.23	5400.0
2007-03-14	DBV	ETF	26.06	26.19	26.0	26.17	503300.0
2007-03-14	DDM	ETF	6.49	6.5208	6.3017	6.5208	3666000.0
2007-03-14	DEF	ETF	25.23	25.24	24.855	25.24	15300.0
2007-03-14	DES	ETF	18.5867	18.7833	18.4533	18.7533	79500.0
2007-03-14	DEW	ETF	59.49	60.01	59.2	60.01	29500.0

> showing 50 of 441 rows — these rows as CSV

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