PREVIEW / etf_daily / 2007-01-05

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-05.parquet
  size:    19 KB
  rows:    394

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-05	SPY	ETF	141.33	141.4	140.38	140.54	76645300.0
2007-01-05	QQQ	ETF	43.93	43.95	43.48	43.85	139026423.0
2007-01-05	IWM	ETF	78.02	78.37	76.7	76.73	57486800.0
2007-01-05	DIA	ETF	124.47	124.5	123.52	123.74	9389000.0
2007-01-05	GLD	ETF	60.75	60.78	59.66	60.17	12500100.0
2007-01-05	TLT	ETF	88.8	89.4	88.75	89.21	1298400.0
2007-01-05	AAA	ETF	62.23	62.23	61.45	61.97	7200.0
2007-01-05	ADRE	ETF	38.4	38.44	37.212	37.63	365221.0
2007-01-05	AGG	ETF	100.0	100.09	99.9	100.05	318200.0
2007-01-05	AIQ	ETF	32.5	32.65	31.7	31.85	38140.0
2007-01-05	AIS	ETF	1.21	1.22	1.18	1.2	57800.0
2007-01-05	ARB	ETF	43.95	44.24	42.91	43.02	127500.0
2007-01-05	BAB	ETF	106.44	106.56	105.7101	106.33	55600.0
2007-01-05	BBC	ETF	4.9	4.95	4.5	4.52	437200.0
2007-01-05	BBH	ETF	63.2833	63.5667	62.6867	62.96	699900.0
2007-01-05	BITS	ETF	34.52	34.76	33.64	33.76	27362.0
2007-01-05	BNE	ETF	15.84	15.96	15.6	15.6	119900.0
2007-01-05	BRF	ETF	14.46	14.53	14.46	14.5	9500.0
2007-01-05	BTF	ETF	105.5	106.19999999999999	105.5	105.6	4080.0
2007-01-05	CBON	ETF	29.81	29.91	29.548	29.85	134736.0
2007-01-05	CDL	ETF	9.85	9.9	9.61	9.66	365600.0
2007-01-05	CEF	ETF	9.02	9.05	8.82	8.9	714100.0
2007-01-05	CGO	ETF	16.82	17.1	16.59	17.0301	43300.0
2007-01-05	CHB	ETF	8.56	8.58	8.07	8.24	1801000.0
2007-01-05	CHI	ETF	20.15	20.21	19.98	20.05	114300.0
2007-01-05	CHIC	ETF	31.2	31.48	30.39	30.44	496415.0
2007-01-05	CHY	ETF	16.97	17.02	16.81	17.0	136600.0
2007-01-05	CN	ETF	53.48	53.66	51.25	51.8	237400.0
2007-01-05	CNXT	ETF	2.15	2.18	2.1	2.11	6988976.0
2007-01-05	CPST	ETF	1.17	1.19	1.14	1.15	1633557.0
2007-01-05	CSA	ETF	20.9	21.21	20.88	21.0	36300.0
2007-01-05	CSB	ETF	32.95	32.95	32.52	32.81	33900.0
2007-01-05	CSD	ETF	24.9	24.91	24.78	24.85	10600.0
2007-01-05	CSQ	ETF	15.59	15.63	15.52	15.61	487700.0
2007-01-05	CTEC	ETF	90.55	91.8	90.55	91.54999999999998	18482.2
2007-01-05	CVY	ETF	26.31	26.31	26.01	26.12	23700.0
2007-01-05	DBA	ETF	24.929	25.05	24.85	25.02	27800.0
2007-01-05	DBB	ETF	24.1	24.1	23.3	23.71	184600.0
2007-01-05	DBC	ETF	23.05	23.35	22.85	23.2	369800.0
2007-01-05	DBE	ETF	24.1	24.19	24.1	24.19	1200.0
2007-01-05	DBO	ETF	23.99	24.38	23.79	24.27	128100.0
2007-01-05	DBP	ETF	24.08	24.08	24.04	24.04	200.0
2007-01-05	DBS	ETF	24.02	24.17	24.02	24.17	3000.0
2007-01-05	DBV	ETF	26.0	26.02	25.85	25.88	186200.0
2007-01-05	DDM	ETF	6.8792	6.8792	6.7917	6.8058	723600.0
2007-01-05	DEF	ETF	24.92	24.92	24.83	24.83	4900.0
2007-01-05	DES	ETF	19.1267	19.1267	18.84	18.8567	158100.0
2007-01-05	DEW	ETF	61.66	61.66	61.21	61.45	10500.0
2007-01-05	DFE	ETF	65.0	65.06	64.87	65.02	16100.0
2007-01-05	DFJ	ETF	50.79	50.92	50.44	50.45	43000.0

> showing 50 of 394 rows — these rows as CSV

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