PREVIEW / etf_daily / 2007-11-27

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-27.parquet
  size:    24 KB
  rows:    538

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-27	SPY	ETF	141.74	143.23	140.95	142.57	293897900.0
2007-11-27	QQQ	ETF	49.39	50.05	49.1	49.96	211369293.0
2007-11-27	IWM	ETF	73.55	74.4	73.16	73.95	80871400.0
2007-11-27	DIA	ETF	127.94	129.91	127.71	129.32	23078300.0
2007-11-27	GLD	ETF	80.7	80.89	79.81	80.1	7229900.0
2007-11-27	TLT	ETF	94.96	95.25	93.99	94.67	3100300.0
2007-11-27	ADRE	ETF	51.06	52.1	50.58	51.99	379877.0
2007-11-27	AGG	ETF	102.21	102.21	101.43	101.75	933000.0
2007-11-27	AIA	ETF	46.58	47.53	46.58	47.44	7300.0
2007-11-27	AIQ	ETF	45.9	47.5	45.85	46.65	36680.0
2007-11-27	AIS	ETF	1.04	1.04	1.02	1.03	77800.0
2007-11-27	AIVI	ETF	71.59	72.47	68.64	72.47	16600.0
2007-11-27	ARB	ETF	38.74	42.16	34.81	41.7	7976650.0
2007-11-27	BBH	ETF	57.6167	59.0233	57.44	58.7667	691800.0
2007-11-27	BIL	ETF	91.82	91.92	91.82	91.92	21100.0
2007-11-27	BITS	ETF	21.2	21.96	21.08	21.2	14239.0
2007-11-27	BIV	ETF	80.25	80.25	77.5	77.7	50200.0
2007-11-27	BKF	ETF	54.62	55.68	54.62	55.68	2900.0
2007-11-27	BLV	ETF	78.12	78.19	77.42	77.69	36300.0
2007-11-27	BMVP	ETF	16.64	16.64	16.41	16.58	68275.0
2007-11-27	BND	ETF	77.2	77.5	76.81	77.04	60000.0
2007-11-27	BNE	ETF	16.43	16.7	16.32	16.47	265200.0
2007-11-27	BRF	ETF	14.64	14.65	14.61	14.62	5200.0
2007-11-27	BSV	ETF	77.75	77.75	77.21	77.39	92300.0
2007-11-27	BTF	ETF	112.79999999999998	112.79999999999998	108.9	111.25	2520.0
2007-11-27	BWX	ETF	27.75	27.75	27.375	27.4	241280.0
2007-11-27	CBON	ETF	17.53	18.18	17.51	18.01	71653.0
2007-11-27	CDL	ETF	2.16	2.26	2.14	2.19	2281200.0
2007-11-27	CEF	ETF	10.85	10.85	10.6	10.68	369400.0
2007-11-27	CGO	ETF	17.88	18.11	17.67	17.9	29100.0
2007-11-27	CGW	ETF	25.02	25.08	24.6101	25.08	106800.0
2007-11-27	CHB	ETF	8.37	8.64	8.24	8.53	1354450.0
2007-11-27	CHI	ETF	14.03	14.1	13.66	13.81	558410.0
2007-11-27	CHIC	ETF	14.85	15.24	14.72	15.15	584475.0
2007-11-27	CHW	ETF	12.03	12.34	11.71	11.86	449301.0
2007-11-27	CHY	ETF	12.5	12.65	12.37	12.47	430508.0
2007-11-27	CMF	ETF	51.985	52.16	51.985	52.13	14800.0
2007-11-27	CN	ETF	54.4	55.98	53.55	55.8	311900.0
2007-11-27	CNXT	ETF	1.16	1.17	1.11	1.11	10318476.0
2007-11-27	COW	ETF	49.33	49.33	48.98	49.04	2900.0
2007-11-27	CPST	ETF	1.26	1.2701	1.2	1.21	2519605.0
2007-11-27	CSA	ETF	16.09	16.14	15.81	15.96	90700.0
2007-11-27	CSD	ETF	25.97	26.05	25.77	26.05	6900.0
2007-11-27	CSQ	ETF	13.08	13.32	13.08	13.3	555709.0
2007-11-27	CUT	ETF	23.7	23.75	23.59	23.75	13100.0
2007-11-27	CVY	ETF	23.55	23.71	23.49	23.65	17400.0
2007-11-27	CWI	ETF	26.9333	27.96	26.9333	27.96	433350.0
2007-11-27	CZA	ETF	25.09	25.22	25.09	25.22	600.0
2007-11-27	DBA	ETF	30.24	30.63	30.18	30.58	265000.0
2007-11-27	DBB	ETF	22.91	23.12	22.86	22.99	42000.0

> showing 50 of 538 rows — these rows as CSV

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