PREVIEW / etf_daily / 2007-11-30

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-30.parquet
  size:    25 KB
  rows:    541

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-30	SPY	ETF	149.04	149.87	147.33	148.66	222908000.0
2007-11-30	QQQ	ETF	52.21	52.25	50.95	51.31	171417328.0
2007-11-30	IWM	ETF	77.43	77.95	76.15	76.65	84981400.0
2007-11-30	DIA	ETF	134.52	134.7	132.85	134.16	18892200.0
2007-11-30	GLD	ETF	78.35	78.6	76.98	77.32	9509100.0
2007-11-30	TLT	ETF	93.88	94.39	93.74	94.38	1952100.0
2007-11-30	ADRE	ETF	55.8	56.02	54.75	55.42	553897.0
2007-11-30	AGG	ETF	101.52	102.11	101.28	102.0	1734300.0
2007-11-30	AIA	ETF	50.46	50.7	49.36	49.36	9400.0
2007-11-30	AIQ	ETF	48.3	49.55	47.5	47.75	43480.0
2007-11-30	AIS	ETF	1.08	1.2	1.03	1.11	207100.0
2007-11-30	AIVI	ETF	74.83	74.99	73.84	74.11	40200.0
2007-11-30	ARB	ETF	40.08	40.63	38.9	39.85	847298.0
2007-11-30	BBH	ETF	60.5933	60.5933	60.0667	60.1433	534600.0
2007-11-30	BIL	ETF	91.98	106.2	91.84	91.9	274300.0
2007-11-30	BITS	ETF	22.6804	23.44	22.56	22.56	4244.0
2007-11-30	BIV	ETF	77.53	77.96	77.53	77.94	22800.0
2007-11-30	BKF	ETF	60.1	60.34	59.0	59.05	36000.0
2007-11-30	BLV	ETF	77.51	77.88	77.48	77.88	50900.0
2007-11-30	BMVP	ETF	17.2433	17.2433	17.0767	17.1567	31300.0
2007-11-30	BND	ETF	76.98	77.35	76.98	77.3	107300.0
2007-11-30	BNE	ETF	18.0	18.29	17.82	18.06	686300.0
2007-11-30	BRF	ETF	14.6001	14.65	14.59	14.65	4400.0
2007-11-30	BSV	ETF	77.23	77.42	77.2	77.4	43000.0
2007-11-30	BTF	ETF	113.6	114.19999999999999	113.49999999999999	113.49999999999999	1940.0
2007-11-30	BWX	ETF	27.21	27.21	26.9	27.005	136000.0
2007-11-30	CBON	ETF	19.26	19.26	18.02	18.03	71154.0
2007-11-30	CDL	ETF	2.22	2.4	2.21	2.3	4518951.0
2007-11-30	CEF	ETF	10.5	10.5	10.17	10.27	521200.0
2007-11-30	CGO	ETF	18.95	20.0	18.91	19.09	33900.0
2007-11-30	CGW	ETF	26.25	26.25	25.36	25.56	78700.0
2007-11-30	CHB	ETF	8.96	9.29	8.79	9.02	2056999.0
2007-11-30	CHI	ETF	14.39	14.87	14.39	14.74	222305.0
2007-11-30	CHIC	ETF	16.2	16.79	16.16	16.46	487224.0
2007-11-30	CHW	ETF	12.48	12.93	12.48	12.77	248200.0
2007-11-30	CHY	ETF	13.4	13.62	13.39	13.6	337490.0
2007-11-30	CN	ETF	64.1	65.08	62.91	64.07	453514.0
2007-11-30	CNXT	ETF	1.13	1.14	1.08	1.11	8752057.0
2007-11-30	COW	ETF	49.0	49.0	48.43	48.65	23000.0
2007-11-30	CPST	ETF	1.22	1.23	1.19	1.22	870342.0
2007-11-30	CSA	ETF	15.9	16.12	15.77	15.77	86450.0
2007-11-30	CSD	ETF	27.34	27.34	27.19	27.19	2000.0
2007-11-30	CSQ	ETF	13.76	14.07	13.76	14.02	347201.0
2007-11-30	CUT	ETF	24.95	25.0	24.77	24.8	15600.0
2007-11-30	CVY	ETF	24.75	24.75	24.38	24.43	16000.0
2007-11-30	CWI	ETF	29.2267	29.8067	28.6533	28.7933	490950.0
2007-11-30	CZA	ETF	26.01	26.01	25.92	25.92	800.0
2007-11-30	DBA	ETF	30.78	31.09	30.41	30.65	323800.0
2007-11-30	DBB	ETF	24.11	24.26	24.06	24.22	17500.0
2007-11-30	DBC	ETF	30.25	30.72	30.19	30.31	352984.0

> showing 50 of 541 rows — these rows as CSV

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