PREVIEW / etf_daily / 2007-01-10

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-10.parquet
  size:    19 KB
  rows:    395

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-10	SPY	ETF	140.58	141.57	140.3	141.54	72428000.0
2007-01-10	QQQ	ETF	43.96	44.66	43.82	44.62	121165921.0
2007-01-10	IWM	ETF	76.76	77.75	76.57	77.75	49239300.0
2007-01-10	DIA	ETF	123.74	124.55	123.5	124.43	8961200.0
2007-01-10	GLD	ETF	60.46	60.82	60.06	60.59	3766000.0
2007-01-10	TLT	ETF	89.07	89.13	88.88	88.97	519600.0
2007-01-10	AAA	ETF	61.56	61.63	61.23	61.59	3100.0
2007-01-10	ADRE	ETF	36.54	37.0	36.14	36.93	677940.0
2007-01-10	AGG	ETF	100.11	100.11	99.91	100.0	697900.0
2007-01-10	AIQ	ETF	32.95	34.35	32.65	33.95	41140.0
2007-01-10	AIS	ETF	1.29	1.3	1.13	1.25	171500.0
2007-01-10	ARB	ETF	43.78	44.5	43.57	44.42	150100.0
2007-01-10	BAB	ETF	106.96	108.3599	106.43	108.31	101400.0
2007-01-10	BBC	ETF	5.11	5.11	4.86	4.95	274700.0
2007-01-10	BBH	ETF	63.07	63.12	62.7633	63.0767	690900.0
2007-01-10	BITS	ETF	33.88	34.44	33.72	34.04	8276.0
2007-01-10	BNE	ETF	15.38	15.55	15.38	15.44	101900.0
2007-01-10	BOSS	ETF	41.8	42.45	41.8	42.45	100.0
2007-01-10	BRF	ETF	14.68	14.68	14.6	14.67	8500.0
2007-01-10	BTF	ETF	105.29999999999998	105.89999999999999	105.05	105.85000000000001	7800.0
2007-01-10	CBON	ETF	29.8	29.88	29.79	29.86	59029.0
2007-01-10	CDL	ETF	9.69	9.78	9.61	9.73	150600.0
2007-01-10	CEF	ETF	8.84	8.85	8.68	8.69	411900.0
2007-01-10	CEW	ETF	25.91	25.95	25.91	25.91	800.0
2007-01-10	CGO	ETF	16.85	16.85	16.51	16.6	29400.0
2007-01-10	CHB	ETF	8.01	8.25	7.98	8.24	732000.0
2007-01-10	CHI	ETF	19.9	19.9899	19.81	19.83	119600.0
2007-01-10	CHIC	ETF	31.29	32.37	31.23	32.22	346782.0
2007-01-10	CHY	ETF	17.12	17.16	17.0	17.01	109900.0
2007-01-10	CN	ETF	49.5	49.6	47.53	48.5	316500.0
2007-01-10	CNXT	ETF	2.06	2.1001	2.04	2.09	7894439.0
2007-01-10	CPST	ETF	1.08	1.09	1.05	1.06	803327.0
2007-01-10	CSA	ETF	20.91	21.4	20.91	21.4	8700.0
2007-01-10	CSB	ETF	32.57	32.83	32.4901	32.74	31700.0
2007-01-10	CSD	ETF	24.94	25.01	24.91	25.01	4800.0
2007-01-10	CSM	ETF	1.3075	1.3075	1.3075	1.3075	800.0
2007-01-10	CSQ	ETF	15.6	15.61	15.5	15.57	450100.0
2007-01-10	CTEC	ETF	91.69999999999999	93.6	91.5	93.24999999999999	23931.2
2007-01-10	CVY	ETF	26.02	26.19	26.02	26.18	24200.0
2007-01-10	DBA	ETF	24.7	24.82	24.5	24.73	76600.0
2007-01-10	DBB	ETF	23.55	24.22	23.55	24.22	10900.0
2007-01-10	DBC	ETF	22.83	22.94	22.62	22.68	285900.0
2007-01-10	DBE	ETF	24.27	24.27	23.75	23.79	9500.0
2007-01-10	DBO	ETF	23.64	23.64	23.07	23.1	211200.0
2007-01-10	DBP	ETF	24.3	24.45	24.25	24.41	6100.0
2007-01-10	DBS	ETF	24.45	24.51	24.23	24.5	800.0
2007-01-10	DBV	ETF	26.14	26.16	26.02	26.12	187600.0
2007-01-10	DDM	ETF	6.8025	6.8817	6.7792	6.8792	477600.0
2007-01-10	DEF	ETF	24.81	25.03	24.81	25.03	7000.0
2007-01-10	DES	ETF	18.85	18.8967	18.8067	18.8633	20700.0

> showing 50 of 395 rows — these rows as CSV

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