PREVIEW / etf_daily / 2007-12-04

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-04.parquet
  size:    24 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-12-04	SPY	ETF	146.66	147.54	146.31	146.36	136533900.0
2007-12-04	QQQ	ETF	50.46	50.94	50.38	50.67	113374086.0
2007-12-04	IWM	ETF	75.02	75.56	74.56	74.95	57670000.0
2007-12-04	DIA	ETF	132.51	133.18	132.36	132.43	8191700.0
2007-12-04	GLD	ETF	78.63	79.62	78.57	79.4	7721900.0
2007-12-04	TLT	ETF	94.9	95.06	94.15	94.74	1721200.0
2007-12-04	ADRE	ETF	54.35	55.06	54.08	54.66	465617.0
2007-12-04	AGG	ETF	102.17	102.23	101.66	101.74	580800.0
2007-12-04	AIA	ETF	49.79	49.79	49.26	49.26	122300.0
2007-12-04	AIQ	ETF	47.85	49.65	47.0	47.3	65880.0
2007-12-04	AIS	ETF	1.03	1.08	1.0	1.03	246900.0
2007-12-04	AIVI	ETF	73.28	73.63	73.13	73.39	27400.0
2007-12-04	ARB	ETF	39.65	40.56	39.24	39.75	480000.0
2007-12-04	BBH	ETF	58.9067	59.0533	58.58	58.6	481800.0
2007-12-04	BIL	ETF	91.62	91.7	91.6	91.62	90750.0
2007-12-04	BITS	ETF	21.28	22.0	21.12	21.12	4926.0
2007-12-04	BIV	ETF	77.94	78.0	77.66	77.94	19500.0
2007-12-04	BKF	ETF	58.59	59.28	58.22	59.05	13400.0
2007-12-04	BLV	ETF	77.9	78.0	77.46	77.89	66600.0
2007-12-04	BMVP	ETF	17.04	17.19	17.04	17.16	63090.0
2007-12-04	BND	ETF	77.43	77.43	77.11	77.33	89300.0
2007-12-04	BNE	ETF	17.9	17.97	17.61	17.66	347800.0
2007-12-04	BRF	ETF	14.61	14.61	14.61	14.61	200.0
2007-12-04	BSV	ETF	77.52	77.53	77.31	77.36	53300.0
2007-12-04	BTF	ETF	114.3	114.7	108.49999999999999	114.04999999999998	780.0
2007-12-04	BWX	ETF	27.225	27.225	27.115	27.21	99200.0
2007-12-04	CBON	ETF	18.39	18.45	17.24	17.46	101444.0
2007-12-04	CDL	ETF	2.15	2.24	1.98	2.08	2316196.0
2007-12-04	CEF	ETF	10.44	10.6	10.41	10.47	269900.0
2007-12-04	CGO	ETF	18.74	19.0599	18.74	19.0599	8500.0
2007-12-04	CGW	ETF	25.65	25.7	25.26	25.42	52900.0
2007-12-04	CHB	ETF	8.35	8.43	8.08	8.18	1275009.0
2007-12-04	CHI	ETF	14.91	14.95	14.54	14.95	259500.0
2007-12-04	CHIC	ETF	15.85	15.945	15.25	15.66	722654.0
2007-12-04	CHW	ETF	12.2	12.49	12.19	12.42	300900.0
2007-12-04	CHY	ETF	13.73	13.73	13.37	13.63	281590.0
2007-12-04	CMF	ETF	52.01	52.2	50.65	52.2	152000.0
2007-12-04	CN	ETF	62.58	63.55	62.42	62.87	296260.0
2007-12-04	CNXT	ETF	1.07	1.07	1.0	1.02	10689704.0
2007-12-04	COW	ETF	48.12	48.18	47.91	48.04	1300.0
2007-12-04	CPST	ETF	1.15	1.18	1.14	1.15	1283858.0
2007-12-04	CSA	ETF	15.35	15.42	14.97	15.03	66400.0
2007-12-04	CSD	ETF	27.1	27.28	27.07	27.23	2800.0
2007-12-04	CSQ	ETF	13.81	13.86	13.7	13.82	295500.0
2007-12-04	CUT	ETF	24.75	24.75	24.4	24.6	43300.0
2007-12-04	CVY	ETF	24.26	24.26	23.96	24.18	19400.0
2007-12-04	CWI	ETF	28.8067	28.8067	28.4133	28.6067	177900.0
2007-12-04	CZA	ETF	25.91	25.91	25.83	25.83	9100.0
2007-12-04	DBA	ETF	30.98	31.39	30.85	31.39	707800.0
2007-12-04	DBB	ETF	23.0	23.25	23.0	23.2	16500.0

> showing 50 of 541 rows — these rows as CSV

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