PREVIEW / etf_daily / 2007-05-21

all etf daily files

  file:    by_date/etf_daily/2007/2007-05-21.parquet
  size:    22 KB
  rows:    477

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-21	SPY	ETF	152.58	153.23	152.5	152.54	174664600.0
2007-05-21	QQQ	ETF	46.74	47.24	46.67	47.01	112895185.0
2007-05-21	IWM	ETF	81.73	83.23	81.65	82.76	148866800.0
2007-05-21	DIA	ETF	135.39	135.74	135.16	135.2	12668600.0
2007-05-21	GLD	ETF	65.29	65.76	65.06	65.67	10954300.0
2007-05-21	TLT	ETF	86.93	87.24	86.83	87.19	821100.0
2007-05-21	ADRE	ETF	43.91	44.11	43.6	43.89	117713.0
2007-05-21	AGG	ETF	99.53	99.65	99.41	99.65	316500.0
2007-05-21	AIQ	ETF	42.35	42.75	41.0	41.2	51720.0
2007-05-21	AIS	ETF	1.81	1.85	1.78	1.78	308800.0
2007-05-21	ARB	ETF	49.5	50.99	49.47	50.51	311200.0
2007-05-21	BBH	ETF	59.3467	59.5567	58.84	59.0967	1914000.0
2007-05-21	BITS	ETF	30.2	31.2	30.2	30.68	10680.0
2007-05-21	BIV	ETF	74.79	74.92	74.77	74.92	37100.0
2007-05-21	BLV	ETF	74.57	74.7	74.53	74.7	6200.0
2007-05-21	BMVP	ETF	18.17	18.22	18.13	18.17	65100.0
2007-05-21	BND	ETF	74.95	75.05	74.88	75.04	49400.0
2007-05-21	BNE	ETF	19.3	19.5	18.95	19.47	190600.0
2007-05-21	BRF	ETF	14.52	14.52	14.51	14.51	3900.0
2007-05-21	BSV	ETF	75.1	75.11	75.06	75.11	45600.0
2007-05-21	BTF	ETF	111.89999999999999	112.2	111.6	111.6	460.0
2007-05-21	CBON	ETF	29.45	29.6	29.21	29.25	34237.0
2007-05-21	CDL	ETF	8.37	8.71	8.3416	8.67	630700.0
2007-05-21	CEF	ETF	9.15	9.26	9.1	9.19	332100.0
2007-05-21	CGO	ETF	18.23	18.31	17.93	18.1	55700.0
2007-05-21	CGW	ETF	24.88	25.1	24.85	25.0	293000.0
2007-05-21	CHB	ETF	11.19	11.72	11.13	11.37	2149500.0
2007-05-21	CHI	ETF	20.15	20.16	20.05	20.06	81400.0
2007-05-21	CHIC	ETF	26.54	27.03	26.54	26.96	383727.0
2007-05-21	CHY	ETF	17.15	17.19	17.15	17.15	100900.0
2007-05-21	CIL	ETF	25.93	25.93	25.93	25.93	500.0
2007-05-21	CN	ETF	53.0	53.5	52.6415	52.81	76800.0
2007-05-21	CNXT	ETF	1.36	1.42	1.34	1.375	12061673.0
2007-05-21	CPI	ETF	23.8	23.8	23.8	23.8	100.0
2007-05-21	CPST	ETF	0.93	0.93	0.9	0.91	998606.0
2007-05-21	CSA	ETF	19.85	20.2	19.85	19.98	26700.0
2007-05-21	CSB	ETF	32.07	32.24	31.95	32.1	18700.0
2007-05-21	CSD	ETF	29.67	29.98	29.62	29.88	109000.0
2007-05-21	CSM	ETF	1.4	1.4	1.4	1.4	8000.0
2007-05-21	CSQ	ETF	15.73	15.75	15.65	15.69	361600.0
2007-05-21	CTEC	ETF	87.24999999999999	87.75	85.99999999999999	86.99999999999999	8006.8
2007-05-21	CVY	ETF	28.12	28.26	28.08	28.2	11500.0
2007-05-21	CWI	ETF	26.9667	27.0533	26.9267	26.9733	33750.0
2007-05-21	CZA	ETF	26.89	26.93	26.89	26.93	1000.0
2007-05-21	DBA	ETF	25.05	25.4	25.01	25.34	289700.0
2007-05-21	DBB	ETF	27.05	27.52	27.0	27.48	67900.0
2007-05-21	DBC	ETF	25.45	25.74	25.32	25.68	281100.0
2007-05-21	DBE	ETF	28.33	28.71	28.22	28.61	73600.0
2007-05-21	DBO	ETF	26.48	26.89	26.37	26.78	10100.0
2007-05-21	DBP	ETF	25.78	26.08	25.78	26.04	8500.0

> showing 50 of 477 rows — these rows as CSV

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