PREVIEW / etf_daily / 2007-10-23

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-23.parquet
  size:    23 KB
  rows:    519

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-10-23	SPY	ETF	151.46	151.95	150.25	151.76	180085100.0
2007-10-23	QQQ	ETF	53.61	54.21	53.34	54.18	162362852.0
2007-10-23	IWM	ETF	81.41	81.54	80.19	81.38	84843000.0
2007-10-23	DIA	ETF	136.17	136.68	135.27	136.42	13325600.0
2007-10-23	GLD	ETF	75.11	75.26	74.63	75.23	3096400.0
2007-10-23	TLT	ETF	90.26	90.52	90.1	90.35	1046600.0
2007-10-23	ADRE	ETF	56.06	56.9699	55.79	56.79	394033.0
2007-10-23	AGG	ETF	100.64	100.67	100.45	100.67	328900.0
2007-10-23	AIQ	ETF	46.65	47.15	45.0	45.65	146260.0
2007-10-23	AIS	ETF	1.28	1.3	1.15	1.2	585200.0
2007-10-23	AIVI	ETF	74.27	74.86	74.01	74.72	125100.0
2007-10-23	ARB	ETF	50.35	50.35	49.44	50.13	320300.0
2007-10-23	BBH	ETF	59.5833	60.0967	59.0733	59.9167	279000.0
2007-10-23	BIL	ETF	91.82	91.84	91.76	91.8	12800.0
2007-10-23	BITS	ETF	25.32	26.2	25.32	25.6	16750.0
2007-10-23	BIV	ETF	76.32	76.46	76.24	76.41	22900.0
2007-10-23	BLV	ETF	76.28	76.39	76.17	76.33	6500.0
2007-10-23	BMVP	ETF	17.29	17.3266	17.1467	17.2967	60400.0
2007-10-23	BND	ETF	76.16	76.3	76.14	76.22	84800.0
2007-10-23	BNE	ETF	17.18	17.26	17.11	17.26	193200.0
2007-10-23	BRF	ETF	14.61	14.65	14.61	14.65	12500.0
2007-10-23	BSV	ETF	76.29	76.38	76.22	76.3	60500.0
2007-10-23	BTF	ETF	115.0	115.85000000000001	114.74999999999999	115.64999999999999	3880.0
2007-10-23	BWX	ETF	26.3	26.305	26.21	26.275	68200.0
2007-10-23	CBON	ETF	20.23	20.99	19.98	20.35	104820.0
2007-10-23	CDL	ETF	4.42	4.52	4.3	4.38	1285600.0
2007-10-23	CEF	ETF	9.95	9.98	9.8	9.96	349400.0
2007-10-23	CGO	ETF	18.6	18.85	18.56	18.77	20000.0
2007-10-23	CGW	ETF	25.99	26.06	25.75	26.06	69100.0
2007-10-23	CHB	ETF	12.93	13.22	12.72	12.85	1339500.0
2007-10-23	CHI	ETF	16.79	16.91	16.7887	16.82	108100.0
2007-10-23	CHIC	ETF	14.4	14.4	13.92	14.09	374194.0
2007-10-23	CHW	ETF	13.26	13.45	13.14	13.29	191200.0
2007-10-23	CHY	ETF	14.82	14.96	14.76	14.79	102700.0
2007-10-23	CMF	ETF	52.09	52.15	52.09	52.15	2600.0
2007-10-23	CN	ETF	63.11	64.26	62.61	64.17	237800.0
2007-10-23	CNXT	ETF	1.34	1.38	1.32	1.37	4830025.0
2007-10-23	CPI	ETF	23.5	23.5	23.5	23.5	100.0
2007-10-23	CPST	ETF	1.05	1.08	1.04	1.06	2131488.0
2007-10-23	CSA	ETF	17.6	17.85	17.4	17.58	56000.0
2007-10-23	CSD	ETF	28.65	28.91	28.58	28.91	53500.0
2007-10-23	CSQ	ETF	14.84	14.84	14.65	14.8	259300.0
2007-10-23	CVY	ETF	25.65	25.66	25.41	25.58	12100.0
2007-10-23	CWI	ETF	28.86	28.9133	28.6067	28.9133	77700.0
2007-10-23	CZA	ETF	26.6	26.6	26.55	26.55	800.0
2007-10-23	DBA	ETF	29.51	29.58	28.93	28.99	291500.0
2007-10-23	DBB	ETF	26.01	26.04	25.71	25.97	15300.0
2007-10-23	DBC	ETF	28.94	28.96	28.49	28.63	1101600.0
2007-10-23	DBE	ETF	31.97	31.97	31.66	31.77	7000.0
2007-10-23	DBO	ETF	31.22	32.04	30.4	30.99	11200.0

> showing 50 of 519 rows — these rows as CSV

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