PREVIEW / etf_daily / 2007-08-07

all etf daily files

  file:    by_date/etf_daily/2007/2007-08-07.parquet
  size:    23 KB
  rows:    499

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-08-07	SPY	ETF	145.94	149.0	145.23	147.77	232568700.0
2007-08-07	QQQ	ETF	47.88	48.62	47.48	48.31	167576141.0
2007-08-07	IWM	ETF	75.88	77.67	75.5	77.2	179153900.0
2007-08-07	DIA	ETF	133.89	136.03	133.39	135.05	25705000.0
2007-08-07	GLD	ETF	66.09	66.58	65.91	66.48	4147200.0
2007-08-07	TLT	ETF	87.43	87.71	86.92	87.22	1890800.0
2007-08-07	ADRE	ETF	44.95	45.4	44.24	45.124	282677.0
2007-08-07	AGG	ETF	98.6	98.78	98.41	98.48	280300.0
2007-08-07	AIQ	ETF	43.25	43.3	40.45	42.25	85720.0
2007-08-07	AIS	ETF	1.49	1.56	1.49	1.55	235600.0
2007-08-07	ARB	ETF	51.65	54.43	51.65	54.06	625800.0
2007-08-07	BBH	ETF	54.7833	55.25	54.3767	54.84	1187400.0
2007-08-07	BIL	ETF	91.66	91.68	91.58	91.66	13950.0
2007-08-07	BITS	ETF	23.52	23.52	22.52	23.4	15485.0
2007-08-07	BIV	ETF	74.46	74.5	74.28	74.32	4700.0
2007-08-07	BLV	ETF	73.91	73.96	73.72	73.76	3900.0
2007-08-07	BMVP	ETF	16.71	16.86	16.59	16.75	47000.0
2007-08-07	BND	ETF	74.63	74.71	74.4	74.6	41700.0
2007-08-07	BNE	ETF	15.75	15.85	15.19	15.28	556100.0
2007-08-07	BSV	ETF	75.14	75.23	75.07	75.12	42700.0
2007-08-07	BTF	ETF	101.54999999999998	102.5	97.94999999999999	101.85	2640.0
2007-08-07	CBON	ETF	23.47	23.59	22.6	23.33	133927.0
2007-08-07	CDL	ETF	4.65	4.65	4.28	4.35	4507201.0
2007-08-07	CEF	ETF	9.1	9.26	9.07	9.25	167100.0
2007-08-07	CGO	ETF	16.75	16.8	16.66	16.75	16200.0
2007-08-07	CGW	ETF	24.82	25.1	24.61	25.04	98300.0
2007-08-07	CHB	ETF	10.9	12.11	10.56	11.7	3211060.0
2007-08-07	CHI	ETF	17.25	17.34	16.85	17.0	136600.0
2007-08-07	CHIC	ETF	16.53	18.1	16.25	17.48	1715656.0
2007-08-07	CHW	ETF	13.75	13.85	13.5	13.65	100000.0
2007-08-07	CHY	ETF	15.05	15.22	14.62	14.86	223800.0
2007-08-07	CN	ETF	48.8	49.7	48.18	49.39	83300.0
2007-08-07	CNXT	ETF	1.16	1.22	1.13	1.2	8305552.0
2007-08-07	CPI	ETF	28.03	28.15	27.7	28.15	600.0
2007-08-07	CPST	ETF	0.9899	1.09	0.9751	1.081	2377941.0
2007-08-07	CSA	ETF	16.43	16.64	16.25	16.51	56100.0
2007-08-07	CSD	ETF	28.42	28.64	28.38	28.64	11000.0
2007-08-07	CSM	ETF	1.43	1.43	1.43	1.43	400.0
2007-08-07	CSQ	ETF	14.12	14.4	14.1001	14.4	290700.0
2007-08-07	CTEC	ETF	101.19999999999999	101.19999999999999	95.15	99.74999999999999	37138.200000000004
2007-08-07	CVY	ETF	25.47	26.03	25.47	25.89	23800.0
2007-08-07	CWI	ETF	26.5467	26.9467	26.5067	26.8667	143250.0
2007-08-07	CZA	ETF	25.54	25.54	25.54	25.54	2000.0
2007-08-07	DBA	ETF	26.0	26.3	25.93	26.25	88300.0
2007-08-07	DBB	ETF	26.91	27.14	26.91	27.0	15000.0
2007-08-07	DBC	ETF	25.4	25.74	25.36	25.68	181500.0
2007-08-07	DBE	ETF	27.88	28.3	27.83	28.12	12200.0
2007-08-07	DBO	ETF	26.65	27.6	26.51	26.9	24000.0
2007-08-07	DBP	ETF	26.08	26.24	26.08	26.2	4500.0
2007-08-07	DBS	ETF	25.45	25.8	25.45	25.72	17100.0

> showing 50 of 499 rows — these rows as CSV

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