PREVIEW / etf_daily / 2007-02-02

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-02.parquet
  size:    20 KB
  rows:    423

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-02-02	SPY	ETF	144.73	144.95	144.38	144.81	49607000.0
2007-02-02	QQQ	ETF	44.11	44.25	43.94	44.16	98202426.0
2007-02-02	IWM	ETF	80.4	80.45	80.02	80.25	26512600.0
2007-02-02	DIA	ETF	126.8	126.83	126.32	126.53	5961000.0
2007-02-02	GLD	ETF	64.76	64.8	63.8	64.28	9078500.0
2007-02-02	TLT	ETF	87.08	87.39	87.08	87.2	814700.0
2007-02-02	AAA	ETF	61.17	61.17	60.88	60.95	1600.0
2007-02-02	ADRE	ETF	39.69	39.72	39.4201	39.6	664398.0
2007-02-02	AGG	ETF	99.39	99.49	99.28	99.43	445100.0
2007-02-02	AIQ	ETF	35.25	36.15	34.85	35.9	39920.0
2007-02-02	AIS	ETF	1.21	1.27	1.21	1.27	474500.0
2007-02-02	ARB	ETF	47.42	47.65	47.24	47.33	141500.0
2007-02-02	BAB	ETF	108.89	109.55	108.45	109.4	87000.0
2007-02-02	BBC	ETF	4.95	5.06	4.87	4.92	147500.0
2007-02-02	BBH	ETF	64.0	64.4567	64.0	64.1333	341700.0
2007-02-02	BITS	ETF	41.6	41.6	40.52	40.8	22287.0
2007-02-02	BNE	ETF	15.3	15.52	15.23	15.41	134000.0
2007-02-02	BRF	ETF	14.5	14.55	14.46	14.5	1500.0
2007-02-02	BTF	ETF	108.4505	108.4505	107.44999999999999	108.05	1540.0
2007-02-02	CBON	ETF	33.4	33.5	33.06	33.44	51664.0
2007-02-02	CDL	ETF	10.54	10.78	10.51	10.77	213600.0
2007-02-02	CEF	ETF	9.64	9.75	9.5	9.57	332200.0
2007-02-02	CGO	ETF	17.26	17.31	17.17	17.25	15500.0
2007-02-02	CHB	ETF	8.09	8.59	8.09	8.38	1693700.0
2007-02-02	CHI	ETF	20.34	20.4	20.33	20.39	51900.0
2007-02-02	CHIC	ETF	31.07	31.07	30.08	30.29	672878.0
2007-02-02	CHY	ETF	17.39	17.47	17.35	17.4	92500.0
2007-02-02	CIL	ETF	25.35	25.42	25.28	25.42	4700.0
2007-02-02	CN	ETF	52.8	52.8	52.0	52.26	91400.0
2007-02-02	CNXT	ETF	1.91	1.98	1.9	1.97	14823246.0
2007-02-02	CPI	ETF	23.85	23.85	23.85	23.85	1100.0
2007-02-02	CPST	ETF	0.9	0.915	0.86	0.9099	2637368.0
2007-02-02	CSA	ETF	22.65	22.65	22.45	22.49	2800.0
2007-02-02	CSB	ETF	33.67	33.74	33.55	33.63	15300.0
2007-02-02	CSD	ETF	26.08	26.15	26.05	26.15	11600.0
2007-02-02	CSM	ETF	1.3325	1.3325	1.3325	1.3325	16000.0
2007-02-02	CSQ	ETF	15.51	15.56	15.46	15.53	288500.0
2007-02-02	CTEC	ETF	87.3	88.64999999999999	87.3	87.69999999999999	22626.800000000003
2007-02-02	CVY	ETF	27.13	27.13	27.05	27.13	27300.0
2007-02-02	CWI	ETF	24.8667	24.9133	24.84	24.9133	34050.0
2007-02-02	DBA	ETF	25.75	26.03	25.67	26.03	109400.0
2007-02-02	DBB	ETF	22.4	22.4	21.93	22.3	39100.0
2007-02-02	DBC	ETF	23.84	24.21	23.6801	24.21	211600.0
2007-02-02	DBE	ETF	24.85	25.33	24.8	25.28	7500.0
2007-02-02	DBO	ETF	24.39	24.9	23.9	24.78	55600.0
2007-02-02	DBP	ETF	26.02	26.02	25.63	25.81	9900.0
2007-02-02	DBS	ETF	26.56	26.56	26.0901	26.41	5800.0
2007-02-02	DBV	ETF	26.14	26.18	26.0701	26.17	276800.0
2007-02-02	DDM	ETF	7.0958	7.1092	7.065	7.0717	838800.0
2007-02-02	DEF	ETF	26.14	26.14	26.09	26.14	14800.0

> showing 50 of 423 rows — these rows as CSV

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