PREVIEW / etf_daily / 2007-05-24

all etf daily files

  file:    by_date/etf_daily/2007/2007-05-24.parquet
  size:    22 KB
  rows:    480

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-05-24	SPY	ETF	152.53	153.21	150.74	151.06	187593000.0
2007-05-24	QQQ	ETF	46.855	47.04	45.97	46.16	206344362.0
2007-05-24	IWM	ETF	82.98	83.56	81.56	81.96	89560000.0
2007-05-24	DIA	ETF	135.27	136.33	134.15	134.39	28156800.0
2007-05-24	GLD	ETF	65.46	65.46	64.52	64.75	6228000.0
2007-05-24	TLT	ETF	86.46	86.59	85.96	86.57	1598200.0
2007-05-24	ADRE	ETF	43.51	43.79	42.4	42.6	202900.0
2007-05-24	AGG	ETF	99.24	99.41	99.04	99.41	339300.0
2007-05-24	AIQ	ETF	41.8	42.1	41.25	41.6	55000.0
2007-05-24	AIS	ETF	1.75	1.79	1.7	1.78	449700.0
2007-05-24	ARB	ETF	50.25	51.26	49.49	49.86	311700.0
2007-05-24	BBH	ETF	59.4	59.6967	59.0233	59.2667	311700.0
2007-05-24	BITS	ETF	32.76	33.36	31.92	32.48	23498.0
2007-05-24	BIV	ETF	74.65	74.65	74.45	74.64	30600.0
2007-05-24	BLV	ETF	74.2	74.31	73.93	74.31	6700.0
2007-05-24	BMVP	ETF	18.1033	18.2033	17.9236	17.94	31800.0
2007-05-24	BND	ETF	74.83	74.87	74.69	74.85	38600.0
2007-05-24	BNE	ETF	18.77	18.94	18.65	18.93	482400.0
2007-05-24	BOSS	ETF	50.06	50.06	48.6	48.6	200.0
2007-05-24	BRF	ETF	14.5	14.51	14.5	14.5099	3800.0
2007-05-24	BSV	ETF	75.09	75.1	75.03	75.08	14300.0
2007-05-24	BTF	ETF	110.25	110.64999999999999	109.49999999999999	110.1	600.0
2007-05-24	CBON	ETF	29.06	29.86	29.06	29.63	68524.0
2007-05-24	CDL	ETF	8.49	8.53	8.29	8.31	364400.0
2007-05-24	CEF	ETF	9.04	9.13	8.9	8.95	481900.0
2007-05-24	CGO	ETF	17.84	17.96	17.62	17.62	32700.0
2007-05-24	CGW	ETF	25.16	25.2	24.83	24.84	176000.0
2007-05-24	CHB	ETF	11.68	11.99	11.37	11.52	3079600.0
2007-05-24	CHI	ETF	20.0	20.06	19.95	20.0	74500.0
2007-05-24	CHIC	ETF	25.87	26.37	25.32	25.57	561968.0
2007-05-24	CHY	ETF	17.17	17.25	17.15	17.16	113300.0
2007-05-24	CIL	ETF	25.92	25.96	25.92	25.96	800.0
2007-05-24	CN	ETF	52.87	53.0	50.72	51.22	128100.0
2007-05-24	CNXT	ETF	1.34	1.36	1.28	1.3	11685204.0
2007-05-24	CPI	ETF	23.84	23.84	23.6	23.6	400.0
2007-05-24	CPST	ETF	0.92	0.922	0.89	0.9	1307052.0
2007-05-24	CSA	ETF	20.27	20.58	20.11	20.21	93900.0
2007-05-24	CSB	ETF	32.12	32.26	31.84	31.84	24300.0
2007-05-24	CSD	ETF	30.0	30.2	29.58	29.67	27700.0
2007-05-24	CSM	ETF	1.4	1.4	1.4	1.4	4000.0
2007-05-24	CSQ	ETF	15.8	15.8	15.29	15.38	415500.0
2007-05-24	CTEC	ETF	86.4	86.8	84.39999999999999	86.6	16479.4
2007-05-24	CVY	ETF	28.29	28.29	27.79	27.84	24700.0
2007-05-24	CWI	ETF	27.0667	27.0667	26.7	26.72	37950.0
2007-05-24	CZA	ETF	26.88	26.88	26.55	26.56	1500.0
2007-05-24	DBA	ETF	25.31	25.56	25.18	25.55	178200.0
2007-05-24	DBB	ETF	26.75	26.81	25.85	26.16	47400.0
2007-05-24	DBC	ETF	25.41	25.55	25.19	25.29	258000.0
2007-05-24	DBE	ETF	28.54	28.7	28.24	28.25	13400.0
2007-05-24	DBO	ETF	26.64	26.67	26.13	26.37	59700.0

> showing 50 of 480 rows — these rows as CSV

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