PREVIEW / etf_daily / 2007-04-09

all etf daily files

  file:    by_date/etf_daily/2007/2007-04-09.parquet
  size:    21 KB
  rows:    440

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-09	SPY	ETF	144.65	144.8	144.15	144.44	50967400.0
2007-04-09	QQQ	ETF	44.71	44.75	44.38	44.45	63064649.0
2007-04-09	IWM	ETF	80.78	80.83	80.32	80.55	38545000.0
2007-04-09	DIA	ETF	125.72	125.9	125.53	125.65	3529200.0
2007-04-09	GLD	ETF	66.88	67.2	66.46	66.53	3297300.0
2007-04-09	TLT	ETF	87.28	87.31	87.13	87.17	1283900.0
2007-04-09	AAA	ETF	67.36	67.37	67.06	67.23	15300.0
2007-04-09	ADRE	ETF	41.04	41.1299	40.8658	41.0	216600.0
2007-04-09	AGG	ETF	99.7	99.71	99.5	99.54	324200.0
2007-04-09	AIQ	ETF	46.25	46.75	45.8	46.25	82260.0
2007-04-09	AIS	ETF	1.5	1.57	1.49	1.55	271900.0
2007-04-09	ARB	ETF	48.01	48.01	47.22	47.42	82700.0
2007-04-09	BAB	ETF	101.2	101.65	100.46	101.12	34200.0
2007-04-09	BBH	ETF	60.0333	60.11	59.5	59.5667	246000.0
2007-04-09	BITS	ETF	31.6	31.8	31.0	31.4	14488.0
2007-04-09	BNE	ETF	15.93	16.25	15.91	16.2	277200.0
2007-04-09	BRF	ETF	14.55	14.55	14.55	14.55	600.0
2007-04-09	BTF	ETF	110.74999999999999	110.74999999999999	110.0	110.19999999999999	4900.0
2007-04-09	CBON	ETF	29.98	30.0	29.54	29.64	125534.0
2007-04-09	CDL	ETF	9.62	9.63	9.53	9.6	373900.0
2007-04-09	CEF	ETF	9.56	9.61	9.55	9.55	190300.0
2007-04-09	CGO	ETF	17.3	17.4	17.27	17.29	12800.0
2007-04-09	CHB	ETF	9.23	9.25	9.0	9.18	1378489.0
2007-04-09	CHI	ETF	20.37	20.46	20.26	20.33	124200.0
2007-04-09	CHIC	ETF	30.82	30.91	30.28	30.49	566293.0
2007-04-09	CHY	ETF	17.1	17.15	16.98	17.04	138400.0
2007-04-09	CN	ETF	51.5	51.93	51.49	51.63	60400.0
2007-04-09	CNXT	ETF	1.6	1.6	1.5	1.51	25037249.0
2007-04-09	CPI	ETF	21.71	21.71	21.62	21.65	300.0
2007-04-09	CPST	ETF	1.01	1.07	1.0	1.03	3169158.0
2007-04-09	CSA	ETF	21.1	21.39	20.96	21.34	10100.0
2007-04-09	CSB	ETF	33.31	33.56	33.21	33.22	19900.0
2007-04-09	CSD	ETF	28.02	28.12	27.97	28.0	22200.0
2007-04-09	CSM	ETF	1.365	1.365	1.3625	1.365	3200.0
2007-04-09	CSQ	ETF	15.31	15.35	15.25	15.31	223000.0
2007-04-09	CTEC	ETF	86.05	89.04999999999998	85.89999999999999	88.24999999999999	10620.2
2007-04-09	CVY	ETF	26.94	26.94	26.81	26.86	13400.0
2007-04-09	CWI	ETF	25.9733	26.0333	25.9467	25.9933	41100.0
2007-04-09	DBA	ETF	26.01	26.1	25.35	25.46	373300.0
2007-04-09	DBB	ETF	26.73	27.07	26.41	27.07	44700.0
2007-04-09	DBC	ETF	25.55	25.64	25.0	25.1	301000.0
2007-04-09	DBE	ETF	27.92	28.0	27.24	27.43	75700.0
2007-04-09	DBO	ETF	26.56	27.12	25.75	25.75	33700.0
2007-04-09	DBP	ETF	26.74	26.86	26.6	26.67	11400.0
2007-04-09	DBS	ETF	27.23	27.25	27.01	27.01	14800.0
2007-04-09	DBV	ETF	27.19	27.28	27.16	27.28	78700.0
2007-04-09	DDM	ETF	6.9175	6.9392	6.9033	6.9092	710400.0
2007-04-09	DEF	ETF	26.44	26.45	26.33	26.42	5800.0
2007-04-09	DES	ETF	19.3133	19.3133	19.2	19.2233	24900.0
2007-04-09	DEW	ETF	64.36	64.66	64.35	64.65	25200.0

> showing 50 of 440 rows — these rows as CSV

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