PREVIEW / etf_daily / 2007-01-29

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-29.parquet
  size:    20 KB
  rows:    410

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-29	SPY	ETF	142.19	142.8	141.74	142.05	66114600.0
2007-01-29	QQQ	ETF	43.45	43.91	43.4	43.61	104211994.0
2007-01-29	IWM	ETF	78.12	78.94	78.03	78.75	59602200.0
2007-01-29	DIA	ETF	124.83	125.31	124.69	124.82	6681200.0
2007-01-29	GLD	ETF	63.85	64.29	63.66	63.77	3487300.0
2007-01-29	TLT	ETF	87.06	87.1	86.6	86.72	1015300.0
2007-01-29	AAA	ETF	61.04	61.28	61.04	61.28	5900.0
2007-01-29	ADRE	ETF	38.71	38.71	38.2	38.21	206382.0
2007-01-29	AGG	ETF	99.68	99.69	99.34	99.4	388400.0
2007-01-29	AIQ	ETF	34.8	35.2	34.1	35.0	31080.0
2007-01-29	AIS	ETF	1.19	1.21	1.14	1.21	246400.0
2007-01-29	ARB	ETF	45.51	46.69	45.05	46.48	409500.0
2007-01-29	BAB	ETF	106.61	107.13	105.97	106.69	95000.0
2007-01-29	BBC	ETF	4.8	5.04	4.8	4.97	77700.0
2007-01-29	BBH	ETF	63.33	63.4567	62.87	63.08	617400.0
2007-01-29	BITS	ETF	40.6	41.04	39.8	40.68	22440.0
2007-01-29	BNE	ETF	15.22	15.45	15.16	15.3	69800.0
2007-01-29	BOSS	ETF	42.19	42.33	42.19	42.33	100.0
2007-01-29	BRF	ETF	14.42	14.48	14.38	14.42	8700.0
2007-01-29	BTF	ETF	108.14999999999999	108.8	108.14999999999999	108.49999999999999	1280.0
2007-01-29	CBON	ETF	32.62	33.56	32.6	33.55	137676.0
2007-01-29	CDL	ETF	10.5	10.52	10.27	10.37	471700.0
2007-01-29	CEF	ETF	9.42	9.45	9.35	9.39	251000.0
2007-01-29	CEW	ETF	25.82	25.92	25.82	25.92	500.0
2007-01-29	CGO	ETF	17.1	17.1332	16.97	17.0	21800.0
2007-01-29	CHB	ETF	7.95	8.08	7.92	8.05	701300.0
2007-01-29	CHI	ETF	20.26	20.34	20.26	20.26	67700.0
2007-01-29	CHIC	ETF	28.9	29.71	28.78	29.38	1013442.0
2007-01-29	CHY	ETF	17.27	17.4	17.25	17.36	123100.0
2007-01-29	CIL	ETF	25.43	25.43	25.43	25.43	500.0
2007-01-29	CN	ETF	48.82	49.69	48.82	49.38	132800.0
2007-01-29	CNXT	ETF	1.8	1.88	1.78	1.86	17429396.0
2007-01-29	CPST	ETF	0.9	0.97	0.89	0.96	2352773.0
2007-01-29	CSA	ETF	21.72	21.9	21.68	21.75	16700.0
2007-01-29	CSB	ETF	33.4	33.48	33.3	33.39	12000.0
2007-01-29	CSD	ETF	25.54	25.67	25.54	25.63	7700.0
2007-01-29	CSQ	ETF	15.47	15.49	15.38	15.47	282800.0
2007-01-29	CTEC	ETF	91.25	93.0	90.25	91.99999999999999	25026.800000000003
2007-01-29	CVY	ETF	26.63	26.64	26.55	26.6	25300.0
2007-01-29	CWI	ETF	24.4133	24.4933	24.3667	24.44	16200.0
2007-01-29	DBA	ETF	25.95	25.95	25.58	25.6	157700.0
2007-01-29	DBB	ETF	23.45	23.45	23.1	23.29	34800.0
2007-01-29	DBC	ETF	23.4	23.45	22.99	23.1	367400.0
2007-01-29	DBE	ETF	24.04	24.04	23.55	23.57	4300.0
2007-01-29	DBO	ETF	23.41	23.41	22.71	22.82	17500.0
2007-01-29	DBP	ETF	25.7	25.74	25.54	25.55	7300.0
2007-01-29	DBS	ETF	26.12	26.2948	25.9	25.9	16100.0
2007-01-29	DBV	ETF	26.5	26.5	26.3	26.36	325100.0
2007-01-29	DDM	ETF	6.9083	6.9508	6.8967	6.8975	344400.0
2007-01-29	DEF	ETF	25.71	25.77	25.65	25.69	7300.0

> showing 50 of 410 rows — these rows as CSV

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