PREVIEW / etf_daily / 2007-01-31

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-31.parquet
  size:    20 KB
  rows:    412

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-31	SPY	ETF	142.63	144.13	142.4	143.75	91868600.0
2007-01-31	QQQ	ETF	43.6	44.19	43.33	44.07	157947693.0
2007-01-31	IWM	ETF	79.06	79.77	78.63	79.35	54267500.0
2007-01-31	DIA	ETF	125.19	126.49	125.13	126.24	9790200.0
2007-01-31	GLD	ETF	63.99	64.98	63.95	64.83	5900900.0
2007-01-31	TLT	ETF	86.7	87.61	86.7	87.55	2078000.0
2007-01-31	AAA	ETF	61.21	61.75	61.1	61.71	10500.0
2007-01-31	ADRE	ETF	38.7	39.14	38.43	39.09	171097.0
2007-01-31	AGG	ETF	99.51	99.82	99.45	99.63	386400.0
2007-01-31	AIQ	ETF	34.6	35.35	34.4	34.95	40940.0
2007-01-31	AIS	ETF	1.23	1.23	1.14	1.18	88000.0
2007-01-31	ARB	ETF	46.48	46.53	45.92	46.37	127800.0
2007-01-31	BAB	ETF	105.73	106.68	105.25	106.4	140900.0
2007-01-31	BBC	ETF	5.01	5.1	4.92	4.95	96700.0
2007-01-31	BBH	ETF	63.39	63.7567	62.8967	63.6167	1644000.0
2007-01-31	BITS	ETF	41.44	41.68	40.08	41.4	16083.0
2007-01-31	BNE	ETF	15.24	15.34	14.83	15.04	148900.0
2007-01-31	BRF	ETF	14.47	14.47	14.38	14.38	12400.0
2007-01-31	BTF	ETF	108.14999999999999	109.04999999999998	108.1	108.64999999999999	2320.0
2007-01-31	CBON	ETF	33.49	33.5	33.14	33.47	123043.0
2007-01-31	CDL	ETF	10.49	10.67	10.45	10.62	337600.0
2007-01-31	CEF	ETF	9.42	9.6	9.42	9.55	279900.0
2007-01-31	CEW	ETF	25.9	26.0	25.9	26.0	1800.0
2007-01-31	CGO	ETF	17.32	17.35	17.03	17.35	30700.0
2007-01-31	CHB	ETF	8.07	8.3	8.05	8.21	1116100.0
2007-01-31	CHI	ETF	20.25	20.37	20.22	20.35	96900.0
2007-01-31	CHIC	ETF	30.32	30.65	29.76	30.55	643489.0
2007-01-31	CHY	ETF	17.31	17.41	17.28	17.38	109000.0
2007-01-31	CIL	ETF	25.43	25.43	25.4	25.4	500.0
2007-01-31	CN	ETF	50.1	50.56	49.3	50.46	201900.0
2007-01-31	CNXT	ETF	1.86	1.9	1.83	1.87	13321244.0
2007-01-31	CPST	ETF	0.93	0.948	0.9	0.92	1717030.0
2007-01-31	CSA	ETF	22.1	22.95	21.85	22.54	47100.0
2007-01-31	CSB	ETF	33.05	33.66	33.05	33.65	21400.0
2007-01-31	CSD	ETF	25.78	25.97	25.68	25.97	31700.0
2007-01-31	CSM	ETF	1.3375	1.3375	1.275	1.335	51200.0
2007-01-31	CSQ	ETF	15.46	15.5	15.4	15.49	295600.0
2007-01-31	CTEC	ETF	92.24999999999999	92.24999999999999	83.50049999999999	84.14999999999999	73822.40000000001
2007-01-31	CVY	ETF	26.72	26.94	26.66	26.91	29500.0
2007-01-31	CWI	ETF	24.4467	24.7467	24.42	24.7467	109650.0
2007-01-31	DBA	ETF	25.98	26.08	25.8	25.9	157000.0
2007-01-31	DBB	ETF	23.25	23.61	23.18	23.59	3700.0
2007-01-31	DBC	ETF	23.7	24.01	23.5	23.99	298400.0
2007-01-31	DBE	ETF	24.48	25.0	24.23	24.94	12700.0
2007-01-31	DBO	ETF	23.87	24.44	23.68	24.44	30700.0
2007-01-31	DBP	ETF	25.77	26.11	25.77	26.05	8800.0
2007-01-31	DBS	ETF	26.82	26.8499	26.64	26.69	1200.0
2007-01-31	DBV	ETF	26.25	26.25	26.0201	26.14	199000.0
2007-01-31	DDM	ETF	6.9417	7.075	6.935	7.0458	966000.0
2007-01-31	DEF	ETF	25.78	25.94	25.74	25.93	23300.0

> showing 50 of 412 rows — these rows as CSV

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