PREVIEW / etf_daily / 2007-01-22

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-22.parquet
  size:    19 KB
  rows:    401

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-22	SPY	ETF	143.07	143.1	141.93	142.38	60253600.0
2007-01-22	QQQ	ETF	44.21	44.23	43.51	43.69	123476129.0
2007-01-22	IWM	ETF	77.82	77.83	76.91	77.19	46305200.0
2007-01-22	DIA	ETF	125.48	125.51	124.38	124.75	10233200.0
2007-01-22	GLD	ETF	63.01	63.48	62.65	62.72	3941200.0
2007-01-22	TLT	ETF	88.15	88.33	88.12	88.2	432000.0
2007-01-22	AAA	ETF	62.11	62.11	61.51	61.65	8000.0
2007-01-22	ADRE	ETF	38.58	38.62	38.268	38.41	243914.0
2007-01-22	AGG	ETF	99.91	99.92	99.79	99.89	263600.0
2007-01-22	AIQ	ETF	34.1	34.2	33.25	33.9	24120.0
2007-01-22	AIS	ETF	1.15	1.2	1.11	1.14	611300.0
2007-01-22	ARB	ETF	46.27	46.27	45.3	45.66	108900.0
2007-01-22	BAB	ETF	106.94	107.1	105.66	106.15	68200.0
2007-01-22	BBC	ETF	5.17	5.17	4.82	4.85	209400.0
2007-01-22	BBH	ETF	66.0	66.4533	65.6133	65.6133	979200.0
2007-01-22	BITS	ETF	36.4	36.56	35.68	36.16	9372.0
2007-01-22	BNE	ETF	15.46	15.51	15.25	15.26	70800.0
2007-01-22	BRF	ETF	14.4	14.5	14.39	14.39	51900.0
2007-01-22	BTF	ETF	107.39999999999999	108.35000000000001	107.39999999999999	108.14999999999999	3480.0
2007-01-22	CBON	ETF	32.29	33.18	31.93	32.85	157036.0
2007-01-22	CDL	ETF	10.2	10.25	10.1	10.23	245800.0
2007-01-22	CEF	ETF	9.25	9.39	9.13	9.13	497700.0
2007-01-22	CEW	ETF	26.0	26.0	26.0	26.0	400.0
2007-01-22	CGO	ETF	16.78	16.89	16.66	16.79	25700.0
2007-01-22	CHB	ETF	8.2	8.32	8.04	8.07	899700.0
2007-01-22	CHI	ETF	20.08	20.3	20.08	20.17	99500.0
2007-01-22	CHIC	ETF	31.82	32.06	31.41	31.68	437050.0
2007-01-22	CHY	ETF	17.28	17.33	17.22	17.3	132000.0
2007-01-22	CIL	ETF	25.38	25.38	25.33	25.33	3000.0
2007-01-22	CN	ETF	49.29	49.38	48.7	49.13	111800.0
2007-01-22	CNXT	ETF	2.0	2.02	1.95	1.96	6693757.0
2007-01-22	CPST	ETF	1.02	1.02	0.95	0.972	4392177.0
2007-01-22	CSA	ETF	21.81	21.81	21.65	21.78	6000.0
2007-01-22	CSB	ETF	34.1	34.15	33.8	34.01	17600.0
2007-01-22	CSD	ETF	25.36	25.36	25.14	25.19	14700.0
2007-01-22	CSM	ETF	1.3375	1.3425	1.3375	1.34	8800.0
2007-01-22	CSQ	ETF	15.67	15.74	15.35	15.5	528100.0
2007-01-22	CTEC	ETF	97.10000000000001	97.85	94.89999999999999	96.1	17555.4
2007-01-22	CVY	ETF	26.41	26.46	26.36	26.41	36400.0
2007-01-22	CWI	ETF	24.5733	24.5867	24.4	24.4533	247050.0
2007-01-22	DBA	ETF	25.81	26.12	25.75	26.1	296700.0
2007-01-22	DBB	ETF	23.86	23.99	23.86	23.93	13800.0
2007-01-22	DBC	ETF	23.08	23.3	22.7	22.97	303300.0
2007-01-22	DBE	ETF	23.55	23.77	22.88	23.14	54600.0
2007-01-22	DBO	ETF	22.88	23.24	22.25	22.43	28300.0
2007-01-22	DBP	ETF	25.34	25.47	25.14	25.14	5500.0
2007-01-22	DBS	ETF	25.7	25.83	25.5	25.53	1300.0
2007-01-22	DBV	ETF	26.65	26.65	26.54	26.56	335800.0
2007-01-22	DDM	ETF	6.9725	6.9725	6.8683	6.9033	1111200.0
2007-01-22	DEF	ETF	25.48	25.48	25.32	25.32	5800.0

> showing 50 of 401 rows — these rows as CSV

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