PREVIEW / etf_daily / 2007-11-26

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-26.parquet
  size:    24 KB
  rows:    536

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-11-26	SPY	ETF	144.43	144.88	140.66	140.95	214232000.0
2007-11-26	QQQ	ETF	49.98	50.37	48.9	48.98	150352064.0
2007-11-26	IWM	ETF	75.35	75.62	72.99	73.1	96764900.0
2007-11-26	DIA	ETF	129.7	130.32	127.25	127.46	11480600.0
2007-11-26	GLD	ETF	82.25	82.25	81.13	81.3	7440200.0
2007-11-26	TLT	ETF	94.22	96.36	94.12	95.58	4427000.0
2007-11-26	ADRE	ETF	52.91	53.58	50.83	50.83	343722.0
2007-11-26	AGG	ETF	101.53	102.42	101.41	102.17	441900.0
2007-11-26	AIA	ETF	47.37	47.75	46.58	46.58	7400.0
2007-11-26	AIQ	ETF	46.5	47.3	45.6	45.85	33000.0
2007-11-26	AIS	ETF	1.01	1.04	1.01	1.02	103100.0
2007-11-26	AIVI	ETF	72.27	72.55	70.84	70.87	23100.0
2007-11-26	ARB	ETF	50.76	50.84	48.57	48.91	235200.0
2007-11-26	BBH	ETF	57.9167	57.9933	57.1667	57.1667	390000.0
2007-11-26	BIL	ETF	91.96	91.96	91.78	91.84	24350.0
2007-11-26	BITS	ETF	22.64	22.64	20.4404	21.2	24817.0
2007-11-26	BIV	ETF	76.69	78.36	76.69	78.36	19100.0
2007-11-26	BKF	ETF	56.21	58.0	54.0	54.0	5400.0
2007-11-26	BLV	ETF	78.14	78.82	77.42	78.71	29000.0
2007-11-26	BMVP	ETF	16.73	16.7967	16.3833	16.3867	46400.0
2007-11-26	BND	ETF	77.54	77.54	76.69	77.45	171100.0
2007-11-26	BNE	ETF	16.43	17.08	16.34	16.4	302700.0
2007-11-26	BRF	ETF	14.59	14.65	14.59	14.64	7300.0
2007-11-26	BSV	ETF	77.75	77.75	76.89	77.6	81300.0
2007-11-26	BTF	ETF	111.89999999999999	111.89999999999999	110.6	110.8	220.0
2007-11-26	BWX	ETF	28.235	28.235	27.38	27.56	205340.0
2007-11-26	CBON	ETF	18.94	19.13	17.46	17.5	51883.0
2007-11-26	CDL	ETF	2.35	2.38	2.14	2.15	2130410.0
2007-11-26	CEF	ETF	10.9	10.95	10.72	10.78	498800.0
2007-11-26	CGO	ETF	18.09	18.15	17.71	17.774	12800.0
2007-11-26	CGW	ETF	25.01	25.2899	24.67	24.67	70000.0
2007-11-26	CHB	ETF	8.79	8.82	8.25	8.28	1350017.0
2007-11-26	CHI	ETF	14.73	14.84	14.25	14.28	197500.0
2007-11-26	CHIC	ETF	15.25	15.52	14.66	14.8	342047.0
2007-11-26	CHW	ETF	12.17	12.3	12.05	12.09	236800.0
2007-11-26	CHY	ETF	12.94	13.0	12.51	12.51	266204.0
2007-11-26	CMF	ETF	51.985	52.34	51.985	52.34	12600.0
2007-11-26	CN	ETF	56.0	56.4	53.9	54.18	225523.0
2007-11-26	CNXT	ETF	1.16	1.18	1.13	1.16	4571637.0
2007-11-26	COW	ETF	49.51	49.55	49.32	49.42	3800.0
2007-11-26	CPST	ETF	1.22	1.25	1.2	1.24	1299291.0
2007-11-26	CSA	ETF	16.15	16.26	15.94	15.98	53300.0
2007-11-26	CSD	ETF	26.59	26.59	25.81	25.81	10400.0
2007-11-26	CSQ	ETF	13.25	13.45	13.05	13.1	354925.0
2007-11-26	CUT	ETF	23.95	24.1	23.45	23.45	6100.0
2007-11-26	CVY	ETF	23.78	24.05	23.43	23.43	22800.0
2007-11-26	CWI	ETF	28.3333	28.3333	27.52	27.52	95400.0
2007-11-26	CZA	ETF	25.29	25.4	25.29	25.4	1600.0
2007-11-26	DBA	ETF	31.02	31.02	30.27	30.29	373100.0
2007-11-26	DBB	ETF	23.09	23.25	22.51	23.01	167500.0

> showing 50 of 536 rows — these rows as CSV

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