PREVIEW / etf_daily / 2007-01-17

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-17.parquet
  size:    20 KB
  rows:    403

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-17	SPY	ETF	142.85	143.46	142.73	143.02	50241400.0
2007-01-17	QQQ	ETF	45.09	45.29	44.83	44.91	127622684.0
2007-01-17	IWM	ETF	78.22	78.78	78.11	78.11	27481200.0
2007-01-17	DIA	ETF	125.54	126.1	125.43	125.75	8768600.0
2007-01-17	GLD	ETF	61.97	62.9	61.97	62.64	4516200.0
2007-01-17	TLT	ETF	88.21	88.27	87.82	87.96	724200.0
2007-01-17	AAA	ETF	61.8	62.22	61.8	62.198	13800.0
2007-01-17	ADRE	ETF	37.88	38.26	37.85	38.13	144837.0
2007-01-17	AGG	ETF	99.89	99.96	99.67	99.74	258800.0
2007-01-17	AIQ	ETF	34.4	34.55	33.35	34.25	17020.0
2007-01-17	AIS	ETF	1.21	1.27	1.21	1.23	72600.0
2007-01-17	ARB	ETF	46.0	46.63	45.91	46.05	141000.0
2007-01-17	BAB	ETF	106.5	107.81	106.35	106.99	127800.0
2007-01-17	BBC	ETF	5.03	5.13	4.92	4.99	196000.0
2007-01-17	BBH	ETF	65.2567	65.5167	65.2167	65.3667	630000.0
2007-01-17	BITS	ETF	38.08	38.16	36.04	36.6652	10923.0
2007-01-17	BNE	ETF	15.42	15.65	15.4	15.45	100500.0
2007-01-17	BRF	ETF	14.46	14.49	14.41	14.46	15000.0
2007-01-17	BTF	ETF	106.05	106.5	106.05	106.476	660.0
2007-01-17	CBON	ETF	29.93	29.94	29.5	29.73	43642.0
2007-01-17	CDL	ETF	10.21	10.21	10.12	10.17	424000.0
2007-01-17	CEF	ETF	8.94	9.13	8.89	9.11	531500.0
2007-01-17	CEW	ETF	25.8	26.1	25.8	26.1	2200.0
2007-01-17	CGO	ETF	16.72	16.91	16.65	16.7207	40500.0
2007-01-17	CHB	ETF	8.38	8.56	8.18	8.26	1384400.0
2007-01-17	CHI	ETF	19.92	20.1	19.9	20.02	110900.0
2007-01-17	CHIC	ETF	32.38	32.66	31.81	32.14	302932.0
2007-01-17	CHY	ETF	17.04	17.05	16.96	17.03	109400.0
2007-01-17	CIL	ETF	25.32	25.32	25.32	25.32	100.0
2007-01-17	CN	ETF	48.5	48.96	48.1	48.5	175900.0
2007-01-17	CNXT	ETF	2.06	2.07	2.04	2.06	7844730.0
2007-01-17	CPST	ETF	1.12	1.15	1.07	1.09	1641506.0
2007-01-17	CSA	ETF	21.98	22.1	21.98	22.07	7500.0
2007-01-17	CSB	ETF	34.15	34.27	34.01	34.15	21500.0
2007-01-17	CSD	ETF	25.4	25.46	25.37	25.37	9400.0
2007-01-17	CSQ	ETF	15.54	15.7	15.52	15.68	382700.0
2007-01-17	CTEC	ETF	93.0	96.25	93.0	95.35	20484.600000000002
2007-01-17	CVY	ETF	26.31	26.5	26.3	26.44	21200.0
2007-01-17	CWI	ETF	24.3	24.5667	24.3	24.3267	1430700.0
2007-01-17	DBA	ETF	26.1	26.15	25.6	25.87	719800.0
2007-01-17	DBB	ETF	23.43	23.53	23.15	23.53	3700.0
2007-01-17	DBC	ETF	22.55	22.92	22.36	22.85	291200.0
2007-01-17	DBE	ETF	22.43	22.85	22.43	22.8	12800.0
2007-01-17	DBO	ETF	21.86	22.74	21.77	22.35	51900.0
2007-01-17	DBP	ETF	24.89	25.16	24.89	25.13	4200.0
2007-01-17	DBS	ETF	24.92	24.92	24.92	24.92	1300.0
2007-01-17	DBV	ETF	26.35	26.39	26.28	26.34	185400.0
2007-01-17	DDM	ETF	7.0008	7.0517	6.9925	7.025	442800.0
2007-01-17	DEF	ETF	25.33	25.41	25.2755	25.38	10100.0
2007-01-17	DES	ETF	19.1233	19.1667	19.0567	19.0567	98700.0

> showing 50 of 403 rows — these rows as CSV

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