PREVIEW / etf_daily / 2007-12-20

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-20.parquet
  size:    25 KB
  rows:    544

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-20	SPY	ETF	146.84	146.86	145.18	146.8	214813800.0
2007-12-20	QQQ	ETF	50.67	50.96	50.2	50.9	167342283.0
2007-12-20	IWM	ETF	76.21	77.01	74.82	76.84	121965700.0
2007-12-20	DIA	ETF	132.81	132.84	131.66	132.71	12707000.0
2007-12-20	GLD	ETF	78.91	79.11	78.36	78.67	6345600.0
2007-12-20	TLT	ETF	93.26	93.87	93.02	93.03	1659400.0
2007-12-20	ADRE	ETF	53.72	53.96	53.21	53.67	276758.0
2007-12-20	AGG	ETF	101.55	101.66	101.18	101.18	489200.0
2007-12-20	AIA	ETF	49.31	49.31	46.3001	47.1964	5300.0
2007-12-20	AIQ	ETF	49.0	49.1	45.45	47.15	32880.0
2007-12-20	AIS	ETF	0.95	0.97	0.93	0.96	341200.0
2007-12-20	AIVI	ETF	69.0	69.0	68.39	68.71	60400.0
2007-12-20	ARB	ETF	42.3	42.55	41.48	42.46	229726.0
2007-12-20	BBH	ETF	54.0533	54.4467	53.9467	54.3933	960300.0
2007-12-20	BIL	ETF	91.76	91.88	91.76	91.86	14700.0
2007-12-20	BITS	ETF	23.48	24.28	23.48	23.88	15185.0
2007-12-20	BIV	ETF	77.03	77.76	77.03	77.58	161700.0
2007-12-20	BKF	ETF	57.35	57.8	56.9	57.75	63800.0
2007-12-20	BLV	ETF	76.87	77.27	76.66	76.8	49800.0
2007-12-20	BMVP	ETF	17.08	17.32	17.08	17.29	75566.0
2007-12-20	BND	ETF	77.13	77.16	76.9	77.0	54800.0
2007-12-20	BNE	ETF	18.01	18.02	17.57	17.89	111600.0
2007-12-20	BRF	ETF	14.58	14.6201	14.58	14.62	1800.0
2007-12-20	BSV	ETF	77.25	77.37	77.16	77.25	74600.0
2007-12-20	BTF	ETF	109.25	109.25	108.75049999999999	109.25	140.0
2007-12-20	BWX	ETF	26.3	26.355	26.23	26.31	60600.0
2007-12-20	CBON	ETF	17.45	17.6	16.53	17.37	55518.0
2007-12-20	CDL	ETF	1.97	2.0	1.91	1.98	1632955.0
2007-12-20	CEF	ETF	10.45	10.47	10.25	10.26	720300.0
2007-12-20	CGO	ETF	18.75	18.8	18.14	18.34	32300.0
2007-12-20	CGW	ETF	24.85	25.15	24.7	25.15	53486.0
2007-12-20	CHB	ETF	8.58	8.65	8.09	8.25	1389386.0
2007-12-20	CHI	ETF	13.72	14.19	13.53	14.14	448287.0
2007-12-20	CHIC	ETF	15.08	15.28	14.55	15.22	518536.0
2007-12-20	CHW	ETF	12.18	12.22	11.9701	12.01	429230.0
2007-12-20	CHY	ETF	12.84	12.93	12.65	12.85	493883.0
2007-12-20	CMF	ETF	52.165	52.165	52.1	52.1	4000.0
2007-12-20	CN	ETF	60.83	60.83	59.62	60.57	294050.0
2007-12-20	CNXT	ETF	0.93	0.94	0.91	0.92	4189169.0
2007-12-20	COW	ETF	47.89	48.79	47.7	47.79	4300.0
2007-12-20	CPI	ETF	24.25	25.55	24.1	25.55	3900.0
2007-12-20	CPST	ETF	1.65	1.65	1.51	1.59	3791360.0
2007-12-20	CSA	ETF	15.5	16.35	15.5	15.81	43900.0
2007-12-20	CSD	ETF	26.78	26.78	26.5	26.73	12500.0
2007-12-20	CSQ	ETF	13.74	13.78	13.51	13.67	461970.0
2007-12-20	CUT	ETF	23.49	23.49	23.0	23.3	24700.0
2007-12-20	CVY	ETF	23.4	23.4	23.12	23.26	39300.0
2007-12-20	CWI	ETF	27.32	27.5867	26.6267	27.5267	225300.0
2007-12-20	DBA	ETF	32.32	32.41	32.13	32.38	871200.0
2007-12-20	DBB	ETF	21.7	21.75	21.56	21.6	40900.0

> showing 50 of 544 rows — these rows as CSV

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