PREVIEW / etf_daily / 2007-01-18

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-18.parquet
  size:    20 KB
  rows:    406

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-01-18	SPY	ETF	143.17	143.26	142.31	142.54	68177300.0
2007-01-18	QQQ	ETF	44.79	44.84	43.95	44.08	189187961.0
2007-01-18	IWM	ETF	78.13	78.13	77.02	77.46	55936200.0
2007-01-18	DIA	ETF	125.96	126.08	125.39	125.51	10423800.0
2007-01-18	GLD	ETF	62.99	63.16	62.15	62.26	4460100.0
2007-01-18	TLT	ETF	87.94	88.28	87.78	88.23	918300.0
2007-01-18	AAA	ETF	61.97	62.25	61.7	62.21	14100.0
2007-01-18	ADRE	ETF	38.55	38.59	37.75	37.81	228330.0
2007-01-18	AGG	ETF	99.74	99.91	99.65	99.88	290600.0
2007-01-18	AIQ	ETF	34.4	34.75	33.65	34.35	18700.0
2007-01-18	AIS	ETF	1.22	1.23	1.15	1.19	123100.0
2007-01-18	ARB	ETF	46.1	46.3	45.51	45.87	130900.0
2007-01-18	BAB	ETF	107.57	108.51	107.31	107.6	100000.0
2007-01-18	BBC	ETF	5.04	5.09	4.81	4.83	202800.0
2007-01-18	BBH	ETF	65.5333	65.79	65.0233	65.0833	843300.0
2007-01-18	BITS	ETF	36.8	37.0	35.08	35.08	15098.0
2007-01-18	BNE	ETF	15.39	15.53	15.22	15.25	99600.0
2007-01-18	BRF	ETF	14.42	14.5	14.4	14.4	68100.0
2007-01-18	BTF	ETF	106.5	106.69999999999999	106.4	106.6	1340.0
2007-01-18	CBON	ETF	29.65	29.72	29.58	29.6	35407.0
2007-01-18	CDL	ETF	10.17	10.26	10.11	10.14	525100.0
2007-01-18	CEF	ETF	9.1	9.11	8.94	8.97	433400.0
2007-01-18	CEW	ETF	26.07	26.07	26.07	26.07	400.0
2007-01-18	CGO	ETF	16.66	16.89	16.66	16.78	32300.0
2007-01-18	CHB	ETF	8.23	8.42	8.11	8.3	1152900.0
2007-01-18	CHI	ETF	19.96	20.08	19.94	20.06	108500.0
2007-01-18	CHIC	ETF	32.17	32.25	31.65	32.09	521972.0
2007-01-18	CHY	ETF	17.01	17.1	16.98	17.1	103000.0
2007-01-18	CIL	ETF	25.27	25.27	25.27	25.27	1000.0
2007-01-18	CN	ETF	48.3	48.56	47.43	47.62	112800.0
2007-01-18	CNXT	ETF	2.05	2.05	1.91	1.93	21834842.0
2007-01-18	CPI	ETF	23.3	23.3	22.85	23.26	1000.0
2007-01-18	CPST	ETF	1.08	1.1	1.06	1.07	1104134.0
2007-01-18	CSA	ETF	22.08	22.08	21.53	21.76	14400.0
2007-01-18	CSB	ETF	33.99	34.08	33.81	34.0	17100.0
2007-01-18	CSD	ETF	25.38	25.38	25.23	25.25	25100.0
2007-01-18	CSM	ETF	1.33	1.34	1.325	1.34	2800.0
2007-01-18	CSQ	ETF	15.68	15.72	15.55	15.62	376500.0
2007-01-18	CTEC	ETF	95.35	97.14999999999999	95.35	96.5	22422.2
2007-01-18	CVY	ETF	26.47	26.47	26.31	26.38	36200.0
2007-01-18	CWI	ETF	24.4933	24.4933	24.3	24.3333	322500.0
2007-01-18	DBA	ETF	26.24	26.27	25.72	26.0	592100.0
2007-01-18	DBB	ETF	23.5	23.63	23.28	23.29	14700.0
2007-01-18	DBC	ETF	22.95	23.04	22.4	22.61	609700.0
2007-01-18	DBE	ETF	22.9	22.98	22.2	22.49	13600.0
2007-01-18	DBO	ETF	22.55	22.55	21.73	21.96	50900.0
2007-01-18	DBP	ETF	25.13	25.13	24.91	24.91	1100.0
2007-01-18	DBS	ETF	25.45	25.45	24.94	25.0	2000.0
2007-01-18	DBV	ETF	26.54	26.54	26.4101	26.46	359500.0
2007-01-18	DDM	ETF	7.0408	7.05	6.9842	6.9958	778800.0

> showing 50 of 406 rows — these rows as CSV

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