PREVIEW / etf_daily / 2007-12-05

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-05.parquet
  size:    25 KB
  rows:    540

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-12-05	SPY	ETF	147.93	149.2	147.83	148.81	171130000.0
2007-12-05	QQQ	ETF	51.2	52.0	51.16	51.57	137621191.0
2007-12-05	IWM	ETF	76.19	76.62	75.52	76.44	70221700.0
2007-12-05	DIA	ETF	133.69	134.67	133.54	134.45	11851000.0
2007-12-05	GLD	ETF	79.25	79.25	78.19	78.63	7685300.0
2007-12-05	TLT	ETF	94.22	94.47	93.56	93.61	1866000.0
2007-12-05	ADRE	ETF	56.07	56.78	55.92	56.71	262063.0
2007-12-05	AGG	ETF	101.8	101.82	101.54	101.55	442400.0
2007-12-05	AIA	ETF	50.13	50.36	49.75	49.91	192500.0
2007-12-05	AIQ	ETF	48.2	48.4	47.3	47.55	17220.0
2007-12-05	AIS	ETF	1.04	1.12	1.01	1.07	516600.0
2007-12-05	AIVI	ETF	73.81	74.42	73.81	74.24	44900.0
2007-12-05	ARB	ETF	40.03	41.21	40.03	40.58	285700.0
2007-12-05	BBH	ETF	59.12	59.2067	56.81	57.1667	1430400.0
2007-12-05	BIL	ETF	91.62	91.68	91.6	91.62	27900.0
2007-12-05	BITS	ETF	22.2	22.2	21.4	21.52	8379.0
2007-12-05	BIV	ETF	77.7	77.85	77.59	77.69	16700.0
2007-12-05	BKF	ETF	60.66	61.46	60.5	61.44	30600.0
2007-12-05	BLV	ETF	77.45	77.65	77.01	77.01	10700.0
2007-12-05	BMVP	ETF	17.283	17.351	17.217	17.32	40400.0
2007-12-05	BND	ETF	77.15	77.31	77.09	77.16	74500.0
2007-12-05	BNE	ETF	17.86	18.18	17.73	18.12	160100.0
2007-12-05	BRF	ETF	14.6201	14.65	14.62	14.63	13000.0
2007-12-05	BSV	ETF	77.23	77.43	77.19	77.4	48100.0
2007-12-05	BTF	ETF	115.0	116.1	115.0	116.1	1100.0
2007-12-05	BWX	ETF	27.125	27.35	26.9	26.935	241000.0
2007-12-05	CBON	ETF	17.75	18.23	17.45	17.88	55909.0
2007-12-05	CDL	ETF	2.11	2.14	1.97	2.0	2307040.0
2007-12-05	CEF	ETF	10.51	10.52	10.37	10.44	191800.0
2007-12-05	CGO	ETF	19.3	19.45	19.12	19.4	13700.0
2007-12-05	CGW	ETF	25.46	26.41	25.46	25.75	46946.0
2007-12-05	CHB	ETF	8.32	8.54	8.25	8.42	892100.0
2007-12-05	CHI	ETF	15.04	15.04	14.83	15.0	178800.0
2007-12-05	CHIC	ETF	15.72	15.75	15.13	15.4	321859.0
2007-12-05	CHW	ETF	12.5	12.64	12.38	12.6	286800.0
2007-12-05	CHY	ETF	13.73	13.8527	13.7	13.8	221300.0
2007-12-05	CMF	ETF	52.105	52.105	52.105	52.105	400.0
2007-12-05	CN	ETF	64.87	66.05	64.18	65.9	357800.0
2007-12-05	CNXT	ETF	1.02	1.08	1.0112	1.07	7343090.0
2007-12-05	COW	ETF	48.08	48.21	48.0001	48.15	2800.0
2007-12-05	CPST	ETF	1.25	1.27	1.21	1.24	3056449.0
2007-12-05	CSA	ETF	15.04	15.6	14.83	15.33	122200.0
2007-12-05	CSD	ETF	27.39	27.5	27.28	27.42	15900.0
2007-12-05	CSQ	ETF	13.86	14.33	13.86	14.09	498800.0
2007-12-05	CUT	ETF	24.85	24.9	24.7	24.8	39600.0
2007-12-05	CVY	ETF	24.32	24.45	24.11	24.22	21000.0
2007-12-05	CWI	ETF	28.8733	29.1533	28.8067	29.1067	268350.0
2007-12-05	DBA	ETF	31.35	31.48	31.12	31.35	777800.0
2007-12-05	DBB	ETF	23.2	23.33	23.09	23.31	26000.0
2007-12-05	DBC	ETF	30.86	30.94	30.31	30.44	438368.0

> showing 50 of 540 rows — these rows as CSV

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