PREVIEW / etf_daily / 2007-06-04

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-04.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-06-04	SPY	ETF	153.54	154.39	153.48	154.1	78008800.0
2007-06-04	QQQ	ETF	47.27	47.64	47.24	47.5801	65389891.0
2007-06-04	IWM	ETF	84.49	84.97	84.34	84.79	52419900.0
2007-06-04	DIA	ETF	136.23	136.81	136.13	136.56	7430400.0
2007-06-04	GLD	ETF	66.61	66.76	66.3	66.54	2626300.0
2007-06-04	TLT	ETF	85.83	86.02	85.67	85.98	877700.0
2007-06-04	ADRE	ETF	45.0	45.09	44.74	45.03	193656.0
2007-06-04	AGG	ETF	98.71	98.77	98.61	98.75	299000.0
2007-06-04	AIQ	ETF	44.9	45.25	44.5	45.0	61120.0
2007-06-04	AIS	ETF	2.05	2.15	1.98	2.12	1114800.0
2007-06-04	ARB	ETF	52.64	52.77	52.31	52.7	126700.0
2007-06-04	BBH	ETF	60.75	61.16	60.45	60.7233	743100.0
2007-06-04	BIL	ETF	91.64	91.64	91.64	91.64	1050.0
2007-06-04	BITS	ETF	33.2	33.56	32.6	33.2	7579.0
2007-06-04	BIV	ETF	74.07	74.11	74.0	74.09	13500.0
2007-06-04	BLV	ETF	73.77	73.88	73.71	73.88	11400.0
2007-06-04	BMVP	ETF	18.2667	18.3767	18.2567	18.3467	31100.0
2007-06-04	BND	ETF	74.39	74.43	74.33	74.42	28500.0
2007-06-04	BNE	ETF	19.31	19.65	19.17	19.56	305100.0
2007-06-04	BRF	ETF	14.53	14.5304	14.52	14.53	3900.0
2007-06-04	BSV	ETF	74.67	74.7	74.64	74.69	27000.0
2007-06-04	BTF	ETF	109.94999999999999	110.5	109.7	110.29999999999998	2780.0
2007-06-04	CBON	ETF	29.94	30.19	29.65	30.12	23161.0
2007-06-04	CDL	ETF	8.7	8.86	8.16	8.31	3590000.0
2007-06-04	CEF	ETF	9.32	9.38	9.23	9.25	521900.0
2007-06-04	CGO	ETF	18.23	18.43	18.07	18.14	40900.0
2007-06-04	CGW	ETF	25.91	26.0	25.7	25.87	449900.0
2007-06-04	CHB	ETF	11.23	11.47	11.01	11.25	1318000.0
2007-06-04	CHI	ETF	20.22	20.3	20.22	20.29	76600.0
2007-06-04	CHIC	ETF	28.9	29.5	28.88	29.26	3987509.0
2007-06-04	CHY	ETF	17.16	17.28	16.95	17.19	143900.0
2007-06-04	CN	ETF	51.35	52.2	51.35	51.66	77700.0
2007-06-04	CNXT	ETF	1.32	1.34	1.26	1.29	10466653.0
2007-06-04	CPI	ETF	23.4	23.84	23.4	23.8	2800.0
2007-06-04	CPST	ETF	1.02	1.06	1.01	1.04	2444526.0
2007-06-04	CSA	ETF	21.31	21.337	20.94	20.99	23100.0
2007-06-04	CSB	ETF	32.26	32.55	32.26	32.5299	8600.0
2007-06-04	CSD	ETF	31.0	31.27	31.0	31.25	53100.0
2007-06-04	CSQ	ETF	15.6	15.76	15.57	15.63	343300.0
2007-06-04	CTEC	ETF	97.69999999999999	101.89999999999999	94.19999999999999	97.79999999999998	393035.0
2007-06-04	CVY	ETF	28.57	28.59	28.52	28.59	37000.0
2007-06-04	CWI	ETF	27.4533	27.54	27.44	27.54	34050.0
2007-06-04	DBA	ETF	26.39	26.49	26.12	26.23	193800.0
2007-06-04	DBB	ETF	27.11	27.62	27.1	27.56	48800.0
2007-06-04	DBC	ETF	25.76	26.0	25.75	25.93	408200.0
2007-06-04	DBE	ETF	28.18	28.7	28.18	28.51	18200.0
2007-06-04	DBO	ETF	26.43	26.7	26.33	26.7	13400.0
2007-06-04	DBP	ETF	26.57	26.64	26.55	26.55	2500.0
2007-06-04	DBS	ETF	27.06	27.14	26.94	26.94	18300.0
2007-06-04	DBV	ETF	28.35	28.45	28.3468	28.42	112000.0

> showing 50 of 477 rows — these rows as CSV

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