PREVIEW / etf_daily / 2007-01-11

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-11.parquet
  size:    20 KB
  rows:    404

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-11	SPY	ETF	141.58	142.62	141.5	142.16	54476800.0
2007-01-11	QQQ	ETF	44.71	45.24	44.65	45.08	174102536.0
2007-01-11	IWM	ETF	77.46	78.54	77.4	78.23	49188300.0
2007-01-11	DIA	ETF	124.51	125.35	124.34	124.99	7467000.0
2007-01-11	GLD	ETF	60.7	61.07	60.53	60.63	4640000.0
2007-01-11	TLT	ETF	88.79	88.8	88.26	88.45	1293500.0
2007-01-11	AAA	ETF	61.16	61.5	61.069	61.21	1600.0
2007-01-11	ADRE	ETF	37.1	37.78	37.0	37.4	405877.0
2007-01-11	AGG	ETF	100.04	100.09	99.74	99.81	445200.0
2007-01-11	AIQ	ETF	34.15	35.0	33.95	34.6	46140.0
2007-01-11	AIS	ETF	1.29	1.29	1.22	1.25	197300.0
2007-01-11	ARB	ETF	46.75	48.76	46.6	46.85	707700.0
2007-01-11	BAB	ETF	107.04	109.1	106.69	109.1	190600.0
2007-01-11	BBC	ETF	4.9	4.98	4.77	4.77	214000.0
2007-01-11	BBH	ETF	63.6267	64.74	63.6267	64.6433	1223400.0
2007-01-11	BITS	ETF	33.92	36.96	33.64	36.92	49313.0
2007-01-11	BNE	ETF	15.5	15.82	15.5	15.65	114100.0
2007-01-11	BOSS	ETF	42.14	42.5	42.14	42.5	100.0
2007-01-11	BRF	ETF	14.57	14.64	14.47	14.54	12300.0
2007-01-11	BTF	ETF	105.55	106.14999999999999	105.5	105.7	1680.0
2007-01-11	CBON	ETF	29.93	30.2	29.84	29.96	23386.0
2007-01-11	CDL	ETF	9.74	9.96	9.73	9.94	205300.0
2007-01-11	CEF	ETF	9.61	9.61	8.65	8.76	377300.0
2007-01-11	CEW	ETF	25.75	25.89	25.75	25.89	400.0
2007-01-11	CGO	ETF	16.65	16.886	16.5	16.8301	41300.0
2007-01-11	CHB	ETF	8.24	8.49	8.21	8.36	1357000.0
2007-01-11	CHI	ETF	19.82	19.9099	19.8	19.87	97200.0
2007-01-11	CHIC	ETF	32.34	32.84	32.13	32.37	454091.0
2007-01-11	CHY	ETF	17.01	17.05	16.9	16.9999	137300.0
2007-01-11	CIL	ETF	25.35	25.35	25.33	25.33	2600.0
2007-01-11	CN	ETF	47.63	49.19	47.38	48.87	182300.0
2007-01-11	CNXT	ETF	2.1	2.13	2.08	2.08	8384491.0
2007-01-11	CPI	ETF	23.41	23.41	23.41	23.41	100.0
2007-01-11	CPST	ETF	1.07	1.14	1.06	1.09	3105871.0
2007-01-11	CSA	ETF	21.5	22.3	21.5	22.25	30900.0
2007-01-11	CSB	ETF	33.66	34.1	33.64	33.96	12800.0
2007-01-11	CSD	ETF	24.98	25.28	24.97	25.2	14300.0
2007-01-11	CSQ	ETF	15.57	15.57	15.48	15.54	350900.0
2007-01-11	CTEC	ETF	93.05	94.04999999999998	92.14999999999999	93.94999999999999	13915.2
2007-01-11	CVY	ETF	26.15	26.43	26.15	26.34	17400.0
2007-01-11	DBA	ETF	24.9	25.13	24.8	25.1	159600.0
2007-01-11	DBB	ETF	24.05	24.85	24.05	24.54	116100.0
2007-01-11	DBC	ETF	22.6	23.0	22.3	22.65	496300.0
2007-01-11	DBE	ETF	23.45	23.93	22.9	23.01	76200.0
2007-01-11	DBO	ETF	23.01	23.26	22.37	22.39	21400.0
2007-01-11	DBP	ETF	24.3	24.51	24.3	24.35	7500.0
2007-01-11	DBS	ETF	24.6	24.6	24.44	24.44	800.0
2007-01-11	DBV	ETF	26.3	26.39	26.25	26.34	406300.0
2007-01-11	DDM	ETF	6.89	6.98	6.89	6.95	723600.0
2007-01-11	DEF	ETF	25.08	25.28	25.08	25.25	9600.0

> showing 50 of 404 rows — these rows as CSV

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