PREVIEW / etf_daily / 2007-02-14

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-14.parquet
  size:    21 KB
  rows:    434

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-14	SPY	ETF	144.8	145.9	144.78	145.61	66039400.0
2007-02-14	QQQ	ETF	44.05	44.71	44.04	44.6	133562710.0
2007-02-14	IWM	ETF	80.73	81.29	80.52	80.8	64326000.0
2007-02-14	DIA	ETF	126.78	127.83	126.7	127.48	7395600.0
2007-02-14	GLD	ETF	66.23	66.66	65.97	66.37	4174600.0
2007-02-14	TLT	ETF	87.52	88.19	87.52	88.07	2262500.0
2007-02-14	AAA	ETF	61.07	61.5	61.07	61.5	8000.0
2007-02-14	ADRE	ETF	39.69	40.51	39.69	40.41	193480.0
2007-02-14	AGG	ETF	99.79	100.02	99.68	100.0	269400.0
2007-02-14	AIQ	ETF	36.25	36.65	35.75	36.2	33870.0
2007-02-14	AIS	ETF	1.24	1.24	1.22	1.22	45900.0
2007-02-14	ARB	ETF	46.56	47.24	46.56	46.64	163214.0
2007-02-14	BAB	ETF	111.83	113.96	111.58	113.96	73600.0
2007-02-14	BBC	ETF	4.5	4.56	4.28	4.35	110125.0
2007-02-14	BBH	ETF	62.87	63.3333	62.7667	63.2567	399600.0
2007-02-14	BITS	ETF	41.36	46.04	41.36	45.76	104691.0
2007-02-14	BNE	ETF	15.62	15.83	15.62	15.8	185330.0
2007-02-14	BOSS	ETF	42.42	43.32	42.42	43.32	100.0
2007-02-14	BRF	ETF	14.43	14.45	14.43	14.43	4200.0
2007-02-14	BTF	ETF	113.0	113.49999999999999	112.75	113.39499999999998	4400.0
2007-02-14	CBON	ETF	33.35	33.54	32.79	32.81	101923.0
2007-02-14	CDL	ETF	10.67	10.67	10.49	10.56	434793.0
2007-02-14	CEF	ETF	9.65	9.74	9.58	9.66	793300.0
2007-02-14	CGO	ETF	16.94	17.1	16.75	16.89	30850.0
2007-02-14	CHB	ETF	7.47	8.25	7.38	7.66	2088727.0
2007-02-14	CHI	ETF	20.38	20.4	20.23	20.35	95600.0
2007-02-14	CHIC	ETF	30.19	30.24	29.5	29.75	396114.0
2007-02-14	CHY	ETF	16.99	17.09	16.94	17.06	131250.0
2007-02-14	CIL	ETF	25.4	25.4	25.4	25.4	100.0
2007-02-14	CN	ETF	48.9	49.8504	48.8	49.51	92400.0
2007-02-14	CNXT	ETF	1.95	2.03	1.94	2.02	9184166.0
2007-02-14	CPI	ETF	24.15	24.15	24.15	24.15	200.0
2007-02-14	CPST	ETF	0.9	0.9009	0.8672	0.8998	7542917.0
2007-02-14	CSA	ETF	21.9	22.22	21.9	22.13	18400.0
2007-02-14	CSB	ETF	33.22	33.32	33.11	33.31	16300.0
2007-02-14	CSD	ETF	26.41	26.58	26.41	26.5	7300.0
2007-02-14	CSM	ETF	1.3475	1.3475	1.3475	1.3475	1200.0
2007-02-14	CSQ	ETF	15.25	15.27	15.16	15.26	419381.0
2007-02-14	CTEC	ETF	88.14999999999999	89.74999999999999	88.0	89.04999999999998	16637.2
2007-02-14	CVY	ETF	27.17	27.35	27.04	27.26	31000.0
2007-02-14	CWI	ETF	25.2267	25.46	25.2267	25.4	58500.0
2007-02-14	DBA	ETF	26.19	26.22	25.86	26.0	406100.0
2007-02-14	DBB	ETF	23.48	23.76	23.42	23.55	21700.0
2007-02-14	DBC	ETF	24.38	24.46	23.95	24.07	383800.0
2007-02-14	DBE	ETF	25.11	25.11	24.76	24.89	14700.0
2007-02-14	DBO	ETF	24.74	24.76	24.18	24.44	35100.0
2007-02-14	DBP	ETF	26.68	26.84	26.62	26.7	21100.0
2007-02-14	DBS	ETF	27.64	27.69	27.53	27.69	8500.0
2007-02-14	DBV	ETF	26.4	26.42	26.3302	26.37	95200.0
2007-02-14	DDM	ETF	7.1	7.1992	7.0725	7.1775	1266000.0

> showing 50 of 434 rows — these rows as CSV

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